1. Oracle API to create Bank BRANCH:
lv_ext_bank_branch_rec.bank_party_id := <l_bank_id>;
lv_ext_bank_branch_rec.branch_name := 'Twitter SBI Branch';
lv_ext_bank_branch_rec.branch_number := '076401251';
lv_ext_bank_branch_rec.branch_type := 'OTHER';
lv_ext_bank_branch_rec.bch_object_version_number
:= 1;
dbms_output.put_line('Calling
API create_ext_bank_branch');
apps.IBY_EXT_BANKACCT_PUB.create_ext_bank_branch
(
p_api_version => 1.0,
p_init_msg_list => apps.FND_API.G_TRUE,
p_ext_bank_branch_rec => lv_ext_bank_branch_rec,
x_branch_id => lvx_branch_id,
x_return_status => lvx_return_status,
x_msg_count => lvx_msg_count,
x_msg_data => lvx_msg_data,
x_response => lv_response_rec
);
2. Oracle API to create Supplier Bank A/C:
p_ext_bank_acct_rec.object_version_number := 1.0;
P_EXT_BANK_ACCT_REC.ACCT_OWNER_PARTY_ID := V_SUPPLIER_PARTY_ID;
P_EXT_BANK_ACCT_REC.BANK_ACCOUNT_NUM := lc_bank_acc_num;
p_ext_bank_acct_rec.bank_id := v_bank_id;
p_ext_bank_acct_rec.branch_id := v_bank_branch_id;
p_ext_bank_acct_rec.start_date := SYSDATE;
p_ext_bank_acct_rec.country_code := 'US';
p_ext_bank_acct_rec.currency := 'USD';
p_ext_bank_acct_rec.foreign_payment_use_flag
:= 'Y';
p_ext_bank_acct_rec.payment_factor_flag := 'N';
IBY_EXT_BANKACCT_PUB.CREATE_EXT_BANK_ACCT
(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
p_ext_bank_acct_rec => p_ext_bank_acct_rec,
x_acct_id => x_acct_id,
x_return_status => x_return_status,
p_association_level => 'S',
p_supplier_site_id => NULL,
p_party_site_id => NULL,
p_org_id => ln_orgid,
-- Mandatory for both supplier and site
p_org_type => 'OPERATING_UNIT',
--Mandatory
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
x_response => x_response);
3. Oracle API to update Branch details:
p_init_msg_list
:= fnd_api.g_true;
p_branch_id := 1174216;
p_branch_number := '021000021';
p_branch_name := 'JP MORGAN CHASE';
p_bch_object_version_number := 8;
CE_BANK_PUB.UPDATE_BANK_BRANCH
(p_init_msg_list => p_init_msg_list,
p_branch_id => p_branch_id,
p_branch_name => p_branch_name,
p_branch_number => p_branch_number,
p_bch_object_version_number => p_bch_object_version_number,
p_typ_object_version_number => p_typ_object_version_number,
p_rfc_object_version_number => p_rfc_object_version_number,
p_eft_object_version_number => p_eft_object_version_number,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data
);
4. Oracle API to create Bank:
lc_return_status := '';
ln_msg_count := '';
lc_msg_data := '';
lr_extbank_rec.bank_name := lc_bank_name;
lr_extbank_rec.bank_number := lc_bank_num;
lr_extbank_rec.country_code := 'US';
apps.fnd_msg_pub.delete_msg(NULL);
apps.fnd_msg_pub.initialize();
IBY_EXT_BANKACCT_PUB.create_ext_bank
( -- ------------------------------
-- Input data elements
-- ------------------------------
p_api_version => 1.0,
p_init_msg_list => FND_API.G_TRUE,
p_ext_bank_rec => lr_extbank_rec,
-- --------------------------------
-- Output data elements
-- --------------------------------
x_bank_id => ln_bank_id,
x_return_status => lc_return_status,
x_msg_count => ln_msg_count,
x_msg_data => lc_msg_data,
x_response => lr_response_rec
);
5. Oracle API to application USER_NAME:
SELECT
FND_USER_AP_PKG.GET_USER_NAME(l_user_id) FROM DUAL;
6. Oracle API to get INVOICE approval status:
6. Oracle API to get INVOICE approval status:
l_invoice_validation_status
:= ap_invoices_pkg.get_approval_status(
l_invoice_id => p_line_rec.invoice_id,
l_invoice_amount => l_invoice_amount,
l_payment_status_flag
=> l_payment_status_flag,
l_invoice_type_lookup_code => l_invoice_type_lookup_code );
7. Oracle API to get INVOICE Period Name:
SELECT
AP_INVOICES_PKG.GET_PERIOD_NAME( GL_DATE, NULL, ORG_ID) PERIOD_NAME FROM DUAL;
8. Oracle API to create ADHOC role:
WF_DIRECTORY.CreateAdHocRole
(
role_name
=> v_role_name,
role_display_name
=>v_role_display_name,
email_address
=> 'email@gmail.com',
notification_preference
=> 'MAILHTML'
);
9. Oracle API to create FND Attachment:
set
serveroutput on
declare
l_rowid
VARCHAR2(100);
l_document_id
NUMBER;
l_filename
VARCHAR2(500);
l_attached_document_id
NUMBER;
l_media_id
NUMBER;
BEGIN
l_filename
:= 'Attachment Through API.';
SELECT
fnd_documents_s.NEXTVAL
INTO
l_document_id
FROM DUAL;
SELECT
fnd_attached_documents_s.NEXTVAL
INTO l_attached_document_id
FROM DUAL;
SELECT MAX
(media_id) + 1 INTO l_media_id
FROM
FND_DOCUMENTS_SHORT_TEXT;
INSERT INTO
FND_DOCUMENTS_SHORT_TEXT (MEDIA_ID, SHORT_TEXT, APP_SOURCE_VERSION)
VALUES
(l_media_id, 'Short Text For Attachment through API', NULL) ;
COMMIT;
fnd_documents_pkg.insert_row
(x_rowid
=> l_rowid,
x_document_id
=> l_document_id,
x_creation_date
=> SYSDATE,
x_created_by
=> 0,
x_last_update_date
=> SYSDATE,
x_last_updated_by
=> 0,
x_last_update_login
=> fnd_profile.VALUE('LOGIN_ID'),
x_datatype_id
=> 1,
--X_security_id
=> <security ID defined in your Attchments, Usaully SOB ID/ORG_ID..>,
x_publish_flag
=> 'Y',
x_category_id
=> 1,
x_security_type
=> 1,
x_usage_type
=> 'O',
x_language
=> USERENV('LANG'),
x_description
=> l_filename,
x_file_name =>
NULL,
x_media_id
=> l_media_id
);
commit;
fnd_documents_pkg.insert_tl_row
(x_document_id
=> l_document_id,
x_creation_date
=> SYSDATE,
x_created_by
=> 0,
x_last_update_date
=> SYSDATE,
x_last_updated_by
=> 0,
x_last_update_login
=> fnd_profile.VALUE('LOGIN_ID'),
x_language
=> USERENV('LANG'),
x_description
=> l_filename
);
COMMIT;
fnd_attached_documents_pkg.insert_row
(x_rowid
=> l_rowid,
x_attached_document_id
=> l_attached_document_id,
x_document_id
=> l_document_id,
x_creation_date
=> SYSDATE,
x_created_by
=> 0,
x_last_update_date
=> SYSDATE,
x_last_updated_by
=> 0,
x_last_update_login
=> fnd_profile.VALUE('LOGIN_ID'),
x_seq_num
=> 10,
x_entity_name
=> 'AP_INVOICES',
x_column1
=> NULL,
x_pk1_value
=> '1',
x_pk2_value
=> NULL,
x_pk3_value
=> NULL,
x_pk4_value
=> NULL,
x_pk5_value
=> NULL,
x_automatically_added_flag
=> 'N',
x_datatype_id
=> 1,
x_category_id
=> 1,
x_security_type
=> 4,
--X_security_id
=> <security ID defined in your Attchments, Usaully SOB ID/ORG_ID..>,
x_publish_flag
=> 'Y',
x_language
=> USERENV('LANG'),
x_description
=> l_filename,
x_file_name
=> NULL,
x_media_id
=> l_media_id
);
COMMIT;
DBMS_OUTPUT.put_line
('MEDIA ID CREATED IS ' || l_media_id||' Document ID: '||l_document_id);
EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT.put_line
('Error : '||SQLERRM);
END;
/
10. Oracle API to wait for the concurrent
request to complete:
fnd_concurrent.wait_for_request
(request_id => ln_request_id
,interval => 2
,max_wait => 60
-- out arguments
,phase => lc_phase
,status =>
lc_status
,dev_phase => lc_dev_phase
,dev_status => lc_dev_status
,message => lc_message
);
11. Oracle API to submit concurrent request with
XML/RTF Layout:
xml_layout
:= FND_REQUEST.ADD_LAYOUT( 'XXONT', --app_short_name
'GEPGS_DRAFT_INVOICE_REPORT_1', -- conc_prog_short_name,
'en',
'US',
'PDF');
v_request_id:= FND_REQUEST.SUBMIT_REQUEST (
'XXONT' --
application_short_name --
,'GEPGS_DRAFT_INVOICE_REPORT_1'
-- Conc. Short name
,'GEPGS Draft Invoice
Report' --Conc. Program Name
,SYSDATE
,NULL
,ln_set_of_books_id,lc_oe_id_flex_code,'D','Y'
,'','','','','','','','','','','','','','',''
,'SALES','ALL','','','Y','','','N','N','N','N'
,lc_order_num,'SINGLE','Y'
,ln_line_number,'','',''
,'','','',''
,'','','','','','','','','',''
,'','','','','','','','','',''
,'','','','','','','','','',''
,'','','','','','','','','',''
,'','','','','','','','','',''
,'','','','','','','','',''
);
12. Oracle API to submit WORKFLOW BACKGROUND
PROCESS concurrent request:
v_request_id:= FND_REQUEST.SUBMIT_REQUEST (
'FND' -- application_short_name
--
,'FNDWFBG' -- Conc. Short name
,'Workflow Background
Process' --Conc. Program Name
,SYSDATE
,NULL
,NULL,NULL,NULL,'Y','Y',
'','','','','','','','','','',
'','','','','','','','','','',
'','','','','','','','','','',
'','','','','','','','','','',
'','','','','','','','','','',
'','','','','','','','','','',
'','','','','','','','','','',
'','','','','','','','','','',
'','','','','','','','','','',
'','','','',''
);
No comments:
Post a Comment