APPS.PAY_HR_OTC_RETRIEVAL_INTERFACE dependencies on HXC_GENERIC_RETRIEVAL_PKG

Line 422: hxc_generic_retrieval_pkg.t_tx_detail_status (p_tbb_idx) := p_status;

418: IS
419: l_proc CONSTANT proc_name := g_package || 'set_transaction_detail';
420: BEGIN
421: hr_utility.set_location ('Entering ' || l_proc, 10);
422: hxc_generic_retrieval_pkg.t_tx_detail_status (p_tbb_idx) := p_status;
423: hxc_generic_retrieval_pkg.t_tx_detail_exception (p_tbb_idx) :=
424: SUBSTR (p_exception, 1, g_max_message_size);
425: hr_utility.set_location ('Leaving ' || l_proc, 100);
426: END set_transaction_detail;

Line 423: hxc_generic_retrieval_pkg.t_tx_detail_exception (p_tbb_idx) :=

419: l_proc CONSTANT proc_name := g_package || 'set_transaction_detail';
420: BEGIN
421: hr_utility.set_location ('Entering ' || l_proc, 10);
422: hxc_generic_retrieval_pkg.t_tx_detail_status (p_tbb_idx) := p_status;
423: hxc_generic_retrieval_pkg.t_tx_detail_exception (p_tbb_idx) :=
424: SUBSTR (p_exception, 1, g_max_message_size);
425: hr_utility.set_location ('Leaving ' || l_proc, 100);
426: END set_transaction_detail;
427:

Line 438: hxc_generic_retrieval_pkg.update_transaction_status

434: l_proc CONSTANT proc_name := g_package || 'set_transaction';
435: BEGIN
436: hr_utility.set_location ('Entering ' || l_proc, 10);
437: hxc_generic_retrieval_utils.set_parent_statuses;
438: hxc_generic_retrieval_pkg.update_transaction_status
439: (p_process => p_process_name,
440: p_status => p_status,
441: p_exception_description => SUBSTR
442: (p_exception,

Line 591: p_attr_tbl IN hxc_generic_retrieval_pkg.t_time_attribute,

587: END process_otlr_employees;
588:
589: PROCEDURE extract_data_from_attr_tbl (
590: p_bg_id IN hr_all_organization_units.business_group_id%TYPE,
591: p_attr_tbl IN hxc_generic_retrieval_pkg.t_time_attribute,
592: p_tbb_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
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,

Line 697: p_tbb_rec IN hxc_generic_retrieval_pkg.r_building_blocks,

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,
701: p_bee_rec OUT NOCOPY hxt_interface_utilities.bee_rec,

Line 699: p_attr_tbl IN hxc_generic_retrieval_pkg.t_time_attribute,

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

Line 1166: p_tbb_tbl IN hxc_generic_retrieval_pkg.t_building_blocks,

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,
1169: p_old_attr_tbl IN hxc_generic_retrieval_pkg.t_time_attribute,
1170: p_batch_id IN OUT NOCOPY NUMBER,

Line 1167: p_attr_tbl IN hxc_generic_retrieval_pkg.t_time_attribute,

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,
1169: p_old_attr_tbl IN hxc_generic_retrieval_pkg.t_time_attribute,
1170: p_batch_id IN OUT NOCOPY NUMBER,
1171: p_retro_batch_id IN OUT NOCOPY NUMBER

Line 1168: p_old_tbb_tbl IN hxc_generic_retrieval_pkg.t_building_blocks,

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,
1169: p_old_attr_tbl IN hxc_generic_retrieval_pkg.t_time_attribute,
1170: p_batch_id IN OUT NOCOPY NUMBER,
1171: p_retro_batch_id IN OUT NOCOPY NUMBER
1172: )

Line 1169: p_old_attr_tbl IN hxc_generic_retrieval_pkg.t_time_attribute,

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,
1169: p_old_attr_tbl IN hxc_generic_retrieval_pkg.t_time_attribute,
1170: p_batch_id IN OUT NOCOPY NUMBER,
1171: p_retro_batch_id IN OUT NOCOPY NUMBER
1172: )
1173: AS

Line 1432: hxc_generic_retrieval_pkg.execute_retrieval_process

1428: -- call generic retrieval to get the non-OTM employees Timecards
1429: -- The retrieval process will only retrieve part of the population
1430: -- as set by the profile option OTL: Transfer Batch Size which is why
1431: -- it is called in a loop
1432: hxc_generic_retrieval_pkg.execute_retrieval_process
1433: (p_process => g_bee_retrieval_process,
1434: p_transaction_code => p_retrieval_transaction_code,
1435: p_start_date => p_start_date,
1436: p_end_date => p_end_date,

Line 1447: (hxc_generic_retrieval_pkg.t_detail_bld_blks)

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
1451: (p_batch_ref,

Line 1454: hxc_generic_retrieval_pkg.t_detail_bld_blks,

1450: add_lines_to_bee_batch
1451: (p_batch_ref,
1452: p_bg_id,
1453: p_session_date,
1454: hxc_generic_retrieval_pkg.t_detail_bld_blks,
1455: hxc_generic_retrieval_pkg.t_detail_attributes,
1456: hxc_generic_retrieval_pkg.t_old_detail_bld_blks,
1457: hxc_generic_retrieval_pkg.t_old_detail_attributes,
1458: l_supa_chunk_batch_id,

Line 1455: hxc_generic_retrieval_pkg.t_detail_attributes,

1451: (p_batch_ref,
1452: p_bg_id,
1453: p_session_date,
1454: hxc_generic_retrieval_pkg.t_detail_bld_blks,
1455: hxc_generic_retrieval_pkg.t_detail_attributes,
1456: hxc_generic_retrieval_pkg.t_old_detail_bld_blks,
1457: hxc_generic_retrieval_pkg.t_old_detail_attributes,
1458: l_supa_chunk_batch_id,
1459: l_supa_chunk_retro_batch_id

Line 1456: hxc_generic_retrieval_pkg.t_old_detail_bld_blks,

1452: p_bg_id,
1453: p_session_date,
1454: hxc_generic_retrieval_pkg.t_detail_bld_blks,
1455: hxc_generic_retrieval_pkg.t_detail_attributes,
1456: hxc_generic_retrieval_pkg.t_old_detail_bld_blks,
1457: hxc_generic_retrieval_pkg.t_old_detail_attributes,
1458: l_supa_chunk_batch_id,
1459: l_supa_chunk_retro_batch_id
1460: );

Line 1457: hxc_generic_retrieval_pkg.t_old_detail_attributes,

1453: p_session_date,
1454: hxc_generic_retrieval_pkg.t_detail_bld_blks,
1455: hxc_generic_retrieval_pkg.t_detail_attributes,
1456: hxc_generic_retrieval_pkg.t_old_detail_bld_blks,
1457: hxc_generic_retrieval_pkg.t_old_detail_attributes,
1458: l_supa_chunk_batch_id,
1459: l_supa_chunk_retro_batch_id
1460: );
1461: ELSE

Line 1462: hxc_generic_retrieval_pkg.update_transaction_status

1458: l_supa_chunk_batch_id,
1459: l_supa_chunk_retro_batch_id
1460: );
1461: ELSE
1462: hxc_generic_retrieval_pkg.update_transaction_status
1463: (p_process => 'BEE Retrieval Process',
1464: p_status => 'SUCCESS',
1465: p_exception_description => NULL
1466: );

Line 1506: hxc_generic_retrieval_pkg.update_transaction_status

1502: WHEN OTHERS
1503: THEN
1504: set_sqlerror_trx (g_bee_retrieval_process);
1505: hxc_generic_retrieval_utils.set_parent_statuses;
1506: hxc_generic_retrieval_pkg.update_transaction_status
1507: (p_process => g_bee_retrieval_process,
1508: p_status => 'ERRORS',
1509: p_exception_description => SUBSTR
1510: (SQLERRM,

Line 1563: hxc_generic_retrieval_pkg.g_ret_criteria.location_id := p_location_id;

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
1563: hxc_generic_retrieval_pkg.g_ret_criteria.location_id := p_location_id;
1564: hxc_generic_retrieval_pkg.g_ret_criteria.payroll_id := p_payroll_id;
1565: hxc_generic_retrieval_pkg.g_ret_criteria.organization_id :=
1566: p_organization_id;
1567: hxc_generic_retrieval_pkg.g_ret_criteria.gre_id := p_gre_id;

Line 1564: hxc_generic_retrieval_pkg.g_ret_criteria.payroll_id := p_payroll_id;

1560: := fnd_profile.VALUE ('HXC_RETRIEVAL_OPTIONS');
1561: BEGIN
1562: -- Set session date
1563: hxc_generic_retrieval_pkg.g_ret_criteria.location_id := p_location_id;
1564: hxc_generic_retrieval_pkg.g_ret_criteria.payroll_id := p_payroll_id;
1565: hxc_generic_retrieval_pkg.g_ret_criteria.organization_id :=
1566: p_organization_id;
1567: hxc_generic_retrieval_pkg.g_ret_criteria.gre_id := p_gre_id;
1568: l_since_date := p_since_date;

Line 1565: hxc_generic_retrieval_pkg.g_ret_criteria.organization_id :=

1561: BEGIN
1562: -- Set session date
1563: hxc_generic_retrieval_pkg.g_ret_criteria.location_id := p_location_id;
1564: hxc_generic_retrieval_pkg.g_ret_criteria.payroll_id := p_payroll_id;
1565: hxc_generic_retrieval_pkg.g_ret_criteria.organization_id :=
1566: p_organization_id;
1567: hxc_generic_retrieval_pkg.g_ret_criteria.gre_id := p_gre_id;
1568: l_since_date := p_since_date;
1569: pay_db_pay_setup.set_session_date (SYSDATE);

Line 1567: hxc_generic_retrieval_pkg.g_ret_criteria.gre_id := p_gre_id;

1563: hxc_generic_retrieval_pkg.g_ret_criteria.location_id := p_location_id;
1564: hxc_generic_retrieval_pkg.g_ret_criteria.payroll_id := p_payroll_id;
1565: hxc_generic_retrieval_pkg.g_ret_criteria.organization_id :=
1566: p_organization_id;
1567: hxc_generic_retrieval_pkg.g_ret_criteria.gre_id := p_gre_id;
1568: l_since_date := p_since_date;
1569: pay_db_pay_setup.set_session_date (SYSDATE);
1570: l_batch_ref := NVL (p_old_batch_ref, p_new_batch_ref);
1571: l_where_clause :=

Line 1641: tnull_old_detail_bld_blks hxc_generic_retrieval_pkg.t_building_blocks;

1637: l_sqlmsg VARCHAR2(2000);
1638:
1639: l_att_cnt NUMBER;
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;

Line 1642: tnull_old_detail_attributes hxc_generic_retrieval_pkg.t_time_attribute;

1638:
1639: l_att_cnt NUMBER;
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:

Line 1656: -- hxc_generic_retrieval_pkg, so that it can use the batch creation API.

1652: -- batch_source as Time Store.
1653: -- 2. Update hxc_bee_pref_adj_lines table with these values for
1654: -- the corresponding bb_ids and ovns.
1655: -- 3. Pull out these into a plsql table for the format prescribed in
1656: -- hxc_generic_retrieval_pkg, so that it can use the batch creation API.
1657:
1658:
1659: PROCEDURE create_bld_blk_table
1660: IS

Line 1824: FOR MAP IN hxc_generic_retrieval_pkg.g_field_mappings_table.FIRST..

1820: LOOP
1821: -- Loop thru all the field mappings ---
1822: -- You already have the mappings in this global pl/sql table for gen retrieval.
1823: -- Use it, no need to query again.
1824: FOR MAP IN hxc_generic_retrieval_pkg.g_field_mappings_table.FIRST..
1825: hxc_generic_retrieval_pkg.g_field_mappings_table.LAST
1826: LOOP
1827: IF (t_attr_info(i).bld_blk_info_type_id =
1828: hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).

Line 1825: hxc_generic_retrieval_pkg.g_field_mappings_table.LAST

1821: -- Loop thru all the field mappings ---
1822: -- You already have the mappings in this global pl/sql table for gen retrieval.
1823: -- Use it, no need to query again.
1824: FOR MAP IN hxc_generic_retrieval_pkg.g_field_mappings_table.FIRST..
1825: hxc_generic_retrieval_pkg.g_field_mappings_table.LAST
1826: LOOP
1827: IF (t_attr_info(i).bld_blk_info_type_id =
1828: hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).
1829: bld_blk_info_type_id)

Line 1828: hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).

1824: FOR MAP IN hxc_generic_retrieval_pkg.g_field_mappings_table.FIRST..
1825: hxc_generic_retrieval_pkg.g_field_mappings_table.LAST
1826: LOOP
1827: IF (t_attr_info(i).bld_blk_info_type_id =
1828: hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).
1829: bld_blk_info_type_id)
1830: -- If there is a valid mapping for the bld blk info type id --
1831: THEN
1832: l_att_cnt := l_att_cnt + 1;

Line 1835: t_dtl_attributes(l_att_cnt).field_name := hxc_generic_retrieval_pkg.

1831: THEN
1832: l_att_cnt := l_att_cnt + 1;
1833: -- copy the the context,category AND the field name into the attribute info table --
1834: t_dtl_attributes(l_att_cnt).bb_id := t_attr_info(i).bb_id;
1835: t_dtl_attributes(l_att_cnt).field_name := hxc_generic_retrieval_pkg.
1836: g_field_mappings_table(MAP).field_name;
1837: t_dtl_attributes(l_att_cnt).context := hxc_generic_retrieval_pkg.
1838: g_field_mappings_table(MAP).context;
1839: t_dtl_attributes(l_att_cnt).category := hxc_generic_retrieval_pkg.

Line 1837: t_dtl_attributes(l_att_cnt).context := hxc_generic_retrieval_pkg.

1833: -- copy the the context,category AND the field name into the attribute info table --
1834: t_dtl_attributes(l_att_cnt).bb_id := t_attr_info(i).bb_id;
1835: t_dtl_attributes(l_att_cnt).field_name := hxc_generic_retrieval_pkg.
1836: g_field_mappings_table(MAP).field_name;
1837: t_dtl_attributes(l_att_cnt).context := hxc_generic_retrieval_pkg.
1838: g_field_mappings_table(MAP).context;
1839: t_dtl_attributes(l_att_cnt).category := hxc_generic_retrieval_pkg.
1840: g_field_mappings_table(MAP).category;
1841: -- check which attribute this mapping belongs to AND copy down that attribute --

Line 1839: t_dtl_attributes(l_att_cnt).category := hxc_generic_retrieval_pkg.

1835: t_dtl_attributes(l_att_cnt).field_name := hxc_generic_retrieval_pkg.
1836: g_field_mappings_table(MAP).field_name;
1837: t_dtl_attributes(l_att_cnt).context := hxc_generic_retrieval_pkg.
1838: g_field_mappings_table(MAP).context;
1839: t_dtl_attributes(l_att_cnt).category := hxc_generic_retrieval_pkg.
1840: g_field_mappings_table(MAP).category;
1841: -- check which attribute this mapping belongs to AND copy down that attribute --
1842:
1843: IF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).

