[Home] [Help]
PACKAGE: APPS.IGC_CC_ACCT_LINE_HISTORY_PKG
Source
1 PACKAGE IGC_CC_ACCT_LINE_HISTORY_PKG as
2 /* $Header: IGCCALHS.pls 120.3.12000000.3 2007/10/18 15:22:04 vumaasha ship $ */
3
4 /* ================================================================================
5 PROCEDURE Insert_Row
6 ===============================================================================*/
7
8 PROCEDURE Insert_Row(
9 p_api_version IN NUMBER,
10 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
11 p_commit IN VARCHAR2 := FND_API.G_FALSE,
12 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
13 X_return_status OUT NOCOPY VARCHAR2,
14 X_msg_count OUT NOCOPY NUMBER,
15 X_msg_data OUT NOCOPY VARCHAR2,
16 p_Rowid IN OUT NOCOPY VARCHAR2,
17 p_CC_Acct_Line_Id IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Line_Id%TYPE,
18 p_CC_Header_Id IGC_CC_ACCT_LINE_HISTORY.CC_Header_Id%TYPE,
19 p_Parent_Header_Id IGC_CC_ACCT_LINE_HISTORY.Parent_Header_Id%TYPE,
20 p_Parent_Acct_Line_Id IGC_CC_ACCT_LINE_HISTORY.Parent_Acct_Line_Id%TYPE,
21 p_CC_Acct_Line_Num IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Line_Num%TYPE,
22 p_CC_Acct_Version_Num IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Version_Num%TYPE,
23 p_CC_Acct_Version_Action IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Version_Action%TYPE,
24 p_CC_Charge_Code_Comb_Id IGC_CC_ACCT_LINE_HISTORY.CC_Charge_Code_Combination_Id%TYPE,
25 p_CC_Budget_Code_Comb_Id IGC_CC_ACCT_LINE_HISTORY.CC_Budget_Code_Combination_Id%TYPE,
26 p_CC_Acct_Entered_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Entered_Amt%TYPE,
27 p_CC_Acct_Func_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Func_Amt%TYPE,
28 p_CC_Acct_Desc IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Desc%TYPE,
29 p_CC_Acct_Billed_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Billed_Amt%TYPE,
30 p_CC_Acct_Unbilled_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Unbilled_Amt%TYPE,
31 p_CC_Acct_Taxable_Flag IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Taxable_Flag%TYPE,
32 p_Tax_Id IGC_CC_ACCT_LINE_HISTORY.Tax_Id%TYPE,
33 p_CC_Acct_Encmbrnc_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Amt%TYPE,
34 p_CC_Acct_Encmbrnc_Date IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Date%TYPE,
35 p_CC_Acct_Encmbrnc_Status IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Status%TYPE,
36 p_Project_Id IGC_CC_ACCT_LINE_HISTORY.Project_Id%TYPE,
37 p_Task_Id IGC_CC_ACCT_LINE_HISTORY.Task_Id%TYPE,
38 p_Expenditure_Type IGC_CC_ACCT_LINE_HISTORY.Expenditure_Type%TYPE,
39 p_Expenditure_Org_Id IGC_CC_ACCT_LINE_HISTORY.Expenditure_Org_Id%TYPE,
40 p_Expenditure_Item_Date IGC_CC_ACCT_LINE_HISTORY.Expenditure_Item_Date%TYPE,
41 p_Last_Update_Date IGC_CC_ACCT_LINE_HISTORY.Last_Update_Date%TYPE,
42 p_Last_Updated_By IGC_CC_ACCT_LINE_HISTORY.Last_Updated_By%TYPE,
43 p_Last_Update_Login IGC_CC_ACCT_LINE_HISTORY.Last_Update_Login%TYPE,
44 p_Creation_Date IGC_CC_ACCT_LINE_HISTORY.Creation_Date%TYPE,
45 p_Created_By IGC_CC_ACCT_LINE_HISTORY.Created_By%TYPE,
46 p_Attribute1 IGC_CC_ACCT_LINE_HISTORY.Attribute1%TYPE,
47 p_Attribute2 IGC_CC_ACCT_LINE_HISTORY.Attribute2%TYPE,
48 p_Attribute3 IGC_CC_ACCT_LINE_HISTORY.Attribute3%TYPE,
49 p_Attribute4 IGC_CC_ACCT_LINE_HISTORY.Attribute4%TYPE,
50 p_Attribute5 IGC_CC_ACCT_LINE_HISTORY.Attribute5%TYPE,
51 p_Attribute6 IGC_CC_ACCT_LINE_HISTORY.Attribute6%TYPE,
52 p_Attribute7 IGC_CC_ACCT_LINE_HISTORY.Attribute7%TYPE,
53 p_Attribute8 IGC_CC_ACCT_LINE_HISTORY.Attribute8%TYPE,
54 p_Attribute9 IGC_CC_ACCT_LINE_HISTORY.Attribute9%TYPE,
55 p_Attribute10 IGC_CC_ACCT_LINE_HISTORY.Attribute10%TYPE,
56 p_Attribute11 IGC_CC_ACCT_LINE_HISTORY.Attribute11%TYPE,
57 p_Attribute12 IGC_CC_ACCT_LINE_HISTORY.Attribute12%TYPE,
58 p_Attribute13 IGC_CC_ACCT_LINE_HISTORY.Attribute13%TYPE,
59 p_Attribute14 IGC_CC_ACCT_LINE_HISTORY.Attribute14%TYPE,
60 p_Attribute15 IGC_CC_ACCT_LINE_HISTORY.Attribute15%TYPE,
61 p_Context IGC_CC_ACCT_LINE_HISTORY.Context%TYPE,
62 p_cc_func_withheld_amt IGC_CC_ACCT_LINE_HISTORY.cc_func_withheld_amt%TYPE,
63 p_cc_ent_withheld_amt IGC_CC_ACCT_LINE_HISTORY.cc_ent_withheld_amt%TYPE,
64 G_FLAG IN OUT NOCOPY VARCHAR2,
65 P_Tax_Classif_Code IGC_CC_ACCT_LINE_HISTORY.Tax_Classif_Code%TYPE
66 );
67
68 /* ================================================================================
69 PROCEDURE Lock_Row
70 ===============================================================================*/
71
72
73 PROCEDURE Lock_Row (
74 p_api_version IN NUMBER,
75 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
76 p_commit IN VARCHAR2 := FND_API.G_FALSE,
77 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
78 X_return_status OUT NOCOPY VARCHAR2,
79 X_msg_count OUT NOCOPY NUMBER,
80 X_msg_data OUT NOCOPY VARCHAR2,
81 p_Rowid IN OUT NOCOPY VARCHAR2,
82 p_CC_Acct_Line_Id IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Line_Id%TYPE,
83 p_CC_Header_Id IGC_CC_ACCT_LINE_HISTORY.CC_Header_Id%TYPE,
84 p_Parent_Header_Id IGC_CC_ACCT_LINE_HISTORY.Parent_Header_Id%TYPE,
85 p_Parent_Acct_Line_Id IGC_CC_ACCT_LINE_HISTORY.Parent_Acct_Line_Id%TYPE,
86 p_CC_Acct_Line_Num IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Line_Num%TYPE,
87 p_CC_Acct_Version_Num IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Version_Num%TYPE,
88 p_CC_Acct_Version_Action IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Version_Action%TYPE,
89 p_CC_Charge_Code_Comb_Id IGC_CC_ACCT_LINE_HISTORY.CC_Charge_Code_Combination_Id%TYPE,
90 p_CC_Budget_Code_Comb_Id IGC_CC_ACCT_LINE_HISTORY.CC_Budget_Code_Combination_Id%TYPE,
91 p_CC_Acct_Entered_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Entered_Amt%TYPE,
92 p_CC_Acct_Func_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Func_Amt%TYPE,
93 p_CC_Acct_Desc IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Desc%TYPE,
94 p_CC_Acct_Billed_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Billed_Amt%TYPE,
95 p_CC_Acct_Unbilled_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Unbilled_Amt%TYPE,
96 p_CC_Acct_Taxable_Flag IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Taxable_Flag%TYPE,
97 p_Tax_Id IGC_CC_ACCT_LINE_HISTORY.Tax_Id%TYPE,
98 p_CC_Acct_Encmbrnc_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Amt%TYPE,
99 p_CC_Acct_Encmbrnc_Date IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Date%TYPE,
100 p_CC_Acct_Encmbrnc_Status IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Status%TYPE,
101 p_Project_Id IGC_CC_ACCT_LINE_HISTORY.Project_Id%TYPE,
102 p_Task_Id IGC_CC_ACCT_LINE_HISTORY.Task_Id%TYPE,
103 p_Expenditure_Type IGC_CC_ACCT_LINE_HISTORY.Expenditure_Type%TYPE,
104 p_Expenditure_Org_Id IGC_CC_ACCT_LINE_HISTORY.Expenditure_Org_Id%TYPE,
105 p_Expenditure_Item_Date IGC_CC_ACCT_LINE_HISTORY.Expenditure_Item_Date%TYPE,
106 p_Last_Update_Date IGC_CC_ACCT_LINE_HISTORY.Last_Update_Date%TYPE,
107 p_Last_Updated_By IGC_CC_ACCT_LINE_HISTORY.Last_Updated_By%TYPE,
108 p_Last_Update_Login IGC_CC_ACCT_LINE_HISTORY.Last_Update_Login%TYPE,
109 p_Creation_Date IGC_CC_ACCT_LINE_HISTORY.Creation_Date%TYPE,
110 p_Created_By IGC_CC_ACCT_LINE_HISTORY.Created_By%TYPE,
111 p_Attribute1 IGC_CC_ACCT_LINE_HISTORY.Attribute1%TYPE,
112 p_Attribute2 IGC_CC_ACCT_LINE_HISTORY.Attribute2%TYPE,
113 p_Attribute3 IGC_CC_ACCT_LINE_HISTORY.Attribute3%TYPE,
114 p_Attribute4 IGC_CC_ACCT_LINE_HISTORY.Attribute4%TYPE,
115 p_Attribute5 IGC_CC_ACCT_LINE_HISTORY.Attribute5%TYPE,
116 p_Attribute6 IGC_CC_ACCT_LINE_HISTORY.Attribute6%TYPE,
117 p_Attribute7 IGC_CC_ACCT_LINE_HISTORY.Attribute7%TYPE,
118 p_Attribute8 IGC_CC_ACCT_LINE_HISTORY.Attribute8%TYPE,
119 p_Attribute9 IGC_CC_ACCT_LINE_HISTORY.Attribute9%TYPE,
120 p_Attribute10 IGC_CC_ACCT_LINE_HISTORY.Attribute10%TYPE,
121 p_Attribute11 IGC_CC_ACCT_LINE_HISTORY.Attribute11%TYPE,
122 p_Attribute12 IGC_CC_ACCT_LINE_HISTORY.Attribute12%TYPE,
123 p_Attribute13 IGC_CC_ACCT_LINE_HISTORY.Attribute13%TYPE,
124 p_Attribute14 IGC_CC_ACCT_LINE_HISTORY.Attribute14%TYPE,
125 p_Attribute15 IGC_CC_ACCT_LINE_HISTORY.Attribute15%TYPE,
126 p_Context IGC_CC_ACCT_LINE_HISTORY.Context%TYPE,
127 p_cc_func_withheld_amt IGC_CC_ACCT_LINE_HISTORY.cc_func_withheld_amt%TYPE,
128 p_cc_ent_withheld_amt IGC_CC_ACCT_LINE_HISTORY.cc_ent_withheld_amt%TYPE,
129 X_row_locked OUT NOCOPY VARCHAR2,
130 G_FLAG IN OUT NOCOPY VARCHAR2,
131 P_Tax_Classif_Code IGC_CC_ACCT_LINE_HISTORY.Tax_Classif_Code%TYPE
132 );
133
134
135 /* ================================================================================
136 PROCEDURE Update_Row
137 ===============================================================================*/
138
139 PROCEDURE Update_Row(
140 p_api_version IN NUMBER,
141 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
142 p_commit IN VARCHAR2 := FND_API.G_FALSE,
143 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
144 X_return_status OUT NOCOPY VARCHAR2,
145 X_msg_count OUT NOCOPY NUMBER,
146 X_msg_data OUT NOCOPY VARCHAR2,
147 p_Rowid IN OUT NOCOPY VARCHAR2,
148 p_CC_Acct_Line_Id IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Line_Id%TYPE,
149 p_CC_Header_Id IGC_CC_ACCT_LINE_HISTORY.CC_Header_Id%TYPE,
150 p_Parent_Header_Id IGC_CC_ACCT_LINE_HISTORY.Parent_Header_Id%TYPE,
151 p_Parent_Acct_Line_Id IGC_CC_ACCT_LINE_HISTORY.Parent_Acct_Line_Id%TYPE,
152 p_CC_Acct_Line_Num IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Line_Num%TYPE,
153 p_CC_Acct_Version_Num IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Version_Num%TYPE,
154 p_CC_Acct_Version_Action IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Version_Action%TYPE,
155 p_CC_Charge_Code_Comb_Id IGC_CC_ACCT_LINE_HISTORY.CC_Charge_Code_Combination_Id%TYPE,
156 p_CC_Budget_Code_Comb_Id IGC_CC_ACCT_LINE_HISTORY.CC_Budget_Code_Combination_Id%TYPE,
157 p_CC_Acct_Entered_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Entered_Amt%TYPE,
158 p_CC_Acct_Func_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Func_Amt%TYPE,
159 p_CC_Acct_Desc IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Desc%TYPE,
160 p_CC_Acct_Billed_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Billed_Amt%TYPE,
161 p_CC_Acct_Unbilled_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Unbilled_Amt%TYPE,
162 p_CC_Acct_Taxable_Flag IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Taxable_Flag%TYPE,
163 p_Tax_Id IGC_CC_ACCT_LINE_HISTORY.Tax_Id%TYPE,
164 p_CC_Acct_Encmbrnc_Amt IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Amt%TYPE,
165 p_CC_Acct_Encmbrnc_Date IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Date%TYPE,
166 p_CC_Acct_Encmbrnc_Status IGC_CC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Status%TYPE,
167 p_Project_Id IGC_CC_ACCT_LINE_HISTORY.Project_Id%TYPE,
168 p_Task_Id IGC_CC_ACCT_LINE_HISTORY.Task_Id%TYPE,
169 p_Expenditure_Type IGC_CC_ACCT_LINE_HISTORY.Expenditure_Type%TYPE,
170 p_Expenditure_Org_Id IGC_CC_ACCT_LINE_HISTORY.Expenditure_Org_Id%TYPE,
171 p_Expenditure_Item_Date IGC_CC_ACCT_LINE_HISTORY.Expenditure_Item_Date%TYPE,
172 p_Last_Update_Date IGC_CC_ACCT_LINE_HISTORY.Last_Update_Date%TYPE,
173 p_Last_Updated_By IGC_CC_ACCT_LINE_HISTORY.Last_Updated_By%TYPE,
174 p_Last_Update_Login IGC_CC_ACCT_LINE_HISTORY.Last_Update_Login%TYPE,
175 p_Creation_Date IGC_CC_ACCT_LINE_HISTORY.Creation_Date%TYPE,
176 p_Created_By IGC_CC_ACCT_LINE_HISTORY.Created_By%TYPE,
177 p_Attribute1 IGC_CC_ACCT_LINE_HISTORY.Attribute1%TYPE,
178 p_Attribute2 IGC_CC_ACCT_LINE_HISTORY.Attribute2%TYPE,
179 p_Attribute3 IGC_CC_ACCT_LINE_HISTORY.Attribute3%TYPE,
180 p_Attribute4 IGC_CC_ACCT_LINE_HISTORY.Attribute4%TYPE,
181 p_Attribute5 IGC_CC_ACCT_LINE_HISTORY.Attribute5%TYPE,
182 p_Attribute6 IGC_CC_ACCT_LINE_HISTORY.Attribute6%TYPE,
183 p_Attribute7 IGC_CC_ACCT_LINE_HISTORY.Attribute7%TYPE,
184 p_Attribute8 IGC_CC_ACCT_LINE_HISTORY.Attribute8%TYPE,
185 p_Attribute9 IGC_CC_ACCT_LINE_HISTORY.Attribute9%TYPE,
186 p_Attribute10 IGC_CC_ACCT_LINE_HISTORY.Attribute10%TYPE,
187 p_Attribute11 IGC_CC_ACCT_LINE_HISTORY.Attribute11%TYPE,
188 p_Attribute12 IGC_CC_ACCT_LINE_HISTORY.Attribute12%TYPE,
189 p_Attribute13 IGC_CC_ACCT_LINE_HISTORY.Attribute13%TYPE,
190 p_Attribute14 IGC_CC_ACCT_LINE_HISTORY.Attribute14%TYPE,
191 p_Attribute15 IGC_CC_ACCT_LINE_HISTORY.Attribute15%TYPE,
192 p_Context IGC_CC_ACCT_LINE_HISTORY.Context%TYPE,
193 p_cc_func_withheld_amt IGC_CC_ACCT_LINE_HISTORY.cc_func_withheld_amt%TYPE,
194 p_cc_ent_withheld_amt IGC_CC_ACCT_LINE_HISTORY.cc_ent_withheld_amt%TYPE,
195 G_FLAG IN OUT NOCOPY VARCHAR2,
196 P_Tax_Classif_Code IGC_CC_ACCT_LINE_HISTORY.Tax_Classif_Code%TYPE
197 );
198
199
200 /* ================================================================================
201 PROCEDURE Delete_Row
202 ===============================================================================*/
203
204 PROCEDURE Delete_Row(
205 p_api_version IN NUMBER,
206 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
207 p_commit IN VARCHAR2 := FND_API.G_FALSE,
208 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
209 X_return_status OUT NOCOPY VARCHAR2,
210 X_msg_count OUT NOCOPY NUMBER,
211 X_msg_data OUT NOCOPY VARCHAR2,
215
212 p_Rowid VARCHAR2,
213 G_FLAG IN OUT NOCOPY VARCHAR2
214 );
216 END IGC_CC_ACCT_LINE_HISTORY_PKG;