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_STAGES

Line 414: gcs_lex_map_rule_stages rstg,

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
418: AND rstg.rule_stage_id = r.rule_stage_id

Line 469: gcs_lex_map_rule_stages rstg,

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
473: WHERE rst.rule_set_id = rstg.rule_set_id

Line 527: gcs_lex_map_rule_stages rstg,

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
531: WHERE rst.rule_set_id = rstg.rule_set_id

Line 580: gcs_lex_map_rule_stages rstg,

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
584: AND rstg.rule_stage_id = r.rule_stage_id

Line 652: gcs_lex_map_rule_stages rstg

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:
656: FND_MESSAGE.set_name('GCS', message_name);

Line 698: gcs_lex_map_rule_stages rstg

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:
702: FND_MESSAGE.set_name('GCS', message_name);

Line 816: gcs_lex_map_rule_stages rstg,

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
820: WHERE rst.rule_set_id = rstg.rule_set_id

Line 871: gcs_lex_map_rule_stages rstg,

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
875: WHERE rst.rule_set_id = rstg.rule_set_id

Line 930: gcs_lex_map_rule_stages rstg,

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,
934: gcs_lex_map_columns lutmc,

Line 1187: FROM gcs_lex_map_rule_stages stg

1183: File_Write VARCHAR2)
1184: RETURN VARCHAR2 IS
1185: CURSOR stage_check IS
1186: SELECT stg.rule_stage_id
1187: FROM gcs_lex_map_rule_stages stg
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

Line 1212: gcs_lex_map_rule_stages stg

1208: CURSOR func_reg_check_c IS
1209: SELECT d.derivation_id
1210: FROM gcs_lex_map_derivations d,
1211: gcs_lex_map_rules r,
1212: gcs_lex_map_rule_stages stg
1213: WHERE d.rule_id = r.rule_id
1214: AND r.rule_stage_id = stg.rule_stage_id
1215: AND stg.rule_set_id = initial_rule_set_check.rule_set_id
1216: AND d.derivation_type_code = 'PLS'

Line 2182: gcs_lex_map_rule_stages stg

2178: 'GCS\_LEX\_GET\_' || p_rule_set_id || '\__%' ESCAPE '\'
2179: AND object_name NOT IN
2180: (SELECT 'GCS_LEX_GET_' || p_rule_set_id || '_' || r.rule_id
2181: FROM gcs_lex_map_rules r,
2182: gcs_lex_map_rule_stages stg
2183: WHERE stg.rule_set_id = p_rule_set_id
2184: AND stg.rule_stage_id = r.rule_stage_id)
2185: AND object_type = 'FUNCTION';
2186: BEGIN

Line 3154: FROM gcs_lex_map_rule_stages rstg,

3150: x_msg_data OUT NOCOPY VARCHAR2,
3151: p_rule_set_id NUMBER) IS
3152: CURSOR all_rules IS
3153: SELECT r.rule_id
3154: FROM gcs_lex_map_rule_stages rstg,
3155: gcs_lex_map_rules r
3156: WHERE rstg.rule_set_id = p_rule_set_id
3157: AND r.rule_stage_id = rstg.rule_stage_id;
3158:

Line 3281: FROM gcs_lex_map_rule_stages rstg

3277: l_api_name VARCHAR2(20);
3278:
3279: CURSOR all_stages IS
3280: SELECT rule_stage_id, stage_number
3281: FROM gcs_lex_map_rule_stages rstg
3282: WHERE rstg.rule_set_id = p_rule_set_id
3283: ORDER BY stage_number;
3284:
3285: idt_name VARCHAR2(30);

Line 3441: gcs_lex_map_rule_stages rstg,

3437: stage_num,
3438: vs_name
3439: FROM gcs_lex_map_rules r,
3440: gcs_lex_map_columns mc,
3441: gcs_lex_map_rule_stages rstg,
3442: fnd_flex_value_sets ffv
3443: WHERE r.rule_stage_id = rstg.rule_stage_id
3444: AND r.value_set_id = ffv.flex_value_set_id
3445: AND r.target_column_id = mc.column_id

Line 3462: gcs_lex_map_rule_stages rstg,

3458: stage_num,
3459: lut_name
3460: FROM gcs_lex_map_rules r,
3461: gcs_lex_map_columns mc,
3462: gcs_lex_map_rule_stages rstg,
3463: gcs_lex_map_structs lutms
3464: WHERE r.rule_stage_id = rstg.rule_stage_id
3465: AND r.lookup_table_id = lutms.structure_id
3466: AND r.target_column_id = mc.column_id

Line 3534: gcs_lex_map_rule_stages rstg,

3530: rstg.stage_number
3531: INTO col_name,
3532: stage_num
3533: FROM gcs_lex_map_rules r,
3534: gcs_lex_map_rule_stages rstg,
3535: gcs_lex_map_columns mc
3536: WHERE r.rule_stage_id = rstg.rule_stage_id
3537: AND r.target_column_id = mc.column_id
3538: AND r.rule_id = error_table(i).rule_id;

Line 3627: FROM gcs_lex_map_rule_stages rstg,

3623: p_rule_set_id NUMBER) IS
3624: CURSOR all_rules IS
3625: SELECT r.rule_id,
3626: r.rule_name
3627: FROM gcs_lex_map_rule_stages rstg,
3628: gcs_lex_map_rules r
3629: WHERE rstg.rule_set_id = p_rule_set_id
3630: AND r.rule_stage_id = rstg.rule_stage_id;
3631:

Line 3755: FROM gcs_lex_map_rule_stages rstg,

3751: l_api_name VARCHAR2(20);
3752:
3753: CURSOR all_rules IS
3754: SELECT r.rule_id, r.rule_name, r.validation_type_code
3755: FROM gcs_lex_map_rule_stages rstg,
3756: gcs_lex_map_rules r
3757: WHERE rstg.rule_set_id = p_rule_set_id
3758: AND r.rule_stage_id = rstg.rule_stage_id
3759: ORDER BY rstg.stage_number;