1 PACKAGE PA_XLA_INTERFACE_PKG AUTHID CURRENT_USER AS
2 -- $Header: PAXLAIFS.pls 120.9.12000000.3 2007/11/23 09:27:43 rjayaram ship $
3
4 /*----------------------------------------------------------------------
5 * Parameter description :
6 * p_calling_module:
7 * This is the token that the calling process will pass.
8 * Based on this different code paths are executed.
9 * Valid values for this parameter are:
10 * LAB - for Straight Time and Over Time
11 * SUPP - for Expense Report Adjustments and Supplier Invoice
12 * Adjustments
13 * USG - for Usages
14 * PJ - for Miscellaneous
15 * INV - for Inventory
16 * WIP - for Work in Process
17 * BTC - for Burden Transactions
18 * TBC - for Burden on same line
19 * Cost - Encompasses all of the above.
20 *
21 * BL - for Borrow and Lend
22 * PC - for Provider Reclassification
23 * Revenue - for Revenue
24 *
25 * p_data_set_id:
26 * The meaning of this parameter is dependent on the calling module.
27 * - If the calling module is one of "Cost" related transactions, it is
28 * the request id of the process.
29 * - If the calling module is Budget Baseline process, then this is
30 * the budget_version_id that is baselined
31 * - If the calling module is Fundscheck process, then packet_id is
32 * passed.
33 *
34 * x_result_code:
35 * 'Success' or 'Failed' based on success or failure in raising
36 * an accounting event.
37 *---------------------------------------------------------------------*/
38
39
40 procedure create_events(p_calling_module IN VARCHAR2,
41 p_data_set_id IN NUMBER,
42 x_result_code OUT NOCOPY VARCHAR2);
43
44
45 -- function to return the accounting source
46 function get_source(p_transaction_source varchar2, p_payment_id number)
47 return varchar2;
48
49 -- procedure to populate accounting source and parent line number
50 procedure populate_acct_source;
51
52 FUNCTION Get_Post_Acc_Sla_Ccid(
53 P_Acct_Event_Id IN PA_Cost_Distribution_Lines_All.Acct_Event_Id%TYPE
54 ,P_Transfer_Status_Code IN PA_Cost_Distribution_Lines_All.Transfer_Status_Code%TYPE
55 ,P_Transaction_Source IN PA_Expenditure_Items_All.Transaction_Source%TYPE
56 ,P_Historical_Flag IN PA_Expenditure_Items_All.Historical_Flag%TYPE
57 ,P_Distribution_Id_1 IN XLA_Distribution_Links.Source_Distribution_Id_Num_1%TYPE
58 ,P_Distribution_Id_2 IN XLA_Distribution_Links.Source_Distribution_Id_Num_2%TYPE
59 ,P_Distribution_Type IN VARCHAR2
60 ,P_Ccid IN PA_Cost_Distribution_Lines_All.Dr_Code_Combination_Id%TYPE DEFAULT NULL
61 ,P_Account_Type IN VARCHAR2 DEFAULT 'DEBIT'
62 ,P_Ledger_Id IN PA_Implementations_All.Set_Of_Books_Id%TYPE
63 )
64 RETURN NUMBER;
65
66 FUNCTION Get_Sla_Ccid( P_Application_Id NUMBER
67 ,P_Distribution_Id_1 NUMBER
68 ,P_Distribution_Id_2 NUMBER
69 ,P_Distribution_Type XLA_Distribution_Links.SOURCE_DISTRIBUTION_TYPE%TYPE
70 ,P_Account_Type VARCHAR2
71 ,P_Ledger_Id NUMBER
72 )
73 RETURN NUMBER;
74
75 END PA_XLA_INTERFACE_PKG;