APPS.GCS_LEX_MAP_API_PKG dependencies on GCS_LEX_MAP_STRUCTS

Line 770: gcs_lex_map_structs ms

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

Line 874: gcs_lex_map_structs lutms

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
877: AND r.target_column_id = mc.column_id
878: AND r.lookup_table_id = lutms.structure_id

Line 935: gcs_lex_map_structs lutms

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
936: WHERE rst.rule_set_id = rstg.rule_set_id
937: AND rstg.rule_stage_id = r.rule_stage_id
938: AND r.rule_id = d.rule_id
939: AND r.target_column_id = mc.column_id

Line 1625: gcs_lex_map_structs ms

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:
1629: table_name VARCHAR2(100);

Line 1953: gcs_lex_map_structs ms

1949: INTO lookup_table_name,
1950: result_col_name
1951: FROM gcs_lex_map_derivations d,
1952: gcs_lex_map_columns mc,
1953: gcs_lex_map_structs ms
1954: WHERE d.lookup_result_column_id = mc.column_id
1955: AND mc.structure_id = ms.structure_id
1956: AND d.derivation_id = create_lookup_derivation.derivation_id;
1957:

Line 1962: FROM gcs_lex_map_structs ms,

1958: deriv_text := 'SELECT lut.' || result_col_name || ' INTO ' || g_ret_val;
1959: ELSE
1960: SELECT ms.structure_name
1961: INTO lookup_table_name
1962: FROM gcs_lex_map_structs ms,
1963: gcs_lex_map_derivations d
1964: WHERE d.lookup_table_id = ms.structure_id
1965: AND d.derivation_id = create_lookup_derivation.derivation_id;
1966:

Line 2663: gcs_lex_map_structs lutms

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
2666: AND r.lookup_table_id = lutms.structure_id (+)
2667: AND r.validation_type_code <> 'N';

Line 3463: gcs_lex_map_structs lutms

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
3467: AND r.rule_id = error_table(i).rule_id;