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_CONTEXTS

Line 4: type con_name_array is table of ff_contexts.context_name%type

1: package body pay_balance_pkg as
2: -- $Header: pybaluex.pkb 120.38.12010000.2 2008/10/01 06:12:29 ankagarw ship $
3: -- Declare tables:
4: type con_name_array is table of ff_contexts.context_name%type
5: index by binary_integer;
6: type con_num_array is table of ff_contexts.context_id%type
7: index by binary_integer;
8: type con_type_array is table of ff_contexts.data_type%type

Line 6: type con_num_array is table of ff_contexts.context_id%type

2: -- $Header: pybaluex.pkb 120.38.12010000.2 2008/10/01 06:12:29 ankagarw ship $
3: -- Declare tables:
4: type con_name_array is table of ff_contexts.context_name%type
5: index by binary_integer;
6: type con_num_array is table of ff_contexts.context_id%type
7: index by binary_integer;
8: type con_type_array is table of ff_contexts.data_type%type
9: index by binary_integer;
10: type con_val_array is table of pay_run_result_values.result_value%type

Line 8: type con_type_array is table of ff_contexts.data_type%type

4: type con_name_array is table of ff_contexts.context_name%type
5: index by binary_integer;
6: type con_num_array is table of ff_contexts.context_id%type
7: index by binary_integer;
8: type con_type_array is table of ff_contexts.data_type%type
9: index by binary_integer;
10: type con_val_array is table of pay_run_result_values.result_value%type
11: index by binary_integer;
12: type par_val_array is table of varchar2(80)

Line 52: (core_context_name ff_contexts.context_name%type,

48: -- The follow types and variables are used to map core contexts
49: -- onto legislative contexts.
50: --
51: type t_context_map_rec is record
52: (core_context_name ff_contexts.context_name%type,
53: loc_context_name pay_legislation_contexts.legislation_name%type
54: );
55: --
56: type t_context_map_tab is table of t_context_map_rec index by binary_integer;

Line 688: from ff_contexts fc,

684: is
685: --
686: cursor get_bal_contexts (p_def_bal_id in number) is
687: select context_name
688: from ff_contexts fc,
689: ff_route_context_usages frcu,
690: pay_balance_dimensions pbd,
691: pay_defined_balances pdb
692: where pdb.defined_balance_id = p_def_bal_id

Line 1041: l_context_id ff_contexts.context_id%type;

1037: (
1038: p_context_name in varchar2,
1039: p_context_value in varchar2
1040: ) is
1041: l_context_id ff_contexts.context_id%type;
1042: l_context_name ff_contexts.context_name%type;
1043: l_context_type ff_contexts.data_type%type;
1044: l_count binary_integer;
1045: l_context_found boolean;

Line 1042: l_context_name ff_contexts.context_name%type;

1038: p_context_name in varchar2,
1039: p_context_value in varchar2
1040: ) is
1041: l_context_id ff_contexts.context_id%type;
1042: l_context_name ff_contexts.context_name%type;
1043: l_context_type ff_contexts.data_type%type;
1044: l_count binary_integer;
1045: l_context_found boolean;
1046: begin

Line 1043: l_context_type ff_contexts.data_type%type;

1039: p_context_value in varchar2
1040: ) is
1041: l_context_id ff_contexts.context_id%type;
1042: l_context_name ff_contexts.context_name%type;
1043: l_context_type ff_contexts.data_type%type;
1044: l_count binary_integer;
1045: l_context_found boolean;
1046: begin
1047: g_debug := hr_utility.debug_enabled;

Line 1083: from ff_contexts

1079: select context_id,
1080: data_type
1081: into l_context_id,
1082: l_context_type
1083: from ff_contexts
1084: where context_name = l_context_name;
1085: --
1086: con_name_tab (no_rows_con_tab) := ltrim(rtrim(l_context_name));
1087: con_id_tab (no_rows_con_tab) := ltrim(rtrim(l_context_id));

Line 1160: l_context_name ff_contexts.context_name%type;

1156: ) is
1157: --
1158: cnt number;
1159: found boolean;
1160: l_context_name ff_contexts.context_name%type;
1161: --
1162: begin
1163: --
1164: -- Reset buffers if needed

Line 1192: from ff_contexts fc,

1188: --
1189: begin
1190: select fc.context_name
1191: into l_context_name
1192: from ff_contexts fc,
1193: pay_legislation_contexts plc
1194: where plc.legislation_name = p_context_name
1195: and plc.context_id = fc.context_id
1196: and plc.legislation_code = p_legislation_code;

Line 1278: l_context_name ff_contexts.context_name%type;

