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 HXT_INTERFACE_UTILITIES

Line 334: l_where_clause hxt_interface_utilities.max_varchar := NULL;

330: )
331: RETURN VARCHAR2
332: IS
333: l_proc CONSTANT proc_name := g_package || 'where_clause';
334: l_where_clause hxt_interface_utilities.max_varchar := NULL;
335: l_payroll hxt_interface_utilities.varchar_256 := NULL;
336: l_person hxt_interface_utilities.varchar_256 := NULL;
337: l_org hxt_interface_utilities.varchar_256 := NULL;
338: l_location hxt_interface_utilities.varchar_256 := NULL;

Line 335: l_payroll hxt_interface_utilities.varchar_256 := NULL;

331: RETURN VARCHAR2
332: IS
333: l_proc CONSTANT proc_name := g_package || 'where_clause';
334: l_where_clause hxt_interface_utilities.max_varchar := NULL;
335: l_payroll hxt_interface_utilities.varchar_256 := NULL;
336: l_person hxt_interface_utilities.varchar_256 := NULL;
337: l_org hxt_interface_utilities.varchar_256 := NULL;
338: l_location hxt_interface_utilities.varchar_256 := NULL;
339:

Line 336: l_person hxt_interface_utilities.varchar_256 := NULL;

332: IS
333: l_proc CONSTANT proc_name := g_package || 'where_clause';
334: l_where_clause hxt_interface_utilities.max_varchar := NULL;
335: l_payroll hxt_interface_utilities.varchar_256 := NULL;
336: l_person hxt_interface_utilities.varchar_256 := NULL;
337: l_org hxt_interface_utilities.varchar_256 := NULL;
338: l_location hxt_interface_utilities.varchar_256 := NULL;
339:
340: -- local functions

Line 337: l_org hxt_interface_utilities.varchar_256 := NULL;

333: l_proc CONSTANT proc_name := g_package || 'where_clause';
334: l_where_clause hxt_interface_utilities.max_varchar := NULL;
335: l_payroll hxt_interface_utilities.varchar_256 := NULL;
336: l_person hxt_interface_utilities.varchar_256 := NULL;
337: l_org hxt_interface_utilities.varchar_256 := NULL;
338: l_location hxt_interface_utilities.varchar_256 := NULL;
339:
340: -- local functions
341: FUNCTION clause_part (p_id IN NUMBER, p_clause VARCHAR2)

Line 338: l_location hxt_interface_utilities.varchar_256 := NULL;

334: l_where_clause hxt_interface_utilities.max_varchar := NULL;
335: l_payroll hxt_interface_utilities.varchar_256 := NULL;
336: l_person hxt_interface_utilities.varchar_256 := NULL;
337: l_org hxt_interface_utilities.varchar_256 := NULL;
338: l_location hxt_interface_utilities.varchar_256 := NULL;
339:
340: -- local functions
341: FUNCTION clause_part (p_id IN NUMBER, p_clause VARCHAR2)
342: RETURN VARCHAR2

Line 344: l_clause_part hxt_interface_utilities.max_varchar := NULL;

340: -- local functions
341: FUNCTION clause_part (p_id IN NUMBER, p_clause VARCHAR2)
342: RETURN VARCHAR2
343: IS
344: l_clause_part hxt_interface_utilities.max_varchar := NULL;
345: BEGIN
346: IF p_id IS NOT NULL
347: THEN
348: l_clause_part := p_clause || TO_CHAR (p_id);

Line 520: p_where_clause IN hxt_interface_utilities.max_varchar,

516: p_start_date IN VARCHAR2,
517: --hxc_time_building_blocks.start_time%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

Line 523: p_unique_params IN hxt_interface_utilities.max_varchar,

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
527: DEFAULT 'N',

Line 524: p_incremental IN hxt_interface_utilities.flag_varchar

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
527: DEFAULT 'N',
528: p_no_otm IN OUT NOCOPY hxt_interface_utilities.flag_varchar

Line 526: p_transfer_to_bee IN hxt_interface_utilities.flag_varchar

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
527: DEFAULT 'N',
528: p_no_otm IN OUT NOCOPY hxt_interface_utilities.flag_varchar
529: )
530: AS

Line 528: p_no_otm IN OUT NOCOPY hxt_interface_utilities.flag_varchar

524: p_incremental IN hxt_interface_utilities.flag_varchar
525: DEFAULT 'Y',
526: p_transfer_to_bee IN hxt_interface_utilities.flag_varchar
527: DEFAULT 'N',
528: p_no_otm IN OUT NOCOPY hxt_interface_utilities.flag_varchar
529: )
530: AS
531: l_proc CONSTANT proc_name := g_package || 'process_otlr_employees';
532:

Line 597: p_bee_rec IN OUT NOCOPY hxt_interface_utilities.bee_rec

593: p_det_tbb_idx IN PLS_INTEGER,
594: p_cost_flex_id IN per_business_groups_perf.cost_allocation_structure%TYPE,
595: p_effective_date IN pay_element_types_f.effective_start_date%TYPE,
596: p_attr_tbl_idx IN OUT NOCOPY PLS_INTEGER,
597: p_bee_rec IN OUT NOCOPY hxt_interface_utilities.bee_rec
598: )
599: AS
600: l_proc CONSTANT proc_name
601: := g_package || 'extract_data_from_attr_tbl';

Line 607: IF (hxt_interface_utilities.is_in_sync

603: l_start_attr_tbl_idx PLS_INTEGER;
604: BEGIN
605: hr_utility.set_location ('Entering ' || l_proc, 10);
606:
607: IF (hxt_interface_utilities.is_in_sync
608: (p_check_tbb_id => p_attr_tbl (NVL (p_attr_tbl_idx,
609: p_attr_tbl.FIRST
610: )
611: ).bb_id,

Line 619: hxt_interface_utilities.find_element_id_in_attr_tbl

615: THEN
616: -- We first have to find the element_id cause we need that for converting
617: -- the associated IVs.
618: p_bee_rec.pay_batch_line.element_type_id :=
619: hxt_interface_utilities.find_element_id_in_attr_tbl
620: (p_att_table => p_attr_tbl,
621: p_tbb_id => p_tbb_id,
622: p_start_position => p_attr_tbl_idx
623: );

Line 632: hxt_interface_utilities.find_other_in_attr_tbl

628: END IF;
629:
630: l_start_attr_tbl_idx := p_attr_tbl_idx;
631: -- Now find all the other data (IVs, Asg Data and Cost Segments)
632: hxt_interface_utilities.find_other_in_attr_tbl
633: (p_bg_id => p_bg_id,
634: p_att_table => p_attr_tbl,
635: p_tbb_id => p_tbb_id,
636: p_element_type_id => p_bee_rec.pay_batch_line.element_type_id,

Line 666: p_bee_rec IN OUT NOCOPY hxt_interface_utilities.bee_rec

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';
670: BEGIN

Line 673: IF NOT (hxt_interface_utilities.cost_segments_all_null (p_bee_rec))

669: l_proc CONSTANT proc_name := g_package || 'parse_cost_flex';
670: BEGIN
671: hr_utility.set_location ('Entering ' || l_proc, 10);
672:
673: IF NOT (hxt_interface_utilities.cost_segments_all_null (p_bee_rec))
674: THEN
675: -- get the cost_allocation_flexfield_id (we can do this after the COST
676: -- segments have been set) ...
677: p_bee_rec.pay_batch_line.cost_allocation_keyflex_id :=

Line 678: hxt_interface_utilities.cost_allocation_kff_id

674: THEN
675: -- get the cost_allocation_flexfield_id (we can do this after the COST
676: -- segments have been set) ...
677: p_bee_rec.pay_batch_line.cost_allocation_keyflex_id :=
678: hxt_interface_utilities.cost_allocation_kff_id
679: (p_business_group_id => p_business_group_id,
680: p_bee_rec => p_bee_rec
681: );
682: -- ... and the concatinated segments

Line 684: hxt_interface_utilities.costflex_concat_segments

680: p_bee_rec => p_bee_rec
681: );
682: -- ... and the concatinated segments
683: p_bee_rec.pay_batch_line.concatenated_segments :=
684: hxt_interface_utilities.costflex_concat_segments
685: (p_cost_allocation_keyflex_id => p_bee_rec.pay_batch_line.cost_allocation_keyflex_id
686: );
687: ELSE
688: p_bee_rec.pay_batch_line.cost_allocation_keyflex_id := NULL;

Line 701: p_bee_rec OUT NOCOPY hxt_interface_utilities.bee_rec,

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,
701: p_bee_rec OUT NOCOPY hxt_interface_utilities.bee_rec,
702: p_cost_flex_id IN per_business_groups_perf.cost_allocation_structure%TYPE,
703: p_is_old IN BOOLEAN DEFAULT FALSE
704: )
705: AS

Line 724: hxt_interface_utilities.hours_iv_position

720: p_attr_tbl_idx => p_attr_tbl_idx,
721: p_bee_rec => p_bee_rec
722: );
723: -- get input value sequence for Hours and Jurisdiction
724: hxt_interface_utilities.hours_iv_position
725: (p_element_type_id => p_bee_rec.pay_batch_line.element_type_id,
726: p_effective_date => l_effective_date,
727: p_hours_iv_position => l_hours_iv_position,
728: p_jurisdiction_iv_position => l_jurisdiction_iv_position,

Line 729: p_iv_type => hxt_interface_utilities.g_hour_juris_iv

725: (p_element_type_id => p_bee_rec.pay_batch_line.element_type_id,
726: p_effective_date => l_effective_date,
727: p_hours_iv_position => l_hours_iv_position,
728: p_jurisdiction_iv_position => l_jurisdiction_iv_position,
729: p_iv_type => hxt_interface_utilities.g_hour_juris_iv
730: );
731: -- Assign Hours to the right input value
732: hxt_interface_utilities.assign_iv
733: (p_iv_seq => l_hours_iv_position,

Line 732: hxt_interface_utilities.assign_iv

728: p_jurisdiction_iv_position => l_jurisdiction_iv_position,
729: p_iv_type => hxt_interface_utilities.g_hour_juris_iv
730: );
731: -- Assign Hours to the right input value
732: hxt_interface_utilities.assign_iv
733: (p_iv_seq => l_hours_iv_position,
734: p_value => (p_tbb_rec.measure --Days Vs Hour Enhancement
735: )
736: * hxt_interface_utilities.hours_factor

Line 736: * hxt_interface_utilities.hours_factor

732: hxt_interface_utilities.assign_iv
733: (p_iv_seq => l_hours_iv_position,
734: p_value => (p_tbb_rec.measure --Days Vs Hour Enhancement
735: )
736: * hxt_interface_utilities.hours_factor
737: (p_is_old),
738: p_bee_rec => p_bee_rec
739: );
740:

Line 745: hxt_interface_utilities.get_geocode_from_attr_tab

741: -- get geocode if its input value sequence is not null
742: IF (l_jurisdiction_iv_position IS NOT NULL)
743: THEN
744: l_geocode :=
745: hxt_interface_utilities.get_geocode_from_attr_tab
746: (p_attr_tbl,
747: p_tbb_rec.bb_id,
748: NULL
749: );

Line 753: hxt_interface_utilities.assign_iv

749: );
750:
751: IF (l_geocode <> '00-000-0000')
752: THEN
753: hxt_interface_utilities.assign_iv
754: (p_iv_seq => l_jurisdiction_iv_position,
755: p_value => l_geocode,
756: p_bee_rec => p_bee_rec
757: );

Line 765: hxt_interface_utilities.assignment_info

761: -- set the assignment if it has not bee set yet (i.e. there was no
762: -- assignment attribute)
763: IF (p_bee_rec.pay_batch_line.assignment_id IS NULL)
764: THEN
765: hxt_interface_utilities.assignment_info
766: (p_tbb_rec => p_tbb_rec,
767: p_assignment_id => p_bee_rec.pay_batch_line.assignment_id,
768: p_assignment_number => p_bee_rec.pay_batch_line.assignment_number
769: );

Line 805: TO_CHAR (hxt_interface_utilities.conc_request_id_suffix);

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);
806: l_batch_suffix :=
807: l_batch_suffix
808: || hxt_interface_utilities.batchname_suffix_connector
809: || hxt_interface_utilities.free_batch_suffix

Line 808: || hxt_interface_utilities.batchname_suffix_connector

804: l_batch_suffix :=
805: TO_CHAR (hxt_interface_utilities.conc_request_id_suffix);
806: l_batch_suffix :=
807: l_batch_suffix
808: || hxt_interface_utilities.batchname_suffix_connector
809: || hxt_interface_utilities.free_batch_suffix
810: (p_batch_reference => p_batch_reference,
811: p_bg_id => p_bg_id
812: );

Line 809: || hxt_interface_utilities.free_batch_suffix

805: TO_CHAR (hxt_interface_utilities.conc_request_id_suffix);
806: l_batch_suffix :=
807: l_batch_suffix
808: || hxt_interface_utilities.batchname_suffix_connector
809: || hxt_interface_utilities.free_batch_suffix
810: (p_batch_reference => p_batch_reference,
811: p_bg_id => p_bg_id
812: );
813: l_batch_name :=

Line 815: || hxt_interface_utilities.batchname_suffix_connector

811: p_bg_id => p_bg_id
812: );
813: l_batch_name :=
814: p_batch_reference
815: || hxt_interface_utilities.batchname_suffix_connector
816: || l_batch_suffix;
817: hr_utility.set_location (' returning batch name: ' || l_batch_name,
818: 20);
819: hr_utility.set_location ('Leaving:' || l_proc, 100);

Line 913: p_bee_rec IN hxt_interface_utilities.bee_rec,

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,
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';

Line 1098: p_bee_rec IN hxt_interface_utilities.bee_rec

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: )
1100: AS
1101: l_proc CONSTANT proc_name := g_package || 'add_to_batch';
1102: l_max_lines_exceeded BOOLEAN;

Line 1121: hxt_interface_utilities.max_lines_exceeded

1117: IF ( g_assignment_id <> p_bee_rec.pay_batch_line.assignment_id
1118: AND g_assignment_id <> -1
1119: )
1120: THEN
1121: hxt_interface_utilities.max_lines_exceeded
1122: (p_batch_id => p_batch_id,
1123: p_number_lines => p_batch_lines,
1124: p_max_lines_exceeded => l_max_lines_exceeded
1125: );

Line 1180: l_bee_rec hxt_interface_utilities.bee_rec;

1176: l_det_tbb_idx PLS_INTEGER;
1177: l_det_old_tbb_idx PLS_INTEGER := 0;
1178: l_det_attr_idx PLS_INTEGER;
1179: l_det_old_attr_idx PLS_INTEGER;
1180: l_bee_rec hxt_interface_utilities.bee_rec;
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);

Line 1181: l_old_bee_rec hxt_interface_utilities.bee_rec;

1177: l_det_old_tbb_idx PLS_INTEGER := 0;
1178: l_det_attr_idx PLS_INTEGER;
1179: l_det_old_attr_idx PLS_INTEGER;
1180: l_bee_rec hxt_interface_utilities.bee_rec;
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;

Line 1182: l_empty_bee_rec hxt_interface_utilities.bee_rec;

1178: l_det_attr_idx PLS_INTEGER;
1179: l_det_old_attr_idx PLS_INTEGER;
1180: l_bee_rec hxt_interface_utilities.bee_rec;
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;

Line 1184: := hxt_interface_utilities.cost_flex_structure_id (p_bg_id);

1180: l_bee_rec hxt_interface_utilities.bee_rec;
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;

