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_LITERALS

Line 14: x_literal_code jl_co_gl_mg_literals.literal_code%TYPE;

10: x_name jl_co_gl_nits.name%TYPE;
11: x_type jl_co_gl_nits.type%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;

Line 38: literal_id jl_co_gl_mg_literals.literal_id%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,
42: reported_value jl_co_gl_mg_configs.reported_value%TYPE,

Line 39: foreign_reported_flag jl_co_gl_mg_literals.foreign_reported_flag%TYPE,

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,
42: reported_value jl_co_gl_mg_configs.reported_value%TYPE,
43: nit_id jl_co_gl_nits.nit_id%TYPE,

Line 40: foreign_description jl_co_gl_mg_literals.foreign_description%TYPE,

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,
42: reported_value jl_co_gl_mg_configs.reported_value%TYPE,
43: nit_id jl_co_gl_nits.nit_id%TYPE,
44: config_id jl_co_gl_mg_configs.config_id%TYPE,

Line 41: domestic_reported_flag jl_co_gl_mg_literals.domestic_reported_flag%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,
42: reported_value jl_co_gl_mg_configs.reported_value%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,

Line 451: p_reported_year IN jl_co_gl_mg_literals.reported_year%TYPE,

447: PROCEDURE get_movement
448: (ERRBUF OUT NOCOPY VARCHAR2,
449: RETCODE OUT NOCOPY VARCHAR2,
450: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE,
451: p_reported_year IN jl_co_gl_mg_literals.reported_year%TYPE,
452: p_period_start IN gl_periods.period_num%TYPE,
453: p_period_end IN gl_periods.period_num%TYPE,
454: p_literal_start IN jl_co_gl_mg_literals.literal_code%TYPE,
455: p_literal_end IN jl_co_gl_mg_literals.literal_code%TYPE

Line 454: p_literal_start IN jl_co_gl_mg_literals.literal_code%TYPE,

450: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE,
451: p_reported_year IN jl_co_gl_mg_literals.reported_year%TYPE,
452: p_period_start IN gl_periods.period_num%TYPE,
453: p_period_end IN gl_periods.period_num%TYPE,
454: p_literal_start IN jl_co_gl_mg_literals.literal_code%TYPE,
455: p_literal_end IN jl_co_gl_mg_literals.literal_code%TYPE
456: ) IS
457:
458: x_mg_hdr_count NUMBER;

Line 455: p_literal_end IN jl_co_gl_mg_literals.literal_code%TYPE

451: p_reported_year IN jl_co_gl_mg_literals.reported_year%TYPE,
452: p_period_start IN gl_periods.period_num%TYPE,
453: p_period_end IN gl_periods.period_num%TYPE,
454: p_literal_start IN jl_co_gl_mg_literals.literal_code%TYPE,
455: p_literal_end IN jl_co_gl_mg_literals.literal_code%TYPE
456: ) IS
457:
458: x_mg_hdr_count NUMBER;
459:

Line 461: Cursor to select rows from jl_co_gl_mg_literals, jl_co_gl_mg_configs

457:
458: x_mg_hdr_count NUMBER;
459:
460: /********************************************************************
461: Cursor to select rows from jl_co_gl_mg_literals, jl_co_gl_mg_configs
462: and jl_co_gl_mg_ranges (accounting ranges) tables
463: ********************************************************************/
464:
465: CURSOR literal_cur IS

Line 479: jl_co_gl_mg_literals mgl

475: mgc.literal_literal_id literal_literal_id,
476: mgr.range_id range_id
477: FROM jl_co_gl_mg_ranges mgr,
478: jl_co_gl_mg_configs mgc,
479: jl_co_gl_mg_literals mgl
480: WHERE mgr.config_id = mgc.config_id
481: AND mgc.literal_id = mgl.literal_id
482: AND mgl.set_of_books_id = p_set_of_books_id
483: AND mgl.reported_year = p_reported_year

Line 733: FROM jl_co_gl_mg_literals

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
733: FROM jl_co_gl_mg_literals
734: WHERE set_of_books_id = p_set_of_books_id
735: AND reported_year = p_reported_year
736: AND literal_code BETWEEN p_literal_start
737: AND p_literal_end

Line 966: Update JL_CO_GL_MG_LITERALS.PROCESSED_FLAG to 'M' for the given Parameters

962:
963: END IF;
964:
965: /**************************************************************************
966: Update JL_CO_GL_MG_LITERALS.PROCESSED_FLAG to 'M' for the given Parameters
967: **************************************************************************/
968:
969: UPDATE jl_co_gl_mg_literals
970: SET processed_flag = 'M'

Line 969: UPDATE jl_co_gl_mg_literals

965: /**************************************************************************
966: Update JL_CO_GL_MG_LITERALS.PROCESSED_FLAG to 'M' for the given Parameters
967: **************************************************************************/
968:
969: UPDATE jl_co_gl_mg_literals
970: SET processed_flag = 'M'
971: WHERE set_of_books_id = p_set_of_books_id
972: AND reported_year = p_reported_year
973: AND literal_code BETWEEN p_literal_start AND p_literal_end;

Line 1039: p_reported_year IN jl_co_gl_mg_literals.reported_year%TYPE,

1035: PROCEDURE threshold
1036: (ERRBUF OUT NOCOPY VARCHAR2,
1037: RETCODE OUT NOCOPY VARCHAR2,
1038: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE,
1039: p_reported_year IN jl_co_gl_mg_literals.reported_year%TYPE,
1040: p_literal_start IN jl_co_gl_mg_literals.literal_code%TYPE,
1041: p_literal_end IN jl_co_gl_mg_literals.literal_code%TYPE
1042: ) IS
1043:

Line 1040: p_literal_start IN jl_co_gl_mg_literals.literal_code%TYPE,

1036: (ERRBUF OUT NOCOPY VARCHAR2,
1037: RETCODE OUT NOCOPY VARCHAR2,
1038: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE,
1039: p_reported_year IN jl_co_gl_mg_literals.reported_year%TYPE,
1040: p_literal_start IN jl_co_gl_mg_literals.literal_code%TYPE,
1041: p_literal_end IN jl_co_gl_mg_literals.literal_code%TYPE
1042: ) IS
1043:
1044: x_foreign_reported_flag jl_co_gl_mg_literals.foreign_reported_flag%TYPE;

Line 1041: p_literal_end IN jl_co_gl_mg_literals.literal_code%TYPE

1037: RETCODE OUT NOCOPY VARCHAR2,
1038: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE,
1039: p_reported_year IN jl_co_gl_mg_literals.reported_year%TYPE,
1040: p_literal_start IN jl_co_gl_mg_literals.literal_code%TYPE,
1041: p_literal_end IN jl_co_gl_mg_literals.literal_code%TYPE
1042: ) IS
1043:
1044: x_foreign_reported_flag jl_co_gl_mg_literals.foreign_reported_flag%TYPE;
1045: x_domestic_reported_flag jl_co_gl_mg_literals.domestic_reported_flag%TYPE;

Line 1044: x_foreign_reported_flag jl_co_gl_mg_literals.foreign_reported_flag%TYPE;

1040: p_literal_start IN jl_co_gl_mg_literals.literal_code%TYPE,
1041: p_literal_end IN jl_co_gl_mg_literals.literal_code%TYPE
1042: ) IS
1043:
1044: x_foreign_reported_flag jl_co_gl_mg_literals.foreign_reported_flag%TYPE;
1045: x_domestic_reported_flag jl_co_gl_mg_literals.domestic_reported_flag%TYPE;
1046: x_threshold_foreign_flag jl_co_gl_mg_literals.threshold_foreign_flag%TYPE;
1047: x_threshold_domestic_flag jl_co_gl_mg_literals.threshold_domestic_flag%TYPE;
1048: x_threshold_exclusion_flag jl_co_gl_mg_literals.threshold_exclusion_flag%TYPE;

Line 1045: x_domestic_reported_flag jl_co_gl_mg_literals.domestic_reported_flag%TYPE;

