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.JL_CO_GL_MG_MEDIA_PKG dependencies on JL_CO_GL_MG_LINES

Line 16: x_reported_flag jl_co_gl_mg_lines.reported_flag%TYPE;

12: x_verifying_digit jl_co_gl_nits.verifying_digit%TYPE;
13:
14: x_literal_code jl_co_gl_mg_literals.literal_code%TYPE;
15:
16: x_reported_flag jl_co_gl_mg_lines.reported_flag%TYPE;
17:
18: x_first_value jl_co_gl_mg_lines.first_reported_value%TYPE;
19: x_second_value jl_co_gl_mg_lines.second_reported_value%TYPE;
20: x_third_value jl_co_gl_mg_lines.third_reported_value%TYPE;

Line 18: x_first_value jl_co_gl_mg_lines.first_reported_value%TYPE;

14: x_literal_code jl_co_gl_mg_literals.literal_code%TYPE;
15:
16: x_reported_flag jl_co_gl_mg_lines.reported_flag%TYPE;
17:
18: x_first_value jl_co_gl_mg_lines.first_reported_value%TYPE;
19: x_second_value jl_co_gl_mg_lines.second_reported_value%TYPE;
20: x_third_value jl_co_gl_mg_lines.third_reported_value%TYPE;
21: x_fourth_value jl_co_gl_mg_lines.fourth_reported_value%TYPE;
22: x_fifth_value jl_co_gl_mg_lines.fifth_reported_value%TYPE;

Line 19: x_second_value jl_co_gl_mg_lines.second_reported_value%TYPE;

15:
16: x_reported_flag jl_co_gl_mg_lines.reported_flag%TYPE;
17:
18: x_first_value jl_co_gl_mg_lines.first_reported_value%TYPE;
19: x_second_value jl_co_gl_mg_lines.second_reported_value%TYPE;
20: x_third_value jl_co_gl_mg_lines.third_reported_value%TYPE;
21: x_fourth_value jl_co_gl_mg_lines.fourth_reported_value%TYPE;
22: x_fifth_value jl_co_gl_mg_lines.fifth_reported_value%TYPE;
23: x_sixth_value jl_co_gl_mg_lines.sixth_reported_value%TYPE;

Line 20: x_third_value jl_co_gl_mg_lines.third_reported_value%TYPE;

16: x_reported_flag jl_co_gl_mg_lines.reported_flag%TYPE;
17:
18: x_first_value jl_co_gl_mg_lines.first_reported_value%TYPE;
19: x_second_value jl_co_gl_mg_lines.second_reported_value%TYPE;
20: x_third_value jl_co_gl_mg_lines.third_reported_value%TYPE;
21: x_fourth_value jl_co_gl_mg_lines.fourth_reported_value%TYPE;
22: x_fifth_value jl_co_gl_mg_lines.fifth_reported_value%TYPE;
23: x_sixth_value jl_co_gl_mg_lines.sixth_reported_value%TYPE;
24: x_seventh_value jl_co_gl_mg_lines.seventh_reported_value%TYPE;

Line 21: x_fourth_value jl_co_gl_mg_lines.fourth_reported_value%TYPE;

17:
18: x_first_value jl_co_gl_mg_lines.first_reported_value%TYPE;
19: x_second_value jl_co_gl_mg_lines.second_reported_value%TYPE;
20: x_third_value jl_co_gl_mg_lines.third_reported_value%TYPE;
21: x_fourth_value jl_co_gl_mg_lines.fourth_reported_value%TYPE;
22: x_fifth_value jl_co_gl_mg_lines.fifth_reported_value%TYPE;
23: x_sixth_value jl_co_gl_mg_lines.sixth_reported_value%TYPE;
24: x_seventh_value jl_co_gl_mg_lines.seventh_reported_value%TYPE;
25: x_eighth_value jl_co_gl_mg_lines.eighth_reported_value%TYPE;

Line 22: x_fifth_value jl_co_gl_mg_lines.fifth_reported_value%TYPE;

18: x_first_value jl_co_gl_mg_lines.first_reported_value%TYPE;
19: x_second_value jl_co_gl_mg_lines.second_reported_value%TYPE;
20: x_third_value jl_co_gl_mg_lines.third_reported_value%TYPE;
21: x_fourth_value jl_co_gl_mg_lines.fourth_reported_value%TYPE;
22: x_fifth_value jl_co_gl_mg_lines.fifth_reported_value%TYPE;
23: x_sixth_value jl_co_gl_mg_lines.sixth_reported_value%TYPE;
24: x_seventh_value jl_co_gl_mg_lines.seventh_reported_value%TYPE;
25: x_eighth_value jl_co_gl_mg_lines.eighth_reported_value%TYPE;
26: x_ninth_value jl_co_gl_mg_lines.ninth_reported_value%TYPE;

