eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGC_CC_MC_ACCT_LINE_HST_PKG dependencies on IGC_CC_MC_ACCT_LINE_HISTORY

Line 20: p_CC_Acct_Line_Id IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Line_Id%TYPE,

16: X_return_status OUT NOCOPY VARCHAR2,
17: X_msg_count OUT NOCOPY NUMBER,
18: X_msg_data OUT NOCOPY VARCHAR2,
19: p_Rowid IN OUT NOCOPY VARCHAR2,
20: p_CC_Acct_Line_Id IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Line_Id%TYPE,
21: p_Set_Of_Books_Id IGC_CC_MC_ACCT_LINE_HISTORY.Set_Of_Books_Id%TYPE,
22: p_CC_Acct_Func_Amt IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Func_Amt%TYPE,
23: p_CC_Acct_Encmbrnc_Amt IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Amt%TYPE,
24: p_cc_acct_version_num IGC_CC_MC_ACCT_LINE_HISTORY.CC_ACCT_VERSION_NUM%TYPE,

Line 21: p_Set_Of_Books_Id IGC_CC_MC_ACCT_LINE_HISTORY.Set_Of_Books_Id%TYPE,

17: X_msg_count OUT NOCOPY NUMBER,
18: X_msg_data OUT NOCOPY VARCHAR2,
19: p_Rowid IN OUT NOCOPY VARCHAR2,
20: p_CC_Acct_Line_Id IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Line_Id%TYPE,
21: p_Set_Of_Books_Id IGC_CC_MC_ACCT_LINE_HISTORY.Set_Of_Books_Id%TYPE,
22: p_CC_Acct_Func_Amt IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Func_Amt%TYPE,
23: p_CC_Acct_Encmbrnc_Amt IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Amt%TYPE,
24: p_cc_acct_version_num IGC_CC_MC_ACCT_LINE_HISTORY.CC_ACCT_VERSION_NUM%TYPE,
25: p_cc_acct_version_action IGC_CC_MC_ACCT_LINE_HISTORY.CC_ACCT_VERSION_ACTION%TYPE,

Line 22: p_CC_Acct_Func_Amt IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Func_Amt%TYPE,

18: X_msg_data OUT NOCOPY VARCHAR2,
19: p_Rowid IN OUT NOCOPY VARCHAR2,
20: p_CC_Acct_Line_Id IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Line_Id%TYPE,
21: p_Set_Of_Books_Id IGC_CC_MC_ACCT_LINE_HISTORY.Set_Of_Books_Id%TYPE,
22: p_CC_Acct_Func_Amt IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Func_Amt%TYPE,
23: p_CC_Acct_Encmbrnc_Amt IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Amt%TYPE,
24: p_cc_acct_version_num IGC_CC_MC_ACCT_LINE_HISTORY.CC_ACCT_VERSION_NUM%TYPE,
25: p_cc_acct_version_action IGC_CC_MC_ACCT_LINE_HISTORY.CC_ACCT_VERSION_ACTION%TYPE,
26: p_Conversion_Type IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Type%TYPE,

Line 23: p_CC_Acct_Encmbrnc_Amt IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Amt%TYPE,

19: p_Rowid IN OUT NOCOPY VARCHAR2,
20: p_CC_Acct_Line_Id IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Line_Id%TYPE,
21: p_Set_Of_Books_Id IGC_CC_MC_ACCT_LINE_HISTORY.Set_Of_Books_Id%TYPE,
22: p_CC_Acct_Func_Amt IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Func_Amt%TYPE,
23: p_CC_Acct_Encmbrnc_Amt IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Amt%TYPE,
24: p_cc_acct_version_num IGC_CC_MC_ACCT_LINE_HISTORY.CC_ACCT_VERSION_NUM%TYPE,
25: p_cc_acct_version_action IGC_CC_MC_ACCT_LINE_HISTORY.CC_ACCT_VERSION_ACTION%TYPE,
26: p_Conversion_Type IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Type%TYPE,
27: p_Conversion_Date IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Date%TYPE,

Line 24: p_cc_acct_version_num IGC_CC_MC_ACCT_LINE_HISTORY.CC_ACCT_VERSION_NUM%TYPE,

20: p_CC_Acct_Line_Id IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Line_Id%TYPE,
21: p_Set_Of_Books_Id IGC_CC_MC_ACCT_LINE_HISTORY.Set_Of_Books_Id%TYPE,
22: p_CC_Acct_Func_Amt IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Func_Amt%TYPE,
23: p_CC_Acct_Encmbrnc_Amt IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Amt%TYPE,
24: p_cc_acct_version_num IGC_CC_MC_ACCT_LINE_HISTORY.CC_ACCT_VERSION_NUM%TYPE,
25: p_cc_acct_version_action IGC_CC_MC_ACCT_LINE_HISTORY.CC_ACCT_VERSION_ACTION%TYPE,
26: p_Conversion_Type IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Type%TYPE,
27: p_Conversion_Date IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Date%TYPE,
28: p_Conversion_Rate IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Rate%TYPE ,

Line 25: p_cc_acct_version_action IGC_CC_MC_ACCT_LINE_HISTORY.CC_ACCT_VERSION_ACTION%TYPE,

21: p_Set_Of_Books_Id IGC_CC_MC_ACCT_LINE_HISTORY.Set_Of_Books_Id%TYPE,
22: p_CC_Acct_Func_Amt IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Func_Amt%TYPE,
23: p_CC_Acct_Encmbrnc_Amt IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Amt%TYPE,
24: p_cc_acct_version_num IGC_CC_MC_ACCT_LINE_HISTORY.CC_ACCT_VERSION_NUM%TYPE,
25: p_cc_acct_version_action IGC_CC_MC_ACCT_LINE_HISTORY.CC_ACCT_VERSION_ACTION%TYPE,
26: p_Conversion_Type IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Type%TYPE,
27: p_Conversion_Date IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Date%TYPE,
28: p_Conversion_Rate IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Rate%TYPE ,
29: p_cc_func_withheld_amt IGC_CC_MC_ACCT_LINE_HISTORY.cc_func_withheld_amt%TYPE

Line 26: p_Conversion_Type IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Type%TYPE,

22: p_CC_Acct_Func_Amt IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Func_Amt%TYPE,
23: p_CC_Acct_Encmbrnc_Amt IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Amt%TYPE,
24: p_cc_acct_version_num IGC_CC_MC_ACCT_LINE_HISTORY.CC_ACCT_VERSION_NUM%TYPE,
25: p_cc_acct_version_action IGC_CC_MC_ACCT_LINE_HISTORY.CC_ACCT_VERSION_ACTION%TYPE,
26: p_Conversion_Type IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Type%TYPE,
27: p_Conversion_Date IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Date%TYPE,
28: p_Conversion_Rate IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Rate%TYPE ,
29: p_cc_func_withheld_amt IGC_CC_MC_ACCT_LINE_HISTORY.cc_func_withheld_amt%TYPE
30: )

Line 27: p_Conversion_Date IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Date%TYPE,

23: p_CC_Acct_Encmbrnc_Amt IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Amt%TYPE,
24: p_cc_acct_version_num IGC_CC_MC_ACCT_LINE_HISTORY.CC_ACCT_VERSION_NUM%TYPE,
25: p_cc_acct_version_action IGC_CC_MC_ACCT_LINE_HISTORY.CC_ACCT_VERSION_ACTION%TYPE,
26: p_Conversion_Type IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Type%TYPE,
27: p_Conversion_Date IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Date%TYPE,
28: p_Conversion_Rate IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Rate%TYPE ,
29: p_cc_func_withheld_amt IGC_CC_MC_ACCT_LINE_HISTORY.cc_func_withheld_amt%TYPE
30: )
31:

Line 28: p_Conversion_Rate IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Rate%TYPE ,

24: p_cc_acct_version_num IGC_CC_MC_ACCT_LINE_HISTORY.CC_ACCT_VERSION_NUM%TYPE,
25: p_cc_acct_version_action IGC_CC_MC_ACCT_LINE_HISTORY.CC_ACCT_VERSION_ACTION%TYPE,
26: p_Conversion_Type IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Type%TYPE,
27: p_Conversion_Date IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Date%TYPE,
28: p_Conversion_Rate IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Rate%TYPE ,
29: p_cc_func_withheld_amt IGC_CC_MC_ACCT_LINE_HISTORY.cc_func_withheld_amt%TYPE
30: )
31:
32: IS

Line 29: p_cc_func_withheld_amt IGC_CC_MC_ACCT_LINE_HISTORY.cc_func_withheld_amt%TYPE

25: p_cc_acct_version_action IGC_CC_MC_ACCT_LINE_HISTORY.CC_ACCT_VERSION_ACTION%TYPE,
26: p_Conversion_Type IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Type%TYPE,
27: p_Conversion_Date IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Date%TYPE,
28: p_Conversion_Rate IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Rate%TYPE ,
29: p_cc_func_withheld_amt IGC_CC_MC_ACCT_LINE_HISTORY.cc_func_withheld_amt%TYPE
30: )
31:
32: IS
33:

Line 39: FROM IGC_CC_MC_ACCT_LINE_HISTORY

35: l_api_version CONSTANT NUMBER := 1.0;
36:
37: CURSOR C_Acct_mrc_hst_rowid
38: IS SELECT Rowid
39: FROM IGC_CC_MC_ACCT_LINE_HISTORY
40: WHERE CC_Acct_Line_Id = p_CC_Acct_Line_Id;
41:
42: BEGIN
43:

Line 66: INSERT INTO IGC_CC_MC_ACCT_LINE_HISTORY (

62: X_return_status := FND_API.G_RET_STS_SUCCESS ;
63: -- -----------------------------------------------------------------
64: -- Insert the MRC Account line history record as requested.
65: -- -----------------------------------------------------------------
66: INSERT INTO IGC_CC_MC_ACCT_LINE_HISTORY (
67: CC_Acct_Line_Id,
68: Set_Of_Books_Id,
69: CC_Acct_Func_Amt,
70: CC_Acct_Encmbrnc_Amt,

Line 170: p_CC_Acct_Line_Id IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Line_Id%TYPE,

166: X_return_status OUT NOCOPY VARCHAR2,
167: X_msg_count OUT NOCOPY NUMBER,
168: X_msg_data OUT NOCOPY VARCHAR2,
169: p_Rowid IN OUT NOCOPY VARCHAR2,
170: p_CC_Acct_Line_Id IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Line_Id%TYPE,
171: p_Set_Of_Books_Id IGC_CC_MC_ACCT_LINE_HISTORY.Set_Of_Books_Id%TYPE,
172: p_CC_Acct_Func_Amt IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Func_Amt%TYPE,
173: p_CC_Acct_Encmbrnc_Amt IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Amt%TYPE,
174: p_cc_acct_version_num IGC_CC_MC_ACCT_LINE_HISTORY.CC_ACCT_VERSION_NUM%TYPE,

Line 171: p_Set_Of_Books_Id IGC_CC_MC_ACCT_LINE_HISTORY.Set_Of_Books_Id%TYPE,

167: X_msg_count OUT NOCOPY NUMBER,
168: X_msg_data OUT NOCOPY VARCHAR2,
169: p_Rowid IN OUT NOCOPY VARCHAR2,
170: p_CC_Acct_Line_Id IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Line_Id%TYPE,
171: p_Set_Of_Books_Id IGC_CC_MC_ACCT_LINE_HISTORY.Set_Of_Books_Id%TYPE,
172: p_CC_Acct_Func_Amt IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Func_Amt%TYPE,
173: p_CC_Acct_Encmbrnc_Amt IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Amt%TYPE,
174: p_cc_acct_version_num IGC_CC_MC_ACCT_LINE_HISTORY.CC_ACCT_VERSION_NUM%TYPE,
175: p_cc_acct_version_action IGC_CC_MC_ACCT_LINE_HISTORY.CC_ACCT_VERSION_ACTION%TYPE,

Line 172: p_CC_Acct_Func_Amt IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Func_Amt%TYPE,

168: X_msg_data OUT NOCOPY VARCHAR2,
169: p_Rowid IN OUT NOCOPY VARCHAR2,
170: p_CC_Acct_Line_Id IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Line_Id%TYPE,
171: p_Set_Of_Books_Id IGC_CC_MC_ACCT_LINE_HISTORY.Set_Of_Books_Id%TYPE,
172: p_CC_Acct_Func_Amt IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Func_Amt%TYPE,
173: p_CC_Acct_Encmbrnc_Amt IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Amt%TYPE,
174: p_cc_acct_version_num IGC_CC_MC_ACCT_LINE_HISTORY.CC_ACCT_VERSION_NUM%TYPE,
175: p_cc_acct_version_action IGC_CC_MC_ACCT_LINE_HISTORY.CC_ACCT_VERSION_ACTION%TYPE,
176: p_Conversion_Type IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Type%TYPE,

Line 173: p_CC_Acct_Encmbrnc_Amt IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Amt%TYPE,

169: p_Rowid IN OUT NOCOPY VARCHAR2,
170: p_CC_Acct_Line_Id IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Line_Id%TYPE,
171: p_Set_Of_Books_Id IGC_CC_MC_ACCT_LINE_HISTORY.Set_Of_Books_Id%TYPE,
172: p_CC_Acct_Func_Amt IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Func_Amt%TYPE,
173: p_CC_Acct_Encmbrnc_Amt IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Amt%TYPE,
174: p_cc_acct_version_num IGC_CC_MC_ACCT_LINE_HISTORY.CC_ACCT_VERSION_NUM%TYPE,
175: p_cc_acct_version_action IGC_CC_MC_ACCT_LINE_HISTORY.CC_ACCT_VERSION_ACTION%TYPE,
176: p_Conversion_Type IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Type%TYPE,
177: p_Conversion_Date IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Date%TYPE,

Line 174: p_cc_acct_version_num IGC_CC_MC_ACCT_LINE_HISTORY.CC_ACCT_VERSION_NUM%TYPE,

170: p_CC_Acct_Line_Id IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Line_Id%TYPE,
171: p_Set_Of_Books_Id IGC_CC_MC_ACCT_LINE_HISTORY.Set_Of_Books_Id%TYPE,
172: p_CC_Acct_Func_Amt IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Func_Amt%TYPE,
173: p_CC_Acct_Encmbrnc_Amt IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Amt%TYPE,
174: p_cc_acct_version_num IGC_CC_MC_ACCT_LINE_HISTORY.CC_ACCT_VERSION_NUM%TYPE,
175: p_cc_acct_version_action IGC_CC_MC_ACCT_LINE_HISTORY.CC_ACCT_VERSION_ACTION%TYPE,
176: p_Conversion_Type IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Type%TYPE,
177: p_Conversion_Date IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Date%TYPE,
178: p_Conversion_Rate IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Rate%TYPE,

Line 175: p_cc_acct_version_action IGC_CC_MC_ACCT_LINE_HISTORY.CC_ACCT_VERSION_ACTION%TYPE,

171: p_Set_Of_Books_Id IGC_CC_MC_ACCT_LINE_HISTORY.Set_Of_Books_Id%TYPE,
172: p_CC_Acct_Func_Amt IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Func_Amt%TYPE,
173: p_CC_Acct_Encmbrnc_Amt IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Amt%TYPE,
174: p_cc_acct_version_num IGC_CC_MC_ACCT_LINE_HISTORY.CC_ACCT_VERSION_NUM%TYPE,
175: p_cc_acct_version_action IGC_CC_MC_ACCT_LINE_HISTORY.CC_ACCT_VERSION_ACTION%TYPE,
176: p_Conversion_Type IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Type%TYPE,
177: p_Conversion_Date IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Date%TYPE,
178: p_Conversion_Rate IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Rate%TYPE,
179: p_cc_func_withheld_amt IGC_CC_MC_ACCT_LINE_HISTORY.cc_func_withheld_amt%TYPE,

Line 176: p_Conversion_Type IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Type%TYPE,

172: p_CC_Acct_Func_Amt IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Func_Amt%TYPE,
173: p_CC_Acct_Encmbrnc_Amt IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Amt%TYPE,
174: p_cc_acct_version_num IGC_CC_MC_ACCT_LINE_HISTORY.CC_ACCT_VERSION_NUM%TYPE,
175: p_cc_acct_version_action IGC_CC_MC_ACCT_LINE_HISTORY.CC_ACCT_VERSION_ACTION%TYPE,
176: p_Conversion_Type IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Type%TYPE,
177: p_Conversion_Date IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Date%TYPE,
178: p_Conversion_Rate IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Rate%TYPE,
179: p_cc_func_withheld_amt IGC_CC_MC_ACCT_LINE_HISTORY.cc_func_withheld_amt%TYPE,
180: X_row_locked OUT NOCOPY VARCHAR2

Line 177: p_Conversion_Date IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Date%TYPE,

173: p_CC_Acct_Encmbrnc_Amt IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Amt%TYPE,
174: p_cc_acct_version_num IGC_CC_MC_ACCT_LINE_HISTORY.CC_ACCT_VERSION_NUM%TYPE,
175: p_cc_acct_version_action IGC_CC_MC_ACCT_LINE_HISTORY.CC_ACCT_VERSION_ACTION%TYPE,
176: p_Conversion_Type IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Type%TYPE,
177: p_Conversion_Date IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Date%TYPE,
178: p_Conversion_Rate IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Rate%TYPE,
179: p_cc_func_withheld_amt IGC_CC_MC_ACCT_LINE_HISTORY.cc_func_withheld_amt%TYPE,
180: X_row_locked OUT NOCOPY VARCHAR2
181: ) IS

Line 178: p_Conversion_Rate IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Rate%TYPE,

174: p_cc_acct_version_num IGC_CC_MC_ACCT_LINE_HISTORY.CC_ACCT_VERSION_NUM%TYPE,
175: p_cc_acct_version_action IGC_CC_MC_ACCT_LINE_HISTORY.CC_ACCT_VERSION_ACTION%TYPE,
176: p_Conversion_Type IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Type%TYPE,
177: p_Conversion_Date IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Date%TYPE,
178: p_Conversion_Rate IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Rate%TYPE,
179: p_cc_func_withheld_amt IGC_CC_MC_ACCT_LINE_HISTORY.cc_func_withheld_amt%TYPE,
180: X_row_locked OUT NOCOPY VARCHAR2
181: ) IS
182: l_api_name CONSTANT VARCHAR2(30) := 'Lock_Row';

Line 179: p_cc_func_withheld_amt IGC_CC_MC_ACCT_LINE_HISTORY.cc_func_withheld_amt%TYPE,

175: p_cc_acct_version_action IGC_CC_MC_ACCT_LINE_HISTORY.CC_ACCT_VERSION_ACTION%TYPE,
176: p_Conversion_Type IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Type%TYPE,
177: p_Conversion_Date IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Date%TYPE,
178: p_Conversion_Rate IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Rate%TYPE,
179: p_cc_func_withheld_amt IGC_CC_MC_ACCT_LINE_HISTORY.cc_func_withheld_amt%TYPE,
180: X_row_locked OUT NOCOPY VARCHAR2
181: ) IS
182: l_api_name CONSTANT VARCHAR2(30) := 'Lock_Row';
183: l_api_version CONSTANT NUMBER := 1.0;

Line 188: FROM IGC_CC_MC_ACCT_LINE_HISTORY

184: Counter NUMBER;
185:
186: CURSOR C IS
187: SELECT *
188: FROM IGC_CC_MC_ACCT_LINE_HISTORY
189: WHERE rowid = p_Rowid
190: FOR UPDATE of CC_Acct_Line_Id NOWAIT;
191: Recinfo C%ROWTYPE;
192: BEGIN

Line 318: p_CC_Acct_Line_Id IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Line_Id%TYPE,