1041: p_literal_end IN jl_co_gl_mg_literals.literal_code%TYPE
1042: ) IS
1043:
1044: x_foreign_reported_flag jl_co_gl_mg_literals.foreign_reported_flag%TYPE;
1045: x_domestic_reported_flag jl_co_gl_mg_literals.domestic_reported_flag%TYPE;
1046: x_threshold_foreign_flag jl_co_gl_mg_literals.threshold_foreign_flag%TYPE;
1047: x_threshold_domestic_flag jl_co_gl_mg_literals.threshold_domestic_flag%TYPE;
1048: x_threshold_exclusion_flag jl_co_gl_mg_literals.threshold_exclusion_flag%TYPE;
1049: x_lit_threshold_value jl_co_gl_mg_literals.threshold_value%TYPE;

Line 1046: x_threshold_foreign_flag jl_co_gl_mg_literals.threshold_foreign_flag%TYPE;

1042: ) IS
1043:
1044: x_foreign_reported_flag jl_co_gl_mg_literals.foreign_reported_flag%TYPE;
1045: x_domestic_reported_flag jl_co_gl_mg_literals.domestic_reported_flag%TYPE;
1046: x_threshold_foreign_flag jl_co_gl_mg_literals.threshold_foreign_flag%TYPE;
1047: x_threshold_domestic_flag jl_co_gl_mg_literals.threshold_domestic_flag%TYPE;
1048: x_threshold_exclusion_flag jl_co_gl_mg_literals.threshold_exclusion_flag%TYPE;
1049: x_lit_threshold_value jl_co_gl_mg_literals.threshold_value%TYPE;
1050: x_config_id_parent jl_co_gl_mg_configs.config_id_parent%TYPE;

Line 1047: x_threshold_domestic_flag jl_co_gl_mg_literals.threshold_domestic_flag%TYPE;

1043:
1044: x_foreign_reported_flag jl_co_gl_mg_literals.foreign_reported_flag%TYPE;
1045: x_domestic_reported_flag jl_co_gl_mg_literals.domestic_reported_flag%TYPE;
1046: x_threshold_foreign_flag jl_co_gl_mg_literals.threshold_foreign_flag%TYPE;
1047: x_threshold_domestic_flag jl_co_gl_mg_literals.threshold_domestic_flag%TYPE;
1048: x_threshold_exclusion_flag jl_co_gl_mg_literals.threshold_exclusion_flag%TYPE;
1049: x_lit_threshold_value jl_co_gl_mg_literals.threshold_value%TYPE;
1050: x_config_id_parent jl_co_gl_mg_configs.config_id_parent%TYPE;
1051:

Line 1048: x_threshold_exclusion_flag jl_co_gl_mg_literals.threshold_exclusion_flag%TYPE;

