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_HEADERS

Line 28: x_mg_header_id jl_co_gl_mg_headers.mg_header_id%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;
31: count_status NUMBER := 0;
32:

Line 36: mg_header_id jl_co_gl_mg_headers.mg_header_id%TYPE,

32:
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,

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 691: Check for JL_CO_GL_MG_HEADERS.STATUS = 'Y'. If any row

687: fnd_file.put_line(fnd_file.log, '----------------------------------------');
688:
689:
690: /******************************************************
691: Check for JL_CO_GL_MG_HEADERS.STATUS = 'Y'. If any row
692: exists with status of 'Y' then give a message to USER
693: and exist the procedure
694: ******************************************************/
695:

Line 700: FROM jl_co_gl_mg_headers

696: BEGIN
697:
698: SELECT count(*)
699: INTO count_status
700: FROM jl_co_gl_mg_headers
701: WHERE set_of_books_id = p_set_of_books_id
702: AND reported_year = p_reported_year
703: AND status = 'Y';
704:

Line 721: jl_co_gl_mg_headers for given parameters

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
725:

Line 728: FROM jl_co_gl_mg_headers

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
731: )
732: AND literal_id IN (SELECT literal_id

Line 766: DELETE FROM jl_co_gl_mg_headers

762: END;
763:
764: BEGIN
765:
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

Line 777: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_HEADERS');

773: IF SQL%FOUND THEN
774: COMMIT;
775: fnd_message.set_name('JL', 'JL_CO_GL_MG_DELETE');
776: fnd_message.set_token('NUMBER', TO_CHAR(SQL%ROWCOUNT));
777: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_HEADERS');
778: put_line( fnd_file.log, fnd_message.get);
779: ELSE
780: NULL;
781: fnd_message.set_name('JL', 'JL_CO_GL_MG_NOT_DELETE');

Line 782: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_HEADERS');

778: put_line( fnd_file.log, fnd_message.get);
779: ELSE
780: NULL;
781: fnd_message.set_name('JL', 'JL_CO_GL_MG_NOT_DELETE');
782: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_HEADERS');
783: put_line( fnd_file.log, fnd_message.get);
784: END IF;
785:
786: EXCEPTION

Line 803: Insert a row for the given parameters in jl_co_gl_mg_headers table

799:
800: find_who_columns;
801:
802: /******************************************************************
803: Insert a row for the given parameters in jl_co_gl_mg_headers table
804: ******************************************************************/
805:
806: BEGIN
807:

Line 810: SELECT jl_co_gl_mg_headers_s.NEXTVAL

806: BEGIN
807:
808: BEGIN
809:
810: SELECT jl_co_gl_mg_headers_s.NEXTVAL
811: INTO x_mg_header_id
812: FROM SYS.DUAL;
813:
814: END;

Line 816: INSERT INTO jl_co_gl_mg_headers

812: FROM SYS.DUAL;
813:
814: END;
815:
816: INSERT INTO jl_co_gl_mg_headers
817: (mg_header_id,
818: set_of_books_id,
819: reported_year,
820: status,

Line 844: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_HEADERS');

840:
841: fnd_message.set_name('JL', 'JL_CO_GL_MG_INSERT');
842: fnd_message.set_token('NUMBER', '1');
843: fnd_message.set_token('TYPE', ' ');
844: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_HEADERS');
845: put_line( fnd_file.log, fnd_message.get);
846:
847: EXCEPTION
848:

Line 853: 'Exception "OTHERS" while inserting into jl_co_gl_mg_headers table');

849: WHEN OTHERS THEN
850:
851: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
852: fnd_message.set_token('GENERIC_TEXT',
853: 'Exception "OTHERS" while inserting into jl_co_gl_mg_headers table');
854: x_error_text := SUBSTR(fnd_message.get, 1, 100);
855: ROLLBACK;
856: app_exception.raise_exception (exception_type => 'APP',
857: exception_code =>

Line 955: DELETE FROM jl_co_gl_mg_headers

951:
952: END IF;
953:
954: IF x_trx_count = 0 AND x_bal_count = 0 THEN
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

Line 1078: jl_co_gl_mg_headers mgh

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
1082: AND mgl.literal_id = l.literal_id

Line 1127: jl_co_gl_mg_headers mgh

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
1130: AND mgh.set_of_books_id = p_set_of_books_id
1131: AND mgl.literal_literal_id = l.literal_id

Line 1160: jl_co_gl_mg_headers mgh

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
1164: AND mgl.config_id = c.config_id

Line 1197: Check for JL_CO_GL_MG_HEADERS.STATUS = 'Y'. If any row

1193: put_line( fnd_file.log, fnd_message.get);
1194: fnd_file.put_line(fnd_file.log, '----------------------------------------');
1195:
1196: /******************************************************
1197: Check for JL_CO_GL_MG_HEADERS.STATUS = 'Y'. If any row
1198: exists with status of 'Y' then give a message to USER
1199: and exist the procedure
1200: ******************************************************/
1201:

Line 1206: FROM jl_co_gl_mg_headers

1202: BEGIN
1203:
1204: SELECT count(*)
1205: INTO count_status
1206: FROM jl_co_gl_mg_headers
1207: WHERE set_of_books_id = p_set_of_books_id
1208: AND reported_year = p_reported_year
1209: AND status = 'Y';
1210:

Line 1574: jl_co_gl_mg_headers mgh

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
1576: AND mgh.reported_year = p_reported_year
1577: AND mgh.set_of_books_id = p_set_of_books_id
1578: AND mgl.reported_flag = 'Y'

Line 1608: Check for JL_CO_GL_MG_HEADERS.STATUS = 'Y'. If any row

1604: fnd_file.put_line(fnd_file.log, '----------------------------------------');
1605:
1606:
1607: /******************************************************
1608: Check for JL_CO_GL_MG_HEADERS.STATUS = 'Y'. If any row
1609: exists with status of 'Y' then give a message to USER
1610: and exist the procedure
1611: ******************************************************/
1612:

Line 1617: FROM jl_co_gl_mg_headers

1613: BEGIN
1614:
1615: SELECT count(*)
1616: INTO count_status
1617: FROM jl_co_gl_mg_headers
1618: WHERE set_of_books_id = p_set_of_books_id
1619: AND reported_year = p_reported_year
1620: AND status = 'Y';
1621:

Line 1882: Update the jl_co_gl_mg_headers.status to 'Y'

1878: fnd_message.set_name('JL', 'JL_CO_GL_MG_CLOSE_REGISTER');
1879: put_line( fnd_file.log, fnd_message.get);
1880:
1881: /********************************************
1882: Update the jl_co_gl_mg_headers.status to 'Y'
1883: for final generation is done for DIAN
1884: ********************************************/
1885:
1886: UPDATE jl_co_gl_mg_headers

Line 1886: UPDATE jl_co_gl_mg_headers

1882: Update the jl_co_gl_mg_headers.status to 'Y'
1883: for final generation is done for DIAN
1884: ********************************************/
1885:
1886: UPDATE jl_co_gl_mg_headers
1887: SET status = 'Y'
1888: WHERE reported_year = p_reported_year
1889: AND set_of_books_id = p_set_of_books_id
1890: AND EXISTS (SELECT 1