1 PACKAGE pa_ap_integration AS
2 --$Header: PAAPINTS.pls 120.3 2006/05/08 15:31:40 aaggarwa noship $
3
4
5 PROCEDURE upd_pa_details_supplier_merge
6 ( p_old_vendor_id IN po_vendors.vendor_id%type,
7 p_new_vendor_id IN po_vendors.vendor_id%type,
8 p_paid_inv_flag IN ap_invoices_all.PAYMENT_STATUS_FLAG%type,
9 x_stage OUT NOCOPY VARCHAR2,
10 x_status OUT NOCOPY VARCHAR2);
11
12
13 FUNCTION Allow_Supplier_Merge ( p_vendor_id IN po_vendors.vendor_id%type)
14 RETURN varchar2;
15
16 PROCEDURE get_asset_addition_flag
17 (p_project_id IN pa_projects_all.project_id%TYPE,
18 x_asset_addition_flag OUT NOCOPY ap_invoice_distributions_all.assets_addition_flag%TYPE);
19
20 FUNCTION Get_Project_Type ( p_project_id IN pa_projects_all.project_id%TYPE)
21 RETURN varchar2;
22
23 -- ==========================================================================================================================================
24 -- Bug 5201382 R12.PJ:XB3:DEV:NEW API TO RETRIEVE THE DATES FOR PROFILE PA_AP_EI_DATE_DEFAULT
25 -- p_transaction_date : API would return transaction date when profile value was set to 'Transaction Date'
26 -- a. For Invoice transaction invoice_date should be passed as parameter
27 -- b. For PO or Receipt Matched Invoice Transactions invoice_date should be passed as parameter
28 -- c. For RCV Transactions transaction_date should be passed.
29 -- d. For payments and discounts ap dist exp_item_date should be passed.
30 -- p_gl_date : API would return transaction date when profile value was set to 'Transaction GL Date'
31 -- a. For Invoice transactions gl_date should be passed b. For payments and discounts the accounting date must be passed
32 -- c. for RCV transactions accounting date should be passed.
33 -- p_po_exp_item_date : API would return the purchase order expenditure item date for po matched cases when profile value was set to
34 -- 'PO Expenditure Item Date/Transaction Date'. This is used for PO matched cases. It may be NULL when
35 -- p_po_distribution_id was passed to the API.
36 -- p_po_distribution_id: The parameter value is used to determine the purchase order expenditure item date for po matched cases when profile
37 -- value was set to 'PO Expenditure Item Date/Transaction Date'. when p_po_exp_item_date was passed then
38 -- p_po_distribution_id is not used to derive the expenditure item date.
39 -- p_creation_date : API would return this date when profile value was set to 'Transaction System Date'
40 -- p_calling_program : a. when called during the PO Match case : PO-MATCH b. When called from Invoice form : APXINWKB
41 -- c. When called from supplier cost xface for discounts : DISCOUNT d. When called from supplier cost xface for Payment: PAYMENT
42 -- e. When called from supplier cost xface for Receipts : RECEIPT
43 -- ==========================================================================================================================================
44 FUNCTION Get_si_cost_exp_item_date ( p_transaction_date IN pa_expenditure_items_all.expenditure_item_date%TYPE,
45 p_gl_date IN pa_cost_distribution_lines_all.gl_date%TYPE,
46 p_po_exp_item_date IN pa_expenditure_items_all.expenditure_item_date%TYPE,
47 p_creation_date IN pa_expenditure_items_all.creation_date%TYPE,
48 p_po_distribution_id IN pa_expenditure_items_all.document_distribution_id%TYPE,
49 p_calling_program IN varchar2 )
50 RETURN date ;
51
52 FUNCTION Get_si_default_exp_org RETURN varchar2 ;
53
54 END pa_ap_integration;