eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_BALANCE_PKG dependencies on FF_USER_ENTITIES

Line 1361: l_user_entity_id ff_user_entities.user_entity_id%type;

1357: sql_cursor integer;
1358: l_rows integer;
1359: l_definition_text ff_database_items.definition_text%type;
1360: l_data_type ff_database_items.data_type%type;
1361: l_user_entity_id ff_user_entities.user_entity_id%type;
1362: l_creator_type ff_user_entities.creator_type%type;
1363: l_notfound_allowed_flag ff_user_entities.notfound_allowed_flag%type;
1364: l_route_id ff_routes.route_id%type;
1365: l_context_name ff_contexts.context_name%type;

Line 1362: l_creator_type ff_user_entities.creator_type%type;

1358: l_rows integer;
1359: l_definition_text ff_database_items.definition_text%type;
1360: l_data_type ff_database_items.data_type%type;
1361: l_user_entity_id ff_user_entities.user_entity_id%type;
1362: l_creator_type ff_user_entities.creator_type%type;
1363: l_notfound_allowed_flag ff_user_entities.notfound_allowed_flag%type;
1364: l_route_id ff_routes.route_id%type;
1365: l_context_name ff_contexts.context_name%type;
1366: l_text varchar2(20000); -- large array for route text

Line 1363: l_notfound_allowed_flag ff_user_entities.notfound_allowed_flag%type;

1359: l_definition_text ff_database_items.definition_text%type;
1360: l_data_type ff_database_items.data_type%type;
1361: l_user_entity_id ff_user_entities.user_entity_id%type;
1362: l_creator_type ff_user_entities.creator_type%type;
1363: l_notfound_allowed_flag ff_user_entities.notfound_allowed_flag%type;
1364: l_route_id ff_routes.route_id%type;
1365: l_context_name ff_contexts.context_name%type;
1366: l_text varchar2(20000); -- large array for route text
1367: l_replace_text varchar2(80);

Line 1406: , ff_user_entities ENT