Line 1843: IF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).

1839: t_dtl_attributes(l_att_cnt).category := hxc_generic_retrieval_pkg.
1840: g_field_mappings_table(MAP).category;
1841: -- check which attribute this mapping belongs to AND copy down that attribute --
1842:
1843: IF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).
1844: ATTRIBUTE = 'ATTRIBUTE_CATEGORY')
1845: THEN
1846: t_dtl_attributes(l_att_cnt).value :=
1847: hxc_deposit_wrapper_utilities.get_dupdff_name(t_attr_info(i).attribute_category);

Line 1848: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE1')

1844: ATTRIBUTE = 'ATTRIBUTE_CATEGORY')
1845: THEN
1846: t_dtl_attributes(l_att_cnt).value :=
1847: hxc_deposit_wrapper_utilities.get_dupdff_name(t_attr_info(i).attribute_category);
1848: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE1')
1849: THEN
1850: t_dtl_attributes(l_att_cnt).value :=
1851: t_attr_info(i).attribute1;
1852: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE2')

Line 1852: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE2')

1848: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE1')
1849: THEN
1850: t_dtl_attributes(l_att_cnt).value :=
1851: t_attr_info(i).attribute1;
1852: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE2')
1853: THEN
1854: t_dtl_attributes(l_att_cnt).value :=
1855: t_attr_info(i).attribute2;
1856: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE3')

Line 1856: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE3')

1852: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE2')
1853: THEN
1854: t_dtl_attributes(l_att_cnt).value :=
1855: t_attr_info(i).attribute2;
1856: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE3')
1857: THEN
1858: t_dtl_attributes(l_att_cnt).value :=
1859: t_attr_info(i).attribute3;
1860: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE4')

Line 1860: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE4')

1856: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE3')
1857: THEN
1858: t_dtl_attributes(l_att_cnt).value :=
1859: t_attr_info(i).attribute3;
1860: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE4')
1861: THEN
1862: t_dtl_attributes(l_att_cnt).value :=
1863: t_attr_info(i).attribute4;
1864: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE5')

Line 1864: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE5')

1860: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE4')
1861: THEN
1862: t_dtl_attributes(l_att_cnt).value :=
1863: t_attr_info(i).attribute4;
1864: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE5')
1865: THEN
1866: t_dtl_attributes(l_att_cnt).value :=
1867: t_attr_info(i).attribute5;
1868: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE6')

Line 1868: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE6')

1864: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE5')
1865: THEN
1866: t_dtl_attributes(l_att_cnt).value :=
1867: t_attr_info(i).attribute5;
1868: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE6')
1869: THEN
1870: t_dtl_attributes(l_att_cnt).value :=
1871: t_attr_info(i).attribute6;
1872: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE7')

Line 1872: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE7')

1868: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE6')
1869: THEN
1870: t_dtl_attributes(l_att_cnt).value :=
1871: t_attr_info(i).attribute6;
1872: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE7')
1873: THEN
1874: t_dtl_attributes(l_att_cnt).value :=
1875: t_attr_info(i).attribute7;
1876: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE8')

Line 1876: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE8')

1872: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE7')
1873: THEN
1874: t_dtl_attributes(l_att_cnt).value :=
1875: t_attr_info(i).attribute7;
1876: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE8')
1877: THEN
1878: t_dtl_attributes(l_att_cnt).value :=
1879: t_attr_info(i).attribute8;
1880: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE9')

Line 1880: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE9')

1876: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE8')
1877: THEN
1878: t_dtl_attributes(l_att_cnt).value :=
1879: t_attr_info(i).attribute8;
1880: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE9')
1881: THEN
1882: t_dtl_attributes(l_att_cnt).value :=
1883: t_attr_info(i).attribute9;
1884: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE10')

Line 1884: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE10')

1880: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE9')
1881: THEN
1882: t_dtl_attributes(l_att_cnt).value :=
1883: t_attr_info(i).attribute9;
1884: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE10')
1885: THEN
1886: t_dtl_attributes(l_att_cnt).value :=
1887: t_attr_info(i).attribute10;
1888: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE11')

Line 1888: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE11')

1884: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE10')
1885: THEN
1886: t_dtl_attributes(l_att_cnt).value :=
1887: t_attr_info(i).attribute10;
1888: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE11')
1889: THEN
1890: t_dtl_attributes(l_att_cnt).value :=
1891: t_attr_info(i).attribute11;
1892: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE12')

Line 1892: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE12')

1888: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE11')
1889: THEN
1890: t_dtl_attributes(l_att_cnt).value :=
1891: t_attr_info(i).attribute11;
1892: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE12')
1893: THEN
1894: t_dtl_attributes(l_att_cnt).value :=
1895: t_attr_info(i).attribute12;
1896: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE13')

Line 1896: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE13')

1892: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE12')
1893: THEN
1894: t_dtl_attributes(l_att_cnt).value :=
1895: t_attr_info(i).attribute12;
1896: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE13')
1897: THEN
1898: t_dtl_attributes(l_att_cnt).value :=
1899: t_attr_info(i).attribute13;
1900: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE14')

Line 1900: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE14')

1896: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE13')
1897: THEN
1898: t_dtl_attributes(l_att_cnt).value :=
1899: t_attr_info(i).attribute13;
1900: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE14')
1901: THEN
1902: t_dtl_attributes(l_att_cnt).value :=
1903: t_attr_info(i).attribute14;
1904: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE15')

Line 1904: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE15')

1900: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE14')
1901: THEN
1902: t_dtl_attributes(l_att_cnt).value :=
1903: t_attr_info(i).attribute14;
1904: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE15')
1905: THEN
1906: t_dtl_attributes(l_att_cnt).value :=
1907: t_attr_info(i).attribute15;
1908: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE16')

Line 1908: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE16')

1904: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE15')
1905: THEN
1906: t_dtl_attributes(l_att_cnt).value :=
1907: t_attr_info(i).attribute15;
1908: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE16')
1909: THEN
1910: t_dtl_attributes(l_att_cnt).value :=
1911: t_attr_info(i).attribute16;
1912: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE17')

Line 1912: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE17')

1908: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE16')
1909: THEN
1910: t_dtl_attributes(l_att_cnt).value :=
1911: t_attr_info(i).attribute16;
1912: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE17')
1913: THEN
1914: t_dtl_attributes(l_att_cnt).value :=
1915: t_attr_info(i).attribute17;
1916: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE18')

Line 1916: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE18')

1912: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE17')
1913: THEN
1914: t_dtl_attributes(l_att_cnt).value :=
1915: t_attr_info(i).attribute17;
1916: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE18')
1917: THEN
1918: t_dtl_attributes(l_att_cnt).value :=
1919: t_attr_info(i).attribute18;
1920: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE19')

Line 1920: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE19')

1916: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE18')
1917: THEN
1918: t_dtl_attributes(l_att_cnt).value :=
1919: t_attr_info(i).attribute18;
1920: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE19')
1921: THEN
1922: t_dtl_attributes(l_att_cnt).value :=
1923: t_attr_info(i).attribute19;
1924: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE20')

Line 1924: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE20')

1920: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE19')
1921: THEN
1922: t_dtl_attributes(l_att_cnt).value :=
1923: t_attr_info(i).attribute19;
1924: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE20')
1925: THEN
1926: t_dtl_attributes(l_att_cnt).value :=
1927: t_attr_info(i).attribute20;
1928: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE21')

Line 1928: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE21')

1924: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE20')
1925: THEN
1926: t_dtl_attributes(l_att_cnt).value :=
1927: t_attr_info(i).attribute20;
1928: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE21')
1929: THEN
1930: t_dtl_attributes(l_att_cnt).value :=
1931: t_attr_info(i).attribute21;
1932: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE22')

Line 1932: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE22')

1928: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE21')
1929: THEN
1930: t_dtl_attributes(l_att_cnt).value :=
1931: t_attr_info(i).attribute21;
1932: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE22')
1933: THEN
1934: t_dtl_attributes(l_att_cnt).value :=
1935: t_attr_info(i).attribute22;
1936: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE23')

Line 1936: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE23')

1932: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE22')
1933: THEN
1934: t_dtl_attributes(l_att_cnt).value :=
1935: t_attr_info(i).attribute22;
1936: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE23')
1937: THEN
1938: t_dtl_attributes(l_att_cnt).value :=
1939: t_attr_info(i).attribute23;
1940: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE24')

Line 1940: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE24')

1936: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE23')
1937: THEN
1938: t_dtl_attributes(l_att_cnt).value :=
1939: t_attr_info(i).attribute23;
1940: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE24')
1941: THEN
1942: t_dtl_attributes(l_att_cnt).value :=
1943: t_attr_info(i).attribute24;
1944: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE25')

Line 1944: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE25')

1940: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE24')
1941: THEN
1942: t_dtl_attributes(l_att_cnt).value :=
1943: t_attr_info(i).attribute24;
1944: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE25')
1945: THEN
1946: t_dtl_attributes(l_att_cnt).value :=
1947: t_attr_info(i).attribute25;
1948: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE26')

Line 1948: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE26')

1944: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE25')
1945: THEN
1946: t_dtl_attributes(l_att_cnt).value :=
1947: t_attr_info(i).attribute25;
1948: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE26')
1949: THEN
1950: t_dtl_attributes(l_att_cnt).value :=
1951: t_attr_info(i).attribute26;
1952: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE27')

Line 1952: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE27')

1948: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE26')
1949: THEN
1950: t_dtl_attributes(l_att_cnt).value :=
1951: t_attr_info(i).attribute26;
1952: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE27')
1953: THEN
1954: t_dtl_attributes(l_att_cnt).value :=
1955: t_attr_info(i).attribute27;
1956: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE28')

Line 1956: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE28')

1952: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE27')
1953: THEN
1954: t_dtl_attributes(l_att_cnt).value :=
1955: t_attr_info(i).attribute27;
1956: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE28')
1957: THEN
1958: t_dtl_attributes(l_att_cnt).value :=
1959: t_attr_info(i).attribute28;
1960: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE29')

Line 1960: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE29')

1956: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE28')
1957: THEN
1958: t_dtl_attributes(l_att_cnt).value :=
1959: t_attr_info(i).attribute28;
1960: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE29')
1961: THEN
1962: t_dtl_attributes(l_att_cnt).value :=
1963: t_attr_info(i).attribute29;
1964: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE30')

Line 1964: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE30')

1960: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE29')
1961: THEN
1962: t_dtl_attributes(l_att_cnt).value :=
1963: t_attr_info(i).attribute29;
1964: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE30')
1965: THEN
1966: t_dtl_attributes(l_att_cnt).value :=
1967: t_attr_info(i).attribute30;
1968: END IF;