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_RULES

Line 415: gcs_lex_map_rules r,

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
419: AND r.target_column_id = mc.column_id

Line 470: gcs_lex_map_rules r,

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

Line 528: gcs_lex_map_rules r,

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

Line 581: gcs_lex_map_rules r,

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
585: AND r.target_column_id = mc.column_id

Line 817: gcs_lex_map_rules r,

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

Line 872: gcs_lex_map_rules r,

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

Line 931: gcs_lex_map_rules r,

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,
935: gcs_lex_map_structs lutms

Line 1197: FROM gcs_lex_map_rules r

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
1197: FROM gcs_lex_map_rules r
1198: WHERE r.rule_stage_id = p_stage_id;
1199:
1200: CURSOR error_column_check IS
1201: SELECT mc.column_name, mc.write_flag

Line 1211: gcs_lex_map_rules r,

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

Line 1597: gcs_lex_map_rules r

1593: IS
1594: CURSOR all_columns IS
1595: SELECT mc.column_name
1596: FROM gcs_lex_map_columns mc,
1597: gcs_lex_map_rules r
1598: WHERE r.lookup_table_id = mc.structure_id
1599: AND r.rule_id = validation_check.rule_id;
1600:
1601: check_text VARCHAR2(32767);

Line 1624: FROM gcs_lex_map_rules r,

1620: valid_type_code VARCHAR2(30);
1621:
1622: CURSOR structure_info IS
1623: SELECT ms.structure_name
1624: FROM gcs_lex_map_rules r,
1625: gcs_lex_map_structs ms
1626: WHERE r.lookup_table_id = ms.structure_id
1627: AND r.rule_id = validation_check.rule_id;
1628:

Line 1641: FROM gcs_lex_map_rules r

1637: SELECT r.validation_type_code,
1638: r.value_set_id
1639: INTO valid_type_code,
1640: value_set_id
1641: FROM gcs_lex_map_rules r
1642: WHERE r.rule_id = validation_check.rule_id;
1643:
1644: IF valid_type_code = 'V' THEN
1645: OPEN value_set_info(value_set_id);

Line 1659: gcs_lex_map_rules r

1655: -- in the validation_tables table.
1656: SELECT COUNT(*)
1657: INTO tv_vs_check_table
1658: FROM fnd_flex_validation_tables ffvt,
1659: gcs_lex_map_rules r
1660: WHERE ffvt.flex_value_set_id = r.value_set_id
1661: AND r.rule_id = validation_check.rule_id;
1662:
1663: IF tv_vs_check_table <> 1 THEN

Line 1773: gcs_lex_map_rules r

1769: 'D', 'DATE',
1770: 'V', 'VARCHAR2',
1771: '') column_type_code
1772: FROM gcs_lex_map_columns mc,
1773: gcs_lex_map_rules r
1774: WHERE mc.column_id = r.target_column_id
1775: AND r.rule_id = create_param_list.rule_id)
1776: UNION
1777: (SELECT mc.column_name column_name,

Line 2181: FROM gcs_lex_map_rules r,

2177: WHERE object_name LIKE
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';

Line 2332: FROM gcs_lex_map_rules r,

2328: param_list := create_param_list(rule_id, 'F', 'N');
2329:
2330: SELECT mc.column_name, mc.column_type_code, mc.write_flag
2331: INTO target_col_name, target_column_type, target_write_flag
2332: FROM gcs_lex_map_rules r,
2333: gcs_lex_map_columns mc
2334: WHERE r.target_column_id = mc.column_id
2335: AND r.rule_id = create_get_function.rule_id;
2336:

Line 2661: FROM gcs_lex_map_rules r,

2657: tgtmc.column_name target_col_name,
2658: r.validation_type_code validation_type_code,
2659: lutms.structure_name lookup_table_name,
2660: r.value_set_id value_set_id
2661: FROM gcs_lex_map_rules r,
2662: gcs_lex_map_columns tgtmc,
2663: gcs_lex_map_structs lutms
2664: WHERE r.rule_stage_id = validate_results.rule_stage_id
2665: AND r.target_column_id = tgtmc.column_id

Line 2736: FROM gcs_lex_map_rules r,

2732: CURSOR all_stage_rules IS
2733: SELECT r.rule_id rule_id,
2734: mc.column_name column_name,
2735: mc.write_flag write_flag
2736: FROM gcs_lex_map_rules r,
2737: gcs_lex_map_columns mc
2738: WHERE r.rule_stage_id = apply_stage.rule_stage_id
2739: AND r.target_column_id = mc.column_id;
2740:

Line 3063: FROM gcs_lex_map_rules r,

3059: param_list := create_param_list(rule_id, 'F', 'N');
3060:
3061: SELECT r.validation_type_code, d.derivation_id, r.error_message
3062: INTO validation_type, deriv_id, error_message
3063: FROM gcs_lex_map_rules r,
3064: gcs_lex_map_derivations d
3065: WHERE r.rule_id = create_vrs_get_function.rule_id
3066: AND d.rule_id = r.rule_id;
3067:

Line 3155: gcs_lex_map_rules r

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:
3159: idt_name VARCHAR2(30);

Line 3439: FROM gcs_lex_map_rules r,

3435: ffv.flex_value_set_name
3436: INTO col_name,
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

Line 3460: FROM gcs_lex_map_rules r,

3456: lutms.structure_name
3457: INTO col_name,
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

Line 3533: FROM gcs_lex_map_rules r,

3529: SELECT mc.column_name,
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

Line 3628: gcs_lex_map_rules r

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:
3632: idt_name VARCHAR2(30);

Line 3756: gcs_lex_map_rules r

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;
3760: