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 181: FROM pay_element_entries_f ee

177: l_business_group_id per_assignments_f.business_group_id%TYPE;
178: --
179: CURSOR c_output_variables IS
180: SELECT ee.object_version_number
181: FROM pay_element_entries_f ee
182: WHERE l_element_entry_id = ee.element_entry_id
183: -- bug 675794, added date condition to select correct row
184: and l_effective_date between ee.effective_start_date
185: and ee.effective_end_date;

Line 203: INDEX(ee pay_element_entries_f_n51) */

199: WHERE pas.assignment_id = p_assignment_id;
200:
201: CURSOR c_entry_exists IS
202: SELECT /*+ LEADING(ee)
203: INDEX(ee pay_element_entries_f_n51) */
204: 'X'
205: FROM pay_element_entries_f ee,
206: pay_element_types_f et,
207: pay_element_links_f el

Line 205: FROM pay_element_entries_f ee,

201: CURSOR c_entry_exists IS
202: SELECT /*+ LEADING(ee)
203: INDEX(ee pay_element_entries_f_n51) */
204: 'X'
205: FROM pay_element_entries_f ee,
206: pay_element_types_f et,
207: pay_element_links_f el
208: WHERE el.element_link_id = ee.element_link_id
209: AND el.element_link_id = p_element_link_id

Line 945: l_object_version_number pay_element_entries_f.object_version_number%TYPE;

941: --
942: -- Declare cursors and local variables
943: --
944: l_proc varchar2(72) := g_package||'delete_element_entry';
945: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
946: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
947: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
948: -- bug 659393, added variables for storing dates passed in and truncate them
949: l_effective_date date;

Line 946: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;

942: -- Declare cursors and local variables
943: --
944: l_proc varchar2(72) := g_package||'delete_element_entry';
945: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
946: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
947: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
948: -- bug 659393, added variables for storing dates passed in and truncate them
949: l_effective_date date;
950: -- divicker Added for new lck signature

Line 947: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;

943: --
944: l_proc varchar2(72) := g_package||'delete_element_entry';
945: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
946: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
947: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
948: -- bug 659393, added variables for storing dates passed in and truncate them
949: l_effective_date date;
950: -- divicker Added for new lck signature
951: l_validation_start_date date;

Line 958: FROM pay_element_entries_f

954: CURSOR C_Output_Variables IS
955: SELECT effective_start_date,
956: effective_end_date,
957: object_version_number
958: FROM pay_element_entries_f
959: WHERE p_element_entry_id = element_entry_id
960: -- bug 675794, added date condition to select correct row
961: and l_effective_date between effective_start_date
962: and effective_end_date;

Line 1147: from pay_element_entries_f

1143:
1144: cursor csr_creator_type (c_element_entry_id in number,
1145: c_effective_date in date) is
1146: select creator_type, count(element_entry_id) total_records
1147: from pay_element_entries_f
1148: where element_entry_id = c_element_entry_id
1149: and c_effective_date between effective_start_date and effective_end_date
1150: group by creator_type;
1151:

Line 1158: from pay_element_entries_f

