APPS.PAY_DB_PAY_SETUP dependencies on PAY_DEFINED_BALANCES

Line 2122: l_run_bal_flag pay_defined_balances.save_run_balance%type;

2118: v_bt_legislation_subgroup varchar2(30);
2119: v_bt_balance_category_id number;
2120: v_def_bal_nextval number;
2121: l_bal_cat_id pay_balance_categories_f.balance_category_id%type;
2122: l_run_bal_flag pay_defined_balances.save_run_balance%type;
2123: l_eff_date date;
2124: l_defined_balance_id pay_defined_balances.defined_balance_id%type;
2125: v_dfb_legislation_code pay_defined_balances.legislation_code%type;
2126: v_dfb_legislation_subgroup pay_defined_balances.legislation_subgroup%type;

Line 2124: l_defined_balance_id pay_defined_balances.defined_balance_id%type;

2120: v_def_bal_nextval number;
2121: l_bal_cat_id pay_balance_categories_f.balance_category_id%type;
2122: l_run_bal_flag pay_defined_balances.save_run_balance%type;
2123: l_eff_date date;
2124: l_defined_balance_id pay_defined_balances.defined_balance_id%type;
2125: v_dfb_legislation_code pay_defined_balances.legislation_code%type;
2126: v_dfb_legislation_subgroup pay_defined_balances.legislation_subgroup%type;
2127: v_dfb_business_group_id pay_defined_balances.business_group_id%type;
2128: --

Line 2125: v_dfb_legislation_code pay_defined_balances.legislation_code%type;

2121: l_bal_cat_id pay_balance_categories_f.balance_category_id%type;
2122: l_run_bal_flag pay_defined_balances.save_run_balance%type;
2123: l_eff_date date;
2124: l_defined_balance_id pay_defined_balances.defined_balance_id%type;
2125: v_dfb_legislation_code pay_defined_balances.legislation_code%type;
2126: v_dfb_legislation_subgroup pay_defined_balances.legislation_subgroup%type;
2127: v_dfb_business_group_id pay_defined_balances.business_group_id%type;
2128: --
2129: begin

Line 2126: v_dfb_legislation_subgroup pay_defined_balances.legislation_subgroup%type;

2122: l_run_bal_flag pay_defined_balances.save_run_balance%type;
2123: l_eff_date date;
2124: l_defined_balance_id pay_defined_balances.defined_balance_id%type;
2125: v_dfb_legislation_code pay_defined_balances.legislation_code%type;
2126: v_dfb_legislation_subgroup pay_defined_balances.legislation_subgroup%type;
2127: v_dfb_business_group_id pay_defined_balances.business_group_id%type;
2128: --
2129: begin
2130: g_debug := hr_utility.debug_enabled;

Line 2127: v_dfb_business_group_id pay_defined_balances.business_group_id%type;

2123: l_eff_date date;
2124: l_defined_balance_id pay_defined_balances.defined_balance_id%type;
2125: v_dfb_legislation_code pay_defined_balances.legislation_code%type;
2126: v_dfb_legislation_subgroup pay_defined_balances.legislation_subgroup%type;
2127: v_dfb_business_group_id pay_defined_balances.business_group_id%type;
2128: --
2129: begin
2130: g_debug := hr_utility.debug_enabled;
2131: --

Line 2203: l_run_bal_flag := PAY_DEFINED_BALANCES_PKG.set_save_run_bals_flag

2199: close get_cat_id;
2200: end if;
2201: end if;
2202: --
2203: l_run_bal_flag := PAY_DEFINED_BALANCES_PKG.set_save_run_bals_flag
2204: (p_balance_category_id => l_bal_cat_id
2205: ,p_effective_date => l_eff_date
2206: ,p_balance_dimension_id => v_balance_dimension_id);
2207: --

Line 2216: select pay_defined_balances_s.nextval

2212: -- Bug 2646924 - changed p_legislation_code to v_legislation_code in the
2213: -- where clause, to enabled user defined_balances to be created for
2214: -- startup balances.
2215: --
2216: select pay_defined_balances_s.nextval
2217: , bt.business_group_id
2218: , bt.legislation_code
2219: , bt.balance_type_id
2220: , bt.legislation_subgroup

Line 2261: -- A mutating table error will occur on pay_defined_balances if a defined

2257: if g_debug then
2258: hr_utility.set_location('pay_db_pay_setup.create_defined_balance', 7);
2259: end if;
2260: --
2261: -- A mutating table error will occur on pay_defined_balances if a defined
2262: -- balance is inserted here, while the old version of trigger
2263: -- pay_defined_balances_ari (pre pytrdfbl.sql 115.6) exists. The new version
2264: -- of the trigger prevents this error by setting a global in the trigger
2265: -- before the call to hrdyndbi.new_defined_balance.

Line 2263: -- pay_defined_balances_ari (pre pytrdfbl.sql 115.6) exists. The new version

2259: end if;
2260: --
2261: -- A mutating table error will occur on pay_defined_balances if a defined
2262: -- balance is inserted here, while the old version of trigger
2263: -- pay_defined_balances_ari (pre pytrdfbl.sql 115.6) exists. The new version
2264: -- of the trigger prevents this error by setting a global in the trigger
2265: -- before the call to hrdyndbi.new_defined_balance.
2266: -- However, when running a patch triggers are pretty much the last things to
2267: -- be run, so it is possible that defined balances could be inserted using the

Line 2280: insert into pay_defined_balances

2276: hrdyndbi.g_trigger_dfb_ari := true;
2277: --
2278: -- Create defined balance
2279: --
2280: insert into pay_defined_balances
2281: (DEFINED_BALANCE_ID,
2282: BUSINESS_GROUP_ID,
2283: LEGISLATION_CODE,
2284: BALANCE_TYPE_ID,

Line 2323: from pay_defined_balances

2319: -- get the defined_balance_id just created.
2320: --
2321: select defined_balance_id
2322: into l_defined_balance_id
2323: from pay_defined_balances
2324: where balance_type_id = v_bt_balance_type_id
2325: and balance_dimension_id = v_balance_dimension_id
2326: and nvl(business_group_id,nvl(v_dfb_business_group_id,-1))
2327: = nvl(v_dfb_business_group_id,-1)

Line 2338: pay_defined_balances_pkg.insert_default_attrib_wrapper

2334: end if;
2335: --
2336: -- see if any default attributes can be inserted.
2337: --
2338: pay_defined_balances_pkg.insert_default_attrib_wrapper
2339: (p_balance_dimension_id => v_balance_dimension_id
2340: ,p_balance_category_id => v_bt_balance_category_id
2341: ,p_def_bal_bg_id => v_dfb_business_group_id
2342: ,p_def_bal_leg_code => v_dfb_legislation_code