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_COMP_AMT_PKG dependencies on IGC_CC_HEADERS

Line 8: l_cc_num igc_cc_headers.cc_num%TYPE;

4: FUNCTION COMPUTE_ACCT_BILLED_AMT_CURR(p_cc_acct_line_id NUMBER)
5: RETURN NUMBER
6: IS
7: l_func_billed_amount NUMBER := 0;
8: l_cc_num igc_cc_headers.cc_num%TYPE;
9: l_cc_type igc_cc_headers.cc_type%TYPE;
10: l_org_id igc_cc_headers.org_id%TYPE;
11: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
12: l_cc_acct_line_num igc_cc_acct_lines.cc_acct_line_num%TYPE;

Line 9: l_cc_type igc_cc_headers.cc_type%TYPE;

5: RETURN NUMBER
6: IS
7: l_func_billed_amount NUMBER := 0;
8: l_cc_num igc_cc_headers.cc_num%TYPE;
9: l_cc_type igc_cc_headers.cc_type%TYPE;
10: l_org_id igc_cc_headers.org_id%TYPE;
11: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
12: l_cc_acct_line_num igc_cc_acct_lines.cc_acct_line_num%TYPE;
13: BEGIN

Line 10: l_org_id igc_cc_headers.org_id%TYPE;

6: IS
7: l_func_billed_amount NUMBER := 0;
8: l_cc_num igc_cc_headers.cc_num%TYPE;
9: l_cc_type igc_cc_headers.cc_type%TYPE;
10: l_org_id igc_cc_headers.org_id%TYPE;
11: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
12: l_cc_acct_line_num igc_cc_acct_lines.cc_acct_line_num%TYPE;
13: BEGIN
14:

Line 11: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;

7: l_func_billed_amount NUMBER := 0;
8: l_cc_num igc_cc_headers.cc_num%TYPE;
9: l_cc_type igc_cc_headers.cc_type%TYPE;
10: l_org_id igc_cc_headers.org_id%TYPE;
11: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
12: l_cc_acct_line_num igc_cc_acct_lines.cc_acct_line_num%TYPE;
13: BEGIN
14:
15: SELECT cc_acct_line_num, cc_header_id

Line 22: FROM igc_cc_headers

18: WHERE cc_acct_line_id = p_cc_acct_line_id;
19:
20: SELECT cc_num, org_id, cc_type
21: INTO l_cc_num, l_org_id, l_cc_type
22: FROM igc_cc_headers
23: WHERE cc_header_id = l_cc_header_id;
24:
25: IF ( (l_cc_type = 'S') OR (l_cc_type = 'R') )
26: THEN

Line 88: l_cc_num igc_cc_headers.cc_num%TYPE;

84: p_cc_acct_line_id NUMBER)
85: RETURN NUMBER
86: IS
87: l_func_billed_amount NUMBER := 0;
88: l_cc_num igc_cc_headers.cc_num%TYPE;
89: l_cc_type igc_cc_headers.cc_type%TYPE;
90: l_org_id igc_cc_headers.org_id%TYPE;
91: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
92: l_cc_acct_line_num igc_cc_acct_lines.cc_acct_line_num%TYPE;

Line 89: l_cc_type igc_cc_headers.cc_type%TYPE;

85: RETURN NUMBER
86: IS
87: l_func_billed_amount NUMBER := 0;
88: l_cc_num igc_cc_headers.cc_num%TYPE;
89: l_cc_type igc_cc_headers.cc_type%TYPE;
90: l_org_id igc_cc_headers.org_id%TYPE;
91: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
92: l_cc_acct_line_num igc_cc_acct_lines.cc_acct_line_num%TYPE;
93: BEGIN

Line 90: l_org_id igc_cc_headers.org_id%TYPE;

86: IS
87: l_func_billed_amount NUMBER := 0;
88: l_cc_num igc_cc_headers.cc_num%TYPE;
89: l_cc_type igc_cc_headers.cc_type%TYPE;
90: l_org_id igc_cc_headers.org_id%TYPE;
91: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
92: l_cc_acct_line_num igc_cc_acct_lines.cc_acct_line_num%TYPE;
93: BEGIN
94:

Line 91: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;

87: l_func_billed_amount NUMBER := 0;
88: l_cc_num igc_cc_headers.cc_num%TYPE;
89: l_cc_type igc_cc_headers.cc_type%TYPE;
90: l_org_id igc_cc_headers.org_id%TYPE;
91: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
92: l_cc_acct_line_num igc_cc_acct_lines.cc_acct_line_num%TYPE;
93: BEGIN
94:
95: SELECT cc_acct_line_num, cc_header_id

Line 102: FROM igc_cc_headers

98: WHERE cc_acct_line_id = p_cc_acct_line_id;
99:
100: SELECT cc_num, org_id, cc_type
101: INTO l_cc_num, l_org_id, l_cc_type
102: FROM igc_cc_headers
103: WHERE cc_header_id = l_cc_header_id;
104:
105: IF ( (l_cc_type = 'S') OR (l_cc_type = 'R') )
106: THEN

Line 161: l_cc_num igc_cc_headers.cc_num%TYPE;

157: p_cc_acct_line_id NUMBER)
158: RETURN NUMBER
159: IS
160: l_billed_amount NUMBER := 0;
161: l_cc_num igc_cc_headers.cc_num%TYPE;
162: l_cc_type igc_cc_headers.cc_type%TYPE;
163: l_org_id igc_cc_headers.org_id%TYPE;
164: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
165: l_cc_acct_line_num igc_cc_acct_lines.cc_acct_line_num%TYPE;

Line 162: l_cc_type igc_cc_headers.cc_type%TYPE;

158: RETURN NUMBER
159: IS
160: l_billed_amount NUMBER := 0;
161: l_cc_num igc_cc_headers.cc_num%TYPE;
162: l_cc_type igc_cc_headers.cc_type%TYPE;
163: l_org_id igc_cc_headers.org_id%TYPE;
164: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
165: l_cc_acct_line_num igc_cc_acct_lines.cc_acct_line_num%TYPE;
166: l_sob_id igc_cc_headers.set_of_books_id%TYPE;

Line 163: l_org_id igc_cc_headers.org_id%TYPE;

159: IS
160: l_billed_amount NUMBER := 0;
161: l_cc_num igc_cc_headers.cc_num%TYPE;
162: l_cc_type igc_cc_headers.cc_type%TYPE;
163: l_org_id igc_cc_headers.org_id%TYPE;
164: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
165: l_cc_acct_line_num igc_cc_acct_lines.cc_acct_line_num%TYPE;
166: l_sob_id igc_cc_headers.set_of_books_id%TYPE;
167: l_currency_code igc_cc_headers.currency_code%TYPE;

Line 164: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;

160: l_billed_amount NUMBER := 0;
161: l_cc_num igc_cc_headers.cc_num%TYPE;
162: l_cc_type igc_cc_headers.cc_type%TYPE;
163: l_org_id igc_cc_headers.org_id%TYPE;
164: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
165: l_cc_acct_line_num igc_cc_acct_lines.cc_acct_line_num%TYPE;
166: l_sob_id igc_cc_headers.set_of_books_id%TYPE;
167: l_currency_code igc_cc_headers.currency_code%TYPE;
168: l_func_currency_code igc_cc_headers.currency_code%TYPE;

Line 166: l_sob_id igc_cc_headers.set_of_books_id%TYPE;

162: l_cc_type igc_cc_headers.cc_type%TYPE;
163: l_org_id igc_cc_headers.org_id%TYPE;
164: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
165: l_cc_acct_line_num igc_cc_acct_lines.cc_acct_line_num%TYPE;
166: l_sob_id igc_cc_headers.set_of_books_id%TYPE;
167: l_currency_code igc_cc_headers.currency_code%TYPE;
168: l_func_currency_code igc_cc_headers.currency_code%TYPE;
169: BEGIN
170:

Line 167: l_currency_code igc_cc_headers.currency_code%TYPE;

