APPS.PAY_DB_PAY_SETUP dependencies on PAY_DEFINED_BALANCES

Line 2099: l_run_bal_flag pay_defined_balances.save_run_balance%type;

2095: v_bt_legislation_subgroup varchar2(30);
2096: v_bt_balance_category_id number;
2097: v_def_bal_nextval number;
2098: l_bal_cat_id pay_balance_categories_f.balance_category_id%type;
2099: l_run_bal_flag pay_defined_balances.save_run_balance%type;
2100: l_eff_date date;
2101: l_defined_balance_id pay_defined_balances.defined_balance_id%type;
2102: v_dfb_legislation_code pay_defined_balances.legislation_code%type;
2103: v_dfb_legislation_subgroup pay_defined_balances.legislation_subgroup%type;

Line 2101: l_defined_balance_id pay_defined_balances.defined_balance_id%type;

2097: v_def_bal_nextval number;
2098: l_bal_cat_id pay_balance_categories_f.balance_category_id%type;
2099: l_run_bal_flag pay_defined_balances.save_run_balance%type;
2100: l_eff_date date;
2101: l_defined_balance_id pay_defined_balances.defined_balance_id%type;
2102: v_dfb_legislation_code pay_defined_balances.legislation_code%type;
2103: v_dfb_legislation_subgroup pay_defined_balances.legislation_subgroup%type;
2104: v_dfb_business_group_id pay_defined_balances.business_group_id%type;
2105: --

Line 2102: v_dfb_legislation_code pay_defined_balances.legislation_code%type;

2098: l_bal_cat_id pay_balance_categories_f.balance_category_id%type;
2099: l_run_bal_flag pay_defined_balances.save_run_balance%type;
2100: l_eff_date date;
2101: l_defined_balance_id pay_defined_balances.defined_balance_id%type;
2102: v_dfb_legislation_code pay_defined_balances.legislation_code%type;
2103: v_dfb_legislation_subgroup pay_defined_balances.legislation_subgroup%type;
2104: v_dfb_business_group_id pay_defined_balances.business_group_id%type;
2105: --
2106: begin

Line 2103: v_dfb_legislation_subgroup pay_defined_balances.legislation_subgroup%type;

2099: l_run_bal_flag pay_defined_balances.save_run_balance%type;
2100: l_eff_date date;
2101: l_defined_balance_id pay_defined_balances.defined_balance_id%type;
2102: v_dfb_legislation_code pay_defined_balances.legislation_code%type;
2103: v_dfb_legislation_subgroup pay_defined_balances.legislation_subgroup%type;
2104: v_dfb_business_group_id pay_defined_balances.business_group_id%type;
2105: --
2106: begin
2107: g_debug := hr_utility.debug_enabled;

Line 2104: v_dfb_business_group_id pay_defined_balances.business_group_id%type;

2100: l_eff_date date;
2101: l_defined_balance_id pay_defined_balances.defined_balance_id%type;
2102: v_dfb_legislation_code pay_defined_balances.legislation_code%type;
2103: v_dfb_legislation_subgroup pay_defined_balances.legislation_subgroup%type;
2104: v_dfb_business_group_id pay_defined_balances.business_group_id%type;
2105: --
2106: begin
2107: g_debug := hr_utility.debug_enabled;
2108: --

Line 2180: l_run_bal_flag := PAY_DEFINED_BALANCES_PKG.set_save_run_bals_flag

2176: close get_cat_id;
2177: end if;
2178: end if;
2179: --
2180: l_run_bal_flag := PAY_DEFINED_BALANCES_PKG.set_save_run_bals_flag
2181: (p_balance_category_id => l_bal_cat_id
2182: ,p_effective_date => l_eff_date
2183: ,p_balance_dimension_id => v_balance_dimension_id);
2184: --

Line 2193: select pay_defined_balances_s.nextval

2189: -- Bug 2646924 - changed p_legislation_code to v_legislation_code in the
2190: -- where clause, to enabled user defined_balances to be created for
2191: -- startup balances.
2192: --
2193: select pay_defined_balances_s.nextval
2194: , bt.business_group_id
2195: , bt.legislation_code
2196: , bt.balance_type_id
2197: , bt.legislation_subgroup

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

2234: if g_debug then
2235: hr_utility.set_location('pay_db_pay_setup.create_defined_balance', 7);
2236: end if;
2237: --
2238: -- A mutating table error will occur on pay_defined_balances if a defined
2239: -- balance is inserted here, while the old version of trigger
2240: -- pay_defined_balances_ari (pre pytrdfbl.sql 115.6) exists. The new version
2241: -- of the trigger prevents this error by setting a global in the trigger
2242: -- before the call to hrdyndbi.new_defined_balance.

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

2236: end if;
2237: --
2238: -- A mutating table error will occur on pay_defined_balances if a defined
2239: -- balance is inserted here, while the old version of trigger
2240: -- pay_defined_balances_ari (pre pytrdfbl.sql 115.6) exists. The new version
2241: -- of the trigger prevents this error by setting a global in the trigger
2242: -- before the call to hrdyndbi.new_defined_balance.
2243: -- However, when running a patch triggers are pretty much the last things to
2244: -- be run, so it is possible that defined balances could be inserted using the

Line 2257: insert into pay_defined_balances

2253: hrdyndbi.g_trigger_dfb_ari := true;
2254: --
2255: -- Create defined balance
2256: --
2257: insert into pay_defined_balances
2258: (DEFINED_BALANCE_ID,
2259: BUSINESS_GROUP_ID,
2260: LEGISLATION_CODE,
2261: BALANCE_TYPE_ID,

Line 2300: from pay_defined_balances

2296: -- get the defined_balance_id just created.
2297: --
2298: select defined_balance_id
2299: into l_defined_balance_id
2300: from pay_defined_balances
2301: where balance_type_id = v_bt_balance_type_id
2302: and balance_dimension_id = v_balance_dimension_id
2303: and nvl(business_group_id,nvl(v_dfb_business_group_id,-1))
2304: = nvl(v_dfb_business_group_id,-1)

Line 2315: pay_defined_balances_pkg.insert_default_attrib_wrapper

2311: end if;
2312: --
2313: -- see if any default attributes can be inserted.
2314: --
2315: pay_defined_balances_pkg.insert_default_attrib_wrapper
2316: (p_balance_dimension_id => v_balance_dimension_id
2317: ,p_balance_category_id => v_bt_balance_category_id
2318: ,p_def_bal_bg_id => v_dfb_business_group_id
2319: ,p_def_bal_leg_code => v_dfb_legislation_code