[Home] [Help]
1251: --
1252: cursor chk_flag_set(p_def_bal number)
1253: is
1254: select count(*)
1255: from pay_defined_balances
1256: where defined_balance_id = p_def_bal
1257: and save_run_balance is null;
1258: --
1259: cursor get_cat_id(p_bal_type number)
1278: usr_ent_id number;
1279: route_param_value number;
1280: l_flag_set number;
1281: l_bal_cat_id pay_balance_types.balance_category_id%type;
1282: l_run_bal_flag pay_defined_balances.save_run_balance%type;
1283: l_sess_date date;
1284: l_ora_db_vers number; -- db version number for LOW_VOLUME
1285:
1286: l_legislation_code varchar2(30);
1332: close get_sess_date;
1333: l_sess_date := trunc(sysdate);
1334: end if;
1335: --
1336: l_run_bal_flag := pay_defined_balances_pkg.set_save_run_bals_flag
1337: (p_balance_category_id => l_bal_cat_id
1338: ,p_effective_date => l_sess_date
1339: ,p_balance_dimension_id => p_balance_dimension_id); --
1340: if l_run_bal_flag is not null then
1341: --
1342: -- update the defined balance
1343: --
1344: begin
1345: update pay_defined_balances
1346: set save_run_balance = l_run_bal_flag
1347: where defined_balance_id = p_defined_balance_id;
1348: exception
1349: when others then
1519: balance_type_id,
1520: business_group_id,
1521: legislation_code,
1522: save_run_balance
1523: from pay_defined_balances b
1524: where not exists (
1525: select null from ff_user_entities u
1526: where b.defined_balance_id = u.creator_id
1527: and u.creator_type = 'B')
1533: balance_type_id,
1534: business_group_id,
1535: legislation_code,
1536: save_run_balance
1537: from pay_defined_balances b
1538: where /* def bal ue simply doesn't exist but has an associated pdr */
1539: ((
1540: not exists (
1541: select null from ff_user_entities u
1690: balance_type_id,
1691: business_group_id,
1692: legislation_code,
1693: save_run_balance
1694: from pay_defined_balances a
1695: where not exists (
1696: select null from ff_user_entities u
1697: where a.defined_balance_id = u.creator_id
1698: and u.creator_type = 'B')
1709: balance_type_id,
1710: business_group_id,
1711: legislation_code,
1712: save_run_balance
1713: from pay_defined_balances a
1714: where /* def bal ue simply doesn't exist but has an associated pdr */
1715: ((
1716: not exists (
1717: select null from ff_user_entities u
5505: -- B
5506: and (
5507: not exists (
5508: select null
5509: from pay_defined_balances b
5510: where b.defined_balance_id = ent.creator_id
5511: and ent.creator_type = 'B'
5512: )
5513: OR
5513: OR
5514: -- RB
5515: (not exists (
5516: select null
5517: from pay_defined_balances b
5518: where b.defined_balance_id = ent.creator_id
5519: and ent.creator_type = 'RB'
5520: and exists
5521: (select null
5525: OR
5526: (exists (
5527: select pdr.balance_dimension_id
5528: from pay_dimension_routes pdr,
5529: pay_defined_balances b
5530: where pdr.balance_dimension_id = b.balance_dimension_id
5531: and not exists (select null
5532: from ff_user_entities ue
5533: where ue.creator_id = b.defined_balance_id
8184: , db.legislation_code
8185: , db.business_group_id
8186: , db.balance_type_id
8187: , db.balance_dimension_id
8188: from pay_defined_balances db
8189: , pay_balance_types b
8190: , pay_balance_dimensions d
8191: where db.defined_balance_id = p_defined_balance_id
8192: and b.balance_type_id = db.balance_type_id
8194: ;
8195: --
8196: l_found boolean;
8197: l_base_name ff_database_items.user_name%type;
8198: l_leg_code pay_defined_balances.legislation_code%type;
8199: l_bg_id pay_defined_balances.business_group_id%type;
8200: l_bal_id pay_defined_balances.balance_type_id%type;
8201: l_baldim_id pay_defined_balances.balance_dimension_id%type;
8202: begin
8195: --
8196: l_found boolean;
8197: l_base_name ff_database_items.user_name%type;
8198: l_leg_code pay_defined_balances.legislation_code%type;
8199: l_bg_id pay_defined_balances.business_group_id%type;
8200: l_bal_id pay_defined_balances.balance_type_id%type;
8201: l_baldim_id pay_defined_balances.balance_dimension_id%type;
8202: begin
8203: open csr_balance_dbi_name
8196: l_found boolean;
8197: l_base_name ff_database_items.user_name%type;
8198: l_leg_code pay_defined_balances.legislation_code%type;
8199: l_bg_id pay_defined_balances.business_group_id%type;
8200: l_bal_id pay_defined_balances.balance_type_id%type;
8201: l_baldim_id pay_defined_balances.balance_dimension_id%type;
8202: begin
8203: open csr_balance_dbi_name
8204: (p_defined_balance_id => p_defined_balance_id
8197: l_base_name ff_database_items.user_name%type;
8198: l_leg_code pay_defined_balances.legislation_code%type;
8199: l_bg_id pay_defined_balances.business_group_id%type;
8200: l_bal_id pay_defined_balances.balance_type_id%type;
8201: l_baldim_id pay_defined_balances.balance_dimension_id%type;
8202: begin
8203: open csr_balance_dbi_name
8204: (p_defined_balance_id => p_defined_balance_id
8205: );
9035: ,p_languages in dbms_sql.varchar2s
9036: ) is
9037: l_leg_code varchar2(30);
9038: l_bg_id number;
9039: l_bal_id pay_defined_balances.balance_type_id%type;
9040: l_baldim_id pay_defined_balances.balance_dimension_id%type;
9041: l_base_name ff_database_items.user_name%type;
9042: l_ueid number;
9043: l_tl_name ff_database_items_tl.translated_user_name%type;
9036: ) is
9037: l_leg_code varchar2(30);
9038: l_bg_id number;
9039: l_bal_id pay_defined_balances.balance_type_id%type;
9040: l_baldim_id pay_defined_balances.balance_dimension_id%type;
9041: l_base_name ff_database_items.user_name%type;
9042: l_ueid number;
9043: l_tl_name ff_database_items_tl.translated_user_name%type;
9044: l_found boolean;
10268: cursor csr_def_balance
10269: (p_defined_balance_id in number
10270: ) is
10271: select to_char(null)
10272: from pay_defined_balances db
10273: where db.defined_balance_id = p_defined_balance_id
10274: ;
10275: --
10276: procedure init_cnt(p_cnt in out nocopy binary_integer) is