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_LINES_PKG dependencies on IGC_CC_MC_ACCT_LINES

Line 1: PACKAGE BODY IGC_CC_MC_ACCT_LINES_PKG as

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

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

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

Line 20: p_CC_Acct_Line_Id IGC_CC_MC_ACCT_LINES.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_LINES.CC_Acct_Line_Id%TYPE,
21: p_Set_Of_Books_Id IGC_CC_MC_ACCT_LINES.Set_Of_Books_Id%TYPE,
22: p_CC_Acct_Func_Amt IGC_CC_MC_ACCT_LINES.CC_Acct_Func_Amt%TYPE,
23: p_CC_Acct_Encmbrnc_Amt IGC_CC_MC_ACCT_LINES.CC_Acct_Encmbrnc_Amt%TYPE,
24: p_Conversion_Type IGC_CC_MC_ACCT_LINES.Conversion_Type%TYPE,

Line 21: p_Set_Of_Books_Id IGC_CC_MC_ACCT_LINES.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_LINES.CC_Acct_Line_Id%TYPE,
21: p_Set_Of_Books_Id IGC_CC_MC_ACCT_LINES.Set_Of_Books_Id%TYPE,
22: p_CC_Acct_Func_Amt IGC_CC_MC_ACCT_LINES.CC_Acct_Func_Amt%TYPE,
23: p_CC_Acct_Encmbrnc_Amt IGC_CC_MC_ACCT_LINES.CC_Acct_Encmbrnc_Amt%TYPE,
24: p_Conversion_Type IGC_CC_MC_ACCT_LINES.Conversion_Type%TYPE,
25: p_Conversion_Date IGC_CC_MC_ACCT_LINES.Conversion_Date%TYPE,

Line 22: p_CC_Acct_Func_Amt IGC_CC_MC_ACCT_LINES.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_LINES.CC_Acct_Line_Id%TYPE,
21: p_Set_Of_Books_Id IGC_CC_MC_ACCT_LINES.Set_Of_Books_Id%TYPE,
22: p_CC_Acct_Func_Amt IGC_CC_MC_ACCT_LINES.CC_Acct_Func_Amt%TYPE,
23: p_CC_Acct_Encmbrnc_Amt IGC_CC_MC_ACCT_LINES.CC_Acct_Encmbrnc_Amt%TYPE,
24: p_Conversion_Type IGC_CC_MC_ACCT_LINES.Conversion_Type%TYPE,
25: p_Conversion_Date IGC_CC_MC_ACCT_LINES.Conversion_Date%TYPE,
26: p_Conversion_Rate IGC_CC_MC_ACCT_LINES.Conversion_Rate%TYPE,

Line 23: p_CC_Acct_Encmbrnc_Amt IGC_CC_MC_ACCT_LINES.CC_Acct_Encmbrnc_Amt%TYPE,

19: p_Rowid IN OUT NOCOPY VARCHAR2,
20: p_CC_Acct_Line_Id IGC_CC_MC_ACCT_LINES.CC_Acct_Line_Id%TYPE,
21: p_Set_Of_Books_Id IGC_CC_MC_ACCT_LINES.Set_Of_Books_Id%TYPE,
22: p_CC_Acct_Func_Amt IGC_CC_MC_ACCT_LINES.CC_Acct_Func_Amt%TYPE,
23: p_CC_Acct_Encmbrnc_Amt IGC_CC_MC_ACCT_LINES.CC_Acct_Encmbrnc_Amt%TYPE,
24: p_Conversion_Type IGC_CC_MC_ACCT_LINES.Conversion_Type%TYPE,
25: p_Conversion_Date IGC_CC_MC_ACCT_LINES.Conversion_Date%TYPE,
26: p_Conversion_Rate IGC_CC_MC_ACCT_LINES.Conversion_Rate%TYPE,
27: p_CC_Func_Withheld_Amt IGC_CC_MC_ACCT_LINES.cc_func_withheld_amt%TYPE

Line 24: p_Conversion_Type IGC_CC_MC_ACCT_LINES.Conversion_Type%TYPE,

20: p_CC_Acct_Line_Id IGC_CC_MC_ACCT_LINES.CC_Acct_Line_Id%TYPE,
21: p_Set_Of_Books_Id IGC_CC_MC_ACCT_LINES.Set_Of_Books_Id%TYPE,
22: p_CC_Acct_Func_Amt IGC_CC_MC_ACCT_LINES.CC_Acct_Func_Amt%TYPE,
23: p_CC_Acct_Encmbrnc_Amt IGC_CC_MC_ACCT_LINES.CC_Acct_Encmbrnc_Amt%TYPE,
24: p_Conversion_Type IGC_CC_MC_ACCT_LINES.Conversion_Type%TYPE,
25: p_Conversion_Date IGC_CC_MC_ACCT_LINES.Conversion_Date%TYPE,
26: p_Conversion_Rate IGC_CC_MC_ACCT_LINES.Conversion_Rate%TYPE,
27: p_CC_Func_Withheld_Amt IGC_CC_MC_ACCT_LINES.cc_func_withheld_amt%TYPE
28:

Line 25: p_Conversion_Date IGC_CC_MC_ACCT_LINES.Conversion_Date%TYPE,

21: p_Set_Of_Books_Id IGC_CC_MC_ACCT_LINES.Set_Of_Books_Id%TYPE,
22: p_CC_Acct_Func_Amt IGC_CC_MC_ACCT_LINES.CC_Acct_Func_Amt%TYPE,
23: p_CC_Acct_Encmbrnc_Amt IGC_CC_MC_ACCT_LINES.CC_Acct_Encmbrnc_Amt%TYPE,
24: p_Conversion_Type IGC_CC_MC_ACCT_LINES.Conversion_Type%TYPE,
25: p_Conversion_Date IGC_CC_MC_ACCT_LINES.Conversion_Date%TYPE,
26: p_Conversion_Rate IGC_CC_MC_ACCT_LINES.Conversion_Rate%TYPE,
27: p_CC_Func_Withheld_Amt IGC_CC_MC_ACCT_LINES.cc_func_withheld_amt%TYPE
28:
29: )

Line 26: p_Conversion_Rate IGC_CC_MC_ACCT_LINES.Conversion_Rate%TYPE,

22: p_CC_Acct_Func_Amt IGC_CC_MC_ACCT_LINES.CC_Acct_Func_Amt%TYPE,
23: p_CC_Acct_Encmbrnc_Amt IGC_CC_MC_ACCT_LINES.CC_Acct_Encmbrnc_Amt%TYPE,
24: p_Conversion_Type IGC_CC_MC_ACCT_LINES.Conversion_Type%TYPE,
25: p_Conversion_Date IGC_CC_MC_ACCT_LINES.Conversion_Date%TYPE,
26: p_Conversion_Rate IGC_CC_MC_ACCT_LINES.Conversion_Rate%TYPE,
27: p_CC_Func_Withheld_Amt IGC_CC_MC_ACCT_LINES.cc_func_withheld_amt%TYPE
28:
29: )
30:

Line 27: p_CC_Func_Withheld_Amt IGC_CC_MC_ACCT_LINES.cc_func_withheld_amt%TYPE

23: p_CC_Acct_Encmbrnc_Amt IGC_CC_MC_ACCT_LINES.CC_Acct_Encmbrnc_Amt%TYPE,
24: p_Conversion_Type IGC_CC_MC_ACCT_LINES.Conversion_Type%TYPE,
25: p_Conversion_Date IGC_CC_MC_ACCT_LINES.Conversion_Date%TYPE,
26: p_Conversion_Rate IGC_CC_MC_ACCT_LINES.Conversion_Rate%TYPE,
27: p_CC_Func_Withheld_Amt IGC_CC_MC_ACCT_LINES.cc_func_withheld_amt%TYPE
28:
29: )
30:
31: IS

Line 36: CURSOR C IS SELECT Rowid FROM IGC_CC_MC_ACCT_LINES

32:
33: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Row';
34: l_api_version CONSTANT NUMBER := 1.0;
35:
36: CURSOR C IS SELECT Rowid FROM IGC_CC_MC_ACCT_LINES
37: WHERE CC_Acct_Line_Id = p_CC_Acct_Line_Id;
38:
39: BEGIN
40:

Line 58: INSERT INTO IGC_CC_MC_ACCT_LINES (

54: END IF;
55:
56: X_return_status := FND_API.G_RET_STS_SUCCESS ;
57:
58: INSERT INTO IGC_CC_MC_ACCT_LINES (
59: CC_Acct_Line_Id,
60: Set_Of_Books_Id,
61: CC_Acct_Func_Amt,
62: CC_Acct_Encmbrnc_Amt,

Line 137: p_CC_Acct_Line_Id IGC_CC_MC_ACCT_LINES.CC_Acct_Line_Id%TYPE,

133: X_return_status OUT NOCOPY VARCHAR2,
134: X_msg_count OUT NOCOPY NUMBER,
135: X_msg_data OUT NOCOPY VARCHAR2,
136: p_Rowid IN OUT NOCOPY VARCHAR2,
137: p_CC_Acct_Line_Id IGC_CC_MC_ACCT_LINES.CC_Acct_Line_Id%TYPE,
138: p_Set_Of_Books_Id IGC_CC_MC_ACCT_LINES.Set_Of_Books_Id%TYPE,
139: p_CC_Acct_Func_Amt IGC_CC_MC_ACCT_LINES.CC_Acct_Func_Amt%TYPE,
140: p_CC_Acct_Encmbrnc_Amt IGC_CC_MC_ACCT_LINES.CC_Acct_Encmbrnc_Amt%TYPE,
141: p_Conversion_Type IGC_CC_MC_ACCT_LINES.Conversion_Type%TYPE,

Line 138: p_Set_Of_Books_Id IGC_CC_MC_ACCT_LINES.Set_Of_Books_Id%TYPE,

134: X_msg_count OUT NOCOPY NUMBER,
135: X_msg_data OUT NOCOPY VARCHAR2,
136: p_Rowid IN OUT NOCOPY VARCHAR2,
137: p_CC_Acct_Line_Id IGC_CC_MC_ACCT_LINES.CC_Acct_Line_Id%TYPE,
138: p_Set_Of_Books_Id IGC_CC_MC_ACCT_LINES.Set_Of_Books_Id%TYPE,
139: p_CC_Acct_Func_Amt IGC_CC_MC_ACCT_LINES.CC_Acct_Func_Amt%TYPE,
140: p_CC_Acct_Encmbrnc_Amt IGC_CC_MC_ACCT_LINES.CC_Acct_Encmbrnc_Amt%TYPE,
141: p_Conversion_Type IGC_CC_MC_ACCT_LINES.Conversion_Type%TYPE,
142: p_Conversion_Date IGC_CC_MC_ACCT_LINES.Conversion_Date%TYPE,

Line 139: p_CC_Acct_Func_Amt IGC_CC_MC_ACCT_LINES.CC_Acct_Func_Amt%TYPE,

135: X_msg_data OUT NOCOPY VARCHAR2,
136: p_Rowid IN OUT NOCOPY VARCHAR2,
137: p_CC_Acct_Line_Id IGC_CC_MC_ACCT_LINES.CC_Acct_Line_Id%TYPE,
138: p_Set_Of_Books_Id IGC_CC_MC_ACCT_LINES.Set_Of_Books_Id%TYPE,
139: p_CC_Acct_Func_Amt IGC_CC_MC_ACCT_LINES.CC_Acct_Func_Amt%TYPE,
140: p_CC_Acct_Encmbrnc_Amt IGC_CC_MC_ACCT_LINES.CC_Acct_Encmbrnc_Amt%TYPE,
141: p_Conversion_Type IGC_CC_MC_ACCT_LINES.Conversion_Type%TYPE,
142: p_Conversion_Date IGC_CC_MC_ACCT_LINES.Conversion_Date%TYPE,
143: p_Conversion_Rate IGC_CC_MC_ACCT_LINES.Conversion_Rate%TYPE,

Line 140: p_CC_Acct_Encmbrnc_Amt IGC_CC_MC_ACCT_LINES.CC_Acct_Encmbrnc_Amt%TYPE,

136: p_Rowid IN OUT NOCOPY VARCHAR2,
137: p_CC_Acct_Line_Id IGC_CC_MC_ACCT_LINES.CC_Acct_Line_Id%TYPE,
138: p_Set_Of_Books_Id IGC_CC_MC_ACCT_LINES.Set_Of_Books_Id%TYPE,
139: p_CC_Acct_Func_Amt IGC_CC_MC_ACCT_LINES.CC_Acct_Func_Amt%TYPE,
140: p_CC_Acct_Encmbrnc_Amt IGC_CC_MC_ACCT_LINES.CC_Acct_Encmbrnc_Amt%TYPE,
141: p_Conversion_Type IGC_CC_MC_ACCT_LINES.Conversion_Type%TYPE,
142: p_Conversion_Date IGC_CC_MC_ACCT_LINES.Conversion_Date%TYPE,
143: p_Conversion_Rate IGC_CC_MC_ACCT_LINES.Conversion_Rate%TYPE,
144: p_CC_Func_Withheld_Amt IGC_CC_MC_ACCT_LINES.cc_func_withheld_amt%TYPE,

Line 141: p_Conversion_Type IGC_CC_MC_ACCT_LINES.Conversion_Type%TYPE,

137: p_CC_Acct_Line_Id IGC_CC_MC_ACCT_LINES.CC_Acct_Line_Id%TYPE,
138: p_Set_Of_Books_Id IGC_CC_MC_ACCT_LINES.Set_Of_Books_Id%TYPE,
139: p_CC_Acct_Func_Amt IGC_CC_MC_ACCT_LINES.CC_Acct_Func_Amt%TYPE,
140: p_CC_Acct_Encmbrnc_Amt IGC_CC_MC_ACCT_LINES.CC_Acct_Encmbrnc_Amt%TYPE,
141: p_Conversion_Type IGC_CC_MC_ACCT_LINES.Conversion_Type%TYPE,
142: p_Conversion_Date IGC_CC_MC_ACCT_LINES.Conversion_Date%TYPE,
143: p_Conversion_Rate IGC_CC_MC_ACCT_LINES.Conversion_Rate%TYPE,
144: p_CC_Func_Withheld_Amt IGC_CC_MC_ACCT_LINES.cc_func_withheld_amt%TYPE,
145: X_row_locked OUT NOCOPY VARCHAR2

Line 142: p_Conversion_Date IGC_CC_MC_ACCT_LINES.Conversion_Date%TYPE,

138: p_Set_Of_Books_Id IGC_CC_MC_ACCT_LINES.Set_Of_Books_Id%TYPE,
139: p_CC_Acct_Func_Amt IGC_CC_MC_ACCT_LINES.CC_Acct_Func_Amt%TYPE,
140: p_CC_Acct_Encmbrnc_Amt IGC_CC_MC_ACCT_LINES.CC_Acct_Encmbrnc_Amt%TYPE,
141: p_Conversion_Type IGC_CC_MC_ACCT_LINES.Conversion_Type%TYPE,
142: p_Conversion_Date IGC_CC_MC_ACCT_LINES.Conversion_Date%TYPE,
143: p_Conversion_Rate IGC_CC_MC_ACCT_LINES.Conversion_Rate%TYPE,
144: p_CC_Func_Withheld_Amt IGC_CC_MC_ACCT_LINES.cc_func_withheld_amt%TYPE,
145: X_row_locked OUT NOCOPY VARCHAR2
146: ) IS

Line 143: p_Conversion_Rate IGC_CC_MC_ACCT_LINES.Conversion_Rate%TYPE,

139: p_CC_Acct_Func_Amt IGC_CC_MC_ACCT_LINES.CC_Acct_Func_Amt%TYPE,
140: p_CC_Acct_Encmbrnc_Amt IGC_CC_MC_ACCT_LINES.CC_Acct_Encmbrnc_Amt%TYPE,
141: p_Conversion_Type IGC_CC_MC_ACCT_LINES.Conversion_Type%TYPE,
142: p_Conversion_Date IGC_CC_MC_ACCT_LINES.Conversion_Date%TYPE,
143: p_Conversion_Rate IGC_CC_MC_ACCT_LINES.Conversion_Rate%TYPE,
144: p_CC_Func_Withheld_Amt IGC_CC_MC_ACCT_LINES.cc_func_withheld_amt%TYPE,
145: X_row_locked OUT NOCOPY VARCHAR2
146: ) IS
147: l_api_name CONSTANT VARCHAR2(30) := 'Lock_Row';

Line 144: p_CC_Func_Withheld_Amt IGC_CC_MC_ACCT_LINES.cc_func_withheld_amt%TYPE,

140: p_CC_Acct_Encmbrnc_Amt IGC_CC_MC_ACCT_LINES.CC_Acct_Encmbrnc_Amt%TYPE,
141: p_Conversion_Type IGC_CC_MC_ACCT_LINES.Conversion_Type%TYPE,
142: p_Conversion_Date IGC_CC_MC_ACCT_LINES.Conversion_Date%TYPE,
143: p_Conversion_Rate IGC_CC_MC_ACCT_LINES.Conversion_Rate%TYPE,
144: p_CC_Func_Withheld_Amt IGC_CC_MC_ACCT_LINES.cc_func_withheld_amt%TYPE,
145: X_row_locked OUT NOCOPY VARCHAR2
146: ) IS
147: l_api_name CONSTANT VARCHAR2(30) := 'Lock_Row';
148: l_api_version CONSTANT NUMBER := 1.0;

Line 153: FROM IGC_CC_MC_ACCT_LINES

149: Counter NUMBER;
150:
151: CURSOR C IS
152: SELECT *
153: FROM IGC_CC_MC_ACCT_LINES
154: WHERE rowid = p_Rowid
155: FOR UPDATE of CC_Acct_Line_Id NOWAIT;
156: Recinfo C%ROWTYPE;
157: BEGIN

Line 277: p_CC_Acct_Line_Id IGC_CC_MC_ACCT_LINES.CC_Acct_Line_Id%TYPE,

273: X_return_status OUT NOCOPY VARCHAR2,
274: X_msg_count OUT NOCOPY NUMBER,
275: X_msg_data OUT NOCOPY VARCHAR2,
276: p_Rowid IN OUT NOCOPY VARCHAR2,
277: p_CC_Acct_Line_Id IGC_CC_MC_ACCT_LINES.CC_Acct_Line_Id%TYPE,
278: p_Set_Of_Books_Id IGC_CC_MC_ACCT_LINES.Set_Of_Books_Id%TYPE,
279: p_CC_Acct_Func_Amt IGC_CC_MC_ACCT_LINES.CC_Acct_Func_Amt%TYPE,
280: p_CC_Acct_Encmbrnc_Amt IGC_CC_MC_ACCT_LINES.CC_Acct_Encmbrnc_Amt%TYPE,
281: p_Conversion_Type IGC_CC_MC_ACCT_LINES.Conversion_Type%TYPE,

Line 278: p_Set_Of_Books_Id IGC_CC_MC_ACCT_LINES.Set_Of_Books_Id%TYPE,

274: X_msg_count OUT NOCOPY NUMBER,
275: X_msg_data OUT NOCOPY VARCHAR2,
276: p_Rowid IN OUT NOCOPY VARCHAR2,
277: p_CC_Acct_Line_Id IGC_CC_MC_ACCT_LINES.CC_Acct_Line_Id%TYPE,
278: p_Set_Of_Books_Id IGC_CC_MC_ACCT_LINES.Set_Of_Books_Id%TYPE,
279: p_CC_Acct_Func_Amt IGC_CC_MC_ACCT_LINES.CC_Acct_Func_Amt%TYPE,
280: p_CC_Acct_Encmbrnc_Amt IGC_CC_MC_ACCT_LINES.CC_Acct_Encmbrnc_Amt%TYPE,
281: p_Conversion_Type IGC_CC_MC_ACCT_LINES.Conversion_Type%TYPE,
282: p_Conversion_Date IGC_CC_MC_ACCT_LINES.Conversion_Date%TYPE,

Line 279: p_CC_Acct_Func_Amt IGC_CC_MC_ACCT_LINES.CC_Acct_Func_Amt%TYPE,

275: X_msg_data OUT NOCOPY VARCHAR2,
276: p_Rowid IN OUT NOCOPY VARCHAR2,
277: p_CC_Acct_Line_Id IGC_CC_MC_ACCT_LINES.CC_Acct_Line_Id%TYPE,
278: p_Set_Of_Books_Id IGC_CC_MC_ACCT_LINES.Set_Of_Books_Id%TYPE,
279: p_CC_Acct_Func_Amt IGC_CC_MC_ACCT_LINES.CC_Acct_Func_Amt%TYPE,
280: p_CC_Acct_Encmbrnc_Amt IGC_CC_MC_ACCT_LINES.CC_Acct_Encmbrnc_Amt%TYPE,
281: p_Conversion_Type IGC_CC_MC_ACCT_LINES.Conversion_Type%TYPE,
282: p_Conversion_Date IGC_CC_MC_ACCT_LINES.Conversion_Date%TYPE,
283: p_Conversion_Rate IGC_CC_MC_ACCT_LINES.Conversion_Rate%TYPE,

Line 280: p_CC_Acct_Encmbrnc_Amt IGC_CC_MC_ACCT_LINES.CC_Acct_Encmbrnc_Amt%TYPE,

276: p_Rowid IN OUT NOCOPY VARCHAR2,
277: p_CC_Acct_Line_Id IGC_CC_MC_ACCT_LINES.CC_Acct_Line_Id%TYPE,
278: p_Set_Of_Books_Id IGC_CC_MC_ACCT_LINES.Set_Of_Books_Id%TYPE,
279: p_CC_Acct_Func_Amt IGC_CC_MC_ACCT_LINES.CC_Acct_Func_Amt%TYPE,
280: p_CC_Acct_Encmbrnc_Amt IGC_CC_MC_ACCT_LINES.CC_Acct_Encmbrnc_Amt%TYPE,
281: p_Conversion_Type IGC_CC_MC_ACCT_LINES.Conversion_Type%TYPE,
282: p_Conversion_Date IGC_CC_MC_ACCT_LINES.Conversion_Date%TYPE,
283: p_Conversion_Rate IGC_CC_MC_ACCT_LINES.Conversion_Rate%TYPE,
284: p_CC_Func_Withheld_Amt IGC_CC_MC_ACCT_LINES.cc_func_withheld_amt%TYPE

Line 281: p_Conversion_Type IGC_CC_MC_ACCT_LINES.Conversion_Type%TYPE,

277: p_CC_Acct_Line_Id IGC_CC_MC_ACCT_LINES.CC_Acct_Line_Id%TYPE,
278: p_Set_Of_Books_Id IGC_CC_MC_ACCT_LINES.Set_Of_Books_Id%TYPE,
279: p_CC_Acct_Func_Amt IGC_CC_MC_ACCT_LINES.CC_Acct_Func_Amt%TYPE,
280: p_CC_Acct_Encmbrnc_Amt IGC_CC_MC_ACCT_LINES.CC_Acct_Encmbrnc_Amt%TYPE,
281: p_Conversion_Type IGC_CC_MC_ACCT_LINES.Conversion_Type%TYPE,
282: p_Conversion_Date IGC_CC_MC_ACCT_LINES.Conversion_Date%TYPE,
283: p_Conversion_Rate IGC_CC_MC_ACCT_LINES.Conversion_Rate%TYPE,
284: p_CC_Func_Withheld_Amt IGC_CC_MC_ACCT_LINES.cc_func_withheld_amt%TYPE
285: ) IS

Line 282: p_Conversion_Date IGC_CC_MC_ACCT_LINES.Conversion_Date%TYPE,

278: p_Set_Of_Books_Id IGC_CC_MC_ACCT_LINES.Set_Of_Books_Id%TYPE,
279: p_CC_Acct_Func_Amt IGC_CC_MC_ACCT_LINES.CC_Acct_Func_Amt%TYPE,
280: p_CC_Acct_Encmbrnc_Amt IGC_CC_MC_ACCT_LINES.CC_Acct_Encmbrnc_Amt%TYPE,
281: p_Conversion_Type IGC_CC_MC_ACCT_LINES.Conversion_Type%TYPE,
282: p_Conversion_Date IGC_CC_MC_ACCT_LINES.Conversion_Date%TYPE,
283: p_Conversion_Rate IGC_CC_MC_ACCT_LINES.Conversion_Rate%TYPE,
284: p_CC_Func_Withheld_Amt IGC_CC_MC_ACCT_LINES.cc_func_withheld_amt%TYPE
285: ) IS
286:

Line 283: p_Conversion_Rate IGC_CC_MC_ACCT_LINES.Conversion_Rate%TYPE,

279: p_CC_Acct_Func_Amt IGC_CC_MC_ACCT_LINES.CC_Acct_Func_Amt%TYPE,
280: p_CC_Acct_Encmbrnc_Amt IGC_CC_MC_ACCT_LINES.CC_Acct_Encmbrnc_Amt%TYPE,
281: p_Conversion_Type IGC_CC_MC_ACCT_LINES.Conversion_Type%TYPE,
282: p_Conversion_Date IGC_CC_MC_ACCT_LINES.Conversion_Date%TYPE,
283: p_Conversion_Rate IGC_CC_MC_ACCT_LINES.Conversion_Rate%TYPE,
284: p_CC_Func_Withheld_Amt IGC_CC_MC_ACCT_LINES.cc_func_withheld_amt%TYPE
285: ) IS
286:
287: l_api_name CONSTANT VARCHAR2(30) := 'Update_Row';

Line 284: p_CC_Func_Withheld_Amt IGC_CC_MC_ACCT_LINES.cc_func_withheld_amt%TYPE

280: p_CC_Acct_Encmbrnc_Amt IGC_CC_MC_ACCT_LINES.CC_Acct_Encmbrnc_Amt%TYPE,
281: p_Conversion_Type IGC_CC_MC_ACCT_LINES.Conversion_Type%TYPE,
282: p_Conversion_Date IGC_CC_MC_ACCT_LINES.Conversion_Date%TYPE,
283: p_Conversion_Rate IGC_CC_MC_ACCT_LINES.Conversion_Rate%TYPE,
284: p_CC_Func_Withheld_Amt IGC_CC_MC_ACCT_LINES.cc_func_withheld_amt%TYPE
285: ) IS
286:
287: l_api_name CONSTANT VARCHAR2(30) := 'Update_Row';
288: l_api_version CONSTANT NUMBER := 1.0;

Line 309: UPDATE IGC_CC_MC_ACCT_LINES

305: END IF;
306:
307: X_return_status := FND_API.G_RET_STS_SUCCESS ;
308:
309: UPDATE IGC_CC_MC_ACCT_LINES
310: SET
311: CC_Acct_Line_Id = p_CC_Acct_Line_Id,
312: Set_Of_Books_Id = p_Set_Of_Books_Id,
313: CC_Acct_Func_Amt = p_CC_Acct_Func_Amt,

Line 403: DELETE FROM IGC_CC_MC_ACCT_LINES

399: END IF ;
400:
401: X_return_status := FND_API.G_RET_STS_SUCCESS ;
402:
403: DELETE FROM IGC_CC_MC_ACCT_LINES
404: WHERE rowid = p_Rowid;
405:
406: if (SQL%NOTFOUND) then
407: Raise NO_DATA_FOUND;

Line 452: END IGC_CC_MC_ACCT_LINES_PKG;

448:
449:
450:
451:
452: END IGC_CC_MC_ACCT_LINES_PKG;