[Home] [Help]
751: END delete_event;
752: --
753: -- Procedure to create custom ADRs based on their existing PAY-GL flex map
754: -- Creates a rule (in xla_rules_t) per Chart of Accounts Segment
755: -- Creates a rule detail (in xla_rule_details_t) for each Payroll Segment
756: -- mapped to this COA Segment
757: -- Creats 1 condition (in xla_conditions_t) for each rule detail
758: -- specifying the Payroll name
759: --
786: l_acc_segment xla_rules_t.flexfield_segment_code%type;
787: l_pay_segment xla_rules_t.flexfield_segment_code%type;
788: l_prev_payroll_id pay_all_payrolls_f.payroll_id%type := -1;
789: l_payroll_name pay_all_payrolls_f.payroll_name%type;
790: l_rule_det_seq xla_rule_details_t.user_sequence%type;
791: --
792: BEGIN
793: --
794: hr_utility.set_location('pay_sla_pkg.create_custom_adrs',10);
848: -- Create the rule detail if it doesn't exist
849:
850: select count(*)
851: into l_rule_det_seq
852: from xla_rule_details_t
853: where application_id = 801
854: and segment_rule_code = l_segment_rule_code;
855:
856: insert into xla_rule_details_t (
852: from xla_rule_details_t
853: where application_id = 801
854: and segment_rule_code = l_segment_rule_code;
855:
856: insert into xla_rule_details_t (
857: application_id,
858: amb_context_code,
859: segment_rule_type_code,
860: segment_rule_code,
880: 0
881: from dual
882: where not exists
883: (select 1
884: from xla_rule_details_t xrd,
885: xla_conditions_t xc
886: where xrd.application_id = 801
887: and xrd.segment_rule_code = l_segment_rule_code
888: and xrd.value_source_code = l_pay_segment
921: 0
922: from dual
923: where not exists
924: (select 1
925: from xla_rule_details_t xrd,
926: xla_conditions_t xc
927: where xrd.application_id = 801
928: and xrd.segment_rule_code = l_segment_rule_code
929: and xrd.value_source_code = l_pay_segment