1 PACKAGE IGC_CC_OPEN_INTERFACE_PKG AS
2 /* $Header: IGCCOPIS.pls 120.4.12000000.3 2007/11/07 11:54:42 bmaddine ship $ */
3
4 -- Main program which selects all the records from Header Interface table
5 -- and calls other programs for processing
6 PROCEDURE HEADER_INTERFACE_MAIN
7 ( ERRBUF OUT NOCOPY VARCHAR2,
8 RETCODE OUT NOCOPY VARCHAR2,
9 P_Process_Phase IN VARCHAR2,
10 P_Batch_Id IN NUMBER);
11
12 -- Validate the interface header record and return the result
13 PROCEDURE HEADER_INTERFACE_VALIDATE
14 ( P_Interface_Header_Id IN NUMBER,
15 P_Org_Id IN NUMBER,
16 P_Cc_Type IN VARCHAR2,
17 P_Cc_Num IN VARCHAR2,
18 P_Cc_Version_Num IN NUMBER,
19 p_Interface_Parent_Header_Id IN NUMBER,
20 P_Cc_State IN VARCHAR2,
21 P_Cc_Ctrl_Status IN VARCHAR2,
22 P_Cc_Encmbrnc_Status IN VARCHAR2,
23 P_Cc_Apprvl_Status IN VARCHAR2,
24 P_Vendor_Id IN NUMBER,
25 P_Vendor_Site_Id IN NUMBER,
26 P_Vendor_Contact_Id IN NUMBER,
27 P_Term_Id IN NUMBER,
28 P_Location_Id IN NUMBER,
29 P_Set_of_Books_Id IN NUMBER,
30 P_Cc_Acct_Date IN DATE,
31 P_Cc_Start_Date IN DATE,
32 P_Cc_End_Date IN DATE,
33 P_Cc_Owner_User_Id IN NUMBER,
34 P_Cc_Preparer_User_Id IN NUMBER,
35 P_Currency_Code IN VARCHAR2,
36 P_Conversion_Type IN VARCHAR2,
37 P_Conversion_Rate IN NUMBER,
38 P_Conversion_Date IN DATE,
39 P_Created_By IN NUMBER,
40 P_CC_Guarantee_Flag IN VARCHAR2,
41 P_CC_Current_User_Id IN NUMBER,
42 P_X_Error_Status IN OUT NOCOPY VARCHAR2,
43 P_Current_Org_Id IN NUMBER,
44 P_Current_Set_of_Books_Id IN NUMBER,
45 P_Func_Currency_Code IN VARCHAR2,
46 P_Cbc_Enable_Flag IN VARCHAR2);
47
48 -- Program which selects all the records from Acct Lines Interface table
49 -- for a particular Header record and calls other programs for processing
50 PROCEDURE ACCT_LINE_INTERFACE_MAIN
51 ( P_Interface_Header_Id IN NUMBER,
52 P_Header_Id IN NUMBER,
53 P_Int_Head_Parent_Header_Id IN NUMBER,
54 P_Parent_Header_Id IN NUMBER,
55 P_Org_Id IN NUMBER,
56 P_Set_of_Books_Id IN NUMBER,
57 P_Cc_Type IN VARCHAR2,
58 P_Cc_Encmbrnc_Status IN VARCHAR2,
59 P_Cc_Start_Date IN DATE,
60 P_Cc_End_Date IN DATE,
61 P_Cc_Acct_Date IN DATE,
62 P_User_Id IN NUMBER,
63 P_Login_Id IN NUMBER,
64 P_CC_State IN VARCHAR2,
65 P_CC_Apprvl_Status IN VARCHAR2,
66 P_X_Error_Status IN OUT NOCOPY VARCHAR2);
67
68 -- Validate the interface acct line record and return the result
69 PROCEDURE ACCT_LINE_INTERFACE_VALIDATE
70 ( P_Interface_Header_Id IN NUMBER,
71 P_Int_Head_Parent_Header_Id IN NUMBER,
72 P_Interface_Acct_Line_Id IN NUMBER,
73 P_Org_Id IN NUMBER,
74 P_Set_of_Books_Id IN NUMBER,
75 P_Cc_Type IN VARCHAR2,
76 P_Cc_Encmbrnc_Status IN VARCHAR2,
77 P_Cc_Start_Date IN DATE,
78 P_Cc_End_Date IN DATE,
79 P_Cc_Acct_Date IN DATE,
80 P_Interface_Parent_Header_Id IN NUMBER,
81 P_Interface_Parent_AcctLine_Id IN NUMBER,
82 P_Charge_Code_Combination_Id IN NUMBER,
83 P_Budget_Code_Combination_Id IN NUMBER,
84 P_Cc_Acct_Entered_Amt IN NUMBER,
85 P_Cc_Acct_Func_Amt IN NUMBER,
86 P_Cc_Acct_Encmbrnc_Amt IN NUMBER,
87 P_Cc_Acct_Encmbrnc_Date IN DATE,
88 P_Cc_Acct_Encmbrnc_Status IN VARCHAR2,
89 P_Project_Id IN NUMBER,
90 P_Task_Id IN NUMBER,
91 P_Expenditure_Type IN VARCHAR2,
92 P_Expenditure_Org_Id IN NUMBER,
93 P_Expenditure_Item_Date IN DATE,
94 P_Created_By IN NUMBER,
95 P_CC_Ent_Withheld_Amt IN NUMBER,
96 P_CC_Func_Withheld_Amt IN NUMBER,
97 P_CC_State IN VARCHAR2,
98 P_CC_Apprvl_Status IN VARCHAR2,
99 P_X_Error_Status IN OUT NOCOPY VARCHAR2);
100
101 -- Program which selects all the records from Det Pf Interface table for
102 -- a particular acct line and calls other programs for processing
103 PROCEDURE DET_PF_INTERFACE_MAIN
104 ( P_Interface_Header_Id IN NUMBER,
105 P_Interface_Acct_Line_Id IN NUMBER,
106 P_Acct_Line_Id IN NUMBER,
107 P_Int_Acct_Parent_AcctLine_Id IN NUMBER,
108 P_Parent_Acct_Line_Id IN NUMBER,
109 P_Org_Id IN NUMBER,
110 P_Set_of_Books_Id IN NUMBER,
111 P_Cc_Type IN VARCHAR2,
112 P_Cc_Encmbrnc_Status IN VARCHAR2,
113 P_Cc_Start_Date IN DATE,
114 P_Cc_End_Date IN DATE,
115 P_User_Id IN NUMBER,
116 P_Login_Id IN NUMBER,
117 P_header_Id IN NUMBER,
118 P_Project_Id IN NUMBER,
119 p_task_id IN NUMBER,
120 p_expenditure_type IN VARCHAR2,
121 p_expenditure_item_date IN DATE,
122 p_expenditure_org_id IN NUMBER,
123 p_cc_budget_ccid IN NUMBER,
124 P_X_Error_Status IN OUT NOCOPY VARCHAR2);
125
126 -- Validate the interface det pf record and return the result
127 PROCEDURE DET_PF_INTERFACE_VALIDATE
128 ( P_Interface_Header_Id IN NUMBER,
129 P_Interface_Acct_Line_Id IN NUMBER,
130 P_Int_Acct_Parent_AcctLine_Id IN NUMBER,
131 P_Interface_Det_Pf_Id IN NUMBER,
132 P_Org_Id IN NUMBER,
133 P_Set_of_Books_Id IN NUMBER,
134 P_Cc_Type IN VARCHAR2,
135 P_Cc_Encmbrnc_Status IN VARCHAR2,
136 P_Cc_Start_Date IN DATE,
137 P_Cc_End_Date IN DATE,
138 P_Interface_Parent_AcctLine_Id IN NUMBER,
139 P_Interface_Parent_Det_Pf_Id IN NUMBER,
140 P_Cc_Det_Pf_Date IN DATE,
141 P_Cc_Det_Pf_Entered_Amt IN NUMBER,
142 P_Cc_Det_Pf_Func_Amt IN NUMBER,
143 P_Cc_Det_Pf_Encmbrnc_Amt IN NUMBER,
144 P_Cc_Det_Pf_Encmbrnc_Date IN DATE,
145 P_Cc_Det_Pf_Encmbrnc_Status IN VARCHAR2,
146 P_Created_By IN NUMBER,
147 P_X_Error_Status IN OUT NOCOPY VARCHAR2);
148
149 END IGC_CC_OPEN_INTERFACE_PKG;