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_HEADER_HST_PKG dependencies on IGC_CC_MC_HEADER_HISTORY

Line 20: p_CC_Header_Id IGC_CC_MC_HEADER_HISTORY.CC_Header_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_Header_Id IGC_CC_MC_HEADER_HISTORY.CC_Header_Id%TYPE,
21: p_Set_Of_Books_Id IGC_CC_MC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
22: p_cc_version_num IGC_CC_MC_HEADER_HISTORY.cc_version_num%TYPE,
23: p_cc_version_action IGC_CC_MC_HEADER_HISTORY.cc_version_action%TYPE,
24: p_Conversion_Type IGC_CC_MC_HEADER_HISTORY.Conversion_Type%TYPE,

Line 21: p_Set_Of_Books_Id IGC_CC_MC_HEADER_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_Header_Id IGC_CC_MC_HEADER_HISTORY.CC_Header_Id%TYPE,
21: p_Set_Of_Books_Id IGC_CC_MC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
22: p_cc_version_num IGC_CC_MC_HEADER_HISTORY.cc_version_num%TYPE,
23: p_cc_version_action IGC_CC_MC_HEADER_HISTORY.cc_version_action%TYPE,
24: p_Conversion_Type IGC_CC_MC_HEADER_HISTORY.Conversion_Type%TYPE,
25: p_Conversion_Date IGC_CC_MC_HEADER_HISTORY.Conversion_Date%TYPE,

Line 22: p_cc_version_num IGC_CC_MC_HEADER_HISTORY.cc_version_num%TYPE,

18: X_msg_data OUT NOCOPY VARCHAR2,
19: p_Rowid IN OUT NOCOPY VARCHAR2,
20: p_CC_Header_Id IGC_CC_MC_HEADER_HISTORY.CC_Header_Id%TYPE,
21: p_Set_Of_Books_Id IGC_CC_MC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
22: p_cc_version_num IGC_CC_MC_HEADER_HISTORY.cc_version_num%TYPE,
23: p_cc_version_action IGC_CC_MC_HEADER_HISTORY.cc_version_action%TYPE,
24: p_Conversion_Type IGC_CC_MC_HEADER_HISTORY.Conversion_Type%TYPE,
25: p_Conversion_Date IGC_CC_MC_HEADER_HISTORY.Conversion_Date%TYPE,
26: p_Conversion_Rate IGC_CC_MC_HEADER_HISTORY.Conversion_Rate%TYPE

Line 23: p_cc_version_action IGC_CC_MC_HEADER_HISTORY.cc_version_action%TYPE,

19: p_Rowid IN OUT NOCOPY VARCHAR2,
20: p_CC_Header_Id IGC_CC_MC_HEADER_HISTORY.CC_Header_Id%TYPE,
21: p_Set_Of_Books_Id IGC_CC_MC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
22: p_cc_version_num IGC_CC_MC_HEADER_HISTORY.cc_version_num%TYPE,
23: p_cc_version_action IGC_CC_MC_HEADER_HISTORY.cc_version_action%TYPE,
24: p_Conversion_Type IGC_CC_MC_HEADER_HISTORY.Conversion_Type%TYPE,
25: p_Conversion_Date IGC_CC_MC_HEADER_HISTORY.Conversion_Date%TYPE,
26: p_Conversion_Rate IGC_CC_MC_HEADER_HISTORY.Conversion_Rate%TYPE
27: )

Line 24: p_Conversion_Type IGC_CC_MC_HEADER_HISTORY.Conversion_Type%TYPE,

20: p_CC_Header_Id IGC_CC_MC_HEADER_HISTORY.CC_Header_Id%TYPE,
21: p_Set_Of_Books_Id IGC_CC_MC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
22: p_cc_version_num IGC_CC_MC_HEADER_HISTORY.cc_version_num%TYPE,
23: p_cc_version_action IGC_CC_MC_HEADER_HISTORY.cc_version_action%TYPE,
24: p_Conversion_Type IGC_CC_MC_HEADER_HISTORY.Conversion_Type%TYPE,
25: p_Conversion_Date IGC_CC_MC_HEADER_HISTORY.Conversion_Date%TYPE,
26: p_Conversion_Rate IGC_CC_MC_HEADER_HISTORY.Conversion_Rate%TYPE
27: )
28:

Line 25: p_Conversion_Date IGC_CC_MC_HEADER_HISTORY.Conversion_Date%TYPE,

21: p_Set_Of_Books_Id IGC_CC_MC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
22: p_cc_version_num IGC_CC_MC_HEADER_HISTORY.cc_version_num%TYPE,
23: p_cc_version_action IGC_CC_MC_HEADER_HISTORY.cc_version_action%TYPE,
24: p_Conversion_Type IGC_CC_MC_HEADER_HISTORY.Conversion_Type%TYPE,
25: p_Conversion_Date IGC_CC_MC_HEADER_HISTORY.Conversion_Date%TYPE,
26: p_Conversion_Rate IGC_CC_MC_HEADER_HISTORY.Conversion_Rate%TYPE
27: )
28:
29: IS

Line 26: p_Conversion_Rate IGC_CC_MC_HEADER_HISTORY.Conversion_Rate%TYPE

22: p_cc_version_num IGC_CC_MC_HEADER_HISTORY.cc_version_num%TYPE,
23: p_cc_version_action IGC_CC_MC_HEADER_HISTORY.cc_version_action%TYPE,
24: p_Conversion_Type IGC_CC_MC_HEADER_HISTORY.Conversion_Type%TYPE,
25: p_Conversion_Date IGC_CC_MC_HEADER_HISTORY.Conversion_Date%TYPE,
26: p_Conversion_Rate IGC_CC_MC_HEADER_HISTORY.Conversion_Rate%TYPE
27: )
28:
29: IS
30:

Line 36: FROM IGC_CC_MC_HEADER_HISTORY

32: l_api_version CONSTANT NUMBER := 1.0;
33:
34: CURSOR C_header_mrc_hst_rowid
35: IS SELECT Rowid
36: FROM IGC_CC_MC_HEADER_HISTORY
37: WHERE CC_Header_id = p_CC_Header_id;
38:
39: BEGIN
40:

Line 64: INSERT INTO IGC_CC_MC_HEADER_HISTORY (

60: X_return_status := FND_API.G_RET_STS_SUCCESS ;
61: -- -----------------------------------------------------------------
62: -- Insert the CC MRC Header History record as requested.
63: -- -----------------------------------------------------------------
64: INSERT INTO IGC_CC_MC_HEADER_HISTORY (
65: CC_Header_Id,
66: Set_Of_Books_Id,
67: cc_version_num,
68: cc_version_action,

Line 166: p_CC_Header_Id IGC_CC_MC_HEADER_HISTORY.CC_Header_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_Header_Id IGC_CC_MC_HEADER_HISTORY.CC_Header_Id%TYPE,
167: p_Set_Of_Books_Id IGC_CC_MC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
168: p_cc_version_num IGC_CC_MC_HEADER_HISTORY.cc_version_num%TYPE,
169: p_cc_version_action IGC_CC_MC_HEADER_HISTORY.cc_version_action%TYPE,
170: p_Conversion_Type IGC_CC_MC_HEADER_HISTORY.Conversion_Type%TYPE,

Line 167: p_Set_Of_Books_Id IGC_CC_MC_HEADER_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_Header_Id IGC_CC_MC_HEADER_HISTORY.CC_Header_Id%TYPE,
167: p_Set_Of_Books_Id IGC_CC_MC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
168: p_cc_version_num IGC_CC_MC_HEADER_HISTORY.cc_version_num%TYPE,
169: p_cc_version_action IGC_CC_MC_HEADER_HISTORY.cc_version_action%TYPE,
170: p_Conversion_Type IGC_CC_MC_HEADER_HISTORY.Conversion_Type%TYPE,
171: p_Conversion_Date IGC_CC_MC_HEADER_HISTORY.Conversion_Date%TYPE,

Line 168: p_cc_version_num IGC_CC_MC_HEADER_HISTORY.cc_version_num%TYPE,

164: X_msg_data OUT NOCOPY VARCHAR2,
165: p_Rowid IN OUT NOCOPY VARCHAR2,
166: p_CC_Header_Id IGC_CC_MC_HEADER_HISTORY.CC_Header_Id%TYPE,
167: p_Set_Of_Books_Id IGC_CC_MC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
168: p_cc_version_num IGC_CC_MC_HEADER_HISTORY.cc_version_num%TYPE,
169: p_cc_version_action IGC_CC_MC_HEADER_HISTORY.cc_version_action%TYPE,
170: p_Conversion_Type IGC_CC_MC_HEADER_HISTORY.Conversion_Type%TYPE,
171: p_Conversion_Date IGC_CC_MC_HEADER_HISTORY.Conversion_Date%TYPE,
172: p_Conversion_Rate IGC_CC_MC_HEADER_HISTORY.Conversion_Rate%TYPE,

Line 169: p_cc_version_action IGC_CC_MC_HEADER_HISTORY.cc_version_action%TYPE,

165: p_Rowid IN OUT NOCOPY VARCHAR2,
166: p_CC_Header_Id IGC_CC_MC_HEADER_HISTORY.CC_Header_Id%TYPE,
167: p_Set_Of_Books_Id IGC_CC_MC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
168: p_cc_version_num IGC_CC_MC_HEADER_HISTORY.cc_version_num%TYPE,
169: p_cc_version_action IGC_CC_MC_HEADER_HISTORY.cc_version_action%TYPE,
170: p_Conversion_Type IGC_CC_MC_HEADER_HISTORY.Conversion_Type%TYPE,
171: p_Conversion_Date IGC_CC_MC_HEADER_HISTORY.Conversion_Date%TYPE,
172: p_Conversion_Rate IGC_CC_MC_HEADER_HISTORY.Conversion_Rate%TYPE,
173: X_row_locked OUT NOCOPY VARCHAR2

Line 170: p_Conversion_Type IGC_CC_MC_HEADER_HISTORY.Conversion_Type%TYPE,

166: p_CC_Header_Id IGC_CC_MC_HEADER_HISTORY.CC_Header_Id%TYPE,
167: p_Set_Of_Books_Id IGC_CC_MC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
168: p_cc_version_num IGC_CC_MC_HEADER_HISTORY.cc_version_num%TYPE,
169: p_cc_version_action IGC_CC_MC_HEADER_HISTORY.cc_version_action%TYPE,
170: p_Conversion_Type IGC_CC_MC_HEADER_HISTORY.Conversion_Type%TYPE,
171: p_Conversion_Date IGC_CC_MC_HEADER_HISTORY.Conversion_Date%TYPE,
172: p_Conversion_Rate IGC_CC_MC_HEADER_HISTORY.Conversion_Rate%TYPE,
173: X_row_locked OUT NOCOPY VARCHAR2
174: ) IS

Line 171: p_Conversion_Date IGC_CC_MC_HEADER_HISTORY.Conversion_Date%TYPE,

167: p_Set_Of_Books_Id IGC_CC_MC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
168: p_cc_version_num IGC_CC_MC_HEADER_HISTORY.cc_version_num%TYPE,
169: p_cc_version_action IGC_CC_MC_HEADER_HISTORY.cc_version_action%TYPE,
170: p_Conversion_Type IGC_CC_MC_HEADER_HISTORY.Conversion_Type%TYPE,
171: p_Conversion_Date IGC_CC_MC_HEADER_HISTORY.Conversion_Date%TYPE,
172: p_Conversion_Rate IGC_CC_MC_HEADER_HISTORY.Conversion_Rate%TYPE,
173: X_row_locked OUT NOCOPY VARCHAR2
174: ) IS
175: l_api_name CONSTANT VARCHAR2(30) := 'Lock_Row';

Line 172: p_Conversion_Rate IGC_CC_MC_HEADER_HISTORY.Conversion_Rate%TYPE,

168: p_cc_version_num IGC_CC_MC_HEADER_HISTORY.cc_version_num%TYPE,
169: p_cc_version_action IGC_CC_MC_HEADER_HISTORY.cc_version_action%TYPE,
170: p_Conversion_Type IGC_CC_MC_HEADER_HISTORY.Conversion_Type%TYPE,
171: p_Conversion_Date IGC_CC_MC_HEADER_HISTORY.Conversion_Date%TYPE,
172: p_Conversion_Rate IGC_CC_MC_HEADER_HISTORY.Conversion_Rate%TYPE,
173: X_row_locked OUT NOCOPY VARCHAR2
174: ) IS
175: l_api_name CONSTANT VARCHAR2(30) := 'Lock_Row';
176: l_api_version CONSTANT NUMBER := 1.0;

Line 181: FROM IGC_CC_MC_HEADER_HISTORY

177: Counter NUMBER;
178:
179: CURSOR C IS
180: SELECT *
181: FROM IGC_CC_MC_HEADER_HISTORY
182: WHERE rowid = p_Rowid
183: FOR UPDATE of CC_Header_Id NOWAIT;
184: Recinfo C%ROWTYPE;
185: BEGIN

Line 302: p_CC_Header_Id IGC_CC_MC_HEADER_HISTORY.CC_Header_Id%TYPE,

298: X_return_status OUT NOCOPY VARCHAR2,
299: X_msg_count OUT NOCOPY NUMBER,
300: X_msg_data OUT NOCOPY VARCHAR2,
301: p_Rowid IN OUT NOCOPY VARCHAR2,
302: p_CC_Header_Id IGC_CC_MC_HEADER_HISTORY.CC_Header_Id%TYPE,
303: p_Set_Of_Books_Id IGC_CC_MC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
304: p_cc_version_num IGC_CC_MC_HEADER_HISTORY.cc_version_num%TYPE,
305: p_cc_version_action IGC_CC_MC_HEADER_HISTORY.cc_version_action%TYPE,
306: p_Conversion_Type IGC_CC_MC_HEADER_HISTORY.Conversion_Type%TYPE,

Line 303: p_Set_Of_Books_Id IGC_CC_MC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,

299: X_msg_count OUT NOCOPY NUMBER,
300: X_msg_data OUT NOCOPY VARCHAR2,
301: p_Rowid IN OUT NOCOPY VARCHAR2,
302: p_CC_Header_Id IGC_CC_MC_HEADER_HISTORY.CC_Header_Id%TYPE,
303: p_Set_Of_Books_Id IGC_CC_MC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
304: p_cc_version_num IGC_CC_MC_HEADER_HISTORY.cc_version_num%TYPE,
305: p_cc_version_action IGC_CC_MC_HEADER_HISTORY.cc_version_action%TYPE,
306: p_Conversion_Type IGC_CC_MC_HEADER_HISTORY.Conversion_Type%TYPE,
307: p_Conversion_Date IGC_CC_MC_HEADER_HISTORY.Conversion_Date%TYPE,

Line 304: p_cc_version_num IGC_CC_MC_HEADER_HISTORY.cc_version_num%TYPE,

300: X_msg_data OUT NOCOPY VARCHAR2,
301: p_Rowid IN OUT NOCOPY VARCHAR2,
302: p_CC_Header_Id IGC_CC_MC_HEADER_HISTORY.CC_Header_Id%TYPE,
303: p_Set_Of_Books_Id IGC_CC_MC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
304: p_cc_version_num IGC_CC_MC_HEADER_HISTORY.cc_version_num%TYPE,
305: p_cc_version_action IGC_CC_MC_HEADER_HISTORY.cc_version_action%TYPE,
306: p_Conversion_Type IGC_CC_MC_HEADER_HISTORY.Conversion_Type%TYPE,
307: p_Conversion_Date IGC_CC_MC_HEADER_HISTORY.Conversion_Date%TYPE,
308: p_Conversion_Rate IGC_CC_MC_HEADER_HISTORY.Conversion_Rate%TYPE

Line 305: p_cc_version_action IGC_CC_MC_HEADER_HISTORY.cc_version_action%TYPE,

301: p_Rowid IN OUT NOCOPY VARCHAR2,
302: p_CC_Header_Id IGC_CC_MC_HEADER_HISTORY.CC_Header_Id%TYPE,
303: p_Set_Of_Books_Id IGC_CC_MC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
304: p_cc_version_num IGC_CC_MC_HEADER_HISTORY.cc_version_num%TYPE,
305: p_cc_version_action IGC_CC_MC_HEADER_HISTORY.cc_version_action%TYPE,
306: p_Conversion_Type IGC_CC_MC_HEADER_HISTORY.Conversion_Type%TYPE,
307: p_Conversion_Date IGC_CC_MC_HEADER_HISTORY.Conversion_Date%TYPE,
308: p_Conversion_Rate IGC_CC_MC_HEADER_HISTORY.Conversion_Rate%TYPE
309: ) IS

Line 306: p_Conversion_Type IGC_CC_MC_HEADER_HISTORY.Conversion_Type%TYPE,

302: p_CC_Header_Id IGC_CC_MC_HEADER_HISTORY.CC_Header_Id%TYPE,
303: p_Set_Of_Books_Id IGC_CC_MC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
304: p_cc_version_num IGC_CC_MC_HEADER_HISTORY.cc_version_num%TYPE,
305: p_cc_version_action IGC_CC_MC_HEADER_HISTORY.cc_version_action%TYPE,
306: p_Conversion_Type IGC_CC_MC_HEADER_HISTORY.Conversion_Type%TYPE,
307: p_Conversion_Date IGC_CC_MC_HEADER_HISTORY.Conversion_Date%TYPE,
308: p_Conversion_Rate IGC_CC_MC_HEADER_HISTORY.Conversion_Rate%TYPE
309: ) IS
310:

Line 307: p_Conversion_Date IGC_CC_MC_HEADER_HISTORY.Conversion_Date%TYPE,

303: p_Set_Of_Books_Id IGC_CC_MC_HEADER_HISTORY.Set_Of_Books_Id%TYPE,
304: p_cc_version_num IGC_CC_MC_HEADER_HISTORY.cc_version_num%TYPE,
305: p_cc_version_action IGC_CC_MC_HEADER_HISTORY.cc_version_action%TYPE,
306: p_Conversion_Type IGC_CC_MC_HEADER_HISTORY.Conversion_Type%TYPE,
307: p_Conversion_Date IGC_CC_MC_HEADER_HISTORY.Conversion_Date%TYPE,
308: p_Conversion_Rate IGC_CC_MC_HEADER_HISTORY.Conversion_Rate%TYPE
309: ) IS
310:
311: l_api_name CONSTANT VARCHAR2(30) := 'Update_Row';

Line 308: p_Conversion_Rate IGC_CC_MC_HEADER_HISTORY.Conversion_Rate%TYPE

304: p_cc_version_num IGC_CC_MC_HEADER_HISTORY.cc_version_num%TYPE,
305: p_cc_version_action IGC_CC_MC_HEADER_HISTORY.cc_version_action%TYPE,
306: p_Conversion_Type IGC_CC_MC_HEADER_HISTORY.Conversion_Type%TYPE,
307: p_Conversion_Date IGC_CC_MC_HEADER_HISTORY.Conversion_Date%TYPE,
308: p_Conversion_Rate IGC_CC_MC_HEADER_HISTORY.Conversion_Rate%TYPE
309: ) IS
310:
311: l_api_name CONSTANT VARCHAR2(30) := 'Update_Row';
312: l_api_version CONSTANT NUMBER := 1.0;

Line 333: UPDATE IGC_CC_MC_HEADER_HISTORY

329: END IF;
330:
331: X_return_status := FND_API.G_RET_STS_SUCCESS ;
332:
333: UPDATE IGC_CC_MC_HEADER_HISTORY
334: SET
335: CC_Header_Id = p_CC_Header_Id,
336: Set_Of_Books_Id = p_Set_Of_Books_Id,
337: cc_version_num = p_cc_version_num,

Line 426: DELETE FROM IGC_CC_MC_HEADER_HISTORY

422: END IF ;
423:
424: X_return_status := FND_API.G_RET_STS_SUCCESS ;
425:
426: DELETE FROM IGC_CC_MC_HEADER_HISTORY
427: WHERE rowid = p_Rowid;
428:
429: if (SQL%NOTFOUND) then
430: Raise NO_DATA_FOUND;