163: l_org_id igc_cc_headers.org_id%TYPE;
164: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
165: l_cc_acct_line_num igc_cc_acct_lines.cc_acct_line_num%TYPE;
166: l_sob_id igc_cc_headers.set_of_books_id%TYPE;
167: l_currency_code igc_cc_headers.currency_code%TYPE;
168: l_func_currency_code igc_cc_headers.currency_code%TYPE;
169: BEGIN
170:
171: SELECT cc_acct_line_num, cc_header_id

Line 168: l_func_currency_code igc_cc_headers.currency_code%TYPE;

164: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
165: l_cc_acct_line_num igc_cc_acct_lines.cc_acct_line_num%TYPE;
166: l_sob_id igc_cc_headers.set_of_books_id%TYPE;
167: l_currency_code igc_cc_headers.currency_code%TYPE;
168: l_func_currency_code igc_cc_headers.currency_code%TYPE;
169: BEGIN
170:
171: SELECT cc_acct_line_num, cc_header_id
172: INTO l_cc_acct_line_num, l_cc_header_id

Line 178: FROM igc_cc_headers

174: WHERE cc_acct_line_id = p_cc_acct_line_id;
175:
176: SELECT cc_num, org_id, cc_type, set_of_books_id, currency_code
177: INTO l_cc_num, l_org_id, l_cc_type, l_sob_id, l_currency_code
178: FROM igc_cc_headers
179: WHERE cc_header_id = l_cc_header_id;
180:
181: SELECT currency_code
182: INTO l_func_currency_code

Line 266: l_cc_num igc_cc_headers.cc_num%TYPE;

262: FUNCTION COMPUTE_ACCT_BILLED_AMT(p_cc_acct_line_id NUMBER)
263: RETURN NUMBER
264: IS
265: l_billed_amount NUMBER := 0;
266: l_cc_num igc_cc_headers.cc_num%TYPE;
267: l_cc_type igc_cc_headers.cc_type%TYPE;
268: l_org_id igc_cc_headers.org_id%TYPE;
269: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
270: l_cc_acct_line_num igc_cc_acct_lines.cc_acct_line_num%TYPE;

Line 267: l_cc_type igc_cc_headers.cc_type%TYPE;

263: RETURN NUMBER
264: IS
265: l_billed_amount NUMBER := 0;
266: l_cc_num igc_cc_headers.cc_num%TYPE;
267: l_cc_type igc_cc_headers.cc_type%TYPE;
268: l_org_id igc_cc_headers.org_id%TYPE;
269: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
270: l_cc_acct_line_num igc_cc_acct_lines.cc_acct_line_num%TYPE;
271: l_sob_id igc_cc_headers.set_of_books_id%TYPE;

Line 268: l_org_id igc_cc_headers.org_id%TYPE;

264: IS
265: l_billed_amount NUMBER := 0;
266: l_cc_num igc_cc_headers.cc_num%TYPE;
267: l_cc_type igc_cc_headers.cc_type%TYPE;
268: l_org_id igc_cc_headers.org_id%TYPE;
269: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
270: l_cc_acct_line_num igc_cc_acct_lines.cc_acct_line_num%TYPE;
271: l_sob_id igc_cc_headers.set_of_books_id%TYPE;
272: l_currency_code igc_cc_headers.currency_code%TYPE;

Line 269: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;

265: l_billed_amount NUMBER := 0;
266: l_cc_num igc_cc_headers.cc_num%TYPE;
267: l_cc_type igc_cc_headers.cc_type%TYPE;
268: l_org_id igc_cc_headers.org_id%TYPE;
269: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
270: l_cc_acct_line_num igc_cc_acct_lines.cc_acct_line_num%TYPE;
271: l_sob_id igc_cc_headers.set_of_books_id%TYPE;
272: l_currency_code igc_cc_headers.currency_code%TYPE;
273: l_func_currency_code igc_cc_headers.currency_code%TYPE;

Line 271: l_sob_id igc_cc_headers.set_of_books_id%TYPE;

