APPS.PAY_SLA_PKG dependencies on XLA_RULES_T

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

731: --
732: END delete_event;
733: --
734: -- Procedure to create custom ADRs based on their existing PAY-GL flex map
735: -- Creates a rule (in xla_rules_t) per Chart of Accounts Segment
736: -- Creates a rule detail (in xla_rule_details_t) for each Payroll Segment
737: -- mapped to this COA Segment
738: -- Creats 1 condition (in xla_conditions_t) for each rule detail
739: -- specifying the Payroll name

Line 765: l_segment_rule_code xla_rules_t.segment_rule_code%type;

761: AND fseg.id_flex_num = gl.chart_of_accounts_id
762: AND fseg.application_column_name = fm.gl_account_segment
763: ORDER BY gl.chart_of_accounts_id, fm.gl_account_segment;
764: --
765: l_segment_rule_code xla_rules_t.segment_rule_code%type;
766: l_coa_id xla_rules_t.accounting_coa_id%type;
767: l_acc_segment xla_rules_t.flexfield_segment_code%type;
768: l_pay_segment xla_rules_t.flexfield_segment_code%type;
769: l_prev_payroll_id pay_all_payrolls_f.payroll_id%type := -1;

Line 766: l_coa_id xla_rules_t.accounting_coa_id%type;

762: AND fseg.application_column_name = fm.gl_account_segment
763: ORDER BY gl.chart_of_accounts_id, fm.gl_account_segment;
764: --
765: l_segment_rule_code xla_rules_t.segment_rule_code%type;
766: l_coa_id xla_rules_t.accounting_coa_id%type;
767: l_acc_segment xla_rules_t.flexfield_segment_code%type;
768: l_pay_segment xla_rules_t.flexfield_segment_code%type;
769: l_prev_payroll_id pay_all_payrolls_f.payroll_id%type := -1;
770: l_payroll_name pay_all_payrolls_f.payroll_name%type;

Line 767: l_acc_segment xla_rules_t.flexfield_segment_code%type;

763: ORDER BY gl.chart_of_accounts_id, fm.gl_account_segment;
764: --
765: l_segment_rule_code xla_rules_t.segment_rule_code%type;
766: l_coa_id xla_rules_t.accounting_coa_id%type;
767: l_acc_segment xla_rules_t.flexfield_segment_code%type;
768: l_pay_segment xla_rules_t.flexfield_segment_code%type;
769: l_prev_payroll_id pay_all_payrolls_f.payroll_id%type := -1;
770: l_payroll_name pay_all_payrolls_f.payroll_name%type;
771: l_rule_det_seq xla_rule_details_t.user_sequence%type;

Line 768: l_pay_segment xla_rules_t.flexfield_segment_code%type;

764: --
765: l_segment_rule_code xla_rules_t.segment_rule_code%type;
766: l_coa_id xla_rules_t.accounting_coa_id%type;
767: l_acc_segment xla_rules_t.flexfield_segment_code%type;
768: l_pay_segment xla_rules_t.flexfield_segment_code%type;
769: l_prev_payroll_id pay_all_payrolls_f.payroll_id%type := -1;
770: l_payroll_name pay_all_payrolls_f.payroll_name%type;
771: l_rule_det_seq xla_rule_details_t.user_sequence%type;
772: --

Line 797: insert into xla_rules_t (

793: end if;
794:
795: -- Create the rule if it doesn't exist
796:
797: insert into xla_rules_t (
798: application_id,
799: amb_context_code,
800: segment_rule_type_code,
801: segment_rule_code,

Line 824: from xla_rules_t

820: 0
821: from dual
822: where not exists
823: (select 1
824: from xla_rules_t
825: where application_id = 801
826: and segment_rule_code = l_segment_rule_code);
827:
828: