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_ELEMENT_ENTRY_API dependencies on PAY_ELEMENT_ENTRIES_F

Line 123: l_creator_type pay_element_entries_f.creator_type%TYPE;

119: ) IS
120: --
121: -- Declare cursors and local variables
122: --
123: l_creator_type pay_element_entries_f.creator_type%TYPE;
124: l_creator_id pay_element_entries_f.creator_id%TYPE;
125: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
126: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
127: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;

Line 124: l_creator_id pay_element_entries_f.creator_id%TYPE;

120: --
121: -- Declare cursors and local variables
122: --
123: l_creator_type pay_element_entries_f.creator_type%TYPE;
124: l_creator_id pay_element_entries_f.creator_id%TYPE;
125: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
126: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
127: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
128: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;

Line 125: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

121: -- Declare cursors and local variables
122: --
123: l_creator_type pay_element_entries_f.creator_type%TYPE;
124: l_creator_id pay_element_entries_f.creator_id%TYPE;
125: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
126: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
127: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
128: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
129: l_process_in_run_flag pay_element_types_f.process_in_run_flag%TYPE;

Line 126: l_object_version_number pay_element_entries_f.object_version_number%TYPE;

122: --
123: l_creator_type pay_element_entries_f.creator_type%TYPE;
124: l_creator_id pay_element_entries_f.creator_id%TYPE;
125: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
126: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
127: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
128: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
129: l_process_in_run_flag pay_element_types_f.process_in_run_flag%TYPE;
130: l_closed_for_entry_flag pay_element_types_f.closed_for_entry_flag%TYPE;

Line 127: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;

123: l_creator_type pay_element_entries_f.creator_type%TYPE;
124: l_creator_id pay_element_entries_f.creator_id%TYPE;
125: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
126: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
127: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
128: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
129: l_process_in_run_flag pay_element_types_f.process_in_run_flag%TYPE;
130: l_closed_for_entry_flag pay_element_types_f.closed_for_entry_flag%TYPE;
131: l_adjustment_only_flag pay_element_types_f.adjustment_only_flag%TYPE; -- Bug 5872519

Line 128: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;

124: l_creator_id pay_element_entries_f.creator_id%TYPE;
125: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
126: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
127: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
128: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
129: l_process_in_run_flag pay_element_types_f.process_in_run_flag%TYPE;
130: l_closed_for_entry_flag pay_element_types_f.closed_for_entry_flag%TYPE;
131: l_adjustment_only_flag pay_element_types_f.adjustment_only_flag%TYPE; -- Bug 5872519
132: l_period_status per_time_periods.status%TYPE;

Line 163: l_date_earned pay_element_entries_f.date_earned%TYPE;

159: l_element_name pay_element_types_f.element_name%TYPE;
160: l_legislation_code pay_element_types_f.legislation_code%TYPE;
161: -- bug 659393, added variables for storing all dates pased in and truncate them
162: l_effective_date date;
163: l_date_earned pay_element_entries_f.date_earned%TYPE;
164: --
165: -- Bugfix 2646060
166: -- l_costable_type needed to hold the costable_type of the element link
167: --

Line 178: FROM pay_element_entries_f ee

174: l_indirect_only_flag pay_element_types_f.indirect_only_flag%TYPE;
175: --
176: CURSOR c_output_variables IS
177: SELECT ee.object_version_number
178: FROM pay_element_entries_f ee
179: WHERE l_element_entry_id = ee.element_entry_id
180: -- bug 675794, added date condition to select correct row
181: and l_effective_date between ee.effective_start_date
182: and ee.effective_end_date;

Line 195: INDEX(ee pay_element_entries_f_n51) */

191: AND l_effective_date BETWEEN pas.effective_start_date
192: AND pas.effective_end_date;
193: CURSOR c_entry_exists IS
194: SELECT /*+ LEADING(ee)
195: INDEX(ee pay_element_entries_f_n51) */
196: 'X'
197: FROM pay_element_entries_f ee,
198: pay_element_types_f et,
199: pay_element_links_f el

Line 197: FROM pay_element_entries_f ee,

193: CURSOR c_entry_exists IS
194: SELECT /*+ LEADING(ee)
195: INDEX(ee pay_element_entries_f_n51) */
196: 'X'
197: FROM pay_element_entries_f ee,
198: pay_element_types_f et,
199: pay_element_links_f el
200: WHERE el.element_link_id = ee.element_link_id
201: AND el.element_link_id = p_element_link_id

Line 921: l_object_version_number pay_element_entries_f.object_version_number%TYPE;

917: --
918: -- Declare cursors and local variables
919: --
920: l_proc varchar2(72) := g_package||'delete_element_entry';
921: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
922: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
923: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
924: -- bug 659393, added variables for storing dates passed in and truncate them
925: l_effective_date date;

Line 922: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;

918: -- Declare cursors and local variables
919: --
920: l_proc varchar2(72) := g_package||'delete_element_entry';
921: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
922: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
923: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
924: -- bug 659393, added variables for storing dates passed in and truncate them
925: l_effective_date date;
926: -- divicker Added for new lck signature

Line 923: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;

919: --
920: l_proc varchar2(72) := g_package||'delete_element_entry';
921: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
922: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
923: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
924: -- bug 659393, added variables for storing dates passed in and truncate them
925: l_effective_date date;
926: -- divicker Added for new lck signature
927: l_validation_start_date date;

Line 934: FROM pay_element_entries_f

930: CURSOR C_Output_Variables IS
931: SELECT effective_start_date,
932: effective_end_date,
933: object_version_number
934: FROM pay_element_entries_f
935: WHERE p_element_entry_id = element_entry_id
936: -- bug 675794, added date condition to select correct row
937: and l_effective_date between effective_start_date
938: and effective_end_date;

Line 1123: from pay_element_entries_f

1119:
1120: cursor csr_creator_type (c_element_entry_id in number,
1121: c_effective_date in date) is
1122: select creator_type, count(element_entry_id) total_records
1123: from pay_element_entries_f
1124: where element_entry_id = c_element_entry_id
1125: and c_effective_date between effective_start_date and effective_end_date
1126: group by creator_type;
1127:

Line 1134: from pay_element_entries_f

1130: c_creator_type in varchar2,
1131: c_creator_id in number,
1132: c_personal_payment_method_id in number) is
1133: select count(creator_type)
1134: from pay_element_entries_f
1135: where element_entry_id = c_element_entry_id
1136: and c_effective_date between effective_start_date and effective_end_date
1137: and ( (c_creator_type <> hr_api.g_varchar2
1138: and creator_type <> c_creator_type)

Line 1159: l_creator_type pay_element_entries_f.creator_type%type;

1155: and c_effective_date between effective_start_date and effective_end_date;
1156:
1157: l_total_elt_entry_records number;
1158: l_proc varchar2(300);
1159: l_creator_type pay_element_entries_f.creator_type%type;
1160:
1161: -- Creating types for storing input value id and entry values
1162: type input_value_id_tbl is table of number index by binary_integer;
1163: type entry_value_tbl is table of varchar2(80) index by binary_integer;

Line 1403: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

1399: --
1400: -- Declare cursors and local variables
1401: --
1402: l_proc varchar2(72) := g_package||'update_element_entry';
1403: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
1404: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
1405: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
1406: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
1407: --

Line 1404: l_object_version_number pay_element_entries_f.object_version_number%TYPE;

1400: -- Declare cursors and local variables
1401: --
1402: l_proc varchar2(72) := g_package||'update_element_entry';
1403: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
1404: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
1405: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
1406: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
1407: --
1408: -- Enhancement 2793978

Line 1405: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;

1401: --
1402: l_proc varchar2(72) := g_package||'update_element_entry';
1403: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
1404: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
1405: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
1406: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
1407: --
1408: -- Enhancement 2793978
1409: -- size of entry_value variables increased to deal with

Line 1406: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;

1402: l_proc varchar2(72) := g_package||'update_element_entry';
1403: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
1404: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
1405: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
1406: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
1407: --
1408: -- Enhancement 2793978
1409: -- size of entry_value variables increased to deal with
1410: -- screen format of entry values that use value sets

Line 1428: l_creator_type pay_element_entries_f.creator_type%TYPE;

1424: l_entry_value13 varchar2(240);
1425: l_entry_value14 varchar2(240);
1426: l_entry_value15 varchar2(240);
1427: --
1428: l_creator_type pay_element_entries_f.creator_type%TYPE;
1429: l_creator_id pay_element_entries_f.creator_id%TYPE;
1430: -- bug 659393, added variables for storing dates passed in and truncate them
1431: l_effective_date date;
1432: l_date_earned pay_element_entries_f.date_earned%TYPE;

Line 1429: l_creator_id pay_element_entries_f.creator_id%TYPE;

1425: l_entry_value14 varchar2(240);
1426: l_entry_value15 varchar2(240);
1427: --
1428: l_creator_type pay_element_entries_f.creator_type%TYPE;
1429: l_creator_id pay_element_entries_f.creator_id%TYPE;
1430: -- bug 659393, added variables for storing dates passed in and truncate them
1431: l_effective_date date;
1432: l_date_earned pay_element_entries_f.date_earned%TYPE;
1433: -- divicker Added for new lck signature

Line 1432: l_date_earned pay_element_entries_f.date_earned%TYPE;

1428: l_creator_type pay_element_entries_f.creator_type%TYPE;
1429: l_creator_id pay_element_entries_f.creator_id%TYPE;
1430: -- bug 659393, added variables for storing dates passed in and truncate them
1431: l_effective_date date;
1432: l_date_earned pay_element_entries_f.date_earned%TYPE;
1433: -- divicker Added for new lck signature
1434: l_validation_start_date date;
1435: l_validation_end_date date;
1436: --

Line 1446: FROM pay_element_entries_f ee

1442: CURSOR c_output_variables IS
1443: SELECT ee.effective_start_date,
1444: ee.effective_end_date,
1445: ee.object_version_number
1446: FROM pay_element_entries_f ee
1447: WHERE p_element_entry_id = ee.element_entry_id
1448: -- bug 675794, added date condition to select correct row
1449: and l_effective_date between ee.effective_start_date
1450: and ee.effective_end_date;

Line 1453: FROM pay_element_entries_f ee

1449: and l_effective_date between ee.effective_start_date
1450: and ee.effective_end_date;
1451: CURSOR c_entry_details IS
1452: SELECT ee.creator_type
1453: FROM pay_element_entries_f ee
1454: WHERE p_element_entry_id = ee.element_entry_id;
1455: --
1456: -- Bugfix 2646060
1457: -- c_link_details required to retrieve the costable_type of the

Line 1463: FROM pay_element_entries_f ee

1459: --
1460: CURSOR c_link_details ( p_element_entry_id NUMBER
1461: , p_effective_date DATE ) IS
1462: SELECT el.costable_type
1463: FROM pay_element_entries_f ee
1464: , pay_element_links_f el
1465: WHERE ee.element_entry_id = p_element_entry_id
1466: AND ee.element_link_id = el.element_link_id
1467: AND p_effective_date BETWEEN ee.effective_start_date