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_DET_PF_HST_PKG dependencies on IGC_CC_MC_DET_PF_HISTORY

Line 20: p_CC_DET_PF_Line_Id IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_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_DET_PF_Line_Id IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Line_Id%TYPE,
21: p_Set_Of_Books_Id IGC_CC_MC_DET_PF_HISTORY.Set_Of_Books_Id%TYPE,
22: p_CC_DET_PF_Func_Amt IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Func_Amt%TYPE,
23: p_CC_DET_PF_Encmbrnc_Amt IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Encmbrnc_Amt%TYPE,
24: p_CC_DET_PF_version_num IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_num%TYPE,

Line 21: p_Set_Of_Books_Id IGC_CC_MC_DET_PF_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_DET_PF_Line_Id IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Line_Id%TYPE,
21: p_Set_Of_Books_Id IGC_CC_MC_DET_PF_HISTORY.Set_Of_Books_Id%TYPE,
22: p_CC_DET_PF_Func_Amt IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Func_Amt%TYPE,
23: p_CC_DET_PF_Encmbrnc_Amt IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Encmbrnc_Amt%TYPE,
24: p_CC_DET_PF_version_num IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_num%TYPE,
25: p_CC_DET_PF_version_action IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_action%TYPE,

Line 22: p_CC_DET_PF_Func_Amt IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Func_Amt%TYPE,

18: X_msg_data OUT NOCOPY VARCHAR2,
19: p_Rowid IN OUT NOCOPY VARCHAR2,
20: p_CC_DET_PF_Line_Id IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Line_Id%TYPE,
21: p_Set_Of_Books_Id IGC_CC_MC_DET_PF_HISTORY.Set_Of_Books_Id%TYPE,
22: p_CC_DET_PF_Func_Amt IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Func_Amt%TYPE,
23: p_CC_DET_PF_Encmbrnc_Amt IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Encmbrnc_Amt%TYPE,
24: p_CC_DET_PF_version_num IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_num%TYPE,
25: p_CC_DET_PF_version_action IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_action%TYPE,
26: p_Conversion_Type IGC_CC_MC_DET_PF_HISTORY.Conversion_Type%TYPE,

Line 23: p_CC_DET_PF_Encmbrnc_Amt IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Encmbrnc_Amt%TYPE,

19: p_Rowid IN OUT NOCOPY VARCHAR2,
20: p_CC_DET_PF_Line_Id IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Line_Id%TYPE,
21: p_Set_Of_Books_Id IGC_CC_MC_DET_PF_HISTORY.Set_Of_Books_Id%TYPE,
22: p_CC_DET_PF_Func_Amt IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Func_Amt%TYPE,
23: p_CC_DET_PF_Encmbrnc_Amt IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Encmbrnc_Amt%TYPE,
24: p_CC_DET_PF_version_num IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_num%TYPE,
25: p_CC_DET_PF_version_action IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_action%TYPE,
26: p_Conversion_Type IGC_CC_MC_DET_PF_HISTORY.Conversion_Type%TYPE,
27: p_Conversion_Date IGC_CC_MC_DET_PF_HISTORY.Conversion_Date%TYPE,

Line 24: p_CC_DET_PF_version_num IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_num%TYPE,

20: p_CC_DET_PF_Line_Id IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Line_Id%TYPE,
21: p_Set_Of_Books_Id IGC_CC_MC_DET_PF_HISTORY.Set_Of_Books_Id%TYPE,
22: p_CC_DET_PF_Func_Amt IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Func_Amt%TYPE,
23: p_CC_DET_PF_Encmbrnc_Amt IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Encmbrnc_Amt%TYPE,
24: p_CC_DET_PF_version_num IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_num%TYPE,
25: p_CC_DET_PF_version_action IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_action%TYPE,
26: p_Conversion_Type IGC_CC_MC_DET_PF_HISTORY.Conversion_Type%TYPE,
27: p_Conversion_Date IGC_CC_MC_DET_PF_HISTORY.Conversion_Date%TYPE,
28: p_Conversion_Rate IGC_CC_MC_DET_PF_HISTORY.Conversion_Rate%TYPE

Line 25: p_CC_DET_PF_version_action IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_action%TYPE,

21: p_Set_Of_Books_Id IGC_CC_MC_DET_PF_HISTORY.Set_Of_Books_Id%TYPE,
22: p_CC_DET_PF_Func_Amt IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Func_Amt%TYPE,
23: p_CC_DET_PF_Encmbrnc_Amt IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Encmbrnc_Amt%TYPE,
24: p_CC_DET_PF_version_num IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_num%TYPE,
25: p_CC_DET_PF_version_action IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_action%TYPE,
26: p_Conversion_Type IGC_CC_MC_DET_PF_HISTORY.Conversion_Type%TYPE,
27: p_Conversion_Date IGC_CC_MC_DET_PF_HISTORY.Conversion_Date%TYPE,
28: p_Conversion_Rate IGC_CC_MC_DET_PF_HISTORY.Conversion_Rate%TYPE
29:

Line 26: p_Conversion_Type IGC_CC_MC_DET_PF_HISTORY.Conversion_Type%TYPE,

22: p_CC_DET_PF_Func_Amt IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Func_Amt%TYPE,
23: p_CC_DET_PF_Encmbrnc_Amt IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Encmbrnc_Amt%TYPE,
24: p_CC_DET_PF_version_num IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_num%TYPE,
25: p_CC_DET_PF_version_action IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_action%TYPE,
26: p_Conversion_Type IGC_CC_MC_DET_PF_HISTORY.Conversion_Type%TYPE,
27: p_Conversion_Date IGC_CC_MC_DET_PF_HISTORY.Conversion_Date%TYPE,
28: p_Conversion_Rate IGC_CC_MC_DET_PF_HISTORY.Conversion_Rate%TYPE
29:
30: )

Line 27: p_Conversion_Date IGC_CC_MC_DET_PF_HISTORY.Conversion_Date%TYPE,

23: p_CC_DET_PF_Encmbrnc_Amt IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Encmbrnc_Amt%TYPE,
24: p_CC_DET_PF_version_num IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_num%TYPE,
25: p_CC_DET_PF_version_action IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_action%TYPE,
26: p_Conversion_Type IGC_CC_MC_DET_PF_HISTORY.Conversion_Type%TYPE,
27: p_Conversion_Date IGC_CC_MC_DET_PF_HISTORY.Conversion_Date%TYPE,
28: p_Conversion_Rate IGC_CC_MC_DET_PF_HISTORY.Conversion_Rate%TYPE
29:
30: )
31:

Line 28: p_Conversion_Rate IGC_CC_MC_DET_PF_HISTORY.Conversion_Rate%TYPE

24: p_CC_DET_PF_version_num IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_num%TYPE,
25: p_CC_DET_PF_version_action IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_action%TYPE,
26: p_Conversion_Type IGC_CC_MC_DET_PF_HISTORY.Conversion_Type%TYPE,
27: p_Conversion_Date IGC_CC_MC_DET_PF_HISTORY.Conversion_Date%TYPE,
28: p_Conversion_Rate IGC_CC_MC_DET_PF_HISTORY.Conversion_Rate%TYPE
29:
30: )
31:
32: IS

Line 39: FROM IGC_CC_MC_DET_PF_HISTORY

35: l_api_version CONSTANT NUMBER := 1.0;
36:
37: CURSOR c_det_pf_mrc_hst_rowid
38: IS SELECT Rowid
39: FROM IGC_CC_MC_DET_PF_HISTORY
40: WHERE CC_DET_PF_Line_Id = p_CC_DET_PF_Line_Id;
41:
42: BEGIN
43:

Line 66: INSERT INTO IGC_CC_MC_DET_PF_HISTORY (

62: X_return_status := FND_API.G_RET_STS_SUCCESS ;
63: -- -----------------------------------------------------------------
64: -- Insert the MRC DET PF line History record as requested.
65: -- -----------------------------------------------------------------
66: INSERT INTO IGC_CC_MC_DET_PF_HISTORY (
67: CC_DET_PF_Line_Id,
68: Set_Of_Books_Id,
69: CC_DET_PF_Func_Amt,
70: CC_DET_PF_Encmbrnc_Amt,

Line 166: p_CC_DET_PF_Line_Id IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Line_Id%TYPE,

162: X_return_status OUT NOCOPY VARCHAR2,
163: X_msg_count OUT NOCOPY NUMBER,
164: X_msg_data OUT NOCOPY VARCHAR2,
165: p_Rowid IN OUT NOCOPY VARCHAR2,
166: p_CC_DET_PF_Line_Id IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Line_Id%TYPE,
167: p_Set_Of_Books_Id IGC_CC_MC_DET_PF_HISTORY.Set_Of_Books_Id%TYPE,
168: p_CC_DET_PF_Func_Amt IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Func_Amt%TYPE,
169: p_CC_DET_PF_Encmbrnc_Amt IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Encmbrnc_Amt%TYPE,
170: p_CC_DET_PF_version_num IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_num%TYPE,

Line 167: p_Set_Of_Books_Id IGC_CC_MC_DET_PF_HISTORY.Set_Of_Books_Id%TYPE,

163: X_msg_count OUT NOCOPY NUMBER,
164: X_msg_data OUT NOCOPY VARCHAR2,
165: p_Rowid IN OUT NOCOPY VARCHAR2,
166: p_CC_DET_PF_Line_Id IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Line_Id%TYPE,
167: p_Set_Of_Books_Id IGC_CC_MC_DET_PF_HISTORY.Set_Of_Books_Id%TYPE,
168: p_CC_DET_PF_Func_Amt IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Func_Amt%TYPE,
169: p_CC_DET_PF_Encmbrnc_Amt IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Encmbrnc_Amt%TYPE,
170: p_CC_DET_PF_version_num IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_num%TYPE,
171: p_CC_DET_PF_version_action IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_action%TYPE,

Line 168: p_CC_DET_PF_Func_Amt IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Func_Amt%TYPE,

164: X_msg_data OUT NOCOPY VARCHAR2,
165: p_Rowid IN OUT NOCOPY VARCHAR2,
166: p_CC_DET_PF_Line_Id IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Line_Id%TYPE,
167: p_Set_Of_Books_Id IGC_CC_MC_DET_PF_HISTORY.Set_Of_Books_Id%TYPE,
168: p_CC_DET_PF_Func_Amt IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Func_Amt%TYPE,
169: p_CC_DET_PF_Encmbrnc_Amt IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Encmbrnc_Amt%TYPE,
170: p_CC_DET_PF_version_num IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_num%TYPE,
171: p_CC_DET_PF_version_action IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_action%TYPE,
172: p_Conversion_Type IGC_CC_MC_DET_PF_HISTORY.Conversion_Type%TYPE,

Line 169: p_CC_DET_PF_Encmbrnc_Amt IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Encmbrnc_Amt%TYPE,

165: p_Rowid IN OUT NOCOPY VARCHAR2,
166: p_CC_DET_PF_Line_Id IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Line_Id%TYPE,
167: p_Set_Of_Books_Id IGC_CC_MC_DET_PF_HISTORY.Set_Of_Books_Id%TYPE,
168: p_CC_DET_PF_Func_Amt IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Func_Amt%TYPE,
169: p_CC_DET_PF_Encmbrnc_Amt IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Encmbrnc_Amt%TYPE,
170: p_CC_DET_PF_version_num IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_num%TYPE,
171: p_CC_DET_PF_version_action IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_action%TYPE,
172: p_Conversion_Type IGC_CC_MC_DET_PF_HISTORY.Conversion_Type%TYPE,
173: p_Conversion_Date IGC_CC_MC_DET_PF_HISTORY.Conversion_Date%TYPE,

Line 170: p_CC_DET_PF_version_num IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_num%TYPE,

166: p_CC_DET_PF_Line_Id IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Line_Id%TYPE,
167: p_Set_Of_Books_Id IGC_CC_MC_DET_PF_HISTORY.Set_Of_Books_Id%TYPE,
168: p_CC_DET_PF_Func_Amt IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Func_Amt%TYPE,
169: p_CC_DET_PF_Encmbrnc_Amt IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Encmbrnc_Amt%TYPE,
170: p_CC_DET_PF_version_num IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_num%TYPE,
171: p_CC_DET_PF_version_action IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_action%TYPE,
172: p_Conversion_Type IGC_CC_MC_DET_PF_HISTORY.Conversion_Type%TYPE,
173: p_Conversion_Date IGC_CC_MC_DET_PF_HISTORY.Conversion_Date%TYPE,
174: p_Conversion_Rate IGC_CC_MC_DET_PF_HISTORY.Conversion_Rate%TYPE,

Line 171: p_CC_DET_PF_version_action IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_action%TYPE,

167: p_Set_Of_Books_Id IGC_CC_MC_DET_PF_HISTORY.Set_Of_Books_Id%TYPE,
168: p_CC_DET_PF_Func_Amt IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Func_Amt%TYPE,
169: p_CC_DET_PF_Encmbrnc_Amt IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Encmbrnc_Amt%TYPE,
170: p_CC_DET_PF_version_num IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_num%TYPE,
171: p_CC_DET_PF_version_action IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_action%TYPE,
172: p_Conversion_Type IGC_CC_MC_DET_PF_HISTORY.Conversion_Type%TYPE,
173: p_Conversion_Date IGC_CC_MC_DET_PF_HISTORY.Conversion_Date%TYPE,
174: p_Conversion_Rate IGC_CC_MC_DET_PF_HISTORY.Conversion_Rate%TYPE,
175: X_row_locked OUT NOCOPY VARCHAR2

Line 172: p_Conversion_Type IGC_CC_MC_DET_PF_HISTORY.Conversion_Type%TYPE,

168: p_CC_DET_PF_Func_Amt IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Func_Amt%TYPE,
169: p_CC_DET_PF_Encmbrnc_Amt IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Encmbrnc_Amt%TYPE,
170: p_CC_DET_PF_version_num IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_num%TYPE,
171: p_CC_DET_PF_version_action IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_action%TYPE,
172: p_Conversion_Type IGC_CC_MC_DET_PF_HISTORY.Conversion_Type%TYPE,
173: p_Conversion_Date IGC_CC_MC_DET_PF_HISTORY.Conversion_Date%TYPE,
174: p_Conversion_Rate IGC_CC_MC_DET_PF_HISTORY.Conversion_Rate%TYPE,
175: X_row_locked OUT NOCOPY VARCHAR2
176: ) IS

Line 173: p_Conversion_Date IGC_CC_MC_DET_PF_HISTORY.Conversion_Date%TYPE,

169: p_CC_DET_PF_Encmbrnc_Amt IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Encmbrnc_Amt%TYPE,
170: p_CC_DET_PF_version_num IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_num%TYPE,
171: p_CC_DET_PF_version_action IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_action%TYPE,
172: p_Conversion_Type IGC_CC_MC_DET_PF_HISTORY.Conversion_Type%TYPE,
173: p_Conversion_Date IGC_CC_MC_DET_PF_HISTORY.Conversion_Date%TYPE,
174: p_Conversion_Rate IGC_CC_MC_DET_PF_HISTORY.Conversion_Rate%TYPE,
175: X_row_locked OUT NOCOPY VARCHAR2
176: ) IS
177: l_api_name CONSTANT VARCHAR2(30) := 'Lock_Row';

Line 174: p_Conversion_Rate IGC_CC_MC_DET_PF_HISTORY.Conversion_Rate%TYPE,

170: p_CC_DET_PF_version_num IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_num%TYPE,
171: p_CC_DET_PF_version_action IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_action%TYPE,
172: p_Conversion_Type IGC_CC_MC_DET_PF_HISTORY.Conversion_Type%TYPE,
173: p_Conversion_Date IGC_CC_MC_DET_PF_HISTORY.Conversion_Date%TYPE,
174: p_Conversion_Rate IGC_CC_MC_DET_PF_HISTORY.Conversion_Rate%TYPE,
175: X_row_locked OUT NOCOPY VARCHAR2
176: ) IS
177: l_api_name CONSTANT VARCHAR2(30) := 'Lock_Row';
178: l_api_version CONSTANT NUMBER := 1.0;

Line 183: FROM IGC_CC_MC_DET_PF_HISTORY

179: Counter NUMBER;
180:
181: CURSOR C IS
182: SELECT *
183: FROM IGC_CC_MC_DET_PF_HISTORY
184: WHERE rowid = p_Rowid
185: FOR UPDATE of CC_DET_PF_Line_Id NOWAIT;
186: Recinfo C%ROWTYPE;
187: BEGIN

Line 310: p_CC_DET_PF_Line_Id IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Line_Id%TYPE,

306: X_return_status OUT NOCOPY VARCHAR2,
307: X_msg_count OUT NOCOPY NUMBER,
308: X_msg_data OUT NOCOPY VARCHAR2,
309: p_Rowid IN OUT NOCOPY VARCHAR2,
310: p_CC_DET_PF_Line_Id IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Line_Id%TYPE,
311: p_Set_Of_Books_Id IGC_CC_MC_DET_PF_HISTORY.Set_Of_Books_Id%TYPE,
312: p_CC_DET_PF_Func_Amt IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Func_Amt%TYPE,
313: p_CC_DET_PF_Encmbrnc_Amt IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Encmbrnc_Amt%TYPE,
314: p_CC_DET_PF_version_num IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_num%TYPE,

Line 311: p_Set_Of_Books_Id IGC_CC_MC_DET_PF_HISTORY.Set_Of_Books_Id%TYPE,

307: X_msg_count OUT NOCOPY NUMBER,
308: X_msg_data OUT NOCOPY VARCHAR2,
309: p_Rowid IN OUT NOCOPY VARCHAR2,
310: p_CC_DET_PF_Line_Id IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Line_Id%TYPE,
311: p_Set_Of_Books_Id IGC_CC_MC_DET_PF_HISTORY.Set_Of_Books_Id%TYPE,
312: p_CC_DET_PF_Func_Amt IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Func_Amt%TYPE,
313: p_CC_DET_PF_Encmbrnc_Amt IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Encmbrnc_Amt%TYPE,
314: p_CC_DET_PF_version_num IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_num%TYPE,
315: p_CC_DET_PF_version_action IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_action%TYPE,

Line 312: p_CC_DET_PF_Func_Amt IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Func_Amt%TYPE,

308: X_msg_data OUT NOCOPY VARCHAR2,
309: p_Rowid IN OUT NOCOPY VARCHAR2,
310: p_CC_DET_PF_Line_Id IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Line_Id%TYPE,
311: p_Set_Of_Books_Id IGC_CC_MC_DET_PF_HISTORY.Set_Of_Books_Id%TYPE,
312: p_CC_DET_PF_Func_Amt IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Func_Amt%TYPE,
313: p_CC_DET_PF_Encmbrnc_Amt IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Encmbrnc_Amt%TYPE,
314: p_CC_DET_PF_version_num IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_num%TYPE,
315: p_CC_DET_PF_version_action IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_action%TYPE,
316: p_Conversion_Type IGC_CC_MC_DET_PF_HISTORY.Conversion_Type%TYPE,

Line 313: p_CC_DET_PF_Encmbrnc_Amt IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Encmbrnc_Amt%TYPE,

309: p_Rowid IN OUT NOCOPY VARCHAR2,
310: p_CC_DET_PF_Line_Id IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Line_Id%TYPE,
311: p_Set_Of_Books_Id IGC_CC_MC_DET_PF_HISTORY.Set_Of_Books_Id%TYPE,
312: p_CC_DET_PF_Func_Amt IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Func_Amt%TYPE,
313: p_CC_DET_PF_Encmbrnc_Amt IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Encmbrnc_Amt%TYPE,
314: p_CC_DET_PF_version_num IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_num%TYPE,
315: p_CC_DET_PF_version_action IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_action%TYPE,
316: p_Conversion_Type IGC_CC_MC_DET_PF_HISTORY.Conversion_Type%TYPE,
317: p_Conversion_Date IGC_CC_MC_DET_PF_HISTORY.Conversion_Date%TYPE,

Line 314: p_CC_DET_PF_version_num IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_num%TYPE,

310: p_CC_DET_PF_Line_Id IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Line_Id%TYPE,
311: p_Set_Of_Books_Id IGC_CC_MC_DET_PF_HISTORY.Set_Of_Books_Id%TYPE,
312: p_CC_DET_PF_Func_Amt IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Func_Amt%TYPE,
313: p_CC_DET_PF_Encmbrnc_Amt IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Encmbrnc_Amt%TYPE,
314: p_CC_DET_PF_version_num IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_num%TYPE,
315: p_CC_DET_PF_version_action IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_action%TYPE,
316: p_Conversion_Type IGC_CC_MC_DET_PF_HISTORY.Conversion_Type%TYPE,
317: p_Conversion_Date IGC_CC_MC_DET_PF_HISTORY.Conversion_Date%TYPE,
318: p_Conversion_Rate IGC_CC_MC_DET_PF_HISTORY.Conversion_Rate%TYPE

Line 315: p_CC_DET_PF_version_action IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_action%TYPE,

311: p_Set_Of_Books_Id IGC_CC_MC_DET_PF_HISTORY.Set_Of_Books_Id%TYPE,
312: p_CC_DET_PF_Func_Amt IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Func_Amt%TYPE,
313: p_CC_DET_PF_Encmbrnc_Amt IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Encmbrnc_Amt%TYPE,
314: p_CC_DET_PF_version_num IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_num%TYPE,
315: p_CC_DET_PF_version_action IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_action%TYPE,
316: p_Conversion_Type IGC_CC_MC_DET_PF_HISTORY.Conversion_Type%TYPE,
317: p_Conversion_Date IGC_CC_MC_DET_PF_HISTORY.Conversion_Date%TYPE,
318: p_Conversion_Rate IGC_CC_MC_DET_PF_HISTORY.Conversion_Rate%TYPE
319:

Line 316: p_Conversion_Type IGC_CC_MC_DET_PF_HISTORY.Conversion_Type%TYPE,

312: p_CC_DET_PF_Func_Amt IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Func_Amt%TYPE,
313: p_CC_DET_PF_Encmbrnc_Amt IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Encmbrnc_Amt%TYPE,
314: p_CC_DET_PF_version_num IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_num%TYPE,
315: p_CC_DET_PF_version_action IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_action%TYPE,
316: p_Conversion_Type IGC_CC_MC_DET_PF_HISTORY.Conversion_Type%TYPE,
317: p_Conversion_Date IGC_CC_MC_DET_PF_HISTORY.Conversion_Date%TYPE,
318: p_Conversion_Rate IGC_CC_MC_DET_PF_HISTORY.Conversion_Rate%TYPE
319:
320: ) IS

Line 317: p_Conversion_Date IGC_CC_MC_DET_PF_HISTORY.Conversion_Date%TYPE,

313: p_CC_DET_PF_Encmbrnc_Amt IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_Encmbrnc_Amt%TYPE,
314: p_CC_DET_PF_version_num IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_num%TYPE,
315: p_CC_DET_PF_version_action IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_action%TYPE,
316: p_Conversion_Type IGC_CC_MC_DET_PF_HISTORY.Conversion_Type%TYPE,
317: p_Conversion_Date IGC_CC_MC_DET_PF_HISTORY.Conversion_Date%TYPE,
318: p_Conversion_Rate IGC_CC_MC_DET_PF_HISTORY.Conversion_Rate%TYPE
319:
320: ) IS
321:

Line 318: p_Conversion_Rate IGC_CC_MC_DET_PF_HISTORY.Conversion_Rate%TYPE

314: p_CC_DET_PF_version_num IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_num%TYPE,
315: p_CC_DET_PF_version_action IGC_CC_MC_DET_PF_HISTORY.CC_DET_PF_version_action%TYPE,
316: p_Conversion_Type IGC_CC_MC_DET_PF_HISTORY.Conversion_Type%TYPE,
317: p_Conversion_Date IGC_CC_MC_DET_PF_HISTORY.Conversion_Date%TYPE,
318: p_Conversion_Rate IGC_CC_MC_DET_PF_HISTORY.Conversion_Rate%TYPE
319:
320: ) IS
321:
322: l_api_name CONSTANT VARCHAR2(30) := 'Update_Row';

Line 344: UPDATE IGC_CC_MC_DET_PF_HISTORY

340: END IF;
341:
342: X_return_status := FND_API.G_RET_STS_SUCCESS ;
343:
344: UPDATE IGC_CC_MC_DET_PF_HISTORY
345: SET
346: CC_DET_PF_Line_Id = p_CC_DET_PF_Line_Id,
347: Set_Of_Books_Id = p_Set_Of_Books_Id,
348: CC_DET_PF_Func_Amt = p_CC_DET_PF_Func_Amt,

Line 439: DELETE FROM IGC_CC_MC_DET_PF_HISTORY

435: END IF ;
436:
437: X_return_status := FND_API.G_RET_STS_SUCCESS ;
438:
439: DELETE FROM IGC_CC_MC_DET_PF_HISTORY
440: WHERE rowid = p_Rowid;
441:
442: if (SQL%NOTFOUND) then
443: Raise NO_DATA_FOUND;