APPS.GCS_LEX_MAP_API_PKG dependencies on GCS_LEX_MAP_DERIVATIONS

Line 471: gcs_lex_map_derivations d,

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
475: AND r.rule_id = d.rule_id

Line 529: gcs_lex_map_derivations d,

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
533: AND r.rule_id = d.rule_id

Line 932: gcs_lex_map_derivations d,

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

Line 1210: FROM gcs_lex_map_derivations d,

1206: AND rst.rule_set_id = initial_rule_set_check.rule_set_id;
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

Line 1784: gcs_lex_map_derivations d

1780: 'V', 'VARCHAR2',
1781: '') column_type_code
1782: FROM gcs_lex_map_columns mc,
1783: gcs_lex_map_drv_details dvd,
1784: gcs_lex_map_derivations d
1785: WHERE d.rule_id = create_param_list.rule_id
1786: AND dvd.derivation_id = d.derivation_id
1787: AND dvd.detail_column_id = mc.column_id)
1788: UNION

Line 1796: gcs_lex_map_derivations d

1792: 'V', 'VARCHAR2',
1793: '') column_type_code
1794: FROM gcs_lex_map_columns mc,
1795: gcs_lex_map_conditions c,
1796: gcs_lex_map_derivations d
1797: WHERE d.rule_id = create_param_list.rule_id
1798: AND c.derivation_id = d.derivation_id
1799: AND c.source_column_id = mc.column_id)
1800: ORDER BY column_name;

Line 1951: FROM gcs_lex_map_derivations d,

1947: SELECT ms.structure_name,
1948: mc.column_name
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

Line 1963: gcs_lex_map_derivations d

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:
1967: deriv_text := 'SELECT DISTINCT 1 INTO dummy';

Line 2106: FROM gcs_lex_map_derivations d

2102: module := g_api || '.Create_PLSQL_Derivation';
2103:
2104: SELECT function_name
2105: INTO deriv_text
2106: FROM gcs_lex_map_derivations d
2107: WHERE d.derivation_id = create_plsql_derivation.derivation_id;
2108:
2109: -- With the validation case, we only pass in the rowid
2110: IF usage = 'VALIDATION' THEN

Line 2276: FROM gcs_lex_map_derivations d

2272: func_body VARCHAR2(32767);
2273:
2274: CURSOR all_derivs IS
2275: SELECT d.derivation_id, d.derivation_type_code
2276: FROM gcs_lex_map_derivations d
2277: WHERE d.rule_id = create_get_function.rule_id
2278: ORDER BY d.derivation_sequence;
2279:
2280: CURSOR check_condition_c(c_deriv_id NUMBER) IS

Line 3064: gcs_lex_map_derivations d

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:
3068: log_error_text :=