APPS.XLA_SEG_RULES_PKG dependencies on XLA_SEG_RULE_DETAILS

Line 45: FROM xla_seg_rule_details

41:
42: CURSOR c_seg_rule_details
43: IS
44: SELECT segment_rule_detail_id
45: FROM xla_seg_rule_details
46: WHERE application_id = p_application_id
47: AND amb_context_code = p_amb_context_code
48: AND segment_rule_type_code = p_segment_rule_type_code
49: AND segment_rule_code = p_segment_rule_code;

Line 73: FROM xla_seg_rule_details

69: END LOOP;
70: CLOSE c_seg_rule_details;
71:
72: DELETE
73: FROM xla_seg_rule_details
74: WHERE application_id = p_application_id
75: AND amb_context_code = p_amb_context_code
76: AND segment_rule_type_code = p_segment_rule_type_code
77: AND segment_rule_code = p_segment_rule_code;

Line 149: FROM xla_seg_rule_details

145: value_flexfield_segment_code, input_source_application_id,
146: input_source_type_code, input_source_code,
147: value_segment_rule_appl_id, value_segment_rule_type_code,
148: value_segment_rule_code, value_adr_version_num
149: FROM xla_seg_rule_details
150: WHERE application_id = p_application_id
151: AND amb_context_code = p_amb_context_code
152: AND segment_rule_type_code = p_old_segment_rule_type_code
153: AND segment_rule_code = p_old_segment_rule_code;

Line 261: SELECT xla_seg_rule_details_s.nextval

257: -- value_flexfield_segment_code is null
258: l_value_flexfield_segment_code := l_seg_rule_detail.value_flexfield_segment_code;
259: END IF;
260:
261: SELECT xla_seg_rule_details_s.nextval
262: INTO l_new_segment_rule_detail_id
263: FROM DUAL;
264:
265: INSERT INTO xla_seg_rule_details

Line 265: INSERT INTO xla_seg_rule_details

261: SELECT xla_seg_rule_details_s.nextval
262: INTO l_new_segment_rule_detail_id
263: FROM DUAL;
264:
265: INSERT INTO xla_seg_rule_details
266: (segment_rule_detail_id
267: ,application_id
268: ,amb_context_code
269: ,segment_rule_type_code

Line 1309: FROM xla_seg_rule_details seg

1305:
1306: CURSOR c_flex_value
1307: IS
1308: SELECT value_constant
1309: FROM xla_seg_rule_details seg
1310: WHERE application_id = p_application_id
1311: AND amb_context_code = p_amb_context_code
1312: AND segment_rule_type_code = p_old_segment_rule_type_code
1313: AND segment_rule_code = p_old_segment_rule_code

Line 1329: FROM xla_seg_rule_details

1325: value_source_code, value_constant, value_code_combination_id,
1326: value_mapping_set_code,
1327: value_flexfield_segment_code, input_source_application_id,
1328: input_source_type_code, input_source_code
1329: FROM xla_seg_rule_details
1330: WHERE application_id = p_application_id
1331: AND amb_context_code = p_amb_context_code
1332: AND segment_rule_type_code = p_old_segment_rule_type_code
1333: AND segment_rule_code = p_old_segment_rule_code;

Line 1599: FROM xla_seg_rule_details

1595: SELECT application_id
1596: ,amb_context_code
1597: ,segment_rule_type_code
1598: ,segment_rule_code
1599: FROM xla_seg_rule_details
1600: WHERE amb_context_code = p_amb_context_code
1601: AND value_segment_rule_appl_id = p_application_id
1602: AND value_segment_rule_type_code = p_segment_rule_type_code
1603: AND value_segment_rule_code = p_segment_rule_code;

Line 1672: FROM xla_seg_rule_details s

1668: SELECT application_id
1669: ,amb_context_code
1670: ,segment_rule_type_code
1671: ,segment_rule_code
1672: FROM xla_seg_rule_details s
1673: WHERE value_segment_rule_appl_id = p_application_id
1674: AND value_segment_rule_type_code = p_segment_rule_type_code
1675: AND value_segment_rule_code = p_segment_rule_code;
1676: