102: END IF;
103:
104: AD_ZD_SEED.PREPARE('XLA_SEG_RULES_B');
105: AD_ZD_SEED.PREPARE('XLA_SEG_RULES_TL');
106: AD_ZD_SEED.PREPARE('XLA_SEG_RULE_DETAILS');
107: AD_ZD_SEED.PREPARE('XLA_CONDITIONS');
108: AD_ZD_SEED.PREPARE('XLA_LINE_DEFN_ADR_ASSGNS');
109:
110:
349: FETCH c_xla_rule_details_t into l_xla_rule_details;
350: EXIT WHEN c_xla_rule_details_t%NOTFOUND;
351:
352: BEGIN -- Block begins
353: -- Insert data into xla_seg_rule_details
354: INSERT INTO xla_seg_rule_details
355: (segment_rule_detail_id
356: ,application_id
357: ,amb_context_code
350: EXIT WHEN c_xla_rule_details_t%NOTFOUND;
351:
352: BEGIN -- Block begins
353: -- Insert data into xla_seg_rule_details
354: INSERT INTO xla_seg_rule_details
355: (segment_rule_detail_id
356: ,application_id
357: ,amb_context_code
358: ,segment_rule_type_code