1274: l_user_entity_id ff_user_entities.user_entity_id%type;
1275: l_creator_type ff_user_entities.creator_type%type;
1276: l_notfound_allowed_flag ff_user_entities.notfound_allowed_flag%type;
1277: l_route_id ff_routes.route_id%type;
1278: l_context_name ff_contexts.context_name%type;
1279: l_text varchar2(20000); -- large array for route text
1280: l_replace_text varchar2(80);
1281: l_error_text varchar2(200); -- used for sql error messages
1282: l_o_hint varchar2(2000); -- Route optimiser hint

Line 1367: from ff_contexts

1363: hr_utility.set_location ('pay_balance_pkg.run_db_item', 10);
1364: end if;
1365: select context_name
1366: into l_context_name
1367: from ff_contexts
1368: where context_id = c1rec.context_id;
1369: --
1370: hr_utility.set_message(801, 'HR_7271_PAY_CONTEXT_MISSING');
1371: hr_utility.set_message_token ('CONTEXT_NAME', l_context_name);

Line 1523: from ff_contexts

1519: hr_utility.set_location ('pay_balance_pkg.run_db_item', 101);
1520: end if;
1521: select context_name
1522: into l_context_name
1523: from ff_contexts
1524: where context_id = route_contexts_cache.cxt_id(l_cxt_num);
1525: --
1526: hr_utility.set_message(801, 'HR_7271_PAY_CONTEXT_MISSING');
1527: hr_utility.set_message_token ('CONTEXT_NAME', l_context_name);

Line 1886: l_context_name ff_contexts.context_name%type;

1882: sql_cursor integer;
1883: l_rows integer;
1884: l_count number;
1885: l_context_found boolean;
1886: l_context_name ff_contexts.context_name%type;
1887: l_balance_type_id number;
1888: ignore number;
1889: l_retrieve boolean;
1890: l_value_retrieved boolean;

Line 1968: from ff_contexts

1964: hr_utility.set_location ('pay_balance_pkg.process_balance_statement', 60);
1965: end if;
1966: select context_name
1967: into l_context_name
1968: from ff_contexts
1969: where context_id = c1rec.context_id;
1970: --
1971: hr_utility.set_message(801, 'HR_7271_PAY_CONTEXT_MISSING');
1972: hr_utility.set_message_token ('CONTEXT_NAME', l_context_name);

Line 2141: l_context_name ff_contexts.context_name%type;

2137: where route_id = p_route_id
2138: order by sequence_no;
2139: --
2140: --
2141: l_context_name ff_contexts.context_name%type;
2142: --
2143: -- Do not change the length of these without changing MAX_DYN_SQL size.
2144: --
2145: l_from_clause varchar2(20000); -- large array for route text

Line 2207: from ff_contexts

2203: hr_utility.set_location ('pay_balance_pkg.run_rr_route', 10);
2204: end if;
2205: select context_name
2206: into l_context_name
2207: from ff_contexts
2208: where context_id = c1rec.context_id;
2209: --
2210: hr_utility.set_message(801, 'HR_7271_PAY_CONTEXT_MISSING');
2211: hr_utility.set_message_token ('CONTEXT_NAME', l_context_name);

Line 2382: l_context_name ff_contexts.context_name%type;

2378: l_user_entity_id ff_user_entities.user_entity_id%type;
2379: l_creator_type ff_user_entities.creator_type%type;
2380: l_notfound_allowed_flag ff_user_entities.notfound_allowed_flag%type;
2381: l_route_id ff_routes.route_id%type;
2382: l_context_name ff_contexts.context_name%type;
2383: l_text varchar2(20000); -- large array for route text
2384: l_replace_text varchar2(80);
2385: l_error_text varchar2(200); -- used for sql error messages
2386: l_o_hint varchar2(2000); -- optimiser hint

Line 2461: from ff_contexts

2457: hr_utility.set_location ('pay_balance_pkg.get_run_balance', 10);
2458: end if;
2459: select context_name
2460: into l_context_name
2461: from ff_contexts
2462: where context_id = c1rec.context_id;
2463: --
2464: hr_utility.set_message(801, 'HR_7271_PAY_CONTEXT_MISSING');
2465: hr_utility.set_message_token ('CONTEXT_NAME', l_context_name);

Line 2596: from ff_contexts

2592: hr_utility.set_location ('pay_balance_pkg.get_run_balance', 60);
2593: end if;
2594: select context_name
2595: into l_context_name
2596: from ff_contexts
2597: where context_id = route_contexts_cache.cxt_id(l_cxt_num);
2598: --
2599: hr_utility.set_message(801, 'HR_7271_PAY_CONTEXT_MISSING');
2600: hr_utility.set_message_token ('CONTEXT_NAME', l_context_name);

Line 3569: , ff_contexts CON

3565: select CONVAL.context_id,
3566: CONVAL.value,
3567: CON.context_name
3568: from pay_balance_context_values CONVAL
3569: , ff_contexts CON
3570: where latest_balance_id = p_latest_balance_id
3571: and CON.context_id = CONVAL.context_id
3572: order by 1;
3573: --