[Home] [Help]
1254: --
1255: cursor chk_flag_set(p_def_bal number)
1256: is
1257: select count(*)
1258: from pay_defined_balances
1259: where defined_balance_id = p_def_bal
1260: and save_run_balance is null;
1261: --
1262: cursor get_cat_id(p_bal_type number)
1281: usr_ent_id number;
1282: route_param_value number;
1283: l_flag_set number;
1284: l_bal_cat_id pay_balance_types.balance_category_id%type;
1285: l_run_bal_flag pay_defined_balances.save_run_balance%type;
1286: l_sess_date date;
1287: l_ora_db_vers number; -- db version number for LOW_VOLUME
1288:
1289: l_legislation_code varchar2(30);
1335: close get_sess_date;
1336: l_sess_date := trunc(sysdate);
1337: end if;
1338: --
1339: l_run_bal_flag := pay_defined_balances_pkg.set_save_run_bals_flag
1340: (p_balance_category_id => l_bal_cat_id
1341: ,p_effective_date => l_sess_date
1342: ,p_balance_dimension_id => p_balance_dimension_id); --
1343: if l_run_bal_flag is not null then
1344: --
1345: -- update the defined balance
1346: --
1347: begin
1348: update pay_defined_balances
1349: set save_run_balance = l_run_bal_flag
1350: where defined_balance_id = p_defined_balance_id;
1351: exception
1352: when others then
1522: balance_type_id,
1523: business_group_id,
1524: legislation_code,
1525: save_run_balance
1526: from pay_defined_balances b
1527: where not exists (
1528: select null from ff_user_entities u
1529: where b.defined_balance_id = u.creator_id
1530: and u.creator_type = 'B')
1536: balance_type_id,
1537: business_group_id,
1538: legislation_code,
1539: save_run_balance
1540: from pay_defined_balances b
1541: where /* def bal ue simply doesn't exist but has an associated pdr */
1542: ((
1543: not exists (
1544: select null from ff_user_entities u
1693: balance_type_id,
1694: business_group_id,
1695: legislation_code,
1696: save_run_balance
1697: from pay_defined_balances a
1698: where not exists (
1699: select null from ff_user_entities u
1700: where a.defined_balance_id = u.creator_id
1701: and u.creator_type = 'B')
1712: balance_type_id,
1713: business_group_id,
1714: legislation_code,
1715: save_run_balance
1716: from pay_defined_balances a
1717: where /* def bal ue simply doesn't exist but has an associated pdr */
1718: ((
1719: not exists (
1720: select null from ff_user_entities u
5508: -- B
5509: and (
5510: not exists (
5511: select null
5512: from pay_defined_balances b
5513: where b.defined_balance_id = ent.creator_id
5514: and ent.creator_type = 'B'
5515: )
5516: OR
5516: OR
5517: -- RB
5518: (not exists (
5519: select null
5520: from pay_defined_balances b
5521: where b.defined_balance_id = ent.creator_id
5522: and ent.creator_type = 'RB'
5523: and exists
5524: (select null
5528: OR
5529: (exists (
5530: select pdr.balance_dimension_id
5531: from pay_dimension_routes pdr,
5532: pay_defined_balances b
5533: where pdr.balance_dimension_id = b.balance_dimension_id
5534: and not exists (select null
5535: from ff_user_entities ue
5536: where ue.creator_id = b.defined_balance_id
8261: , db.legislation_code
8262: , db.business_group_id
8263: , db.balance_type_id
8264: , db.balance_dimension_id
8265: from pay_defined_balances db
8266: , pay_balance_types b
8267: , pay_balance_dimensions d
8268: where db.defined_balance_id = p_defined_balance_id
8269: and b.balance_type_id = db.balance_type_id
8271: ;
8272: --
8273: l_found boolean;
8274: l_base_name ff_database_items.user_name%type;
8275: l_leg_code pay_defined_balances.legislation_code%type;
8276: l_bg_id pay_defined_balances.business_group_id%type;
8277: l_bal_id pay_defined_balances.balance_type_id%type;
8278: l_baldim_id pay_defined_balances.balance_dimension_id%type;
8279: begin
8272: --
8273: l_found boolean;
8274: l_base_name ff_database_items.user_name%type;
8275: l_leg_code pay_defined_balances.legislation_code%type;
8276: l_bg_id pay_defined_balances.business_group_id%type;
8277: l_bal_id pay_defined_balances.balance_type_id%type;
8278: l_baldim_id pay_defined_balances.balance_dimension_id%type;
8279: begin
8280: open csr_balance_dbi_name
8273: l_found boolean;
8274: l_base_name ff_database_items.user_name%type;
8275: l_leg_code pay_defined_balances.legislation_code%type;
8276: l_bg_id pay_defined_balances.business_group_id%type;
8277: l_bal_id pay_defined_balances.balance_type_id%type;
8278: l_baldim_id pay_defined_balances.balance_dimension_id%type;
8279: begin
8280: open csr_balance_dbi_name
8281: (p_defined_balance_id => p_defined_balance_id
8274: l_base_name ff_database_items.user_name%type;
8275: l_leg_code pay_defined_balances.legislation_code%type;
8276: l_bg_id pay_defined_balances.business_group_id%type;
8277: l_bal_id pay_defined_balances.balance_type_id%type;
8278: l_baldim_id pay_defined_balances.balance_dimension_id%type;
8279: begin
8280: open csr_balance_dbi_name
8281: (p_defined_balance_id => p_defined_balance_id
8282: );
9112: ,p_languages in dbms_sql.varchar2s
9113: ) is
9114: l_leg_code varchar2(30);
9115: l_bg_id number;
9116: l_bal_id pay_defined_balances.balance_type_id%type;
9117: l_baldim_id pay_defined_balances.balance_dimension_id%type;
9118: l_base_name ff_database_items.user_name%type;
9119: l_ueid number;
9120: l_tl_name ff_database_items_tl.translated_user_name%type;
9113: ) is
9114: l_leg_code varchar2(30);
9115: l_bg_id number;
9116: l_bal_id pay_defined_balances.balance_type_id%type;
9117: l_baldim_id pay_defined_balances.balance_dimension_id%type;
9118: l_base_name ff_database_items.user_name%type;
9119: l_ueid number;
9120: l_tl_name ff_database_items_tl.translated_user_name%type;
9121: l_found boolean;
10345: cursor csr_def_balance
10346: (p_defined_balance_id in number
10347: ) is
10348: select to_char(null)
10349: from pay_defined_balances db
10350: where db.defined_balance_id = p_defined_balance_id
10351: ;
10352: --
10353: procedure init_cnt(p_cnt in out nocopy binary_integer) is