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 223: p_batch_id IN pay_batch_headers.batch_id%TYPE,

219: hr_utility.set_location ('Leaving:' || l_proc, 100);
220: END record_batch_info;
221:
222: PROCEDURE record_batch_info (
223: p_batch_id IN pay_batch_headers.batch_id%TYPE,
224: p_business_group_id IN pay_batch_headers.business_group_id%TYPE,
225: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
226: p_batch_name IN pay_batch_headers.batch_name%TYPE
227: )

Line 224: p_business_group_id IN pay_batch_headers.business_group_id%TYPE,

220: END record_batch_info;
221:
222: PROCEDURE record_batch_info (
223: p_batch_id IN pay_batch_headers.batch_id%TYPE,
224: p_business_group_id IN pay_batch_headers.business_group_id%TYPE,
225: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
226: p_batch_name IN pay_batch_headers.batch_name%TYPE
227: )
228: IS

Line 225: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,

221:
222: PROCEDURE record_batch_info (
223: p_batch_id IN pay_batch_headers.batch_id%TYPE,
224: p_business_group_id IN pay_batch_headers.business_group_id%TYPE,
225: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
226: p_batch_name IN pay_batch_headers.batch_name%TYPE
227: )
228: IS
229: l_proc CONSTANT proc_name

Line 226: p_batch_name IN pay_batch_headers.batch_name%TYPE

222: PROCEDURE record_batch_info (
223: p_batch_id IN pay_batch_headers.batch_id%TYPE,
224: p_business_group_id IN pay_batch_headers.business_group_id%TYPE,
225: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
226: p_batch_name IN pay_batch_headers.batch_name%TYPE
227: )
228: IS
229: l_proc CONSTANT proc_name
230: := g_package || 'record_batch_info (Overloaded)';

Line 522: p_batch_ref IN pay_batch_headers.batch_reference%TYPE,

518: p_end_date IN VARCHAR2,
519: --hxc_time_building_blocks.stop_time%TYPE,
520: p_where_clause IN hxt_interface_utilities.max_varchar,
521: p_retrieval_transaction_code IN hxc_transactions.transaction_code%TYPE,
522: p_batch_ref IN pay_batch_headers.batch_reference%TYPE,
523: p_unique_params IN hxt_interface_utilities.max_varchar,
524: p_incremental IN hxt_interface_utilities.flag_varchar
525: DEFAULT 'Y',
526: p_transfer_to_bee IN hxt_interface_utilities.flag_varchar

Line 665: p_business_group_id IN pay_batch_headers.business_group_id%TYPE,

661: RAISE e_continue;
662: END extract_data_from_attr_tbl;
663:
664: PROCEDURE parse_cost_flex (
665: p_business_group_id IN pay_batch_headers.business_group_id%TYPE,
666: p_bee_rec IN OUT NOCOPY hxt_interface_utilities.bee_rec
667: )
668: AS
669: l_proc CONSTANT proc_name := g_package || 'parse_cost_flex';

Line 696: p_bg_id IN pay_batch_headers.business_group_id%TYPE,

692: hr_utility.set_location ('Leaving ' || l_proc, 100);
693: END parse_cost_flex;
694:
695: PROCEDURE bee_batch_line (
696: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
697: p_tbb_rec IN hxc_generic_retrieval_pkg.r_building_blocks,
698: p_det_tbb_idx IN PLS_INTEGER,
699: p_attr_tbl IN hxc_generic_retrieval_pkg.t_time_attribute,
700: p_attr_tbl_idx IN OUT NOCOPY PLS_INTEGER,

Line 794: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,

790: RAISE e_continue;
791: END bee_batch_line;
792:
793: FUNCTION batch_name (
794: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
795: p_bg_id IN pay_batch_headers.business_group_id%TYPE
796: )
797: RETURN pay_batch_headers.batch_name%TYPE
798: AS

Line 795: p_bg_id IN pay_batch_headers.business_group_id%TYPE

791: END bee_batch_line;
792:
793: FUNCTION batch_name (
794: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
795: p_bg_id IN pay_batch_headers.business_group_id%TYPE
796: )
797: RETURN pay_batch_headers.batch_name%TYPE
798: AS
799: l_proc CONSTANT proc_name := g_package || 'batch_name';

Line 797: RETURN pay_batch_headers.batch_name%TYPE

793: FUNCTION batch_name (
794: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
795: p_bg_id IN pay_batch_headers.business_group_id%TYPE
796: )
797: RETURN pay_batch_headers.batch_name%TYPE
798: AS
799: l_proc CONSTANT proc_name := g_package || 'batch_name';
800: l_batch_suffix pay_batch_headers.batch_name%TYPE; -- NUMBER;
801: l_batch_name pay_batch_headers.batch_name%TYPE;

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

796: )
797: RETURN pay_batch_headers.batch_name%TYPE
798: AS
799: l_proc CONSTANT proc_name := g_package || 'batch_name';
800: l_batch_suffix pay_batch_headers.batch_name%TYPE; -- NUMBER;
801: l_batch_name pay_batch_headers.batch_name%TYPE;
802: BEGIN
803: hr_utility.set_location ('Entering:' || l_proc, 10);
804: l_batch_suffix :=

Line 801: l_batch_name pay_batch_headers.batch_name%TYPE;

797: RETURN pay_batch_headers.batch_name%TYPE
798: AS
799: l_proc CONSTANT proc_name := g_package || 'batch_name';
800: l_batch_suffix pay_batch_headers.batch_name%TYPE; -- NUMBER;
801: l_batch_name pay_batch_headers.batch_name%TYPE;
802: BEGIN
803: hr_utility.set_location ('Entering:' || l_proc, 10);
804: l_batch_suffix :=
805: TO_CHAR (hxt_interface_utilities.conc_request_id_suffix);

Line 824: p_batch_name IN pay_batch_headers.batch_name%TYPE,

820: RETURN l_batch_name;
821: END batch_name;
822:
823: FUNCTION create_batch_header (
824: p_batch_name IN pay_batch_headers.batch_name%TYPE,
825: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
826: p_batch_source IN pay_batch_headers.batch_source%TYPE
827: DEFAULT g_time_store_batch_source,
828: p_bg_id IN pay_batch_headers.business_group_id%TYPE,

Line 825: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,

821: END batch_name;
822:
823: FUNCTION create_batch_header (
824: p_batch_name IN pay_batch_headers.batch_name%TYPE,
825: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
826: p_batch_source IN pay_batch_headers.batch_source%TYPE
827: DEFAULT g_time_store_batch_source,
828: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
829: p_session_date IN DATE,

Line 826: p_batch_source IN pay_batch_headers.batch_source%TYPE

822:
823: FUNCTION create_batch_header (
824: p_batch_name IN pay_batch_headers.batch_name%TYPE,
825: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
826: p_batch_source IN pay_batch_headers.batch_source%TYPE
827: DEFAULT g_time_store_batch_source,
828: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
829: p_session_date IN DATE,
830: p_det_tbb_idx IN PLS_INTEGER

Line 828: p_bg_id IN pay_batch_headers.business_group_id%TYPE,

824: p_batch_name IN pay_batch_headers.batch_name%TYPE,
825: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
826: p_batch_source IN pay_batch_headers.batch_source%TYPE
827: DEFAULT g_time_store_batch_source,
828: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
829: p_session_date IN DATE,
830: p_det_tbb_idx IN PLS_INTEGER
831: )
832: RETURN pay_batch_headers.batch_id%TYPE

Line 832: RETURN pay_batch_headers.batch_id%TYPE

828: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
829: p_session_date IN DATE,
830: p_det_tbb_idx IN PLS_INTEGER
831: )
832: RETURN pay_batch_headers.batch_id%TYPE
833: AS
834: l_proc CONSTANT proc_name
835: := g_package || 'create_batch_header';
836: l_object_version_number pay_batch_headers.object_version_number%TYPE;

Line 836: l_object_version_number pay_batch_headers.object_version_number%TYPE;

832: RETURN pay_batch_headers.batch_id%TYPE
833: AS
834: l_proc CONSTANT proc_name
835: := g_package || 'create_batch_header';
836: l_object_version_number pay_batch_headers.object_version_number%TYPE;
837: l_new_batch pay_batch_headers.batch_id%TYPE;
838: BEGIN
839: hr_utility.set_location ('Entering:' || l_proc, 10);
840: pay_batch_element_entry_api.create_batch_header

Line 837: l_new_batch pay_batch_headers.batch_id%TYPE;

833: AS
834: l_proc CONSTANT proc_name
835: := g_package || 'create_batch_header';
836: l_object_version_number pay_batch_headers.object_version_number%TYPE;
837: l_new_batch pay_batch_headers.batch_id%TYPE;
838: BEGIN
839: hr_utility.set_location ('Entering:' || l_proc, 10);
840: pay_batch_element_entry_api.create_batch_header
841: (p_session_date => p_session_date,

Line 872: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,

868: RAISE e_halt;
869: END create_batch_header;
870:
871: FUNCTION create_batch_header (
872: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
873: p_batch_source IN pay_batch_headers.batch_source%TYPE
874: DEFAULT g_time_store_batch_source,
875: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
876: p_session_date IN DATE,

Line 873: p_batch_source IN pay_batch_headers.batch_source%TYPE

869: END create_batch_header;
870:
871: FUNCTION create_batch_header (
872: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
873: p_batch_source IN pay_batch_headers.batch_source%TYPE
874: DEFAULT g_time_store_batch_source,
875: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
876: p_session_date IN DATE,
877: p_det_tbb_idx IN PLS_INTEGER

Line 875: p_bg_id IN pay_batch_headers.business_group_id%TYPE,

871: FUNCTION create_batch_header (
872: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
873: p_batch_source IN pay_batch_headers.batch_source%TYPE
874: DEFAULT g_time_store_batch_source,
875: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
876: p_session_date IN DATE,
877: p_det_tbb_idx IN PLS_INTEGER
878: )
879: RETURN pay_batch_headers.batch_id%TYPE

Line 879: RETURN pay_batch_headers.batch_id%TYPE

875: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
876: p_session_date IN DATE,
877: p_det_tbb_idx IN PLS_INTEGER
878: )
879: RETURN pay_batch_headers.batch_id%TYPE
880: AS
881: l_proc CONSTANT proc_name
882: := g_package || 'create_batch_header';
883: l_object_version_number pay_batch_headers.object_version_number%TYPE;

Line 883: l_object_version_number pay_batch_headers.object_version_number%TYPE;

879: RETURN pay_batch_headers.batch_id%TYPE
880: AS
881: l_proc CONSTANT proc_name
882: := g_package || 'create_batch_header';
883: l_object_version_number pay_batch_headers.object_version_number%TYPE;
884: l_batch_name pay_batch_headers.batch_name%TYPE;
885: l_new_batch pay_batch_headers.batch_id%TYPE;
886: BEGIN
887: hr_utility.set_location ('Entering:' || l_proc, 10);

Line 884: l_batch_name pay_batch_headers.batch_name%TYPE;

880: AS
881: l_proc CONSTANT proc_name
882: := g_package || 'create_batch_header';
883: l_object_version_number pay_batch_headers.object_version_number%TYPE;
884: l_batch_name pay_batch_headers.batch_name%TYPE;
885: l_new_batch pay_batch_headers.batch_id%TYPE;
886: BEGIN
887: hr_utility.set_location ('Entering:' || l_proc, 10);
888: l_batch_name :=

Line 885: l_new_batch pay_batch_headers.batch_id%TYPE;

881: l_proc CONSTANT proc_name
882: := g_package || 'create_batch_header';
883: l_object_version_number pay_batch_headers.object_version_number%TYPE;
884: l_batch_name pay_batch_headers.batch_name%TYPE;
885: l_new_batch pay_batch_headers.batch_id%TYPE;
886: BEGIN
887: hr_utility.set_location ('Entering:' || l_proc, 10);
888: l_batch_name :=
889: batch_name (p_batch_reference => p_batch_reference,

Line 908: p_batch_id IN pay_batch_headers.batch_id%TYPE,

904: RETURN l_new_batch;
905: END create_batch_header;
906:
907: PROCEDURE create_batch_line (
908: p_batch_id IN pay_batch_headers.batch_id%TYPE,
909: p_det_tbb_idx IN PLS_INTEGER,
910: p_session_date IN DATE,
911: p_effective_date IN DATE,
912: p_batch_sequence IN pay_batch_lines.batch_sequence%TYPE,

Line 914: p_bg_id IN pay_batch_headers.business_group_id%TYPE

910: p_session_date IN DATE,
911: p_effective_date IN DATE,
912: p_batch_sequence IN pay_batch_lines.batch_sequence%TYPE,
913: p_bee_rec IN hxt_interface_utilities.bee_rec,
914: p_bg_id IN pay_batch_headers.business_group_id%TYPE
915: )
916: AS
917: l_proc CONSTANT proc_name := g_package || 'create_batch_line';
918: l_total_lines NUMBER;

Line 1090: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,

1086: RAISE e_continue;
1087: END create_batch_line;
1088:
1089: PROCEDURE add_to_batch (
1090: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
1091: p_batch_id IN OUT NOCOPY pay_batch_headers.batch_id%TYPE,
1092: p_det_tbb_idx IN PLS_INTEGER,
1093: p_batch_sequence IN OUT NOCOPY pay_batch_lines.batch_sequence%TYPE,
1094: p_batch_lines IN OUT NOCOPY PLS_INTEGER,

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

1087: END create_batch_line;
1088:
1089: PROCEDURE add_to_batch (
1090: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
1091: p_batch_id IN OUT NOCOPY pay_batch_headers.batch_id%TYPE,
1092: p_det_tbb_idx IN PLS_INTEGER,
1093: p_batch_sequence IN OUT NOCOPY pay_batch_lines.batch_sequence%TYPE,
1094: p_batch_lines IN OUT NOCOPY PLS_INTEGER,
1095: p_bg_id IN pay_batch_headers.business_group_id%TYPE,

Line 1095: p_bg_id IN pay_batch_headers.business_group_id%TYPE,

1091: p_batch_id IN OUT NOCOPY pay_batch_headers.batch_id%TYPE,
1092: p_det_tbb_idx IN PLS_INTEGER,
1093: p_batch_sequence IN OUT NOCOPY pay_batch_lines.batch_sequence%TYPE,
1094: p_batch_lines IN OUT NOCOPY PLS_INTEGER,
1095: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
1096: p_session_date IN DATE,
1097: p_effective_date IN DATE,
1098: p_bee_rec IN hxt_interface_utilities.bee_rec
1099: )

Line 1163: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,

1159: hr_utility.set_location ('Leaving:' || l_proc, 100);
1160: END add_to_batch;
1161:
1162: PROCEDURE add_lines_to_bee_batch (
1163: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
1164: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
1165: p_session_date IN DATE,
1166: p_tbb_tbl IN hxc_generic_retrieval_pkg.t_building_blocks,
1167: p_attr_tbl IN hxc_generic_retrieval_pkg.t_time_attribute,

Line 1164: p_bg_id IN pay_batch_headers.business_group_id%TYPE,

1160: END add_to_batch;
1161:
1162: PROCEDURE add_lines_to_bee_batch (
1163: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
1164: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
1165: p_session_date IN DATE,
1166: p_tbb_tbl IN hxc_generic_retrieval_pkg.t_building_blocks,
1167: p_attr_tbl IN hxc_generic_retrieval_pkg.t_time_attribute,
1168: p_old_tbb_tbl IN hxc_generic_retrieval_pkg.t_building_blocks,

Line 1185: l_batch_id pay_batch_headers.batch_reference%TYPE;

1181: l_old_bee_rec hxt_interface_utilities.bee_rec;
1182: l_empty_bee_rec hxt_interface_utilities.bee_rec;
1183: l_cost_flex_id per_business_groups_perf.cost_allocation_structure%TYPE
1184: := hxt_interface_utilities.cost_flex_structure_id (p_bg_id);
1185: l_batch_id pay_batch_headers.batch_reference%TYPE;
1186: l_batch_sequence pay_batch_lines.batch_sequence%TYPE;
1187: l_retro_batch_id pay_batch_headers.batch_reference%TYPE;
1188: l_retro_batch_sequence pay_batch_lines.batch_sequence%TYPE;
1189: l_batch_lines PLS_INTEGER;

Line 1187: l_retro_batch_id pay_batch_headers.batch_reference%TYPE;

1183: l_cost_flex_id per_business_groups_perf.cost_allocation_structure%TYPE
1184: := hxt_interface_utilities.cost_flex_structure_id (p_bg_id);
1185: l_batch_id pay_batch_headers.batch_reference%TYPE;
1186: l_batch_sequence pay_batch_lines.batch_sequence%TYPE;
1187: l_retro_batch_id pay_batch_headers.batch_reference%TYPE;
1188: l_retro_batch_sequence pay_batch_lines.batch_sequence%TYPE;
1189: l_batch_lines PLS_INTEGER;
1190: l_retro_batch_lines PLS_INTEGER;
1191: BEGIN

Line 1403: p_batch_ref IN pay_batch_headers.batch_reference%TYPE,

1399: p_end_date IN hxc_time_building_blocks.stop_time%TYPE,
1400: p_session_date IN DATE,
1401: p_where_clause IN hxt_interface_utilities.max_varchar,
1402: p_retrieval_transaction_code IN hxc_transactions.transaction_code%TYPE,
1403: p_batch_ref IN pay_batch_headers.batch_reference%TYPE,
1404: p_unique_params IN hxt_interface_utilities.max_varchar,
1405: p_status_in_bee IN VARCHAR2,
1406: p_incremental IN hxt_interface_utilities.flag_varchar
1407: DEFAULT 'Y',

Line 1416: l_supa_chunk_batch_id pay_batch_headers.batch_reference%TYPE

1412: )
1413: AS
1414: l_proc CONSTANT proc_name
1415: := g_package || 'process_non_otlr_employees';
1416: l_supa_chunk_batch_id pay_batch_headers.batch_reference%TYPE
1417: := NULL;
1418: l_supa_chunk_retro_batch_id pay_batch_headers.batch_reference%TYPE
1419: := NULL;
1420:

Line 1418: l_supa_chunk_retro_batch_id pay_batch_headers.batch_reference%TYPE

1414: l_proc CONSTANT proc_name
1415: := g_package || 'process_non_otlr_employees';
1416: l_supa_chunk_batch_id pay_batch_headers.batch_reference%TYPE
1417: := NULL;
1418: l_supa_chunk_retro_batch_id pay_batch_headers.batch_reference%TYPE
1419: := NULL;
1420:
1421: l_dup_count NUMBER; -- Bug 6121705
1422:

Line 1557: l_batch_ref pay_batch_headers.batch_reference%TYPE;

1553: )
1554: AS
1555: l_where_clause hxt_interface_utilities.max_varchar;
1556: l_unique_params hxt_interface_utilities.max_varchar;
1557: l_batch_ref pay_batch_headers.batch_reference%TYPE;
1558: l_no_otm hxt_interface_utilities.flag_varchar := 'N';
1559: l_retrieval_options fnd_profile_option_values.profile_option_value%TYPE
1560: := fnd_profile.VALUE ('HXC_RETRIEVAL_OPTIONS');
1561: BEGIN

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

1640:
1641: tnull_old_detail_bld_blks hxc_generic_retrieval_pkg.t_building_blocks;
1642: tnull_old_detail_attributes hxc_generic_retrieval_pkg.t_time_attribute;
1643:
1644: l_adj_batch_id pay_batch_headers.batch_reference%TYPE := NULL;
1645: l_retro_adj_batch_id pay_batch_headers.batch_reference%TYPE := NULL;
1646:
1647:
1648: -- Private procedure create_bld_blk_table

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

1641: tnull_old_detail_bld_blks hxc_generic_retrieval_pkg.t_building_blocks;
1642: tnull_old_detail_attributes hxc_generic_retrieval_pkg.t_time_attribute;
1643:
1644: l_adj_batch_id pay_batch_headers.batch_reference%TYPE := NULL;
1645: l_retro_adj_batch_id pay_batch_headers.batch_reference%TYPE := NULL;
1646:
1647:
1648: -- Private procedure create_bld_blk_table
1649: -- populates the detail bld blks plsql table like gen. retrieval