APPS.PAY_FR_DB_PAY_SETUP dependencies on PAY_DEFINED_BALANCES

Line 2106: l_run_bal_flag pay_defined_balances.save_run_balance%type;

2102: v_bt_legislation_subgroup varchar2(30);
2103: v_bt_balance_category_id number;
2104: v_def_bal_nextval number;
2105: l_bal_cat_id pay_balance_categories_f.balance_category_id%type;
2106: l_run_bal_flag pay_defined_balances.save_run_balance%type;
2107: l_eff_date date;
2108: l_defined_balance_id pay_defined_balances.defined_balance_id%type;
2109: v_dfb_legislation_code pay_defined_balances.legislation_code%type;
2110: v_dfb_legislation_subgroup pay_defined_balances.legislation_subgroup%type;

Line 2108: l_defined_balance_id pay_defined_balances.defined_balance_id%type;

2104: v_def_bal_nextval number;
2105: l_bal_cat_id pay_balance_categories_f.balance_category_id%type;
2106: l_run_bal_flag pay_defined_balances.save_run_balance%type;
2107: l_eff_date date;
2108: l_defined_balance_id pay_defined_balances.defined_balance_id%type;
2109: v_dfb_legislation_code pay_defined_balances.legislation_code%type;
2110: v_dfb_legislation_subgroup pay_defined_balances.legislation_subgroup%type;
2111: v_dfb_business_group_id pay_defined_balances.business_group_id%type;
2112: --

Line 2109: v_dfb_legislation_code pay_defined_balances.legislation_code%type;

2105: l_bal_cat_id pay_balance_categories_f.balance_category_id%type;
2106: l_run_bal_flag pay_defined_balances.save_run_balance%type;
2107: l_eff_date date;
2108: l_defined_balance_id pay_defined_balances.defined_balance_id%type;
2109: v_dfb_legislation_code pay_defined_balances.legislation_code%type;
2110: v_dfb_legislation_subgroup pay_defined_balances.legislation_subgroup%type;
2111: v_dfb_business_group_id pay_defined_balances.business_group_id%type;
2112: --
2113: begin

Line 2110: v_dfb_legislation_subgroup pay_defined_balances.legislation_subgroup%type;

2106: l_run_bal_flag pay_defined_balances.save_run_balance%type;
2107: l_eff_date date;
2108: l_defined_balance_id pay_defined_balances.defined_balance_id%type;
2109: v_dfb_legislation_code pay_defined_balances.legislation_code%type;
2110: v_dfb_legislation_subgroup pay_defined_balances.legislation_subgroup%type;
2111: v_dfb_business_group_id pay_defined_balances.business_group_id%type;
2112: --
2113: begin
2114: g_debug := hr_utility.debug_enabled;

Line 2111: v_dfb_business_group_id pay_defined_balances.business_group_id%type;

2107: l_eff_date date;
2108: l_defined_balance_id pay_defined_balances.defined_balance_id%type;
2109: v_dfb_legislation_code pay_defined_balances.legislation_code%type;
2110: v_dfb_legislation_subgroup pay_defined_balances.legislation_subgroup%type;
2111: v_dfb_business_group_id pay_defined_balances.business_group_id%type;
2112: --
2113: begin
2114: g_debug := hr_utility.debug_enabled;
2115: --

Line 2187: l_run_bal_flag := PAY_DEFINED_BALANCES_PKG.set_save_run_bals_flag

2183: close get_cat_id;
2184: end if;
2185: end if;
2186: --
2187: l_run_bal_flag := PAY_DEFINED_BALANCES_PKG.set_save_run_bals_flag
2188: (p_balance_category_id => l_bal_cat_id
2189: ,p_effective_date => p_effective_date
2190: ,p_balance_dimension_id => v_balance_dimension_id);
2191: --

Line 2200: select pay_defined_balances_s.nextval

2196: -- Bug 2646924 - changed p_legislation_code to v_legislation_code in the
2197: -- where clause, to enabled user defined_balances to be created for
2198: -- startup balances.
2199: --
2200: select pay_defined_balances_s.nextval
2201: , bt.business_group_id
2202: , bt.legislation_code
2203: , bt.balance_type_id
2204: , bt.legislation_subgroup

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

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

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

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

Line 2264: insert into pay_defined_balances

2260: hrdyndbi.g_trigger_dfb_ari := true;
2261: --
2262: -- Create defined balance
2263: --
2264: insert into pay_defined_balances
2265: (DEFINED_BALANCE_ID,
2266: BUSINESS_GROUP_ID,
2267: LEGISLATION_CODE,
2268: BALANCE_TYPE_ID,

Line 2307: from pay_defined_balances

2303: -- get the defined_balance_id just created.
2304: --
2305: select defined_balance_id
2306: into l_defined_balance_id
2307: from pay_defined_balances
2308: where balance_type_id = v_bt_balance_type_id
2309: and balance_dimension_id = v_balance_dimension_id
2310: and nvl(business_group_id,nvl(v_dfb_business_group_id,-1))
2311: = nvl(v_dfb_business_group_id,-1)

Line 2322: pay_defined_balances_pkg.insert_default_attrib_wrapper

2318: end if;
2319: --
2320: -- see if any default attributes can be inserted.
2321: --
2322: pay_defined_balances_pkg.insert_default_attrib_wrapper
2323: (p_balance_dimension_id => v_balance_dimension_id
2324: ,p_balance_category_id => v_bt_balance_category_id
2325: ,p_def_bal_bg_id => v_dfb_business_group_id
2326: ,p_def_bal_leg_code => v_dfb_legislation_code