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.GCS_LEX_MAP_API_PKG dependencies on GCS_LEX_MAP_RULE_SETS

Line 413: FROM gcs_lex_map_rule_sets rst,

409: mc.column_name
410: INTO idt_name,
411: stage_num,
412: col_name
413: FROM gcs_lex_map_rule_sets rst,
414: gcs_lex_map_rule_stages rstg,
415: gcs_lex_map_rules r,
416: gcs_lex_map_columns mc
417: WHERE rst.rule_set_id = rstg.rule_set_id

Line 468: FROM gcs_lex_map_rule_sets rst,

464: INTO idt_name,
465: stage_num,
466: col_name,
467: deriv_num
468: FROM gcs_lex_map_rule_sets rst,
469: gcs_lex_map_rule_stages rstg,
470: gcs_lex_map_rules r,
471: gcs_lex_map_derivations d,
472: gcs_lex_map_columns mc

Line 526: FROM gcs_lex_map_rule_sets rst,

522: stage_num,
523: col_name,
524: deriv_num,
525: func_name
526: FROM gcs_lex_map_rule_sets rst,
527: gcs_lex_map_rule_stages rstg,
528: gcs_lex_map_rules r,
529: gcs_lex_map_derivations d,
530: gcs_lex_map_columns mc

Line 579: FROM gcs_lex_map_rule_sets rst,

575: mc.column_name
576: INTO idt_name,
577: stage_num,
578: col_name
579: FROM gcs_lex_map_rule_sets rst,
580: gcs_lex_map_rule_stages rstg,
581: gcs_lex_map_rules r,
582: gcs_lex_map_columns mc
583: WHERE rst.rule_set_id = rstg.rule_set_id

Line 651: FROM gcs_lex_map_rule_sets rst,

647: SELECT rst.name,
648: rstg.stage_number
649: INTO idt_name,
650: stage_num
651: FROM gcs_lex_map_rule_sets rst,
652: gcs_lex_map_rule_stages rstg
653: WHERE rst.rule_set_id = rstg.rule_set_id
654: AND rstg.rule_stage_id = add_stage_failed_msg.rule_stage_id;
655:

Line 697: FROM gcs_lex_map_rule_sets rst,

693: SELECT rst.name,
694: rstg.stage_number
695: INTO idt_name,
696: stage_num
697: FROM gcs_lex_map_rule_sets rst,
698: gcs_lex_map_rule_stages rstg
699: WHERE rst.rule_set_id = rstg.rule_set_id
700: AND rstg.rule_stage_id = add_rows_changed_msg.rule_stage_id;
701:

Line 735: FROM gcs_lex_map_rule_sets rst

731: idt_name VARCHAR2(100);
732: BEGIN
733: SELECT rst.name
734: INTO idt_name
735: FROM gcs_lex_map_rule_sets rst
736: WHERE rst.rule_set_id = add_idt_failed_msg.rule_set_id;
737:
738: FND_MESSAGE.set_name('GCS', message_name);
739: FND_MESSAGE.set_token('IDT_NAME', idt_name);

Line 769: FROM gcs_lex_map_rule_sets rst,

765: struct_name VARCHAR2(100);
766: BEGIN
767: SELECT ms.structure_name
768: INTO struct_name
769: FROM gcs_lex_map_rule_sets rst,
770: gcs_lex_map_structs ms
771: WHERE rst.structure_id = ms.structure_id
772: AND rst.rule_set_id = add_structure_failed_msg.rule_set_id;
773:

Line 815: FROM gcs_lex_map_rule_sets rst,

811: INTO idt_name,
812: stage_num,
813: col_name,
814: vs_name
815: FROM gcs_lex_map_rule_sets rst,
816: gcs_lex_map_rule_stages rstg,
817: gcs_lex_map_rules r,
818: gcs_lex_map_columns mc,
819: fnd_flex_value_sets ffvs

Line 870: FROM gcs_lex_map_rule_sets rst,

866: INTO idt_name,
867: stage_num,
868: col_name,
869: lut_name
870: FROM gcs_lex_map_rule_sets rst,
871: gcs_lex_map_rule_stages rstg,
872: gcs_lex_map_rules r,
873: gcs_lex_map_columns mc,
874: gcs_lex_map_structs lutms

Line 929: FROM gcs_lex_map_rule_sets rst,

925: stage_num,
926: col_name,
927: deriv_num,
928: lut_name
929: FROM gcs_lex_map_rule_sets rst,
930: gcs_lex_map_rule_stages rstg,
931: gcs_lex_map_rules r,
932: gcs_lex_map_derivations d,
933: gcs_lex_map_columns mc,

Line 1116: FROM gcs_lex_map_rule_sets rst,

1112: error_code_col_name VARCHAR2(100);
1113: BEGIN
1114: SELECT mc.column_name
1115: INTO error_code_col_name
1116: FROM gcs_lex_map_rule_sets rst,
1117: gcs_lex_map_columns mc
1118: WHERE rst.structure_id = mc.structure_id
1119: AND mc.error_code_column_flag = 'Y'
1120: AND rst.rule_set_id = add_error_code_failed_msg.rule_set_id;

Line 1192: FROM gcs_lex_map_rule_sets rsts

1188: WHERE stg.rule_set_id = initial_rule_set_check.rule_set_id;
1189:
1190: CURSOR rule_set_check IS
1191: SELECT name, enabled_flag
1192: FROM gcs_lex_map_rule_sets rsts
1193: WHERE rsts.rule_set_id = initial_rule_set_check.rule_set_id;
1194:
1195: CURSOR rule_check(p_stage_id NUMBER) IS
1196: SELECT r.rule_id

Line 1202: FROM gcs_lex_map_rule_sets rst,