Line 23: x_sixth_value jl_co_gl_mg_lines.sixth_reported_value%TYPE;

19: x_second_value jl_co_gl_mg_lines.second_reported_value%TYPE;
20: x_third_value jl_co_gl_mg_lines.third_reported_value%TYPE;
21: x_fourth_value jl_co_gl_mg_lines.fourth_reported_value%TYPE;
22: x_fifth_value jl_co_gl_mg_lines.fifth_reported_value%TYPE;
23: x_sixth_value jl_co_gl_mg_lines.sixth_reported_value%TYPE;
24: x_seventh_value jl_co_gl_mg_lines.seventh_reported_value%TYPE;
25: x_eighth_value jl_co_gl_mg_lines.eighth_reported_value%TYPE;
26: x_ninth_value jl_co_gl_mg_lines.ninth_reported_value%TYPE;
27:

Line 24: x_seventh_value jl_co_gl_mg_lines.seventh_reported_value%TYPE;

20: x_third_value jl_co_gl_mg_lines.third_reported_value%TYPE;
21: x_fourth_value jl_co_gl_mg_lines.fourth_reported_value%TYPE;
22: x_fifth_value jl_co_gl_mg_lines.fifth_reported_value%TYPE;
23: x_sixth_value jl_co_gl_mg_lines.sixth_reported_value%TYPE;
24: x_seventh_value jl_co_gl_mg_lines.seventh_reported_value%TYPE;
25: x_eighth_value jl_co_gl_mg_lines.eighth_reported_value%TYPE;
26: x_ninth_value jl_co_gl_mg_lines.ninth_reported_value%TYPE;
27:
28: x_mg_header_id jl_co_gl_mg_headers.mg_header_id%TYPE;

Line 25: x_eighth_value jl_co_gl_mg_lines.eighth_reported_value%TYPE;

21: x_fourth_value jl_co_gl_mg_lines.fourth_reported_value%TYPE;
22: x_fifth_value jl_co_gl_mg_lines.fifth_reported_value%TYPE;
23: x_sixth_value jl_co_gl_mg_lines.sixth_reported_value%TYPE;
24: x_seventh_value jl_co_gl_mg_lines.seventh_reported_value%TYPE;
25: x_eighth_value jl_co_gl_mg_lines.eighth_reported_value%TYPE;
26: x_ninth_value jl_co_gl_mg_lines.ninth_reported_value%TYPE;
27:
28: x_mg_header_id jl_co_gl_mg_headers.mg_header_id%TYPE;
29:

Line 26: x_ninth_value jl_co_gl_mg_lines.ninth_reported_value%TYPE;

22: x_fifth_value jl_co_gl_mg_lines.fifth_reported_value%TYPE;
23: x_sixth_value jl_co_gl_mg_lines.sixth_reported_value%TYPE;
24: x_seventh_value jl_co_gl_mg_lines.seventh_reported_value%TYPE;
25: x_eighth_value jl_co_gl_mg_lines.eighth_reported_value%TYPE;
26: x_ninth_value jl_co_gl_mg_lines.ninth_reported_value%TYPE;
27:
28: x_mg_header_id jl_co_gl_mg_headers.mg_header_id%TYPE;
29:
30: count_process_flag NUMBER := 0;

Line 37: mg_line_id jl_co_gl_mg_lines.mg_line_id%TYPE,

33: x_file_handle UTL_FILE.FILE_TYPE;
34:
35: TYPE get_movement_record IS RECORD (
36: mg_header_id jl_co_gl_mg_headers.mg_header_id%TYPE,
37: mg_line_id jl_co_gl_mg_lines.mg_line_id%TYPE,
38: literal_id jl_co_gl_mg_literals.literal_id%TYPE,
39: foreign_reported_flag jl_co_gl_mg_literals.foreign_reported_flag%TYPE,
40: foreign_description jl_co_gl_mg_literals.foreign_description%TYPE,
41: domestic_reported_flag jl_co_gl_mg_literals.domestic_reported_flag%TYPE,

Line 47: send_back_flag jl_co_gl_mg_lines.send_back_flag%TYPE,

43: nit_id jl_co_gl_nits.nit_id%TYPE,
44: config_id jl_co_gl_mg_configs.config_id%TYPE,
45: literal_literal_id jl_co_gl_mg_configs.literal_literal_id%TYPE,
46: range_id jl_co_gl_mg_ranges.range_id%TYPE,
47: send_back_flag jl_co_gl_mg_lines.send_back_flag%TYPE,
48: origin jl_co_gl_mg_lines.origin%TYPE,
49: amount jl_co_gl_mg_lines.first_reported_value%TYPE
50: );
51:

Line 48: origin jl_co_gl_mg_lines.origin%TYPE,

44: config_id jl_co_gl_mg_configs.config_id%TYPE,
45: literal_literal_id jl_co_gl_mg_configs.literal_literal_id%TYPE,
46: range_id jl_co_gl_mg_ranges.range_id%TYPE,
47: send_back_flag jl_co_gl_mg_lines.send_back_flag%TYPE,
48: origin jl_co_gl_mg_lines.origin%TYPE,
49: amount jl_co_gl_mg_lines.first_reported_value%TYPE
50: );
51:
52: get_move_rec get_movement_record;

Line 49: amount jl_co_gl_mg_lines.first_reported_value%TYPE

45: literal_literal_id jl_co_gl_mg_configs.literal_literal_id%TYPE,
46: range_id jl_co_gl_mg_ranges.range_id%TYPE,
47: send_back_flag jl_co_gl_mg_lines.send_back_flag%TYPE,
48: origin jl_co_gl_mg_lines.origin%TYPE,
49: amount jl_co_gl_mg_lines.first_reported_value%TYPE
50: );
51:
52: get_move_rec get_movement_record;
53: null_get_move_rec get_movement_record;

Line 219: Procedure to validate and insert into jl_co_gl_mg_lines table.

215:
216:
217:
218: /****************************************************************
219: Procedure to validate and insert into jl_co_gl_mg_lines table.
220: This procedure will be called only when the amount returned from
221: cursors trx_cur and bal_cur is more than zero
222: ****************************************************************/
223:

Line 322: Insert rows into jl_co_gl_mg_lines

318: x_reported_flag := 'N';
319: END IF;
320:
321: /**********************************
322: Insert rows into jl_co_gl_mg_lines
323: **********************************/
324:
325: BEGIN
326:

Line 327: INSERT INTO jl_co_gl_mg_lines

323: **********************************/
324:
325: BEGIN
326:
327: INSERT INTO jl_co_gl_mg_lines
328: (mg_line_id,
329: mg_header_id,
330: literal_id,
331: reported_value,

Line 390: 'Exception "OTHERS" while inserting into jl_co_gl_mg_lines table');

386: WHEN OTHERS THEN
387:
388: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
389: fnd_message.set_token('GENERIC_TEXT',
390: 'Exception "OTHERS" while inserting into jl_co_gl_mg_lines table');
391: x_error_text := SUBSTR(fnd_message.get, 1, 100);
392: ROLLBACK;
393: app_exception.raise_exception (exception_type => 'APP',
394: exception_code =>

Line 426: tables into jl_co_gl_mg_headers and jl_co_gl_mg_lines tables, for a

422: get_movement
423:
424: DESCRIPTION
425: Use this procedure to insert transactions and balances from nit
426: tables into jl_co_gl_mg_headers and jl_co_gl_mg_lines tables, for a
427: set of literal/sub-literal, reported_value (called report_group)
428: for a given range of accounts from magnetic media set-up tables
429:
430: PURPOSE:

Line 720: Delete rows from jl_co_gl_mg_lines and

716: END IF;
717:
718:
719: /****************************************
720: Delete rows from jl_co_gl_mg_lines and
721: jl_co_gl_mg_headers for given parameters
722: ****************************************/
723:
724: BEGIN

Line 726: DELETE FROM jl_co_gl_mg_lines

722: ****************************************/
723:
724: BEGIN
725:
726: DELETE FROM jl_co_gl_mg_lines
727: WHERE mg_header_id IN (SELECT mg_header_id
728: FROM jl_co_gl_mg_headers
729: WHERE set_of_books_id = p_set_of_books_id
730: AND reported_year = p_reported_year

Line 745: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_LINES');

741: IF SQL%FOUND THEN
742: COMMIT;
743: fnd_message.set_name('JL', 'JL_CO_GL_MG_DELETE');
744: fnd_message.set_token('NUMBER', TO_CHAR(SQL%ROWCOUNT));
745: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_LINES');
746: put_line( fnd_file.log, fnd_message.get);
747: ELSE
748: NULL;
749: fnd_message.set_name('JL', 'JL_CO_GL_MG_NOT_DELETE');

Line 750: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_LINES');

746: put_line( fnd_file.log, fnd_message.get);
747: ELSE
748: NULL;
749: fnd_message.set_name('JL', 'JL_CO_GL_MG_NOT_DELETE');
750: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_LINES');
751: put_line( fnd_file.log, fnd_message.get);
752: END IF;
753:
754: EXCEPTION

Line 770: FROM jl_co_gl_mg_lines

766: DELETE FROM jl_co_gl_mg_headers
767: WHERE reported_year = p_reported_year
768: AND set_of_books_id = p_set_of_books_id
769: AND mg_header_id NOT IN (SELECT mg_header_id
770: FROM jl_co_gl_mg_lines
771: );
772:
773: IF SQL%FOUND THEN
774: COMMIT;

Line 892: SELECT jl_co_gl_mg_lines_s.NEXTVAL

888:
889: get_move_rec.nit_id := trx_rec.nit_id;
890: get_move_rec.amount := trx_rec.amount;
891:
892: SELECT jl_co_gl_mg_lines_s.NEXTVAL
893: INTO get_move_rec.mg_line_id
894: FROM SYS.DUAL;
895:
896: get_movement_insert (get_move_rec);

Line 916: SELECT jl_co_gl_mg_lines_s.NEXTVAL

912:
913: get_move_rec.nit_id := bal_rec.nit_id;
914: get_move_rec.amount := bal_rec.amount;
915:
916: SELECT jl_co_gl_mg_lines_s.NEXTVAL
917: INTO get_move_rec.mg_line_id
918: FROM SYS.DUAL;
919:
920: get_movement_insert (get_move_rec);

Line 939: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_LINES');

935:
936: fnd_message.set_name('JL', 'JL_CO_GL_MG_INSERT');
937: fnd_message.set_token('NUMBER', TO_CHAR(x_trx_count));
938: fnd_message.set_token('TYPE', 'NIT_TRANSACTIONS');
939: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_LINES');
940: put_line( fnd_file.log, fnd_message.get);
941:
942: END IF;
943:

Line 949: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_LINES');

945:
946: fnd_message.set_name('JL', 'JL_CO_GL_MG_INSERT');
947: fnd_message.set_token('NUMBER', TO_CHAR(x_bal_count));
948: fnd_message.set_token('TYPE', 'NIT_BALANCES');
949: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_LINES');
950: put_line( fnd_file.log, fnd_message.get);
951:
952: END IF;
953:

Line 959: FROM jl_co_gl_mg_lines

955: DELETE FROM jl_co_gl_mg_headers
956: WHERE reported_year = p_reported_year
957: AND set_of_books_id = p_set_of_books_id
958: AND mg_header_id NOT IN (SELECT mg_header_id
959: FROM jl_co_gl_mg_lines
960: );
961: COMMIT;
962:
963: END IF;

Line 1018: in jl_co_gl_mg_lines table.

1014:
1015: DESCRIPTION
1016: Use this procedure to apply Parent Report Grouping Threshold,
1017: Literal Threshold and Child Report Grouping Threshold to the rows
1018: in jl_co_gl_mg_lines table.
1019:
1020: PURPOSE:
1021: Oracle Applications Rel 11.0
1022:

Line 1077: jl_co_gl_mg_lines mgl,

1073: SUM(mgl.eighth_reported_value) eighth_reported_value,
1074: SUM(mgl.ninth_reported_value) ninth_reported_value
1075: FROM jl_co_gl_mg_configs c,
1076: jl_co_gl_mg_literals l,
1077: jl_co_gl_mg_lines mgl,
1078: jl_co_gl_mg_headers mgh
1079: WHERE mgl.mg_header_id = mgh.mg_header_id
1080: AND mgh.reported_year = p_reported_year
1081: AND mgh.set_of_books_id = p_set_of_books_id

Line 1125: jl_co_gl_mg_lines mgl,

1121: SUM(mgl.seventh_reported_value) seventh_reported_value,
1122: SUM(mgl.eighth_reported_value) eighth_reported_value,
1123: SUM(mgl.ninth_reported_value) ninth_reported_value
1124: FROM jl_co_gl_mg_literals l,
1125: jl_co_gl_mg_lines mgl,
1126: jl_co_gl_mg_literals ll,
1127: jl_co_gl_mg_headers mgh
1128: WHERE mgl.mg_header_id = mgh.mg_header_id
1129: AND mgh.reported_year = p_reported_year

Line 1159: jl_co_gl_mg_lines mgl,

1155: mgl.config_id config_id,
1156: mgl.nit_id nit_id
1157: FROM jl_co_gl_mg_configs c,
1158: jl_co_gl_mg_literals l,
1159: jl_co_gl_mg_lines mgl,
1160: jl_co_gl_mg_headers mgh
1161: WHERE mgl.mg_header_id = mgh.mg_header_id
1162: AND mgh.reported_year = p_reported_year
1163: AND mgh.set_of_books_id = p_set_of_books_id

Line 1288: Update jl_co_gl_mg_lines.reported_flag to "N"

1284:
1285: END;
1286:
1287: /*********************************************
1288: Update jl_co_gl_mg_lines.reported_flag to "N"
1289: that are not required to be reported
1290: *********************************************/
1291:
1292: IF (x_type = 'FOREIGN_ENTITY' AND

Line 1298: UPDATE jl_co_gl_mg_lines

1294: (x_type <> 'FOREIGN_ENTITY' AND
1295: x_domestic_reported_flag = 'N') THEN
1296:
1297:
1298: UPDATE jl_co_gl_mg_lines
1299: SET reported_flag = 'N'
1300: WHERE mg_header_id = rg_threshold_rec.mg_header_id
1301: AND literal_id = rg_threshold_rec.literal_id
1302: AND reported_value = rg_threshold_rec.reported_value

Line 1331: UPDATE jl_co_gl_mg_lines

1327: (rg_threshold_rec.reported_value = '8' AND rg_threshold_rec.eighth_reported_value < rg_threshold_rec.threshold_value) OR
1328: (rg_threshold_rec.reported_value = '9' AND rg_threshold_rec.ninth_reported_value < rg_threshold_rec.threshold_value) THEN
1329:
1330:
1331: UPDATE jl_co_gl_mg_lines
1332: SET reported_flag = 'N'
1333: WHERE mg_header_id = rg_threshold_rec.mg_header_id
1334: AND literal_id = rg_threshold_rec.literal_id
1335: AND reported_value = rg_threshold_rec.reported_value

Line 1382: UPDATE jl_co_gl_mg_lines mgl

1378: lit_threshold_rec.seventh_reported_value +
1379: lit_threshold_rec.eighth_reported_value +
1380: lit_threshold_rec.ninth_reported_value) >= lit_threshold_rec.threshold_value) THEN
1381:
1382: UPDATE jl_co_gl_mg_lines mgl
1383: SET mgl.reported_flag = 'Y'
1384: WHERE mgl.mg_header_id = lit_threshold_rec.mg_header_id
1385: AND mgl.literal_literal_id = lit_threshold_rec.literal_literal_id
1386: AND mgl.nit_id = lit_threshold_rec.nit_id

Line 1392: UPDATE jl_co_gl_mg_lines mgl

1388: FROM jl_co_gl_mg_literals ll
1389: WHERE mgl.literal_id = ll.literal_id
1390: AND ll.threshold_exclusion_flag='N');
1391: ELSE
1392: UPDATE jl_co_gl_mg_lines mgl
1393: SET mgl.reported_flag = 'N'
1394: WHERE mgl.mg_header_id = lit_threshold_rec.mg_header_id
1395: AND mgl.literal_literal_id = lit_threshold_rec.literal_literal_id
1396: AND mgl.nit_id = lit_threshold_rec.nit_id