Line 1205: IF (hxt_interface_utilities.is_changed (p_tbb_tbl (l_det_tbb_idx))

1201: BEGIN
1202: EXIT process_all_detail_tbb WHEN NOT p_tbb_tbl.EXISTS
1203: (l_det_tbb_idx);
1204:
1205: IF (hxt_interface_utilities.is_changed (p_tbb_tbl (l_det_tbb_idx))
1206: )
1207: THEN -- get previously transferred line
1208: l_det_old_tbb_idx := l_det_old_tbb_idx + 1;
1209:

Line 1210: IF (hxt_interface_utilities.is_in_sync

1206: )
1207: THEN -- get previously transferred line
1208: l_det_old_tbb_idx := l_det_old_tbb_idx + 1;
1209:
1210: IF (hxt_interface_utilities.is_in_sync
1211: (p_check_tbb_id => p_old_tbb_tbl
1212: (l_det_old_tbb_idx).bb_id,
1213: p_against_tbb_id => p_tbb_tbl (l_det_tbb_idx).bb_id
1214: )

Line 1245: IF NOT (hxt_interface_utilities.is_deleted

1241: ),
1242: p_bee_rec => l_old_bee_rec
1243: );
1244:
1245: IF NOT (hxt_interface_utilities.is_deleted
1246: (p_tbb_tbl (l_det_tbb_idx)
1247: )
1248: )
1249: THEN -- must be an update to an existing BEE entry

Line 1266: IF (hxt_interface_utilities.use_old_retro_batches)

1262: -- Previously Transferred rows go into Retro Batch
1263: -- New usage = New rows go into New Batch
1264: -- Previously Transferred and Updated rows go into
1265: -- Retro Batch
1266: IF (hxt_interface_utilities.use_old_retro_batches)
1267: THEN
1268: add_to_batch
1269: (p_batch_reference => p_batch_reference,
1270: p_batch_id => l_batch_id,

Line 1303: hxt_interface_utilities.skip_attributes

1299: ELSE
1300: -- Delete, so we only need to backout the previously
1301: -- transferred data which we already did so nothing to do
1302: l_det_attr_idx :=
1303: hxt_interface_utilities.skip_attributes
1304: (p_att_table => p_attr_tbl,
1305: p_tbb_id => p_tbb_tbl
1306: (l_det_tbb_idx).bb_id,
1307: p_start_position => l_det_attr_idx

Line 1311: ELSE -- IF (hxt_interface_utilities.is_in_sync ...)

1307: p_start_position => l_det_attr_idx
1308: );
1309: l_bee_rec := l_empty_bee_rec;
1310: END IF;
1311: ELSE -- IF (hxt_interface_utilities.is_in_sync ...)
1312: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1313: fnd_message.set_token ('PROCEDURE', l_proc);
1314: fnd_message.set_token ('STEP', 'tbb mismatch');
1315: fnd_message.raise_error;

Line 1318: IF NOT (hxt_interface_utilities.is_deleted

1314: fnd_message.set_token ('STEP', 'tbb mismatch');
1315: fnd_message.raise_error;
1316: END IF;
1317: ELSE -- new record (i.e. never transferred to BEE before)
1318: IF NOT (hxt_interface_utilities.is_deleted
1319: (p_tbb_tbl (l_det_tbb_idx)
1320: )
1321: )
1322: THEN

Line 1348: hxt_interface_utilities.skip_attributes

1344: );
1345: ELSE
1346: -- deleted but never existed in BEE so we don't have to do anything
1347: l_det_attr_idx :=
1348: hxt_interface_utilities.skip_attributes
1349: (p_att_table => p_attr_tbl,
1350: p_tbb_id => p_tbb_tbl
1351: (l_det_tbb_idx).bb_id,
1352: p_start_position => l_det_attr_idx

Line 1364: hxt_interface_utilities.skip_attributes

1360: EXCEPTION
1361: WHEN e_continue
1362: THEN
1363: l_det_attr_idx :=
1364: hxt_interface_utilities.skip_attributes
1365: (p_att_table => p_attr_tbl,
1366: p_tbb_id => p_tbb_tbl
1367: (l_det_tbb_idx).bb_id,
1368: p_start_position => l_det_attr_idx

Line 1371: hxt_interface_utilities.skip_attributes

1367: (l_det_tbb_idx).bb_id,
1368: p_start_position => l_det_attr_idx
1369: );
1370: l_det_old_attr_idx :=
1371: hxt_interface_utilities.skip_attributes
1372: (p_att_table => p_old_attr_tbl,
1373: p_tbb_id => p_tbb_tbl
1374: (l_det_tbb_idx).bb_id,
1375: p_start_position => l_det_old_attr_idx

Line 1390: hxt_interface_utilities.perform_commit;

1386: END processing_tbb;
1387: END LOOP process_all_detail_tbb;
1388:
1389: set_successfull_trx (g_bee_retrieval_process);
1390: hxt_interface_utilities.perform_commit;
1391: p_batch_id := l_batch_id;
1392: p_retro_batch_id := l_retro_batch_id;
1393: hr_utility.set_location ('Leaving ' || l_proc, 100);
1394: END add_lines_to_bee_batch;

Line 1401: p_where_clause IN hxt_interface_utilities.max_varchar,

1397: p_bg_id IN hr_all_organization_units.business_group_id%TYPE,
1398: p_start_date IN hxc_time_building_blocks.start_time%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,

Line 1404: p_unique_params IN hxt_interface_utilities.max_varchar,

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',
1408: p_transfer_to_bee IN hxt_interface_utilities.flag_varchar

Line 1406: p_incremental IN hxt_interface_utilities.flag_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',
1408: p_transfer_to_bee IN hxt_interface_utilities.flag_varchar
1409: DEFAULT 'N',
1410: p_no_otm IN hxt_interface_utilities.flag_varchar

Line 1408: p_transfer_to_bee IN hxt_interface_utilities.flag_varchar

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',
1408: p_transfer_to_bee IN hxt_interface_utilities.flag_varchar
1409: DEFAULT 'N',
1410: p_no_otm IN hxt_interface_utilities.flag_varchar
1411: DEFAULT 'N'
1412: )

Line 1410: p_no_otm IN hxt_interface_utilities.flag_varchar

1406: p_incremental IN hxt_interface_utilities.flag_varchar
1407: DEFAULT 'Y',
1408: p_transfer_to_bee IN hxt_interface_utilities.flag_varchar
1409: DEFAULT 'N',
1410: p_no_otm IN hxt_interface_utilities.flag_varchar
1411: DEFAULT 'N'
1412: )
1413: AS
1414: l_proc CONSTANT proc_name

Line 1446: IF (hxt_interface_utilities.detail_lines_retrieved

1442: p_unique_params => p_unique_params,
1443: p_since_date => l_since_date
1444: );
1445:
1446: IF (hxt_interface_utilities.detail_lines_retrieved
1447: (hxc_generic_retrieval_pkg.t_detail_bld_blks)
1448: )
1449: THEN
1450: add_lines_to_bee_batch

Line 1493: hxt_interface_utilities.empty_cache;

1489:
1490: -- --
1491:
1492:
1493: hxt_interface_utilities.empty_cache;
1494: END LOOP retrieve_in_chuncks;
1495:
1496: hxt_interface_utilities.perform_commit;
1497: -- Transfer or Validate the batches that were created

Line 1496: hxt_interface_utilities.perform_commit;

1492:
1493: hxt_interface_utilities.empty_cache;
1494: END LOOP retrieve_in_chuncks;
1495:
1496: hxt_interface_utilities.perform_commit;
1497: -- Transfer or Validate the batches that were created
1498: --(if requested by user)
1499: process_bee_batches (p_status_in_bee => p_status_in_bee);
1500: hr_utility.set_location ('Leaving ' || l_proc, 100);

Line 1555: l_where_clause hxt_interface_utilities.max_varchar;

1551: p_otlr_to_bee IN VARCHAR2,
1552: p_since_date IN VARCHAR2
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

Line 1556: l_unique_params hxt_interface_utilities.max_varchar;

1552: p_since_date IN VARCHAR2
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');

Line 1558: l_no_otm hxt_interface_utilities.flag_varchar := 'N';

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
1562: -- Set session date