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_HR_OTC_RETRIEVAL_INTERFACE dependencies on PAY_BATCH_HEADERS

Line 319: p_batch_id IN pay_batch_headers.batch_id%TYPE,

315: hr_utility.set_location ('Leaving:' || l_proc, 100);
316: END record_batch_info;
317:
318: PROCEDURE record_batch_info (
319: p_batch_id IN pay_batch_headers.batch_id%TYPE,
320: p_business_group_id IN pay_batch_headers.business_group_id%TYPE,
321: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
322: p_batch_name IN pay_batch_headers.batch_name%TYPE
323: )

Line 320: p_business_group_id IN pay_batch_headers.business_group_id%TYPE,

316: END record_batch_info;
317:
318: PROCEDURE record_batch_info (
319: p_batch_id IN pay_batch_headers.batch_id%TYPE,
320: p_business_group_id IN pay_batch_headers.business_group_id%TYPE,
321: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
322: p_batch_name IN pay_batch_headers.batch_name%TYPE
323: )
324: IS

Line 321: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,

317:
318: PROCEDURE record_batch_info (
319: p_batch_id IN pay_batch_headers.batch_id%TYPE,
320: p_business_group_id IN pay_batch_headers.business_group_id%TYPE,
321: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
322: p_batch_name IN pay_batch_headers.batch_name%TYPE
323: )
324: IS
325: l_proc CONSTANT proc_name

Line 322: p_batch_name IN pay_batch_headers.batch_name%TYPE

318: PROCEDURE record_batch_info (
319: p_batch_id IN pay_batch_headers.batch_id%TYPE,
320: p_business_group_id IN pay_batch_headers.business_group_id%TYPE,
321: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
322: p_batch_name IN pay_batch_headers.batch_name%TYPE
323: )
324: IS
325: l_proc CONSTANT proc_name
326: := g_package || 'record_batch_info (Overloaded)';

Line 738: p_batch_ref IN pay_batch_headers.batch_reference%TYPE,

734: p_end_date IN VARCHAR2,
735: --hxc_time_building_blocks.stop_time%TYPE,
736: p_where_clause IN hxt_interface_utilities.max_varchar,
737: p_retrieval_transaction_code IN hxc_transactions.transaction_code%TYPE,
738: p_batch_ref IN pay_batch_headers.batch_reference%TYPE,
739: p_unique_params IN hxt_interface_utilities.max_varchar,
740: p_incremental IN hxt_interface_utilities.flag_varchar
741: DEFAULT 'Y',
742: p_transfer_to_bee IN hxt_interface_utilities.flag_varchar

Line 976: p_business_group_id IN pay_batch_headers.business_group_id%TYPE,

972: RAISE e_continue;
973: END extract_data_from_attr_tbl;
974:
975: PROCEDURE parse_cost_flex (
976: p_business_group_id IN pay_batch_headers.business_group_id%TYPE,
977: p_bee_rec IN OUT NOCOPY hxt_interface_utilities.bee_rec
978: )
979: AS
980: l_proc CONSTANT proc_name := g_package || 'parse_cost_flex';

Line 1007: p_bg_id IN pay_batch_headers.business_group_id%TYPE,

1003: hr_utility.set_location ('Leaving ' || l_proc, 100);
1004: END parse_cost_flex;
1005:
1006: PROCEDURE bee_batch_line (
1007: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
1008: p_tbb_rec IN hxc_generic_retrieval_pkg.r_building_blocks,
1009: p_det_tbb_idx IN PLS_INTEGER,
1010: p_attr_tbl IN hxc_generic_retrieval_pkg.t_time_attribute,
1011: p_attr_tbl_idx IN OUT NOCOPY PLS_INTEGER,

Line 1124: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,

1120: RAISE e_continue;
1121: END bee_batch_line;
1122:
1123: FUNCTION batch_name (
1124: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
1125: p_bg_id IN pay_batch_headers.business_group_id%TYPE
1126: )
1127: RETURN pay_batch_headers.batch_name%TYPE
1128: AS

Line 1125: p_bg_id IN pay_batch_headers.business_group_id%TYPE

1121: END bee_batch_line;
1122:
1123: FUNCTION batch_name (
1124: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
1125: p_bg_id IN pay_batch_headers.business_group_id%TYPE
1126: )
1127: RETURN pay_batch_headers.batch_name%TYPE
1128: AS
1129: l_proc CONSTANT proc_name := g_package || 'batch_name';

Line 1127: RETURN pay_batch_headers.batch_name%TYPE

1123: FUNCTION batch_name (
1124: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
1125: p_bg_id IN pay_batch_headers.business_group_id%TYPE
1126: )
1127: RETURN pay_batch_headers.batch_name%TYPE
1128: AS
1129: l_proc CONSTANT proc_name := g_package || 'batch_name';
1130: l_batch_suffix pay_batch_headers.batch_name%TYPE; -- NUMBER;
1131: l_batch_name pay_batch_headers.batch_name%TYPE;

Line 1130: l_batch_suffix pay_batch_headers.batch_name%TYPE; -- NUMBER;

1126: )
1127: RETURN pay_batch_headers.batch_name%TYPE
1128: AS
1129: l_proc CONSTANT proc_name := g_package || 'batch_name';
1130: l_batch_suffix pay_batch_headers.batch_name%TYPE; -- NUMBER;
1131: l_batch_name pay_batch_headers.batch_name%TYPE;
1132: BEGIN
1133: hr_utility.set_location ('Entering:' || l_proc, 10);
1134: l_batch_suffix :=