Line 1413: Update jl_co_gl_mg_lines for the selected parent config_id in the cursor

1409:
1410: FOR child_threshold_rec IN child_threshold_cur LOOP
1411:
1412: /************************************************************************
1413: Update jl_co_gl_mg_lines for the selected parent config_id in the cursor
1414: ************************************************************************/
1415:
1416: UPDATE jl_co_gl_mg_lines
1417: SET reported_flag = 'N'

Line 1416: UPDATE jl_co_gl_mg_lines

1412: /************************************************************************
1413: Update jl_co_gl_mg_lines for the selected parent config_id in the cursor
1414: ************************************************************************/
1415:
1416: UPDATE jl_co_gl_mg_lines
1417: SET reported_flag = 'N'
1418: WHERE mg_header_id = child_threshold_rec.mg_header_id
1419: AND config_id IN (SELECT config_id
1420: FROM jl_co_gl_mg_configs

Line 1571: FROM jl_co_gl_mg_lines mgl,

1567: DECODE(n.type, 'FOREIGN_ENTITY', foreign_nit, n.nit)
1568: nit_number,
1569: SUM(mgl.first_reported_value) first_reported_value,
1570: SUM(mgl.second_reported_value) second_reported_value
1571: FROM jl_co_gl_mg_lines mgl,
1572: jl_co_gl_nits n,
1573: jl_co_gl_mg_literals mglit,
1574: jl_co_gl_mg_headers mgh
1575: WHERE mgl.mg_header_id = mgh.mg_header_id