314: X_return_status OUT NOCOPY VARCHAR2,
315: X_msg_count OUT NOCOPY NUMBER,
316: X_msg_data OUT NOCOPY VARCHAR2,
317: p_Rowid IN OUT NOCOPY VARCHAR2,
318: p_CC_Acct_Line_Id IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Line_Id%TYPE,
319: p_Set_Of_Books_Id IGC_CC_MC_ACCT_LINE_HISTORY.Set_Of_Books_Id%TYPE,
320: p_CC_Acct_Func_Amt IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Func_Amt%TYPE,
321: p_CC_Acct_Encmbrnc_Amt IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Amt%TYPE,
322: p_cc_acct_version_num IGC_CC_MC_ACCT_LINE_HISTORY.CC_ACCT_VERSION_NUM%TYPE,

Line 319: p_Set_Of_Books_Id IGC_CC_MC_ACCT_LINE_HISTORY.Set_Of_Books_Id%TYPE,

315: X_msg_count OUT NOCOPY NUMBER,
316: X_msg_data OUT NOCOPY VARCHAR2,
317: p_Rowid IN OUT NOCOPY VARCHAR2,
318: p_CC_Acct_Line_Id IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Line_Id%TYPE,
319: p_Set_Of_Books_Id IGC_CC_MC_ACCT_LINE_HISTORY.Set_Of_Books_Id%TYPE,
320: p_CC_Acct_Func_Amt IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Func_Amt%TYPE,
321: p_CC_Acct_Encmbrnc_Amt IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Amt%TYPE,
322: p_cc_acct_version_num IGC_CC_MC_ACCT_LINE_HISTORY.CC_ACCT_VERSION_NUM%TYPE,
323: p_cc_acct_version_action IGC_CC_MC_ACCT_LINE_HISTORY.CC_ACCT_VERSION_ACTION%TYPE,