Line 1131: l_batch_name pay_batch_headers.batch_name%TYPE;

1127: RETURN pay_batch_headers.batch_name%TYPE
1128: AS
1129: l_proc CONSTANT proc_name := g_package || 'batch_name';
1130: l_batch_suffix pay_batch_headers.batch_name%TYPE; -- NUMBER;
1131: l_batch_name pay_batch_headers.batch_name%TYPE;
1132: BEGIN
1133: hr_utility.set_location ('Entering:' || l_proc, 10);
1134: l_batch_suffix :=
1135: TO_CHAR (hxt_interface_utilities.conc_request_id_suffix);

Line 1154: p_batch_name IN pay_batch_headers.batch_name%TYPE,

1150: RETURN l_batch_name;
1151: END batch_name;
1152:
1153: FUNCTION create_batch_header (
1154: p_batch_name IN pay_batch_headers.batch_name%TYPE,
1155: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
1156: p_batch_source IN pay_batch_headers.batch_source%TYPE
1157: DEFAULT g_time_store_batch_source,
1158: p_bg_id IN pay_batch_headers.business_group_id%TYPE,

Line 1155: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,

1151: END batch_name;
1152:
1153: FUNCTION create_batch_header (
1154: p_batch_name IN pay_batch_headers.batch_name%TYPE,
1155: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
1156: p_batch_source IN pay_batch_headers.batch_source%TYPE
1157: DEFAULT g_time_store_batch_source,
1158: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
1159: p_session_date IN DATE,

Line 1156: p_batch_source IN pay_batch_headers.batch_source%TYPE

1152:
1153: FUNCTION create_batch_header (
1154: p_batch_name IN pay_batch_headers.batch_name%TYPE,
1155: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
1156: p_batch_source IN pay_batch_headers.batch_source%TYPE
1157: DEFAULT g_time_store_batch_source,
1158: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
1159: p_session_date IN DATE,
1160: p_det_tbb_idx IN PLS_INTEGER

Line 1158: p_bg_id IN pay_batch_headers.business_group_id%TYPE,

1154: p_batch_name IN pay_batch_headers.batch_name%TYPE,
1155: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
1156: p_batch_source IN pay_batch_headers.batch_source%TYPE
1157: DEFAULT g_time_store_batch_source,
1158: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
1159: p_session_date IN DATE,
1160: p_det_tbb_idx IN PLS_INTEGER
1161: )
1162: RETURN pay_batch_headers.batch_id%TYPE

Line 1162: RETURN pay_batch_headers.batch_id%TYPE

1158: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
1159: p_session_date IN DATE,
1160: p_det_tbb_idx IN PLS_INTEGER
1161: )
1162: RETURN pay_batch_headers.batch_id%TYPE
1163: AS
1164: l_proc CONSTANT proc_name
1165: := g_package || 'create_batch_header';
1166: l_object_version_number pay_batch_headers.object_version_number%TYPE;

Line 1166: l_object_version_number pay_batch_headers.object_version_number%TYPE;

1162: RETURN pay_batch_headers.batch_id%TYPE
1163: AS
1164: l_proc CONSTANT proc_name
1165: := g_package || 'create_batch_header';
1166: l_object_version_number pay_batch_headers.object_version_number%TYPE;
1167: l_new_batch pay_batch_headers.batch_id%TYPE;
1168: BEGIN
1169: hr_utility.set_location ('Entering:' || l_proc, 10);
1170: pay_batch_element_entry_api.create_batch_header

Line 1167: l_new_batch pay_batch_headers.batch_id%TYPE;

1163: AS
1164: l_proc CONSTANT proc_name
1165: := g_package || 'create_batch_header';
1166: l_object_version_number pay_batch_headers.object_version_number%TYPE;
1167: l_new_batch pay_batch_headers.batch_id%TYPE;
1168: BEGIN
1169: hr_utility.set_location ('Entering:' || l_proc, 10);
1170: pay_batch_element_entry_api.create_batch_header
1171: (p_session_date => p_session_date,

Line 1203: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,

1199: RAISE e_halt;
1200: END create_batch_header;
1201:
1202: FUNCTION create_batch_header (
1203: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
1204: p_batch_source IN pay_batch_headers.batch_source%TYPE
1205: DEFAULT g_time_store_batch_source,
1206: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
1207: p_session_date IN DATE,

Line 1204: p_batch_source IN pay_batch_headers.batch_source%TYPE

1200: END create_batch_header;
1201:
1202: FUNCTION create_batch_header (
1203: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
1204: p_batch_source IN pay_batch_headers.batch_source%TYPE
1205: DEFAULT g_time_store_batch_source,
1206: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
1207: p_session_date IN DATE,
1208: p_det_tbb_idx IN PLS_INTEGER

Line 1206: p_bg_id IN pay_batch_headers.business_group_id%TYPE,

1202: FUNCTION create_batch_header (
1203: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
1204: p_batch_source IN pay_batch_headers.batch_source%TYPE
1205: DEFAULT g_time_store_batch_source,
1206: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
1207: p_session_date IN DATE,
1208: p_det_tbb_idx IN PLS_INTEGER
1209: )
1210: RETURN pay_batch_headers.batch_id%TYPE

Line 1210: RETURN pay_batch_headers.batch_id%TYPE

1206: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
1207: p_session_date IN DATE,
1208: p_det_tbb_idx IN PLS_INTEGER
1209: )
1210: RETURN pay_batch_headers.batch_id%TYPE
1211: AS
1212: l_proc CONSTANT proc_name
1213: := g_package || 'create_batch_header';
1214: l_object_version_number pay_batch_headers.object_version_number%TYPE;

Line 1214: l_object_version_number pay_batch_headers.object_version_number%TYPE;

1210: RETURN pay_batch_headers.batch_id%TYPE
1211: AS
1212: l_proc CONSTANT proc_name
1213: := g_package || 'create_batch_header';
1214: l_object_version_number pay_batch_headers.object_version_number%TYPE;
1215: l_batch_name pay_batch_headers.batch_name%TYPE;
1216: l_new_batch pay_batch_headers.batch_id%TYPE;
1217: BEGIN
1218: hr_utility.set_location ('Entering:' || l_proc, 10);

Line 1215: l_batch_name pay_batch_headers.batch_name%TYPE;

1211: AS
1212: l_proc CONSTANT proc_name
1213: := g_package || 'create_batch_header';
1214: l_object_version_number pay_batch_headers.object_version_number%TYPE;
1215: l_batch_name pay_batch_headers.batch_name%TYPE;
1216: l_new_batch pay_batch_headers.batch_id%TYPE;
1217: BEGIN
1218: hr_utility.set_location ('Entering:' || l_proc, 10);
1219: l_batch_name :=

Line 1216: l_new_batch pay_batch_headers.batch_id%TYPE;

1212: l_proc CONSTANT proc_name
1213: := g_package || 'create_batch_header';
1214: l_object_version_number pay_batch_headers.object_version_number%TYPE;
1215: l_batch_name pay_batch_headers.batch_name%TYPE;
1216: l_new_batch pay_batch_headers.batch_id%TYPE;
1217: BEGIN
1218: hr_utility.set_location ('Entering:' || l_proc, 10);
1219: l_batch_name :=
1220: batch_name (p_batch_reference => p_batch_reference,

Line 1242: p_batch_id IN pay_batch_headers.batch_id%TYPE,

1238: -- Bug 9494444
1239: -- Added new paramter to separately record the batch and line
1240: -- information for a retro batch.
1241: PROCEDURE create_batch_line (
1242: p_batch_id IN pay_batch_headers.batch_id%TYPE,
1243: p_det_tbb_idx IN PLS_INTEGER,
1244: p_session_date IN DATE,
1245: p_effective_date IN DATE,
1246: p_batch_sequence IN pay_batch_lines.batch_sequence%TYPE,

Line 1248: p_bg_id IN pay_batch_headers.business_group_id%TYPE,

1244: p_session_date IN DATE,
1245: p_effective_date IN DATE,
1246: p_batch_sequence IN pay_batch_lines.batch_sequence%TYPE,
1247: p_bee_rec IN hxt_interface_utilities.bee_rec,
1248: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
1249: p_is_retro IN BOOLEAN DEFAULT FALSE -- Bug 9494444
1250: )
1251: AS
1252: l_proc CONSTANT proc_name := g_package || 'create_batch_line';

Line 1549: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,

1545:
1546: -- Bug 9494444
1547: -- Added new parameter for marking retro lines.
1548: PROCEDURE add_to_batch (
1549: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
1550: p_batch_id IN OUT NOCOPY pay_batch_headers.batch_id%TYPE,
1551: p_det_tbb_idx IN PLS_INTEGER,
1552: p_batch_sequence IN OUT NOCOPY pay_batch_lines.batch_sequence%TYPE,
1553: p_batch_lines IN OUT NOCOPY PLS_INTEGER,

Line 1550: p_batch_id IN OUT NOCOPY pay_batch_headers.batch_id%TYPE,

1546: -- Bug 9494444
1547: -- Added new parameter for marking retro lines.
1548: PROCEDURE add_to_batch (
1549: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
1550: p_batch_id IN OUT NOCOPY pay_batch_headers.batch_id%TYPE,
1551: p_det_tbb_idx IN PLS_INTEGER,
1552: p_batch_sequence IN OUT NOCOPY pay_batch_lines.batch_sequence%TYPE,
1553: p_batch_lines IN OUT NOCOPY PLS_INTEGER,
1554: p_bg_id IN pay_batch_headers.business_group_id%TYPE,

Line 1554: p_bg_id IN pay_batch_headers.business_group_id%TYPE,

1550: p_batch_id IN OUT NOCOPY pay_batch_headers.batch_id%TYPE,
1551: p_det_tbb_idx IN PLS_INTEGER,
1552: p_batch_sequence IN OUT NOCOPY pay_batch_lines.batch_sequence%TYPE,
1553: p_batch_lines IN OUT NOCOPY PLS_INTEGER,
1554: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
1555: p_session_date IN DATE,
1556: p_effective_date IN DATE,
1557: p_bee_rec IN hxt_interface_utilities.bee_rec,
1558: p_is_retro IN BOOLEAN DEFAULT FALSE

Line 1624: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,

1620: hr_utility.set_location ('Leaving:' || l_proc, 100);
1621: END add_to_batch;
1622:
1623: PROCEDURE add_lines_to_bee_batch (
1624: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
1625: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
1626: p_session_date IN DATE,
1627: p_tbb_tbl IN hxc_generic_retrieval_pkg.t_building_blocks,
1628: p_attr_tbl IN hxc_generic_retrieval_pkg.t_time_attribute,

Line 1625: p_bg_id IN pay_batch_headers.business_group_id%TYPE,

1621: END add_to_batch;
1622:
1623: PROCEDURE add_lines_to_bee_batch (
1624: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
1625: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
1626: p_session_date IN DATE,
1627: p_tbb_tbl IN hxc_generic_retrieval_pkg.t_building_blocks,
1628: p_attr_tbl IN hxc_generic_retrieval_pkg.t_time_attribute,
1629: p_old_tbb_tbl IN hxc_generic_retrieval_pkg.t_building_blocks,

Line 1646: l_batch_id pay_batch_headers.batch_reference%TYPE;

1642: l_old_bee_rec hxt_interface_utilities.bee_rec;
1643: l_empty_bee_rec hxt_interface_utilities.bee_rec;
1644: l_cost_flex_id per_business_groups_perf.cost_allocation_structure%TYPE
1645: := hxt_interface_utilities.cost_flex_structure_id (p_bg_id);
1646: l_batch_id pay_batch_headers.batch_reference%TYPE;
1647: l_batch_sequence pay_batch_lines.batch_sequence%TYPE;
1648: l_retro_batch_id pay_batch_headers.batch_reference%TYPE;
1649: l_retro_batch_sequence pay_batch_lines.batch_sequence%TYPE;
1650: l_batch_lines PLS_INTEGER;

Line 1648: l_retro_batch_id pay_batch_headers.batch_reference%TYPE;

1644: l_cost_flex_id per_business_groups_perf.cost_allocation_structure%TYPE
1645: := hxt_interface_utilities.cost_flex_structure_id (p_bg_id);
1646: l_batch_id pay_batch_headers.batch_reference%TYPE;
1647: l_batch_sequence pay_batch_lines.batch_sequence%TYPE;
1648: l_retro_batch_id pay_batch_headers.batch_reference%TYPE;
1649: l_retro_batch_sequence pay_batch_lines.batch_sequence%TYPE;
1650: l_batch_lines PLS_INTEGER;
1651: l_retro_batch_lines PLS_INTEGER;
1652: i BINARY_INTEGER;

Line 2120: p_batch_ref IN pay_batch_headers.batch_reference%TYPE,

2116: p_end_date IN hxc_time_building_blocks.stop_time%TYPE,
2117: p_session_date IN DATE,
2118: p_where_clause IN hxt_interface_utilities.max_varchar,
2119: p_retrieval_transaction_code IN hxc_transactions.transaction_code%TYPE,
2120: p_batch_ref IN pay_batch_headers.batch_reference%TYPE,
2121: p_unique_params IN hxt_interface_utilities.max_varchar,
2122: p_status_in_bee IN VARCHAR2,
2123: p_incremental IN hxt_interface_utilities.flag_varchar
2124: DEFAULT 'Y',

Line 2133: l_supa_chunk_batch_id pay_batch_headers.batch_reference%TYPE

2129: )
2130: AS
2131: l_proc CONSTANT proc_name
2132: := g_package || 'process_non_otlr_employees';
2133: l_supa_chunk_batch_id pay_batch_headers.batch_reference%TYPE
2134: := NULL;
2135: l_supa_chunk_retro_batch_id pay_batch_headers.batch_reference%TYPE
2136: := NULL;
2137:

Line 2135: l_supa_chunk_retro_batch_id pay_batch_headers.batch_reference%TYPE

2131: l_proc CONSTANT proc_name
2132: := g_package || 'process_non_otlr_employees';
2133: l_supa_chunk_batch_id pay_batch_headers.batch_reference%TYPE
2134: := NULL;
2135: l_supa_chunk_retro_batch_id pay_batch_headers.batch_reference%TYPE
2136: := NULL;
2137:
2138: l_dup_count NUMBER; -- Bug 6121705
2139:

Line 2289: l_batch_ref pay_batch_headers.batch_reference%TYPE;

2285: )
2286: AS
2287: l_where_clause hxt_interface_utilities.max_varchar;
2288: l_unique_params hxt_interface_utilities.max_varchar;
2289: l_batch_ref pay_batch_headers.batch_reference%TYPE;
2290: l_no_otm hxt_interface_utilities.flag_varchar := 'N';
2291: l_retrieval_options fnd_profile_option_values.profile_option_value%TYPE
2292: := fnd_profile.VALUE ('HXC_RETRIEVAL_OPTIONS');
2293: BEGIN

Line 2383: l_adj_batch_id pay_batch_headers.batch_reference%TYPE := NULL;

2379:
2380: tnull_old_detail_bld_blks hxc_generic_retrieval_pkg.t_building_blocks;
2381: tnull_old_detail_attributes hxc_generic_retrieval_pkg.t_time_attribute;
2382:
2383: l_adj_batch_id pay_batch_headers.batch_reference%TYPE := NULL;
2384: l_retro_adj_batch_id pay_batch_headers.batch_reference%TYPE := NULL;
2385:
2386:
2387: -- Private procedure create_bld_blk_table

Line 2384: l_retro_adj_batch_id pay_batch_headers.batch_reference%TYPE := NULL;

2380: tnull_old_detail_bld_blks hxc_generic_retrieval_pkg.t_building_blocks;
2381: tnull_old_detail_attributes hxc_generic_retrieval_pkg.t_time_attribute;
2382:
2383: l_adj_batch_id pay_batch_headers.batch_reference%TYPE := NULL;
2384: l_retro_adj_batch_id pay_batch_headers.batch_reference%TYPE := NULL;
2385:
2386:
2387: -- Private procedure create_bld_blk_table
2388: -- populates the detail bld blks plsql table like gen. retrieval