[Home] [Help]
307: g_con_local_unit_id pay_latest_balances.local_unit_id%type;
308: g_con_organization_id pay_latest_balances.organization_id%type;
309: g_con_source_number2 pay_latest_balances.source_number2%type;
310: --
311: -- Copy of Hr_General2.get_oracle_db_version to avoid a very nasty patching
312: -- issue in the c-code chain.
313: -- Bug 2865665.
314: -- --------------------------------------------------------------------------
315: -- |-------------------< get_oracle_db_version >----------------------------|
1693: -- Now setup the balance type joining details.
1694: --
1695: if (p_batch_mode = TRUE) then
1696: if (p_balance_type_column is null) then
1697: hr_general.assert_condition(false);
1698: else
1699: declare
1700: l_first_bt boolean;
1701: begin
2069: --
2070: -- Error, no rows found when the entity has been defined to always
2071: -- find a row.
2072: --
2073: hr_general.assert_condition(false);
2074: end if;
2075: --
2076: exception
2077: --
2515: if g_debug then
2516: hr_utility.set_location('pay_balance_pkg.get_run_balance', 20);
2517: end if;
2518: --
2519: hr_general.assert_condition(false);
2520: --
2521: end if;
2522: --
2523: -- Now execute the SQL statement using dynamic pl/sql:
2899: if g_debug then
2900: hr_utility.set_location ('Entering: pay_balance_pkg.get_rr_value', 20);
2901: end if;
2902: if (l_defbal_rec.start_rb_ptr is not null) then
2903: hr_general.assert_condition(false);
2904: else
2905: if g_debug then
2906: hr_utility.set_location ('Entering: pay_balance_pkg.get_rr_value', 30);
2907: end if;
6380: --
6381: -- error as should find a row for updating
6382: --
6383: close get_row_to_update;
6384: hr_general.assert_condition(false);
6385: --
6386: else
6387: close get_row_to_update;
6388: if g_debug then