1 PACKAGE PA_XLA_INTERFACE_PKG AUTHID CURRENT_USER AS
2 -- $Header: PAXLAIFS.pls 120.11.12020000.3 2013/04/18 14:08:38 sisana 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 -- This procedure will derive the budget version to reverse (if any)
53 -- It will also derive budget status code of the current budget version
54
55 PROCEDURE GET_BVID_TO_REVERSE(p_budget_version_id IN NUMBER,
56 p_curr_budget_status_code OUT NOCOPY VARCHAR2,
57 p_old_budget_version_id OUT NOCOPY NUMBER);
58
59 -- This procedure will reset the event id information on the current budget
60 -- and the budget being reversed
61
62 PROCEDURE RESET_EVENT_ID (p_budget_version_id IN NUMBER,
63 p_curr_budget_status_code IN VARCHAR2,
64 p_old_budget_version_id IN NUMBER);
65 */
66 FUNCTION Get_Post_Acc_Sla_Ccid(
67 P_Acct_Event_Id IN PA_Cost_Distribution_Lines_All.Acct_Event_Id%TYPE
68 ,P_Transfer_Status_Code IN PA_Cost_Distribution_Lines_All.Transfer_Status_Code%TYPE
69 ,P_Transaction_Source IN PA_Expenditure_Items_All.Transaction_Source%TYPE
70 ,P_Historical_Flag IN PA_Expenditure_Items_All.Historical_Flag%TYPE
71 ,P_Distribution_Id_1 IN XLA_Distribution_Links.Source_Distribution_Id_Num_1%TYPE
72 ,P_Distribution_Id_2 IN XLA_Distribution_Links.Source_Distribution_Id_Num_2%TYPE
73 ,P_Distribution_Type IN VARCHAR2
74 ,P_Ccid IN PA_Cost_Distribution_Lines_All.Dr_Code_Combination_Id%TYPE DEFAULT NULL
75 ,P_Account_Type IN VARCHAR2 DEFAULT 'DEBIT'
76 ,P_Ledger_Id IN PA_Implementations_All.Set_Of_Books_Id%TYPE
77 )
78 RETURN NUMBER;
79
80 FUNCTION Get_Sla_Ccid( P_Application_Id NUMBER
81 ,P_Distribution_Id_1 NUMBER
82 ,P_Distribution_Id_2 NUMBER
83 ,P_Distribution_Type XLA_Distribution_Links.SOURCE_DISTRIBUTION_TYPE%TYPE
84 ,P_Account_Type VARCHAR2
85 ,P_Ledger_Id NUMBER
86 )
87 RETURN NUMBER;
88
89 END PA_XLA_INTERFACE_PKG;