267: l_cc_type igc_cc_headers.cc_type%TYPE;
268: l_org_id igc_cc_headers.org_id%TYPE;
269: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
270: l_cc_acct_line_num igc_cc_acct_lines.cc_acct_line_num%TYPE;
271: l_sob_id igc_cc_headers.set_of_books_id%TYPE;
272: l_currency_code igc_cc_headers.currency_code%TYPE;
273: l_func_currency_code igc_cc_headers.currency_code%TYPE;
274: BEGIN
275:

Line 272: l_currency_code igc_cc_headers.currency_code%TYPE;

268: l_org_id igc_cc_headers.org_id%TYPE;
269: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
270: l_cc_acct_line_num igc_cc_acct_lines.cc_acct_line_num%TYPE;
271: l_sob_id igc_cc_headers.set_of_books_id%TYPE;
272: l_currency_code igc_cc_headers.currency_code%TYPE;
273: l_func_currency_code igc_cc_headers.currency_code%TYPE;
274: BEGIN
275:
276: SELECT cc_acct_line_num, cc_header_id

Line 273: l_func_currency_code igc_cc_headers.currency_code%TYPE;

269: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
270: l_cc_acct_line_num igc_cc_acct_lines.cc_acct_line_num%TYPE;
271: l_sob_id igc_cc_headers.set_of_books_id%TYPE;
272: l_currency_code igc_cc_headers.currency_code%TYPE;
273: l_func_currency_code igc_cc_headers.currency_code%TYPE;
274: BEGIN
275:
276: SELECT cc_acct_line_num, cc_header_id
277: INTO l_cc_acct_line_num, l_cc_header_id

Line 283: FROM igc_cc_headers

279: WHERE cc_acct_line_id = p_cc_acct_line_id;
280:
281: SELECT cc_num, org_id, cc_type, set_of_books_id, currency_code
282: INTO l_cc_num, l_org_id, l_cc_type, l_sob_id, l_currency_code
283: FROM igc_cc_headers
284: WHERE cc_header_id = l_cc_header_id;
285:
286: SELECT currency_code
287: INTO l_func_currency_code

Line 380: l_cc_conversion_rate igc_cc_headers.conversion_rate%TYPE;

376:
377: FUNCTION COMPUTE_FUNCTIONAL_AMT ( p_cc_header_id NUMBER, p_cc_func_amt NUMBER)
378: RETURN NUMBER
379: IS
380: l_cc_conversion_rate igc_cc_headers.conversion_rate%TYPE;
381: l_cc_func_amt igc_cc_acct_lines.cc_acct_func_amt%TYPE;
382: BEGIN
383: BEGIN
384: SELECT cc.conversion_rate

Line 386: FROM igc_cc_headers cc

382: BEGIN
383: BEGIN
384: SELECT cc.conversion_rate
385: INTO l_cc_conversion_rate
386: FROM igc_cc_headers cc
387: WHERE cc.cc_header_id = p_cc_header_id;
388: EXCEPTION
389: WHEN NO_DATA_FOUND THEN
390: l_cc_conversion_rate := 1;

Line 405: l_cc_num igc_cc_headers.cc_num%TYPE;

401: p_cc_acct_line_id NUMBER)
402: RETURN NUMBER
403: IS
404: l_func_billed_amount NUMBER := 0;
405: l_cc_num igc_cc_headers.cc_num%TYPE;
406: l_cc_type igc_cc_headers.cc_type%TYPE;
407: l_org_id igc_cc_headers.org_id%TYPE;
408: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
409: l_cc_acct_line_num igc_cc_acct_lines.cc_acct_line_num%TYPE;

Line 406: l_cc_type igc_cc_headers.cc_type%TYPE;

402: RETURN NUMBER
403: IS
404: l_func_billed_amount NUMBER := 0;
405: l_cc_num igc_cc_headers.cc_num%TYPE;
406: l_cc_type igc_cc_headers.cc_type%TYPE;
407: l_org_id igc_cc_headers.org_id%TYPE;
408: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
409: l_cc_acct_line_num igc_cc_acct_lines.cc_acct_line_num%TYPE;
410: BEGIN

Line 407: l_org_id igc_cc_headers.org_id%TYPE;

403: IS
404: l_func_billed_amount NUMBER := 0;
405: l_cc_num igc_cc_headers.cc_num%TYPE;
406: l_cc_type igc_cc_headers.cc_type%TYPE;
407: l_org_id igc_cc_headers.org_id%TYPE;
408: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
409: l_cc_acct_line_num igc_cc_acct_lines.cc_acct_line_num%TYPE;
410: BEGIN
411:

Line 408: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;

404: l_func_billed_amount NUMBER := 0;
405: l_cc_num igc_cc_headers.cc_num%TYPE;
406: l_cc_type igc_cc_headers.cc_type%TYPE;
407: l_org_id igc_cc_headers.org_id%TYPE;
408: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
409: l_cc_acct_line_num igc_cc_acct_lines.cc_acct_line_num%TYPE;
410: BEGIN
411:
412: SELECT cc_acct_line_num, cc_header_id

Line 419: FROM igc_cc_headers

415: WHERE cc_acct_line_id = p_cc_acct_line_id;
416:
417: SELECT cc_num, org_id, cc_type
418: INTO l_cc_num, l_org_id, l_cc_type
419: FROM igc_cc_headers
420: WHERE cc_header_id = l_cc_header_id;
421:
422: IF ( (l_cc_type = 'S') OR (l_cc_type = 'R') )
423: THEN

Line 475: l_cc_num igc_cc_headers.cc_num%TYPE;

471: FUNCTION COMPUTE_ACCT_FUNC_BILLED_AMT(p_cc_acct_line_id NUMBER)
472: RETURN NUMBER
473: IS
474: l_func_billed_amount NUMBER := 0;
475: l_cc_num igc_cc_headers.cc_num%TYPE;
476: l_cc_type igc_cc_headers.cc_type%TYPE;
477: l_org_id igc_cc_headers.org_id%TYPE;
478: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
479: l_cc_acct_line_num igc_cc_acct_lines.cc_acct_line_num%TYPE;

Line 476: l_cc_type igc_cc_headers.cc_type%TYPE;

472: RETURN NUMBER
473: IS
474: l_func_billed_amount NUMBER := 0;
475: l_cc_num igc_cc_headers.cc_num%TYPE;
476: l_cc_type igc_cc_headers.cc_type%TYPE;
477: l_org_id igc_cc_headers.org_id%TYPE;
478: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
479: l_cc_acct_line_num igc_cc_acct_lines.cc_acct_line_num%TYPE;
480: BEGIN

Line 477: l_org_id igc_cc_headers.org_id%TYPE;

473: IS
474: l_func_billed_amount NUMBER := 0;
475: l_cc_num igc_cc_headers.cc_num%TYPE;
476: l_cc_type igc_cc_headers.cc_type%TYPE;
477: l_org_id igc_cc_headers.org_id%TYPE;
478: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
479: l_cc_acct_line_num igc_cc_acct_lines.cc_acct_line_num%TYPE;
480: BEGIN
481:

Line 478: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;

474: l_func_billed_amount NUMBER := 0;
475: l_cc_num igc_cc_headers.cc_num%TYPE;
476: l_cc_type igc_cc_headers.cc_type%TYPE;
477: l_org_id igc_cc_headers.org_id%TYPE;
478: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;
479: l_cc_acct_line_num igc_cc_acct_lines.cc_acct_line_num%TYPE;
480: BEGIN
481:
482: SELECT cc_acct_line_num, cc_header_id

Line 489: FROM igc_cc_headers

485: WHERE cc_acct_line_id = p_cc_acct_line_id;
486:
487: SELECT cc_num, org_id, cc_type
488: INTO l_cc_num, l_org_id, l_cc_type
489: FROM igc_cc_headers
490: WHERE cc_header_id = l_cc_header_id;
491:
492: IF ( (l_cc_type = 'S') OR (l_cc_type = 'R') )
493: THEN