1154: c_creator_type in varchar2,
1155: c_creator_id in number,
1156: c_personal_payment_method_id in number) is
1157: select count(creator_type)
1158: from pay_element_entries_f
1159: where element_entry_id = c_element_entry_id
1160: and c_effective_date between effective_start_date and effective_end_date
1161: and ( (c_creator_type <> hr_api.g_varchar2
1162: and creator_type <> c_creator_type)

Line 1183: l_creator_type pay_element_entries_f.creator_type%type;

1179: and c_effective_date between effective_start_date and effective_end_date;
1180:
1181: l_total_elt_entry_records number;
1182: l_proc varchar2(300);
1183: l_creator_type pay_element_entries_f.creator_type%type;
1184:
1185: -- Creating types for storing input value id and entry values
1186: type input_value_id_tbl is table of number index by binary_integer;
1187: type entry_value_tbl is table of varchar2(80) index by binary_integer;

Line 1427: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

1423: --
1424: -- Declare cursors and local variables
1425: --
1426: l_proc varchar2(72) := g_package||'update_element_entry';
1427: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
1428: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
1429: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
1430: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
1431: --

Line 1428: l_object_version_number pay_element_entries_f.object_version_number%TYPE;

1424: -- Declare cursors and local variables
1425: --
1426: l_proc varchar2(72) := g_package||'update_element_entry';
1427: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
1428: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
1429: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
1430: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
1431: --
1432: -- Enhancement 2793978

Line 1429: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;

1425: --
1426: l_proc varchar2(72) := g_package||'update_element_entry';
1427: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
1428: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
1429: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
1430: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
1431: --
1432: -- Enhancement 2793978
1433: -- size of entry_value variables increased to deal with

Line 1430: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;

1426: l_proc varchar2(72) := g_package||'update_element_entry';
1427: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
1428: l_object_version_number pay_element_entries_f.object_version_number%TYPE;
1429: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
1430: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
1431: --
1432: -- Enhancement 2793978
1433: -- size of entry_value variables increased to deal with
1434: -- screen format of entry values that use value sets

Line 1452: l_creator_type pay_element_entries_f.creator_type%TYPE;

1448: l_entry_value13 varchar2(240);
1449: l_entry_value14 varchar2(240);
1450: l_entry_value15 varchar2(240);
1451: --
1452: l_creator_type pay_element_entries_f.creator_type%TYPE;
1453: l_creator_id pay_element_entries_f.creator_id%TYPE;
1454: -- bug 659393, added variables for storing dates passed in and truncate them
1455: l_effective_date date;
1456: l_date_earned pay_element_entries_f.date_earned%TYPE;

Line 1453: l_creator_id pay_element_entries_f.creator_id%TYPE;

1449: l_entry_value14 varchar2(240);
1450: l_entry_value15 varchar2(240);
1451: --
1452: l_creator_type pay_element_entries_f.creator_type%TYPE;
1453: l_creator_id pay_element_entries_f.creator_id%TYPE;
1454: -- bug 659393, added variables for storing dates passed in and truncate them
1455: l_effective_date date;
1456: l_date_earned pay_element_entries_f.date_earned%TYPE;
1457: -- divicker Added for new lck signature

Line 1456: l_date_earned pay_element_entries_f.date_earned%TYPE;

1452: l_creator_type pay_element_entries_f.creator_type%TYPE;
1453: l_creator_id pay_element_entries_f.creator_id%TYPE;
1454: -- bug 659393, added variables for storing dates passed in and truncate them
1455: l_effective_date date;
1456: l_date_earned pay_element_entries_f.date_earned%TYPE;
1457: -- divicker Added for new lck signature
1458: l_validation_start_date date;
1459: l_validation_end_date date;
1460: --

Line 1473: FROM pay_element_entries_f ee

1469: CURSOR c_output_variables IS
1470: SELECT ee.effective_start_date,
1471: ee.effective_end_date,
1472: ee.object_version_number
1473: FROM pay_element_entries_f ee
1474: WHERE p_element_entry_id = ee.element_entry_id
1475: -- bug 675794, added date condition to select correct row
1476: and l_effective_date between ee.effective_start_date
1477: and ee.effective_end_date;

Line 1480: FROM pay_element_entries_f ee

1476: and l_effective_date between ee.effective_start_date
1477: and ee.effective_end_date;
1478: CURSOR c_entry_details IS
1479: SELECT ee.creator_type
1480: FROM pay_element_entries_f ee
1481: WHERE p_element_entry_id = ee.element_entry_id;
1482: --
1483: -- Bugfix 2646060
1484: -- c_link_details required to retrieve the costable_type of the

Line 1490: FROM pay_element_entries_f ee

1486: --
1487: CURSOR c_link_details ( p_element_entry_id NUMBER
1488: , p_effective_date DATE ) IS
1489: SELECT el.costable_type
1490: FROM pay_element_entries_f ee
1491: , pay_element_links_f el
1492: WHERE ee.element_entry_id = p_element_entry_id
1493: AND ee.element_link_id = el.element_link_id
1494: AND p_effective_date BETWEEN ee.effective_start_date