1402: l_route_id,
1403: l_text,
1404: l_o_hint
1405: from ff_database_items DBI
1406: , ff_user_entities ENT
1407: , ff_routes RO
1408: where DBI.user_name = p_database_name
1409: and DBI.user_entity_id = ENT.user_entity_id
1410: and ( (ENT.legislation_code is null and ENT.business_group_id is null)

Line 2549: l_user_entity_id ff_user_entities.user_entity_id%type;

2545: l_rows integer;
2546: l_definition_text varchar2(240);
2547: --l_data_type ff_database_items.data_type%type;
2548: l_data_type varchar2(1) := 'N';
2549: l_user_entity_id ff_user_entities.user_entity_id%type;
2550: l_creator_type ff_user_entities.creator_type%type;
2551: l_notfound_allowed_flag ff_user_entities.notfound_allowed_flag%type;
2552: l_route_id ff_routes.route_id%type;
2553: l_context_name ff_contexts.context_name%type;

Line 2550: l_creator_type ff_user_entities.creator_type%type;

2546: l_definition_text varchar2(240);
2547: --l_data_type ff_database_items.data_type%type;
2548: l_data_type varchar2(1) := 'N';
2549: l_user_entity_id ff_user_entities.user_entity_id%type;
2550: l_creator_type ff_user_entities.creator_type%type;
2551: l_notfound_allowed_flag ff_user_entities.notfound_allowed_flag%type;
2552: l_route_id ff_routes.route_id%type;
2553: l_context_name ff_contexts.context_name%type;
2554: l_text varchar2(20000); -- large array for route text

Line 2551: l_notfound_allowed_flag ff_user_entities.notfound_allowed_flag%type;

2547: --l_data_type ff_database_items.data_type%type;
2548: l_data_type varchar2(1) := 'N';
2549: l_user_entity_id ff_user_entities.user_entity_id%type;
2550: l_creator_type ff_user_entities.creator_type%type;
2551: l_notfound_allowed_flag ff_user_entities.notfound_allowed_flag%type;
2552: l_route_id ff_routes.route_id%type;
2553: l_context_name ff_contexts.context_name%type;
2554: l_text varchar2(20000); -- large array for route text
2555: l_replace_text varchar2(80);

Line 2599: from ff_user_entities ENT

2595: l_notfound_allowed_flag,
2596: l_route_id,
2597: l_text,
2598: l_o_hint
2599: from ff_user_entities ENT
2600: , ff_routes RO
2601: where ent.user_entity_name = p_user_name
2602: and ( (ENT.legislation_code is null and ENT.business_group_id is null)
2603: or (ENT.business_group_id is null

Line 2996: , ff_user_entities ent

2992: select dbi.user_name
2993: , nvl(ent.business_group_id, -1)
2994: , nvl(ent.legislation_code, ' ')
2995: from ff_database_items dbi
2996: , ff_user_entities ent
2997: where ent.creator_id = p_def_bal
2998: and ent.creator_type = 'B'
2999: and ent.user_entity_id = dbi.user_entity_id;
3000: --

Line 3003: l_business_group_id ff_user_entities.business_group_id%type;

2999: and ent.user_entity_id = dbi.user_entity_id;
3000: --
3001: l_balance_val varchar2(240);
3002: l_user_name ff_database_items.user_name%type;
3003: l_business_group_id ff_user_entities.business_group_id%type;
3004: l_legislation_code ff_user_entities.legislation_code%type;
3005: --
3006: BEGIN
3007: open get_vals(p_def_bal_id);

Line 3004: l_legislation_code ff_user_entities.legislation_code%type;

3000: --
3001: l_balance_val varchar2(240);
3002: l_user_name ff_database_items.user_name%type;
3003: l_business_group_id ff_user_entities.business_group_id%type;
3004: l_legislation_code ff_user_entities.legislation_code%type;
3005: --
3006: BEGIN
3007: open get_vals(p_def_bal_id);
3008: fetch get_vals into l_user_name, l_business_group_id, l_legislation_code;

Line 3045: from ff_user_entities fue

3041: is
3042: select fue.user_entity_name
3043: , nvl(fue.business_group_id, -1)
3044: , nvl(fue.legislation_code, ' ')
3045: from ff_user_entities fue
3046: , ff_user_entities fue_b
3047: where fue.creator_id = p_def_bal
3048: and fue_b.creator_type = 'B'
3049: and fue.creator_id = fue_b.creator_id

Line 3046: , ff_user_entities fue_b

3042: select fue.user_entity_name
3043: , nvl(fue.business_group_id, -1)
3044: , nvl(fue.legislation_code, ' ')
3045: from ff_user_entities fue
3046: , ff_user_entities fue_b
3047: where fue.creator_id = p_def_bal
3048: and fue_b.creator_type = 'B'
3049: and fue.creator_id = fue_b.creator_id
3050: and fue.creator_type = 'RB'

Line 3055: l_user_name ff_user_entities.user_entity_name%type;

3051: and fue.user_entity_name = fue_b.user_entity_name||'_'||to_char(p_prty)
3052: ;
3053: --
3054: l_balance_val number;
3055: l_user_name ff_user_entities.user_entity_name%type;
3056: l_business_group_id ff_user_entities.business_group_id%type;
3057: l_legislation_code ff_user_entities.legislation_code%type;
3058: l_balance_list t_batch_list;
3059: l_balance_type_id pay_defined_balances.balance_type_id%type;

Line 3056: l_business_group_id ff_user_entities.business_group_id%type;

3052: ;
3053: --
3054: l_balance_val number;
3055: l_user_name ff_user_entities.user_entity_name%type;
3056: l_business_group_id ff_user_entities.business_group_id%type;
3057: l_legislation_code ff_user_entities.legislation_code%type;
3058: l_balance_list t_batch_list;
3059: l_balance_type_id pay_defined_balances.balance_type_id%type;
3060: l_route_id pay_dimension_routes.route_id%type;

Line 3057: l_legislation_code ff_user_entities.legislation_code%type;

3053: --
3054: l_balance_val number;
3055: l_user_name ff_user_entities.user_entity_name%type;
3056: l_business_group_id ff_user_entities.business_group_id%type;
3057: l_legislation_code ff_user_entities.legislation_code%type;
3058: l_balance_list t_batch_list;
3059: l_balance_type_id pay_defined_balances.balance_type_id%type;
3060: l_route_id pay_dimension_routes.route_id%type;
3061: l_balance_type_column pay_dimension_routes.balance_type_column%type;

Line 11993: l_user_entity_name ff_user_entities.user_entity_name%type;

11989: p_balance_load_date in date)
11990: return number is
11991: l_balance_type_id pay_balance_types.balance_type_id%type;
11992: l_balance_dimension_id pay_defined_balances.balance_dimension_id%type;
11993: l_user_entity_name ff_user_entities.user_entity_name%type;
11994: l_linked_ue_name ff_user_entities.user_entity_name%type;
11995: l_ue_leg_code ff_user_entities.legislation_code%type;
11996: l_ue_bg ff_user_entities.business_group_id%type;
11997: l_linked_def_bal pay_defined_balances.defined_balance_id%type;

Line 11994: l_linked_ue_name ff_user_entities.user_entity_name%type;

11990: return number is
11991: l_balance_type_id pay_balance_types.balance_type_id%type;
11992: l_balance_dimension_id pay_defined_balances.balance_dimension_id%type;
11993: l_user_entity_name ff_user_entities.user_entity_name%type;
11994: l_linked_ue_name ff_user_entities.user_entity_name%type;
11995: l_ue_leg_code ff_user_entities.legislation_code%type;
11996: l_ue_bg ff_user_entities.business_group_id%type;
11997: l_linked_def_bal pay_defined_balances.defined_balance_id%type;
11998:

Line 11995: l_ue_leg_code ff_user_entities.legislation_code%type;

11991: l_balance_type_id pay_balance_types.balance_type_id%type;
11992: l_balance_dimension_id pay_defined_balances.balance_dimension_id%type;
11993: l_user_entity_name ff_user_entities.user_entity_name%type;
11994: l_linked_ue_name ff_user_entities.user_entity_name%type;
11995: l_ue_leg_code ff_user_entities.legislation_code%type;
11996: l_ue_bg ff_user_entities.business_group_id%type;
11997: l_linked_def_bal pay_defined_balances.defined_balance_id%type;
11998:
11999: begin

Line 11996: l_ue_bg ff_user_entities.business_group_id%type;

11992: l_balance_dimension_id pay_defined_balances.balance_dimension_id%type;
11993: l_user_entity_name ff_user_entities.user_entity_name%type;
11994: l_linked_ue_name ff_user_entities.user_entity_name%type;
11995: l_ue_leg_code ff_user_entities.legislation_code%type;
11996: l_ue_bg ff_user_entities.business_group_id%type;
11997: l_linked_def_bal pay_defined_balances.defined_balance_id%type;
11998:
11999: begin
12000: