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.

[Home] [Help]

APPS.PAY_HR_OTC_RETRIEVAL_INTERFACE dependencies on HXT_INTERFACE_UTILITIES

Line 430: l_where_clause hxt_interface_utilities.max_varchar := NULL;

426: )
427: RETURN VARCHAR2
428: IS
429: l_proc CONSTANT proc_name := g_package || 'where_clause';
430: l_where_clause hxt_interface_utilities.max_varchar := NULL;
431: l_payroll hxt_interface_utilities.varchar_256 := NULL;
432: l_person hxt_interface_utilities.varchar_256 := NULL;
433: l_org hxt_interface_utilities.varchar_256 := NULL;
434: l_location hxt_interface_utilities.varchar_256 := NULL;

Line 431: l_payroll hxt_interface_utilities.varchar_256 := NULL;

427: RETURN VARCHAR2
428: IS
429: l_proc CONSTANT proc_name := g_package || 'where_clause';
430: l_where_clause hxt_interface_utilities.max_varchar := NULL;
431: l_payroll hxt_interface_utilities.varchar_256 := NULL;
432: l_person hxt_interface_utilities.varchar_256 := NULL;
433: l_org hxt_interface_utilities.varchar_256 := NULL;
434: l_location hxt_interface_utilities.varchar_256 := NULL;
435:

Line 432: l_person hxt_interface_utilities.varchar_256 := NULL;

428: IS
429: l_proc CONSTANT proc_name := g_package || 'where_clause';
430: l_where_clause hxt_interface_utilities.max_varchar := NULL;
431: l_payroll hxt_interface_utilities.varchar_256 := NULL;
432: l_person hxt_interface_utilities.varchar_256 := NULL;
433: l_org hxt_interface_utilities.varchar_256 := NULL;
434: l_location hxt_interface_utilities.varchar_256 := NULL;
435:
436: -- local functions

Line 433: l_org hxt_interface_utilities.varchar_256 := NULL;

429: l_proc CONSTANT proc_name := g_package || 'where_clause';
430: l_where_clause hxt_interface_utilities.max_varchar := NULL;
431: l_payroll hxt_interface_utilities.varchar_256 := NULL;
432: l_person hxt_interface_utilities.varchar_256 := NULL;
433: l_org hxt_interface_utilities.varchar_256 := NULL;
434: l_location hxt_interface_utilities.varchar_256 := NULL;
435:
436: -- local functions
437: FUNCTION clause_part (p_id IN NUMBER, p_clause VARCHAR2)

Line 434: l_location hxt_interface_utilities.varchar_256 := NULL;

430: l_where_clause hxt_interface_utilities.max_varchar := NULL;
431: l_payroll hxt_interface_utilities.varchar_256 := NULL;
432: l_person hxt_interface_utilities.varchar_256 := NULL;
433: l_org hxt_interface_utilities.varchar_256 := NULL;
434: l_location hxt_interface_utilities.varchar_256 := NULL;
435:
436: -- local functions
437: FUNCTION clause_part (p_id IN NUMBER, p_clause VARCHAR2)
438: RETURN VARCHAR2

Line 440: l_clause_part hxt_interface_utilities.max_varchar := NULL;

436: -- local functions
437: FUNCTION clause_part (p_id IN NUMBER, p_clause VARCHAR2)
438: RETURN VARCHAR2
439: IS
440: l_clause_part hxt_interface_utilities.max_varchar := NULL;
441: BEGIN
442: IF p_id IS NOT NULL
443: THEN
444: l_clause_part := p_clause || TO_CHAR (p_id);

Line 736: p_where_clause IN hxt_interface_utilities.max_varchar,

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

Line 739: p_unique_params IN hxt_interface_utilities.max_varchar,

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

Line 740: p_incremental IN hxt_interface_utilities.flag_varchar

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

Line 742: p_transfer_to_bee IN hxt_interface_utilities.flag_varchar

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
743: DEFAULT 'N',
744: p_no_otm IN OUT NOCOPY hxt_interface_utilities.flag_varchar
745: )
746: AS

Line 744: p_no_otm IN OUT NOCOPY hxt_interface_utilities.flag_varchar

740: p_incremental IN hxt_interface_utilities.flag_varchar
741: DEFAULT 'Y',
742: p_transfer_to_bee IN hxt_interface_utilities.flag_varchar
743: DEFAULT 'N',
744: p_no_otm IN OUT NOCOPY hxt_interface_utilities.flag_varchar
745: )
746: AS
747: l_proc CONSTANT proc_name := g_package || 'process_otlr_employees';
748:

Line 901: p_bee_rec IN OUT NOCOPY hxt_interface_utilities.bee_rec,

897: p_det_tbb_idx IN PLS_INTEGER,
898: p_cost_flex_id IN per_business_groups_perf.cost_allocation_structure%TYPE,
899: p_effective_date IN pay_element_types_f.effective_start_date%TYPE,
900: p_attr_tbl_idx IN OUT NOCOPY PLS_INTEGER,
901: p_bee_rec IN OUT NOCOPY hxt_interface_utilities.bee_rec,
902: p_is_old IN BOOLEAN DEFAULT FALSE
903: )
904:
905: AS

Line 913: IF (hxt_interface_utilities.is_in_sync

909: l_start_attr_tbl_idx PLS_INTEGER;
910: BEGIN
911: hr_utility.set_location ('Entering ' || l_proc, 10);
912:
913: IF (hxt_interface_utilities.is_in_sync
914: (p_check_tbb_id => p_attr_tbl (NVL (p_attr_tbl_idx,
915: p_attr_tbl.FIRST
916: )
917: ).bb_id,

Line 925: hxt_interface_utilities.find_element_id_in_attr_tbl

921: THEN
922: -- We first have to find the element_id cause we need that for converting
923: -- the associated IVs.
924: p_bee_rec.pay_batch_line.element_type_id :=
925: hxt_interface_utilities.find_element_id_in_attr_tbl
926: (p_att_table => p_attr_tbl,
927: p_tbb_id => p_tbb_id,
928: p_start_position => p_attr_tbl_idx
929: );

Line 938: hxt_interface_utilities.find_other_in_attr_tbl

934: END IF;
935:
936: l_start_attr_tbl_idx := p_attr_tbl_idx;
937: -- Now find all the other data (IVs, Asg Data and Cost Segments)
938: hxt_interface_utilities.find_other_in_attr_tbl
939: (p_bg_id => p_bg_id,
940: p_att_table => p_attr_tbl,
941: p_tbb_id => p_tbb_id,
942: p_element_type_id => p_bee_rec.pay_batch_line.element_type_id,

Line 977: p_bee_rec IN OUT NOCOPY hxt_interface_utilities.bee_rec

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

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

980: l_proc CONSTANT proc_name := g_package || 'parse_cost_flex';
981: BEGIN
982: hr_utility.set_location ('Entering ' || l_proc, 10);
983:
984: IF NOT (hxt_interface_utilities.cost_segments_all_null (p_bee_rec))
985: THEN
986: -- get the cost_allocation_flexfield_id (we can do this after the COST
987: -- segments have been set) ...
988: p_bee_rec.pay_batch_line.cost_allocation_keyflex_id :=

Line 989: hxt_interface_utilities.cost_allocation_kff_id

985: THEN
986: -- get the cost_allocation_flexfield_id (we can do this after the COST
987: -- segments have been set) ...
988: p_bee_rec.pay_batch_line.cost_allocation_keyflex_id :=
989: hxt_interface_utilities.cost_allocation_kff_id
990: (p_business_group_id => p_business_group_id,
991: p_bee_rec => p_bee_rec
992: );
993: -- ... and the concatinated segments

Line 995: hxt_interface_utilities.costflex_concat_segments

991: p_bee_rec => p_bee_rec
992: );
993: -- ... and the concatinated segments
994: p_bee_rec.pay_batch_line.concatenated_segments :=
995: hxt_interface_utilities.costflex_concat_segments
996: (p_cost_allocation_keyflex_id => p_bee_rec.pay_batch_line.cost_allocation_keyflex_id
997: );
998: ELSE
999: p_bee_rec.pay_batch_line.cost_allocation_keyflex_id := NULL;

Line 1012: p_bee_rec OUT NOCOPY hxt_interface_utilities.bee_rec,

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,
1012: p_bee_rec OUT NOCOPY hxt_interface_utilities.bee_rec,
1013: p_cost_flex_id IN per_business_groups_perf.cost_allocation_structure%TYPE,
1014: p_is_old IN BOOLEAN DEFAULT FALSE
1015: )
1016: AS

Line 1036: hxt_interface_utilities.hours_iv_position

1032: p_bee_rec => p_bee_rec,
1033: p_is_old => p_is_old
1034: );
1035: -- get input value sequence for Hours and Jurisdiction
1036: hxt_interface_utilities.hours_iv_position
1037: (p_element_type_id => p_bee_rec.pay_batch_line.element_type_id,
1038: p_effective_date => l_effective_date,
1039: p_hours_iv_position => l_hours_iv_position,
1040: p_jurisdiction_iv_position => l_jurisdiction_iv_position,

Line 1041: p_iv_type => hxt_interface_utilities.g_hour_juris_iv

1037: (p_element_type_id => p_bee_rec.pay_batch_line.element_type_id,
1038: p_effective_date => l_effective_date,
1039: p_hours_iv_position => l_hours_iv_position,
1040: p_jurisdiction_iv_position => l_jurisdiction_iv_position,
1041: p_iv_type => hxt_interface_utilities.g_hour_juris_iv
1042: );
1043: -- Assign Hours to the right input value
1044:
1045: -- Bug 13777315

Line 1050: hxt_interface_utilities.assign_iv

1046: -- If IV Upgrade is complete, pass the Canonical format.
1047: -- Else pass the number as is, and let it get converted to CHAR implicitly.
1048: IF g_iv_upgrade = 'Y'
1049: THEN
1050: hxt_interface_utilities.assign_iv
1051: (p_iv_seq => l_hours_iv_position,
1052: p_value => FND_NUMBER.NUMBER_TO_CANONICAL( (p_tbb_rec.measure --Days Vs Hour Enhancement
1053: )
1054: * hxt_interface_utilities.hours_factor

Line 1054: * hxt_interface_utilities.hours_factor

1050: hxt_interface_utilities.assign_iv
1051: (p_iv_seq => l_hours_iv_position,
1052: p_value => FND_NUMBER.NUMBER_TO_CANONICAL( (p_tbb_rec.measure --Days Vs Hour Enhancement
1053: )
1054: * hxt_interface_utilities.hours_factor
1055: (p_is_old)),
1056: p_bee_rec => p_bee_rec
1057: );
1058:

Line 1060: hxt_interface_utilities.assign_iv

1056: p_bee_rec => p_bee_rec
1057: );
1058:
1059: ELSE
1060: hxt_interface_utilities.assign_iv
1061: (p_iv_seq => l_hours_iv_position,
1062: p_value => (p_tbb_rec.measure --Days Vs Hour Enhancement
1063: )
1064: * hxt_interface_utilities.hours_factor

Line 1064: * hxt_interface_utilities.hours_factor

1060: hxt_interface_utilities.assign_iv
1061: (p_iv_seq => l_hours_iv_position,
1062: p_value => (p_tbb_rec.measure --Days Vs Hour Enhancement
1063: )
1064: * hxt_interface_utilities.hours_factor
1065: (p_is_old),
1066: p_bee_rec => p_bee_rec
1067: );
1068: END IF;

Line 1075: hxt_interface_utilities.get_geocode_from_attr_tab

1071: -- get geocode if its input value sequence is not null
1072: IF (l_jurisdiction_iv_position IS NOT NULL)
1073: THEN
1074: l_geocode :=
1075: hxt_interface_utilities.get_geocode_from_attr_tab
1076: (p_attr_tbl,
1077: p_tbb_rec.bb_id,
1078: NULL
1079: );

Line 1083: hxt_interface_utilities.assign_iv

1079: );
1080:
1081: IF (l_geocode <> '00-000-0000')
1082: THEN
1083: hxt_interface_utilities.assign_iv
1084: (p_iv_seq => l_jurisdiction_iv_position,
1085: p_value => l_geocode,
1086: p_bee_rec => p_bee_rec
1087: );

Line 1095: hxt_interface_utilities.assignment_info

1091: -- set the assignment if it has not bee set yet (i.e. there was no
1092: -- assignment attribute)
1093: IF (p_bee_rec.pay_batch_line.assignment_id IS NULL)
1094: THEN
1095: hxt_interface_utilities.assignment_info
1096: (p_tbb_rec => p_tbb_rec,
1097: p_assignment_id => p_bee_rec.pay_batch_line.assignment_id,
1098: p_assignment_number => p_bee_rec.pay_batch_line.assignment_number
1099: );

Line 1135: TO_CHAR (hxt_interface_utilities.conc_request_id_suffix);

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);
1136: l_batch_suffix :=
1137: l_batch_suffix
1138: || hxt_interface_utilities.batchname_suffix_connector
1139: || hxt_interface_utilities.free_batch_suffix

Line 1138: || hxt_interface_utilities.batchname_suffix_connector

1134: l_batch_suffix :=
1135: TO_CHAR (hxt_interface_utilities.conc_request_id_suffix);
1136: l_batch_suffix :=
1137: l_batch_suffix
1138: || hxt_interface_utilities.batchname_suffix_connector
1139: || hxt_interface_utilities.free_batch_suffix
1140: (p_batch_reference => p_batch_reference,
1141: p_bg_id => p_bg_id
1142: );

Line 1139: || hxt_interface_utilities.free_batch_suffix

1135: TO_CHAR (hxt_interface_utilities.conc_request_id_suffix);
1136: l_batch_suffix :=
1137: l_batch_suffix
1138: || hxt_interface_utilities.batchname_suffix_connector
1139: || hxt_interface_utilities.free_batch_suffix
1140: (p_batch_reference => p_batch_reference,
1141: p_bg_id => p_bg_id
1142: );
1143: l_batch_name :=

Line 1145: || hxt_interface_utilities.batchname_suffix_connector

1141: p_bg_id => p_bg_id
1142: );
1143: l_batch_name :=
1144: p_batch_reference
1145: || hxt_interface_utilities.batchname_suffix_connector
1146: || l_batch_suffix;
1147: hr_utility.set_location (' returning batch name: ' || l_batch_name,
1148: 20);
1149: hr_utility.set_location ('Leaving:' || l_proc, 100);

Line 1247: p_bee_rec IN hxt_interface_utilities.bee_rec,

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

Line 1557: p_bee_rec IN hxt_interface_utilities.bee_rec,

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
1559: )
1560: AS
1561: l_proc CONSTANT proc_name := g_package || 'add_to_batch';

Line 1581: hxt_interface_utilities.max_lines_exceeded

1577: IF ( g_assignment_id <> p_bee_rec.pay_batch_line.assignment_id
1578: AND g_assignment_id <> -1
1579: )
1580: THEN
1581: hxt_interface_utilities.max_lines_exceeded
1582: (p_batch_id => p_batch_id,
1583: p_number_lines => p_batch_lines,
1584: p_max_lines_exceeded => l_max_lines_exceeded
1585: );

Line 1641: l_bee_rec hxt_interface_utilities.bee_rec;

1637: l_det_tbb_idx PLS_INTEGER;
1638: l_det_old_tbb_idx PLS_INTEGER := 0;
1639: l_det_attr_idx PLS_INTEGER;
1640: l_det_old_attr_idx PLS_INTEGER;
1641: l_bee_rec hxt_interface_utilities.bee_rec;
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);

Line 1642: l_old_bee_rec hxt_interface_utilities.bee_rec;

1638: l_det_old_tbb_idx PLS_INTEGER := 0;
1639: l_det_attr_idx PLS_INTEGER;
1640: l_det_old_attr_idx PLS_INTEGER;
1641: l_bee_rec hxt_interface_utilities.bee_rec;
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;

Line 1643: l_empty_bee_rec hxt_interface_utilities.bee_rec;

1639: l_det_attr_idx PLS_INTEGER;
1640: l_det_old_attr_idx PLS_INTEGER;
1641: l_bee_rec hxt_interface_utilities.bee_rec;
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;

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

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

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

1670: cache_preferences(p_tbb_tbl(l_det_tbb_idx).resource_id,
1671: g_start_date,
1672: g_end_date);
1673:
1674: IF (hxt_interface_utilities.is_changed (p_tbb_tbl (l_det_tbb_idx))
1675: )
1676: THEN -- get previously transferred line
1677: l_det_old_tbb_idx := l_det_old_tbb_idx + 1;
1678:

Line 1679: IF (hxt_interface_utilities.is_in_sync

1675: )
1676: THEN -- get previously transferred line
1677: l_det_old_tbb_idx := l_det_old_tbb_idx + 1;
1678:
1679: IF (hxt_interface_utilities.is_in_sync
1680: (p_check_tbb_id => p_old_tbb_tbl
1681: (l_det_old_tbb_idx).bb_id,
1682: p_against_tbb_id => p_tbb_tbl (l_det_tbb_idx).bb_id
1683: )

Line 1731: IF NOT (hxt_interface_utilities.is_deleted

1727: p_bee_rec => l_old_bee_rec,
1728: p_is_retro => TRUE -- Bug 9494444
1729: );
1730:
1731: IF NOT (hxt_interface_utilities.is_deleted
1732: (p_tbb_tbl (l_det_tbb_idx)
1733: )
1734: )
1735: THEN -- must be an update to an existing BEE entry

Line 1763: IF (hxt_interface_utilities.use_old_retro_batches)

1759: -- Previously Transferred rows go into Retro Batch
1760: -- New usage = New rows go into New Batch
1761: -- Previously Transferred and Updated rows go into
1762: -- Retro Batch
1763: IF (hxt_interface_utilities.use_old_retro_batches)
1764: THEN
1765: add_to_batch
1766: (p_batch_reference => p_batch_reference,
1767: p_batch_id => l_batch_id,

Line 1800: hxt_interface_utilities.skip_attributes

1796: ELSE
1797: -- Delete, so we only need to backout the previously
1798: -- transferred data which we already did so nothing to do
1799: l_det_attr_idx :=
1800: hxt_interface_utilities.skip_attributes
1801: (p_att_table => p_attr_tbl,
1802: p_tbb_id => p_tbb_tbl
1803: (l_det_tbb_idx).bb_id,
1804: p_start_position => l_det_attr_idx

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

1804: p_start_position => l_det_attr_idx
1805: );
1806: l_bee_rec := l_empty_bee_rec;
1807: END IF;
1808: ELSE -- IF (hxt_interface_utilities.is_in_sync ...)
1809: fnd_message.set_name ('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1810: fnd_message.set_token ('PROCEDURE', l_proc);
1811: fnd_message.set_token ('STEP', 'tbb mismatch');
1812: fnd_message.raise_error;

Line 1826: IF NOT (hxt_interface_utilities.is_deleted

1822: g_pay_pa_link_tab(l_det_tbb_idx).timecard_id
1823: := p_tbb_tbl(l_det_tbb_idx).timecard_bb_id;
1824: END IF;
1825:
1826: IF NOT (hxt_interface_utilities.is_deleted
1827: (p_tbb_tbl (l_det_tbb_idx)
1828: )
1829: )
1830: THEN

Line 1856: hxt_interface_utilities.skip_attributes

1852: );
1853: ELSE
1854: -- deleted but never existed in BEE so we don't have to do anything
1855: l_det_attr_idx :=
1856: hxt_interface_utilities.skip_attributes
1857: (p_att_table => p_attr_tbl,
1858: p_tbb_id => p_tbb_tbl
1859: (l_det_tbb_idx).bb_id,
1860: p_start_position => l_det_attr_idx

Line 1872: hxt_interface_utilities.skip_attributes

1868: EXCEPTION
1869: WHEN e_continue
1870: THEN
1871: l_det_attr_idx :=
1872: hxt_interface_utilities.skip_attributes
1873: (p_att_table => p_attr_tbl,
1874: p_tbb_id => p_tbb_tbl
1875: (l_det_tbb_idx).bb_id,
1876: p_start_position => l_det_attr_idx

Line 1879: hxt_interface_utilities.skip_attributes

1875: (l_det_tbb_idx).bb_id,
1876: p_start_position => l_det_attr_idx
1877: );
1878: l_det_old_attr_idx :=
1879: hxt_interface_utilities.skip_attributes
1880: (p_att_table => p_old_attr_tbl,
1881: p_tbb_id => p_tbb_tbl
1882: (l_det_tbb_idx).bb_id,
1883: p_start_position => l_det_old_attr_idx

Line 2107: hxt_interface_utilities.perform_commit;

2103:
2104:
2105: END IF;
2106:
2107: hxt_interface_utilities.perform_commit;
2108: p_batch_id := l_batch_id;
2109: p_retro_batch_id := l_retro_batch_id;
2110: hr_utility.set_location ('Leaving ' || l_proc, 100);
2111: END add_lines_to_bee_batch;

Line 2118: p_where_clause IN hxt_interface_utilities.max_varchar,

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

Line 2121: p_unique_params IN hxt_interface_utilities.max_varchar,

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

Line 2123: p_incremental IN hxt_interface_utilities.flag_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',
2125: p_transfer_to_bee IN hxt_interface_utilities.flag_varchar
2126: DEFAULT 'N',
2127: p_no_otm IN hxt_interface_utilities.flag_varchar

Line 2125: p_transfer_to_bee IN hxt_interface_utilities.flag_varchar

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',
2125: p_transfer_to_bee IN hxt_interface_utilities.flag_varchar
2126: DEFAULT 'N',
2127: p_no_otm IN hxt_interface_utilities.flag_varchar
2128: DEFAULT 'N'
2129: )

Line 2127: p_no_otm IN hxt_interface_utilities.flag_varchar

2123: p_incremental IN hxt_interface_utilities.flag_varchar
2124: DEFAULT 'Y',
2125: p_transfer_to_bee IN hxt_interface_utilities.flag_varchar
2126: DEFAULT 'N',
2127: p_no_otm IN hxt_interface_utilities.flag_varchar
2128: DEFAULT 'N'
2129: )
2130: AS
2131: l_proc CONSTANT proc_name

Line 2172: IF (hxt_interface_utilities.detail_lines_retrieved

2168: p_unique_params => p_unique_params,
2169: p_since_date => l_since_date
2170: );
2171:
2172: IF (hxt_interface_utilities.detail_lines_retrieved
2173: (hxc_generic_retrieval_pkg.t_detail_bld_blks)
2174: )
2175: THEN
2176: add_lines_to_bee_batch

Line 2219: hxt_interface_utilities.empty_cache;

2215:
2216: -- --
2217:
2218:
2219: hxt_interface_utilities.empty_cache;
2220: END LOOP retrieve_in_chuncks;
2221:
2222: -- Bug 12919783
2223: mark_batches_for_rollback;

Line 2225: hxt_interface_utilities.perform_commit;

2221:
2222: -- Bug 12919783
2223: mark_batches_for_rollback;
2224:
2225: hxt_interface_utilities.perform_commit;
2226: -- Transfer or Validate the batches that were created
2227: --(if requested by user)
2228: process_bee_batches (p_status_in_bee => p_status_in_bee);
2229: hr_utility.set_location ('Leaving ' || l_proc, 100);

Line 2287: l_where_clause hxt_interface_utilities.max_varchar;

2283: p_otlr_to_bee IN VARCHAR2,
2284: p_since_date IN VARCHAR2
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

Line 2288: l_unique_params hxt_interface_utilities.max_varchar;

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

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

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