APPS.PAY_SLA_PKG dependencies on XLA_RULES_T

Line 754: -- Creates a rule (in xla_rules_t) per Chart of Accounts Segment

750: --
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

Line 784: l_segment_rule_code xla_rules_t.segment_rule_code%type;

780: AND fseg.id_flex_num = gl.chart_of_accounts_id
781: AND fseg.application_column_name = fm.gl_account_segment
782: ORDER BY gl.chart_of_accounts_id, fm.gl_account_segment;
783: --
784: l_segment_rule_code xla_rules_t.segment_rule_code%type;
785: l_coa_id xla_rules_t.accounting_coa_id%type;
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;

Line 785: l_coa_id xla_rules_t.accounting_coa_id%type;

781: AND fseg.application_column_name = fm.gl_account_segment
782: ORDER BY gl.chart_of_accounts_id, fm.gl_account_segment;
783: --
784: l_segment_rule_code xla_rules_t.segment_rule_code%type;
785: l_coa_id xla_rules_t.accounting_coa_id%type;
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;

Line 786: l_acc_segment xla_rules_t.flexfield_segment_code%type;

782: ORDER BY gl.chart_of_accounts_id, fm.gl_account_segment;
783: --
784: l_segment_rule_code xla_rules_t.segment_rule_code%type;
785: l_coa_id xla_rules_t.accounting_coa_id%type;
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;

Line 787: l_pay_segment xla_rules_t.flexfield_segment_code%type;

783: --
784: l_segment_rule_code xla_rules_t.segment_rule_code%type;
785: l_coa_id xla_rules_t.accounting_coa_id%type;
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: --

Line 816: insert into xla_rules_t (

812: end if;
813:
814: -- Create the rule if it doesn't exist
815:
816: insert into xla_rules_t (
817: application_id,
818: amb_context_code,
819: segment_rule_type_code,
820: segment_rule_code,

Line 843: from xla_rules_t

839: 0
840: from dual
841: where not exists
842: (select 1
843: from xla_rules_t
844: where application_id = 801
845: and segment_rule_code = l_segment_rule_code);
846:
847: