DBA Data[Home] [Help]

APPS.IGC_CC_MC_DET_PF_PKG dependencies on IGC_CC_MC_DET_PF

Line 1: PACKAGE BODY IGC_CC_MC_DET_PF_PKG as

1: PACKAGE BODY IGC_CC_MC_DET_PF_PKG as
2: /* $Header: IGCCMCDB.pls 120.3.12000000.1 2007/08/20 12:12:56 mbremkum ship $*/
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IGC_CC_MC_DET_PF_PKG';
5: g_debug_flag VARCHAR2(1) := 'N' ;

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IGC_CC_MC_DET_PF_PKG';

1: PACKAGE BODY IGC_CC_MC_DET_PF_PKG as
2: /* $Header: IGCCMCDB.pls 120.3.12000000.1 2007/08/20 12:12:56 mbremkum ship $*/
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IGC_CC_MC_DET_PF_PKG';
5: g_debug_flag VARCHAR2(1) := 'N' ;
6:
7: /* ================================================================================
8: PROCEDURE Insert_Row

Line 20: p_CC_DET_PF_Line_Id IGC_CC_MC_DET_PF.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.CC_DET_PF_Line_Id%TYPE,
21: p_Set_Of_Books_Id IGC_CC_MC_DET_PF.Set_Of_Books_Id%TYPE,
22: p_CC_DET_PF_Func_Amt IGC_CC_MC_DET_PF.CC_DET_PF_Func_Amt%TYPE,
23: p_CC_DET_PF_Encmbrnc_Amt IGC_CC_MC_DET_PF.CC_DET_PF_Encmbrnc_Amt%TYPE,
24: p_Conversion_Type IGC_CC_MC_DET_PF.Conversion_Type%TYPE,

Line 21: p_Set_Of_Books_Id IGC_CC_MC_DET_PF.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.CC_DET_PF_Line_Id%TYPE,
21: p_Set_Of_Books_Id IGC_CC_MC_DET_PF.Set_Of_Books_Id%TYPE,
22: p_CC_DET_PF_Func_Amt IGC_CC_MC_DET_PF.CC_DET_PF_Func_Amt%TYPE,
23: p_CC_DET_PF_Encmbrnc_Amt IGC_CC_MC_DET_PF.CC_DET_PF_Encmbrnc_Amt%TYPE,
24: p_Conversion_Type IGC_CC_MC_DET_PF.Conversion_Type%TYPE,
25: p_Conversion_Date IGC_CC_MC_DET_PF.Conversion_Date%TYPE,

Line 22: p_CC_DET_PF_Func_Amt IGC_CC_MC_DET_PF.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.CC_DET_PF_Line_Id%TYPE,
21: p_Set_Of_Books_Id IGC_CC_MC_DET_PF.Set_Of_Books_Id%TYPE,
22: p_CC_DET_PF_Func_Amt IGC_CC_MC_DET_PF.CC_DET_PF_Func_Amt%TYPE,
23: p_CC_DET_PF_Encmbrnc_Amt IGC_CC_MC_DET_PF.CC_DET_PF_Encmbrnc_Amt%TYPE,
24: p_Conversion_Type IGC_CC_MC_DET_PF.Conversion_Type%TYPE,
25: p_Conversion_Date IGC_CC_MC_DET_PF.Conversion_Date%TYPE,
26: p_Conversion_Rate IGC_CC_MC_DET_PF.Conversion_Rate%TYPE

Line 23: p_CC_DET_PF_Encmbrnc_Amt IGC_CC_MC_DET_PF.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.CC_DET_PF_Line_Id%TYPE,
21: p_Set_Of_Books_Id IGC_CC_MC_DET_PF.Set_Of_Books_Id%TYPE,
22: p_CC_DET_PF_Func_Amt IGC_CC_MC_DET_PF.CC_DET_PF_Func_Amt%TYPE,
23: p_CC_DET_PF_Encmbrnc_Amt IGC_CC_MC_DET_PF.CC_DET_PF_Encmbrnc_Amt%TYPE,
24: p_Conversion_Type IGC_CC_MC_DET_PF.Conversion_Type%TYPE,
25: p_Conversion_Date IGC_CC_MC_DET_PF.Conversion_Date%TYPE,
26: p_Conversion_Rate IGC_CC_MC_DET_PF.Conversion_Rate%TYPE
27:

Line 24: p_Conversion_Type IGC_CC_MC_DET_PF.Conversion_Type%TYPE,

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

Line 25: p_Conversion_Date IGC_CC_MC_DET_PF.Conversion_Date%TYPE,

21: p_Set_Of_Books_Id IGC_CC_MC_DET_PF.Set_Of_Books_Id%TYPE,
22: p_CC_DET_PF_Func_Amt IGC_CC_MC_DET_PF.CC_DET_PF_Func_Amt%TYPE,
23: p_CC_DET_PF_Encmbrnc_Amt IGC_CC_MC_DET_PF.CC_DET_PF_Encmbrnc_Amt%TYPE,
24: p_Conversion_Type IGC_CC_MC_DET_PF.Conversion_Type%TYPE,
25: p_Conversion_Date IGC_CC_MC_DET_PF.Conversion_Date%TYPE,
26: p_Conversion_Rate IGC_CC_MC_DET_PF.Conversion_Rate%TYPE
27:
28: )
29:

Line 26: p_Conversion_Rate IGC_CC_MC_DET_PF.Conversion_Rate%TYPE

22: p_CC_DET_PF_Func_Amt IGC_CC_MC_DET_PF.CC_DET_PF_Func_Amt%TYPE,
23: p_CC_DET_PF_Encmbrnc_Amt IGC_CC_MC_DET_PF.CC_DET_PF_Encmbrnc_Amt%TYPE,
24: p_Conversion_Type IGC_CC_MC_DET_PF.Conversion_Type%TYPE,
25: p_Conversion_Date IGC_CC_MC_DET_PF.Conversion_Date%TYPE,
26: p_Conversion_Rate IGC_CC_MC_DET_PF.Conversion_Rate%TYPE
27:
28: )
29:
30: IS

Line 35: CURSOR C IS SELECT Rowid FROM IGC_CC_MC_DET_PF

31:
32: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Row';
33: l_api_version CONSTANT NUMBER := 1.0;
34:
35: CURSOR C IS SELECT Rowid FROM IGC_CC_MC_DET_PF
36: WHERE CC_DET_PF_Line_Id = p_CC_DET_PF_Line_Id;
37:
38: BEGIN
39:

Line 57: INSERT INTO IGC_CC_MC_DET_PF (

53: END IF;
54:
55: X_return_status := FND_API.G_RET_STS_SUCCESS ;
56:
57: INSERT INTO IGC_CC_MC_DET_PF (
58: CC_DET_PF_Line_Id,
59: Set_Of_Books_Id,
60: CC_DET_PF_Func_Amt,
61: CC_DET_PF_Encmbrnc_Amt,

Line 134: p_CC_DET_PF_Line_Id IGC_CC_MC_DET_PF.CC_DET_PF_Line_Id%TYPE,

130: X_return_status OUT NOCOPY VARCHAR2,
131: X_msg_count OUT NOCOPY NUMBER,
132: X_msg_data OUT NOCOPY VARCHAR2,
133: p_Rowid IN OUT NOCOPY VARCHAR2,
134: p_CC_DET_PF_Line_Id IGC_CC_MC_DET_PF.CC_DET_PF_Line_Id%TYPE,
135: p_Set_Of_Books_Id IGC_CC_MC_DET_PF.Set_Of_Books_Id%TYPE,
136: p_CC_DET_PF_Func_Amt IGC_CC_MC_DET_PF.CC_DET_PF_Func_Amt%TYPE,
137: p_CC_DET_PF_Encmbrnc_Amt IGC_CC_MC_DET_PF.CC_DET_PF_Encmbrnc_Amt%TYPE,
138: p_Conversion_Type IGC_CC_MC_DET_PF.Conversion_Type%TYPE,

Line 135: p_Set_Of_Books_Id IGC_CC_MC_DET_PF.Set_Of_Books_Id%TYPE,

131: X_msg_count OUT NOCOPY NUMBER,
132: X_msg_data OUT NOCOPY VARCHAR2,
133: p_Rowid IN OUT NOCOPY VARCHAR2,
134: p_CC_DET_PF_Line_Id IGC_CC_MC_DET_PF.CC_DET_PF_Line_Id%TYPE,
135: p_Set_Of_Books_Id IGC_CC_MC_DET_PF.Set_Of_Books_Id%TYPE,
136: p_CC_DET_PF_Func_Amt IGC_CC_MC_DET_PF.CC_DET_PF_Func_Amt%TYPE,
137: p_CC_DET_PF_Encmbrnc_Amt IGC_CC_MC_DET_PF.CC_DET_PF_Encmbrnc_Amt%TYPE,
138: p_Conversion_Type IGC_CC_MC_DET_PF.Conversion_Type%TYPE,
139: p_Conversion_Date IGC_CC_MC_DET_PF.Conversion_Date%TYPE,

Line 136: p_CC_DET_PF_Func_Amt IGC_CC_MC_DET_PF.CC_DET_PF_Func_Amt%TYPE,

132: X_msg_data OUT NOCOPY VARCHAR2,
133: p_Rowid IN OUT NOCOPY VARCHAR2,
134: p_CC_DET_PF_Line_Id IGC_CC_MC_DET_PF.CC_DET_PF_Line_Id%TYPE,
135: p_Set_Of_Books_Id IGC_CC_MC_DET_PF.Set_Of_Books_Id%TYPE,
136: p_CC_DET_PF_Func_Amt IGC_CC_MC_DET_PF.CC_DET_PF_Func_Amt%TYPE,
137: p_CC_DET_PF_Encmbrnc_Amt IGC_CC_MC_DET_PF.CC_DET_PF_Encmbrnc_Amt%TYPE,
138: p_Conversion_Type IGC_CC_MC_DET_PF.Conversion_Type%TYPE,
139: p_Conversion_Date IGC_CC_MC_DET_PF.Conversion_Date%TYPE,
140: p_Conversion_Rate IGC_CC_MC_DET_PF.Conversion_Rate%TYPE,

Line 137: p_CC_DET_PF_Encmbrnc_Amt IGC_CC_MC_DET_PF.CC_DET_PF_Encmbrnc_Amt%TYPE,

133: p_Rowid IN OUT NOCOPY VARCHAR2,
134: p_CC_DET_PF_Line_Id IGC_CC_MC_DET_PF.CC_DET_PF_Line_Id%TYPE,
135: p_Set_Of_Books_Id IGC_CC_MC_DET_PF.Set_Of_Books_Id%TYPE,
136: p_CC_DET_PF_Func_Amt IGC_CC_MC_DET_PF.CC_DET_PF_Func_Amt%TYPE,
137: p_CC_DET_PF_Encmbrnc_Amt IGC_CC_MC_DET_PF.CC_DET_PF_Encmbrnc_Amt%TYPE,
138: p_Conversion_Type IGC_CC_MC_DET_PF.Conversion_Type%TYPE,
139: p_Conversion_Date IGC_CC_MC_DET_PF.Conversion_Date%TYPE,
140: p_Conversion_Rate IGC_CC_MC_DET_PF.Conversion_Rate%TYPE,
141: X_row_locked OUT NOCOPY VARCHAR2

Line 138: p_Conversion_Type IGC_CC_MC_DET_PF.Conversion_Type%TYPE,

134: p_CC_DET_PF_Line_Id IGC_CC_MC_DET_PF.CC_DET_PF_Line_Id%TYPE,
135: p_Set_Of_Books_Id IGC_CC_MC_DET_PF.Set_Of_Books_Id%TYPE,
136: p_CC_DET_PF_Func_Amt IGC_CC_MC_DET_PF.CC_DET_PF_Func_Amt%TYPE,
137: p_CC_DET_PF_Encmbrnc_Amt IGC_CC_MC_DET_PF.CC_DET_PF_Encmbrnc_Amt%TYPE,
138: p_Conversion_Type IGC_CC_MC_DET_PF.Conversion_Type%TYPE,
139: p_Conversion_Date IGC_CC_MC_DET_PF.Conversion_Date%TYPE,
140: p_Conversion_Rate IGC_CC_MC_DET_PF.Conversion_Rate%TYPE,
141: X_row_locked OUT NOCOPY VARCHAR2
142: ) IS

Line 139: p_Conversion_Date IGC_CC_MC_DET_PF.Conversion_Date%TYPE,

135: p_Set_Of_Books_Id IGC_CC_MC_DET_PF.Set_Of_Books_Id%TYPE,
136: p_CC_DET_PF_Func_Amt IGC_CC_MC_DET_PF.CC_DET_PF_Func_Amt%TYPE,
137: p_CC_DET_PF_Encmbrnc_Amt IGC_CC_MC_DET_PF.CC_DET_PF_Encmbrnc_Amt%TYPE,
138: p_Conversion_Type IGC_CC_MC_DET_PF.Conversion_Type%TYPE,
139: p_Conversion_Date IGC_CC_MC_DET_PF.Conversion_Date%TYPE,
140: p_Conversion_Rate IGC_CC_MC_DET_PF.Conversion_Rate%TYPE,
141: X_row_locked OUT NOCOPY VARCHAR2
142: ) IS
143: l_api_name CONSTANT VARCHAR2(30) := 'Lock_Row';

Line 140: p_Conversion_Rate IGC_CC_MC_DET_PF.Conversion_Rate%TYPE,

136: p_CC_DET_PF_Func_Amt IGC_CC_MC_DET_PF.CC_DET_PF_Func_Amt%TYPE,
137: p_CC_DET_PF_Encmbrnc_Amt IGC_CC_MC_DET_PF.CC_DET_PF_Encmbrnc_Amt%TYPE,
138: p_Conversion_Type IGC_CC_MC_DET_PF.Conversion_Type%TYPE,
139: p_Conversion_Date IGC_CC_MC_DET_PF.Conversion_Date%TYPE,
140: p_Conversion_Rate IGC_CC_MC_DET_PF.Conversion_Rate%TYPE,
141: X_row_locked OUT NOCOPY VARCHAR2
142: ) IS
143: l_api_name CONSTANT VARCHAR2(30) := 'Lock_Row';
144: l_api_version CONSTANT NUMBER := 1.0;

Line 149: FROM IGC_CC_MC_DET_PF

145: Counter NUMBER;
146:
147: CURSOR C IS
148: SELECT *
149: FROM IGC_CC_MC_DET_PF
150: WHERE rowid = p_Rowid
151: FOR UPDATE of CC_DET_PF_Line_Id NOWAIT;
152: Recinfo C%ROWTYPE;
153: BEGIN

Line 270: p_CC_DET_PF_Line_Id IGC_CC_MC_DET_PF.CC_DET_PF_Line_Id%TYPE,

266: X_return_status OUT NOCOPY VARCHAR2,
267: X_msg_count OUT NOCOPY NUMBER,
268: X_msg_data OUT NOCOPY VARCHAR2,
269: p_Rowid IN OUT NOCOPY VARCHAR2,
270: p_CC_DET_PF_Line_Id IGC_CC_MC_DET_PF.CC_DET_PF_Line_Id%TYPE,
271: p_Set_Of_Books_Id IGC_CC_MC_DET_PF.Set_Of_Books_Id%TYPE,
272: p_CC_DET_PF_Func_Amt IGC_CC_MC_DET_PF.CC_DET_PF_Func_Amt%TYPE,
273: p_CC_DET_PF_Encmbrnc_Amt IGC_CC_MC_DET_PF.CC_DET_PF_Encmbrnc_Amt%TYPE,
274: p_Conversion_Type IGC_CC_MC_DET_PF.Conversion_Type%TYPE,

Line 271: p_Set_Of_Books_Id IGC_CC_MC_DET_PF.Set_Of_Books_Id%TYPE,

267: X_msg_count OUT NOCOPY NUMBER,
268: X_msg_data OUT NOCOPY VARCHAR2,
269: p_Rowid IN OUT NOCOPY VARCHAR2,
270: p_CC_DET_PF_Line_Id IGC_CC_MC_DET_PF.CC_DET_PF_Line_Id%TYPE,
271: p_Set_Of_Books_Id IGC_CC_MC_DET_PF.Set_Of_Books_Id%TYPE,
272: p_CC_DET_PF_Func_Amt IGC_CC_MC_DET_PF.CC_DET_PF_Func_Amt%TYPE,
273: p_CC_DET_PF_Encmbrnc_Amt IGC_CC_MC_DET_PF.CC_DET_PF_Encmbrnc_Amt%TYPE,
274: p_Conversion_Type IGC_CC_MC_DET_PF.Conversion_Type%TYPE,
275: p_Conversion_Date IGC_CC_MC_DET_PF.Conversion_Date%TYPE,

Line 272: p_CC_DET_PF_Func_Amt IGC_CC_MC_DET_PF.CC_DET_PF_Func_Amt%TYPE,

268: X_msg_data OUT NOCOPY VARCHAR2,
269: p_Rowid IN OUT NOCOPY VARCHAR2,
270: p_CC_DET_PF_Line_Id IGC_CC_MC_DET_PF.CC_DET_PF_Line_Id%TYPE,
271: p_Set_Of_Books_Id IGC_CC_MC_DET_PF.Set_Of_Books_Id%TYPE,
272: p_CC_DET_PF_Func_Amt IGC_CC_MC_DET_PF.CC_DET_PF_Func_Amt%TYPE,
273: p_CC_DET_PF_Encmbrnc_Amt IGC_CC_MC_DET_PF.CC_DET_PF_Encmbrnc_Amt%TYPE,
274: p_Conversion_Type IGC_CC_MC_DET_PF.Conversion_Type%TYPE,
275: p_Conversion_Date IGC_CC_MC_DET_PF.Conversion_Date%TYPE,
276: p_Conversion_Rate IGC_CC_MC_DET_PF.Conversion_Rate%TYPE

Line 273: p_CC_DET_PF_Encmbrnc_Amt IGC_CC_MC_DET_PF.CC_DET_PF_Encmbrnc_Amt%TYPE,

269: p_Rowid IN OUT NOCOPY VARCHAR2,
270: p_CC_DET_PF_Line_Id IGC_CC_MC_DET_PF.CC_DET_PF_Line_Id%TYPE,
271: p_Set_Of_Books_Id IGC_CC_MC_DET_PF.Set_Of_Books_Id%TYPE,
272: p_CC_DET_PF_Func_Amt IGC_CC_MC_DET_PF.CC_DET_PF_Func_Amt%TYPE,
273: p_CC_DET_PF_Encmbrnc_Amt IGC_CC_MC_DET_PF.CC_DET_PF_Encmbrnc_Amt%TYPE,
274: p_Conversion_Type IGC_CC_MC_DET_PF.Conversion_Type%TYPE,
275: p_Conversion_Date IGC_CC_MC_DET_PF.Conversion_Date%TYPE,
276: p_Conversion_Rate IGC_CC_MC_DET_PF.Conversion_Rate%TYPE
277:

Line 274: p_Conversion_Type IGC_CC_MC_DET_PF.Conversion_Type%TYPE,

270: p_CC_DET_PF_Line_Id IGC_CC_MC_DET_PF.CC_DET_PF_Line_Id%TYPE,
271: p_Set_Of_Books_Id IGC_CC_MC_DET_PF.Set_Of_Books_Id%TYPE,
272: p_CC_DET_PF_Func_Amt IGC_CC_MC_DET_PF.CC_DET_PF_Func_Amt%TYPE,
273: p_CC_DET_PF_Encmbrnc_Amt IGC_CC_MC_DET_PF.CC_DET_PF_Encmbrnc_Amt%TYPE,
274: p_Conversion_Type IGC_CC_MC_DET_PF.Conversion_Type%TYPE,
275: p_Conversion_Date IGC_CC_MC_DET_PF.Conversion_Date%TYPE,
276: p_Conversion_Rate IGC_CC_MC_DET_PF.Conversion_Rate%TYPE
277:
278: ) IS

Line 275: p_Conversion_Date IGC_CC_MC_DET_PF.Conversion_Date%TYPE,

271: p_Set_Of_Books_Id IGC_CC_MC_DET_PF.Set_Of_Books_Id%TYPE,
272: p_CC_DET_PF_Func_Amt IGC_CC_MC_DET_PF.CC_DET_PF_Func_Amt%TYPE,
273: p_CC_DET_PF_Encmbrnc_Amt IGC_CC_MC_DET_PF.CC_DET_PF_Encmbrnc_Amt%TYPE,
274: p_Conversion_Type IGC_CC_MC_DET_PF.Conversion_Type%TYPE,
275: p_Conversion_Date IGC_CC_MC_DET_PF.Conversion_Date%TYPE,
276: p_Conversion_Rate IGC_CC_MC_DET_PF.Conversion_Rate%TYPE
277:
278: ) IS
279:

Line 276: p_Conversion_Rate IGC_CC_MC_DET_PF.Conversion_Rate%TYPE

272: p_CC_DET_PF_Func_Amt IGC_CC_MC_DET_PF.CC_DET_PF_Func_Amt%TYPE,
273: p_CC_DET_PF_Encmbrnc_Amt IGC_CC_MC_DET_PF.CC_DET_PF_Encmbrnc_Amt%TYPE,
274: p_Conversion_Type IGC_CC_MC_DET_PF.Conversion_Type%TYPE,
275: p_Conversion_Date IGC_CC_MC_DET_PF.Conversion_Date%TYPE,
276: p_Conversion_Rate IGC_CC_MC_DET_PF.Conversion_Rate%TYPE
277:
278: ) IS
279:
280: l_api_name CONSTANT VARCHAR2(30) := 'Update_Row';

Line 302: UPDATE IGC_CC_MC_DET_PF

298: END IF;
299:
300: X_return_status := FND_API.G_RET_STS_SUCCESS ;
301:
302: UPDATE IGC_CC_MC_DET_PF
303: SET
304: CC_DET_PF_Line_Id = p_CC_DET_PF_Line_Id,
305: Set_Of_Books_Id = p_Set_Of_Books_Id,
306: CC_DET_PF_Func_Amt = p_CC_DET_PF_Func_Amt,

Line 395: DELETE FROM IGC_CC_MC_DET_PF

391: END IF ;
392:
393: X_return_status := FND_API.G_RET_STS_SUCCESS ;
394:
395: DELETE FROM IGC_CC_MC_DET_PF
396: WHERE rowid = p_Rowid;
397:
398: if (SQL%NOTFOUND) then
399: Raise NO_DATA_FOUND;

Line 444: END IGC_CC_MC_DET_PF_PKG;

440:
441:
442:
443:
444: END IGC_CC_MC_DET_PF_PKG;