1044: x_foreign_reported_flag jl_co_gl_mg_literals.foreign_reported_flag%TYPE;
1045: x_domestic_reported_flag jl_co_gl_mg_literals.domestic_reported_flag%TYPE;
1046: x_threshold_foreign_flag jl_co_gl_mg_literals.threshold_foreign_flag%TYPE;
1047: x_threshold_domestic_flag jl_co_gl_mg_literals.threshold_domestic_flag%TYPE;
1048: x_threshold_exclusion_flag jl_co_gl_mg_literals.threshold_exclusion_flag%TYPE;
1049: x_lit_threshold_value jl_co_gl_mg_literals.threshold_value%TYPE;
1050: x_config_id_parent jl_co_gl_mg_configs.config_id_parent%TYPE;
1051:
1052: /************************************

Line 1049: x_lit_threshold_value jl_co_gl_mg_literals.threshold_value%TYPE;

1045: x_domestic_reported_flag jl_co_gl_mg_literals.domestic_reported_flag%TYPE;
1046: x_threshold_foreign_flag jl_co_gl_mg_literals.threshold_foreign_flag%TYPE;
1047: x_threshold_domestic_flag jl_co_gl_mg_literals.threshold_domestic_flag%TYPE;
1048: x_threshold_exclusion_flag jl_co_gl_mg_literals.threshold_exclusion_flag%TYPE;
1049: x_lit_threshold_value jl_co_gl_mg_literals.threshold_value%TYPE;
1050: x_config_id_parent jl_co_gl_mg_configs.config_id_parent%TYPE;
1051:
1052: /************************************
1053: Parent Report Group Threshold Cursor

Line 1076: jl_co_gl_mg_literals l,

1072: SUM(mgl.seventh_reported_value) seventh_reported_value,
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

Line 1124: FROM jl_co_gl_mg_literals l,

1120: SUM(mgl.sixth_reported_value) sixth_reported_value,
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

Line 1126: jl_co_gl_mg_literals ll,

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
1130: AND mgh.set_of_books_id = p_set_of_books_id

Line 1158: jl_co_gl_mg_literals l,

1154: SELECT mgl.mg_header_id mg_header_id,
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

Line 1250: FROM jl_co_gl_mg_literals l

1246: x_domestic_reported_flag,
1247: x_threshold_foreign_flag,
1248: x_threshold_domestic_flag,
1249: x_threshold_exclusion_flag
1250: FROM jl_co_gl_mg_literals l
1251: WHERE l.literal_id = rg_threshold_rec.literal_id;
1252:
1253: EXCEPTION
1254:

Line 1259: 'Exception "NO_DATA_FOUND" for selection of flags from JL_CO_GL_MG_LITERALS table');

1255: WHEN NO_DATA_FOUND THEN
1256:
1257: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1258: fnd_message.set_token('GENERIC_TEXT',
1259: 'Exception "NO_DATA_FOUND" for selection of flags from JL_CO_GL_MG_LITERALS table');
1260: put_line(fnd_file.log, fnd_message.get);
1261: x_error_code := SQLCODE;
1262: x_error_text := SUBSTR(SQLERRM,1,200);
1263: RAISE_APPLICATION_ERROR( x_error_code, x_error_text);

Line 1269: 'Exception "TOO_MANY_ROWS" for selection of flags from JL_CO_GL_MG_LITERALS table');

1265: WHEN TOO_MANY_ROWS THEN
1266:
1267: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1268: fnd_message.set_token('GENERIC_TEXT',
1269: 'Exception "TOO_MANY_ROWS" for selection of flags from JL_CO_GL_MG_LITERALS table');
1270: put_line(fnd_file.log, fnd_message.get);
1271: x_error_code := SQLCODE;
1272: x_error_text := SUBSTR(SQLERRM,1,200);
1273: RAISE_APPLICATION_ERROR( x_error_code, x_error_text);

Line 1279: 'Exception "OTHERS" for selection of flags from JL_CO_GL_MG_LITERALS table');

1275: WHEN OTHERS THEN
1276:
1277: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1278: fnd_message.set_token('GENERIC_TEXT',
1279: 'Exception "OTHERS" for selection of flags from JL_CO_GL_MG_LITERALS table');
1280: put_line(fnd_file.log, fnd_message.get);
1281: x_error_code := SQLCODE;
1282: x_error_text := SUBSTR(SQLERRM,1,200);
1283: RAISE_APPLICATION_ERROR( x_error_code, x_error_text);

Line 1388: FROM jl_co_gl_mg_literals ll

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
1387: AND EXISTS (SELECT 1
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

Line 1398: FROM jl_co_gl_mg_literals ll

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
1397: AND EXISTS (SELECT 1
1398: FROM jl_co_gl_mg_literals ll
1399: WHERE mgl.literal_id = ll.literal_id
1400: AND ll.threshold_exclusion_flag='N');
1401:
1402: END IF;

Line 1430: Update JL_CO_GL_MG_LITERALS.PROCESSED_FLAG to 'M' for the given Parameters

1426:
1427: END LOOP;
1428:
1429: /**************************************************************************
1430: Update JL_CO_GL_MG_LITERALS.PROCESSED_FLAG to 'M' for the given Parameters
1431: **************************************************************************/
1432:
1433: UPDATE jl_co_gl_mg_literals
1434: SET processed_flag = 'T'

Line 1433: UPDATE jl_co_gl_mg_literals

1429: /**************************************************************************
1430: Update JL_CO_GL_MG_LITERALS.PROCESSED_FLAG to 'M' for the given Parameters
1431: **************************************************************************/
1432:
1433: UPDATE jl_co_gl_mg_literals
1434: SET processed_flag = 'T'
1435: WHERE set_of_books_id = p_set_of_books_id
1436: AND reported_year = p_reported_year
1437: AND literal_code BETWEEN p_literal_start AND p_literal_end