Line 320: p_CC_Acct_Func_Amt IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Func_Amt%TYPE,

316: X_msg_data OUT NOCOPY VARCHAR2,
317: p_Rowid IN OUT NOCOPY VARCHAR2,
318: p_CC_Acct_Line_Id IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Line_Id%TYPE,
319: p_Set_Of_Books_Id IGC_CC_MC_ACCT_LINE_HISTORY.Set_Of_Books_Id%TYPE,
320: p_CC_Acct_Func_Amt IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Func_Amt%TYPE,
321: p_CC_Acct_Encmbrnc_Amt IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Amt%TYPE,
322: p_cc_acct_version_num IGC_CC_MC_ACCT_LINE_HISTORY.CC_ACCT_VERSION_NUM%TYPE,
323: p_cc_acct_version_action IGC_CC_MC_ACCT_LINE_HISTORY.CC_ACCT_VERSION_ACTION%TYPE,
324: p_Conversion_Type IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Type%TYPE,

Line 321: p_CC_Acct_Encmbrnc_Amt IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Amt%TYPE,

317: p_Rowid IN OUT NOCOPY VARCHAR2,
318: p_CC_Acct_Line_Id IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Line_Id%TYPE,
319: p_Set_Of_Books_Id IGC_CC_MC_ACCT_LINE_HISTORY.Set_Of_Books_Id%TYPE,
320: p_CC_Acct_Func_Amt IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Func_Amt%TYPE,
321: p_CC_Acct_Encmbrnc_Amt IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Amt%TYPE,
322: p_cc_acct_version_num IGC_CC_MC_ACCT_LINE_HISTORY.CC_ACCT_VERSION_NUM%TYPE,
323: p_cc_acct_version_action IGC_CC_MC_ACCT_LINE_HISTORY.CC_ACCT_VERSION_ACTION%TYPE,
324: p_Conversion_Type IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Type%TYPE,
325: p_Conversion_Date IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Date%TYPE,

Line 322: p_cc_acct_version_num IGC_CC_MC_ACCT_LINE_HISTORY.CC_ACCT_VERSION_NUM%TYPE,

318: p_CC_Acct_Line_Id IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Line_Id%TYPE,
319: p_Set_Of_Books_Id IGC_CC_MC_ACCT_LINE_HISTORY.Set_Of_Books_Id%TYPE,
320: p_CC_Acct_Func_Amt IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Func_Amt%TYPE,
321: p_CC_Acct_Encmbrnc_Amt IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Amt%TYPE,
322: p_cc_acct_version_num IGC_CC_MC_ACCT_LINE_HISTORY.CC_ACCT_VERSION_NUM%TYPE,
323: p_cc_acct_version_action IGC_CC_MC_ACCT_LINE_HISTORY.CC_ACCT_VERSION_ACTION%TYPE,
324: p_Conversion_Type IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Type%TYPE,
325: p_Conversion_Date IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Date%TYPE,
326: p_Conversion_Rate IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Rate%TYPE,

Line 323: p_cc_acct_version_action IGC_CC_MC_ACCT_LINE_HISTORY.CC_ACCT_VERSION_ACTION%TYPE,

319: p_Set_Of_Books_Id IGC_CC_MC_ACCT_LINE_HISTORY.Set_Of_Books_Id%TYPE,
320: p_CC_Acct_Func_Amt IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Func_Amt%TYPE,
321: p_CC_Acct_Encmbrnc_Amt IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Amt%TYPE,
322: p_cc_acct_version_num IGC_CC_MC_ACCT_LINE_HISTORY.CC_ACCT_VERSION_NUM%TYPE,
323: p_cc_acct_version_action IGC_CC_MC_ACCT_LINE_HISTORY.CC_ACCT_VERSION_ACTION%TYPE,
324: p_Conversion_Type IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Type%TYPE,
325: p_Conversion_Date IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Date%TYPE,
326: p_Conversion_Rate IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Rate%TYPE,
327: p_cc_func_withheld_amt IGC_CC_MC_ACCT_LINE_HISTORY.cc_func_withheld_amt%TYPE

Line 324: p_Conversion_Type IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Type%TYPE,

320: p_CC_Acct_Func_Amt IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Func_Amt%TYPE,
321: p_CC_Acct_Encmbrnc_Amt IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Amt%TYPE,
322: p_cc_acct_version_num IGC_CC_MC_ACCT_LINE_HISTORY.CC_ACCT_VERSION_NUM%TYPE,
323: p_cc_acct_version_action IGC_CC_MC_ACCT_LINE_HISTORY.CC_ACCT_VERSION_ACTION%TYPE,
324: p_Conversion_Type IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Type%TYPE,
325: p_Conversion_Date IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Date%TYPE,
326: p_Conversion_Rate IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Rate%TYPE,
327: p_cc_func_withheld_amt IGC_CC_MC_ACCT_LINE_HISTORY.cc_func_withheld_amt%TYPE
328: ) IS

Line 325: p_Conversion_Date IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Date%TYPE,

321: p_CC_Acct_Encmbrnc_Amt IGC_CC_MC_ACCT_LINE_HISTORY.CC_Acct_Encmbrnc_Amt%TYPE,
322: p_cc_acct_version_num IGC_CC_MC_ACCT_LINE_HISTORY.CC_ACCT_VERSION_NUM%TYPE,
323: p_cc_acct_version_action IGC_CC_MC_ACCT_LINE_HISTORY.CC_ACCT_VERSION_ACTION%TYPE,
324: p_Conversion_Type IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Type%TYPE,
325: p_Conversion_Date IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Date%TYPE,
326: p_Conversion_Rate IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Rate%TYPE,
327: p_cc_func_withheld_amt IGC_CC_MC_ACCT_LINE_HISTORY.cc_func_withheld_amt%TYPE
328: ) IS
329:

Line 326: p_Conversion_Rate IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Rate%TYPE,

322: p_cc_acct_version_num IGC_CC_MC_ACCT_LINE_HISTORY.CC_ACCT_VERSION_NUM%TYPE,
323: p_cc_acct_version_action IGC_CC_MC_ACCT_LINE_HISTORY.CC_ACCT_VERSION_ACTION%TYPE,
324: p_Conversion_Type IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Type%TYPE,
325: p_Conversion_Date IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Date%TYPE,
326: p_Conversion_Rate IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Rate%TYPE,
327: p_cc_func_withheld_amt IGC_CC_MC_ACCT_LINE_HISTORY.cc_func_withheld_amt%TYPE
328: ) IS
329:
330: l_api_name CONSTANT VARCHAR2(30) := 'Update_Row';

Line 327: p_cc_func_withheld_amt IGC_CC_MC_ACCT_LINE_HISTORY.cc_func_withheld_amt%TYPE

323: p_cc_acct_version_action IGC_CC_MC_ACCT_LINE_HISTORY.CC_ACCT_VERSION_ACTION%TYPE,
324: p_Conversion_Type IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Type%TYPE,
325: p_Conversion_Date IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Date%TYPE,
326: p_Conversion_Rate IGC_CC_MC_ACCT_LINE_HISTORY.Conversion_Rate%TYPE,
327: p_cc_func_withheld_amt IGC_CC_MC_ACCT_LINE_HISTORY.cc_func_withheld_amt%TYPE
328: ) IS
329:
330: l_api_name CONSTANT VARCHAR2(30) := 'Update_Row';
331: l_api_version CONSTANT NUMBER := 1.0;

Line 352: UPDATE IGC_CC_MC_ACCT_LINE_HISTORY

348: END IF;
349:
350: X_return_status := FND_API.G_RET_STS_SUCCESS ;
351:
352: UPDATE IGC_CC_MC_ACCT_LINE_HISTORY
353: SET
354: CC_Acct_Line_Id = p_CC_Acct_Line_Id,
355: Set_Of_Books_Id = p_Set_Of_Books_Id,
356: CC_Acct_Func_Amt = p_CC_Acct_Func_Amt,

Line 448: DELETE FROM IGC_CC_MC_ACCT_LINE_HISTORY

444: END IF ;
445:
446: X_return_status := FND_API.G_RET_STS_SUCCESS ;
447:
448: DELETE FROM IGC_CC_MC_ACCT_LINE_HISTORY
449: WHERE rowid = p_Rowid;
450:
451: if (SQL%NOTFOUND) then
452: Raise NO_DATA_FOUND;