1198: WHERE r.rule_stage_id = p_stage_id;
1199:
1200: CURSOR error_column_check IS
1201: SELECT mc.column_name, mc.write_flag
1202: FROM gcs_lex_map_rule_sets rst,
1203: gcs_lex_map_columns mc
1204: WHERE rst.structure_id = mc.structure_id
1205: AND mc.error_code_column_flag = 'Y'
1206: AND rst.rule_set_id = initial_rule_set_check.rule_set_id;

Line 1393: gcs_lex_map_rule_sets rst

1389: IS
1390: CURSOR all_columns IS
1391: SELECT mc.column_name
1392: FROM gcs_lex_map_columns mc,
1393: gcs_lex_map_rule_sets rst
1394: WHERE rst.structure_id = mc.structure_id
1395: AND rst.rule_set_id = staging_table_check.rule_set_id;
1396:
1397: check_text VARCHAR2(32767);

Line 1482: FROM gcs_lex_map_rule_sets rst,

1478: CURSOR filter_check(col_name VARCHAR2) IS
1479: SELECT decode( usage,
1480: 'TRANSFORMATION', write_flag,
1481: error_code_column_flag)
1482: FROM gcs_lex_map_rule_sets rst,
1483: gcs_lex_map_columns mc
1484: WHERE mc.structure_id = rst.structure_id
1485: AND rst.rule_set_id = get_filter_text.rule_set_id
1486: AND UPPER(mc.column_name) = UPPER(col_name);

Line 2889: gcs_lex_map_rule_sets rsts

2885:
2886: SELECT mc.column_name
2887: INTO error_col_name
2888: FROM gcs_lex_map_columns mc,
2889: gcs_lex_map_rule_sets rsts
2890: WHERE mc.structure_id = rsts.structure_id
2891: AND rsts.rule_set_id = init_error_column.rule_set_id
2892: AND mc.error_code_column_flag = 'Y';
2893:

Line 2942: gcs_lex_map_rule_sets rsts

2938:
2939: SELECT mc.column_name
2940: INTO error_col
2941: FROM gcs_lex_map_columns mc,
2942: gcs_lex_map_rule_sets rsts
2943: WHERE mc.structure_id = rsts.structure_id
2944: AND mc.error_code_column_flag = 'Y'
2945: AND rsts.rule_set_id = fill_error_column.rule_set_id;
2946:

Line 3832: FROM gcs_lex_map_rule_sets rs,

3828:
3829: -- Now get the error column name and add to the filter text
3830: SELECT mc.column_name
3831: INTO error_col_name
3832: FROM gcs_lex_map_rule_sets rs,
3833: gcs_lex_map_columns mc
3834: WHERE rs.rule_set_id = p_rule_set_id
3835: AND mc.structure_id = rs.structure_id
3836: AND mc.error_code_column_flag = 'Y';

Line 3995: UPDATE gcs_lex_map_rule_sets

3991:
3992: PROCEDURE After_FEM_Refresh IS
3993:
3994: BEGIN
3995: UPDATE gcs_lex_map_rule_sets
3996: SET associated_object_id = fem_object_id_seq.nextval;
3997:
3998: INSERT INTO fem_object_catalog_b(
3999: object_id, folder_id, object_type_code, object_access_code,

Line 4004: FROM gcs_lex_map_rule_sets rst;

4000: object_origin_code, object_version_number, creation_date, created_by,
4001: last_update_date, last_updated_by, last_update_login)
4002: SELECT associated_object_id, 1300, 'CONSOLIDATION_DATA', 'R', 'USER', 1,
4003: sysdate, created_by, sysdate, last_updated_by, last_update_login
4004: FROM gcs_lex_map_rule_sets rst;
4005:
4006: INSERT INTO fem_object_catalog_tl(
4007: object_id, object_name, language, source_lang, description, creation_date,
4008: created_by, last_update_date, last_updated_by, last_update_login)

Line 4012: FROM gcs_lex_map_rule_sets rst;

4008: created_by, last_update_date, last_updated_by, last_update_login)
4009: SELECT associated_object_id, rst.name, userenv('LANG'), userenv('LANG'),
4010: description, sysdate, created_by, sysdate, last_updated_by,
4011: last_update_login
4012: FROM gcs_lex_map_rule_sets rst;
4013:
4014: INSERT INTO fem_object_definition_b(
4015: object_definition_id, object_id, effective_start_date, effective_end_date,
4016: object_origin_code, approval_status_code, old_approved_copy_flag,

Line 4023: FROM gcs_lex_map_rule_sets rst;

4019: SELECT fem_object_definition_id_seq.nextval, associated_object_id,
4020: to_date('01-01-1000', 'DD-MM-YYYY'),
4021: to_date('31-12-9999', 'DD-MM-YYYY'), 'USER', 'NOT_APPLICABLE', 'N', 1,
4022: sysdate, created_by, sysdate, last_updated_by, last_update_login
4023: FROM gcs_lex_map_rule_sets rst;
4024:
4025: INSERT INTO fem_object_definition_tl(
4026: object_definition_id, object_id, language, source_lang,
4027: old_approved_copy_flag, display_name, description, creation_date,

Line 4032: FROM gcs_lex_map_rule_sets rst,

4028: created_by, last_update_date, last_updated_by, last_update_login)
4029: SELECT odb.object_definition_id, odb.object_id, userenv('LANG'),
4030: userenv('LANG'), 'N', rst.name, rst.description, sysdate,
4031: rst.created_by, sysdate, rst.last_updated_by, rst.last_update_login
4032: FROM gcs_lex_map_rule_sets rst,
4033: fem_object_definition_b odb
4034: WHERE odb.object_id = rst.associated_object_id;
4035:
4036: END After_FEM_Refresh;