Line 1445: Check for JL_CO_GL_MG_LITERALS.PROCESSED_FLAG = 'N'.

1441: COMMIT;
1442: END IF;
1443:
1444: /****************************************************
1445: Check for JL_CO_GL_MG_LITERALS.PROCESSED_FLAG = 'N'.
1446: If any row exists, give a message to USER
1447: ****************************************************/
1448:
1449: SELECT count(*)

Line 1451: FROM jl_co_gl_mg_literals

1447: ****************************************************/
1448:
1449: SELECT count(*)
1450: INTO count_process_flag
1451: FROM jl_co_gl_mg_literals
1452: WHERE set_of_books_id = p_set_of_books_id
1453: AND reported_year = p_reported_year
1454: AND LENGTH(literal_code) = 4
1455: AND processed_flag = 'N';

Line 1463: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_LITERALS');

1459: x_message := '----***************** W A R N I N G **********************----';
1460: put_line( fnd_file.log, x_message);
1461: fnd_message.set_name('JL', 'JL_CO_GL_MG_TH_ALERT');
1462: fnd_message.set_token('NUMBER', TO_CHAR(count_process_flag));
1463: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_LITERALS');
1464: x_error_text := fnd_message.get;
1465: put_line( fnd_file.log, x_error_text);
1466: x_error_text := SUBSTR(x_error_text, 1, 100);
1467: x_message := '----******************************************************----';

Line 1535: p_reported_year IN jl_co_gl_mg_literals.reported_year%TYPE,

1531: (ERRBUF OUT NOCOPY VARCHAR2,
1532: RETCODE OUT NOCOPY VARCHAR2,
1533: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE,
1534: p_legal_entity_id IN xle_entity_profiles.legal_entity_id%TYPE,
1535: p_reported_year IN jl_co_gl_mg_literals.reported_year%TYPE,
1536: p_label IN VARCHAR2
1537: ) IS
1538:
1539: /*************************************************************************

Line 1573: jl_co_gl_mg_literals mglit,

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
1576: AND mgh.reported_year = p_reported_year
1577: AND mgh.set_of_books_id = p_set_of_books_id

Line 1636: Check for JL_CO_GL_MG_LITERALS.PROCESSED_FLAG = 'T'. If

1632:
1633: END IF;
1634:
1635: /*********************************************************
1636: Check for JL_CO_GL_MG_LITERALS.PROCESSED_FLAG = 'T'. If
1637: any row exists other than 'T' then give a message to USER
1638: and exit the procedure
1639: *********************************************************/
1640:

Line 1645: FROM jl_co_gl_mg_literals

1641: BEGIN
1642:
1643: SELECT count(*)
1644: INTO count_process_flag
1645: FROM jl_co_gl_mg_literals
1646: WHERE set_of_books_id = p_set_of_books_id
1647: AND reported_year = p_reported_year
1648: AND LENGTH(literal_code) = 4
1649: AND processed_flag <> 'T';

Line 1759: FROM jl_co_gl_mg_literals

1755: BEGIN
1756:
1757: SELECT foreign_description
1758: INTO x_name
1759: FROM jl_co_gl_mg_literals
1760: WHERE set_of_books_id = p_set_of_books_id
1761: AND reported_year = p_reported_year
1762: AND literal_code = generate_rec.literal_code;
1763:

Line 1940: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_LITERALS');

1936: x_message := '----***************** W A R N I N G **********************----';
1937: put_line( fnd_file.log, x_message);
1938: fnd_message.set_name('JL', 'JL_CO_GL_MG_GEN_ALERT');
1939: fnd_message.set_token('NUMBER', TO_CHAR(count_process_flag));
1940: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_LITERALS');
1941: x_error_text := SUBSTR(fnd_message.get, 1, 200);
1942: put_line( fnd_file.log, x_error_text);
1943: x_error_text := SUBSTR(x_error_text, 1, 100);
1944: x_message := '----******************************************************----';