[Home] [Help]
514: IS
515: l_proc CONSTANT proc_name := g_package || 'set_transaction_detail';
516: BEGIN
517: hr_utility.set_location ('Entering ' || l_proc, 10);
518: hxc_generic_retrieval_pkg.t_tx_detail_status (p_tbb_idx) := p_status;
519: hxc_generic_retrieval_pkg.t_tx_detail_exception (p_tbb_idx) :=
520: SUBSTR (p_exception, 1, g_max_message_size);
521: hr_utility.set_location ('Leaving ' || l_proc, 100);
522: END set_transaction_detail;
515: l_proc CONSTANT proc_name := g_package || 'set_transaction_detail';
516: BEGIN
517: hr_utility.set_location ('Entering ' || l_proc, 10);
518: hxc_generic_retrieval_pkg.t_tx_detail_status (p_tbb_idx) := p_status;
519: hxc_generic_retrieval_pkg.t_tx_detail_exception (p_tbb_idx) :=
520: SUBSTR (p_exception, 1, g_max_message_size);
521: hr_utility.set_location ('Leaving ' || l_proc, 100);
522: END set_transaction_detail;
523:
530: l_proc CONSTANT proc_name := g_package || 'set_transaction';
531: BEGIN
532: hr_utility.set_location ('Entering ' || l_proc, 10);
533: hxc_generic_retrieval_utils.set_parent_statuses;
534: hxc_generic_retrieval_pkg.update_transaction_status
535: (p_process => p_process_name,
536: p_status => p_status,
537: p_exception_description => SUBSTR
538: (p_exception,
805:
806: -- Bug 10323310
807: -- Proj Pay Integration
808: -- Copies down the attribute records from Attribute table to the global table.
809: PROCEDURE record_pay_pa_details ( p_attr_tbl IN hxc_generic_retrieval_pkg.t_time_attribute,
810: p_tbb_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
811: p_det_tbb_idx IN PLS_INTEGER,
812: p_is_old IN BOOLEAN DEFAULT FALSE )
813: IS
891: END record_pay_pa_details;
892:
893: PROCEDURE extract_data_from_attr_tbl (
894: p_bg_id IN hr_all_organization_units.business_group_id%TYPE,
895: p_attr_tbl IN hxc_generic_retrieval_pkg.t_time_attribute,
896: p_tbb_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
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,
1004: END parse_cost_flex;
1005:
1006: PROCEDURE bee_batch_line (
1007: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
1008: p_tbb_rec IN hxc_generic_retrieval_pkg.r_building_blocks,
1009: p_det_tbb_idx IN PLS_INTEGER,
1010: p_attr_tbl IN hxc_generic_retrieval_pkg.t_time_attribute,
1011: p_attr_tbl_idx IN OUT NOCOPY PLS_INTEGER,
1012: p_bee_rec OUT NOCOPY hxt_interface_utilities.bee_rec,
1006: PROCEDURE bee_batch_line (
1007: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
1008: p_tbb_rec IN hxc_generic_retrieval_pkg.r_building_blocks,
1009: p_det_tbb_idx IN PLS_INTEGER,
1010: p_attr_tbl IN hxc_generic_retrieval_pkg.t_time_attribute,
1011: p_attr_tbl_idx IN OUT NOCOPY PLS_INTEGER,
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
1487: -- Record the line and the batch in the respective table to be passed back to
1488: -- OTL.
1489: IF p_is_retro
1490: THEN
1491: hxc_generic_retrieval_pkg.t_old_detail_rec_lines(p_det_tbb_idx).rec_id := l_batch_line_id;
1492: hxc_generic_retrieval_pkg.t_old_detail_rec_lines(p_det_tbb_idx).batch_id := p_batch_id;
1493:
1494: -- Bug 10323310
1495: IF g_old_pay_pa_link_tab.EXISTS(p_det_tbb_idx)
1488: -- OTL.
1489: IF p_is_retro
1490: THEN
1491: hxc_generic_retrieval_pkg.t_old_detail_rec_lines(p_det_tbb_idx).rec_id := l_batch_line_id;
1492: hxc_generic_retrieval_pkg.t_old_detail_rec_lines(p_det_tbb_idx).batch_id := p_batch_id;
1493:
1494: -- Bug 10323310
1495: IF g_old_pay_pa_link_tab.EXISTS(p_det_tbb_idx)
1496: THEN
1506: g_batch_tab(TO_CHAR(p_batch_id)) := 1;
1507: END IF;
1508:
1509: ELSE
1510: hxc_generic_retrieval_pkg.t_detail_rec_lines(p_det_tbb_idx).rec_id := l_batch_line_id;
1511: hxc_generic_retrieval_pkg.t_detail_rec_lines(p_det_tbb_idx).batch_id := p_batch_id;
1512:
1513: -- Bug 10323310
1514: IF g_pay_pa_link_tab.EXISTS(p_det_tbb_idx)
1507: END IF;
1508:
1509: ELSE
1510: hxc_generic_retrieval_pkg.t_detail_rec_lines(p_det_tbb_idx).rec_id := l_batch_line_id;
1511: hxc_generic_retrieval_pkg.t_detail_rec_lines(p_det_tbb_idx).batch_id := p_batch_id;
1512:
1513: -- Bug 10323310
1514: IF g_pay_pa_link_tab.EXISTS(p_det_tbb_idx)
1515: THEN
1623: PROCEDURE add_lines_to_bee_batch (
1624: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
1625: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
1626: p_session_date IN DATE,
1627: p_tbb_tbl IN hxc_generic_retrieval_pkg.t_building_blocks,
1628: p_attr_tbl IN hxc_generic_retrieval_pkg.t_time_attribute,
1629: p_old_tbb_tbl IN hxc_generic_retrieval_pkg.t_building_blocks,
1630: p_old_attr_tbl IN hxc_generic_retrieval_pkg.t_time_attribute,
1631: p_batch_id IN OUT NOCOPY NUMBER,
1624: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
1625: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
1626: p_session_date IN DATE,
1627: p_tbb_tbl IN hxc_generic_retrieval_pkg.t_building_blocks,
1628: p_attr_tbl IN hxc_generic_retrieval_pkg.t_time_attribute,
1629: p_old_tbb_tbl IN hxc_generic_retrieval_pkg.t_building_blocks,
1630: p_old_attr_tbl IN hxc_generic_retrieval_pkg.t_time_attribute,
1631: p_batch_id IN OUT NOCOPY NUMBER,
1632: p_retro_batch_id IN OUT NOCOPY NUMBER
1625: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
1626: p_session_date IN DATE,
1627: p_tbb_tbl IN hxc_generic_retrieval_pkg.t_building_blocks,
1628: p_attr_tbl IN hxc_generic_retrieval_pkg.t_time_attribute,
1629: p_old_tbb_tbl IN hxc_generic_retrieval_pkg.t_building_blocks,
1630: p_old_attr_tbl IN hxc_generic_retrieval_pkg.t_time_attribute,
1631: p_batch_id IN OUT NOCOPY NUMBER,
1632: p_retro_batch_id IN OUT NOCOPY NUMBER
1633: )
1626: p_session_date IN DATE,
1627: p_tbb_tbl IN hxc_generic_retrieval_pkg.t_building_blocks,
1628: p_attr_tbl IN hxc_generic_retrieval_pkg.t_time_attribute,
1629: p_old_tbb_tbl IN hxc_generic_retrieval_pkg.t_building_blocks,
1630: p_old_attr_tbl IN hxc_generic_retrieval_pkg.t_time_attribute,
1631: p_batch_id IN OUT NOCOPY NUMBER,
1632: p_retro_batch_id IN OUT NOCOPY NUMBER
1633: )
1634: AS
2154: -- call generic retrieval to get the non-OTM employees Timecards
2155: -- The retrieval process will only retrieve part of the population
2156: -- as set by the profile option OTL: Transfer Batch Size which is why
2157: -- it is called in a loop
2158: hxc_generic_retrieval_pkg.execute_retrieval_process
2159: (p_process => g_bee_retrieval_process,
2160: p_transaction_code => p_retrieval_transaction_code,
2161: p_start_date => p_start_date,
2162: p_end_date => p_end_date,
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
2177: (p_batch_ref,
2176: add_lines_to_bee_batch
2177: (p_batch_ref,
2178: p_bg_id,
2179: p_session_date,
2180: hxc_generic_retrieval_pkg.t_detail_bld_blks,
2181: hxc_generic_retrieval_pkg.t_detail_attributes,
2182: hxc_generic_retrieval_pkg.t_old_detail_bld_blks,
2183: hxc_generic_retrieval_pkg.t_old_detail_attributes,
2184: l_supa_chunk_batch_id,
2177: (p_batch_ref,
2178: p_bg_id,
2179: p_session_date,
2180: hxc_generic_retrieval_pkg.t_detail_bld_blks,
2181: hxc_generic_retrieval_pkg.t_detail_attributes,
2182: hxc_generic_retrieval_pkg.t_old_detail_bld_blks,
2183: hxc_generic_retrieval_pkg.t_old_detail_attributes,
2184: l_supa_chunk_batch_id,
2185: l_supa_chunk_retro_batch_id
2178: p_bg_id,
2179: p_session_date,
2180: hxc_generic_retrieval_pkg.t_detail_bld_blks,
2181: hxc_generic_retrieval_pkg.t_detail_attributes,
2182: hxc_generic_retrieval_pkg.t_old_detail_bld_blks,
2183: hxc_generic_retrieval_pkg.t_old_detail_attributes,
2184: l_supa_chunk_batch_id,
2185: l_supa_chunk_retro_batch_id
2186: );
2179: p_session_date,
2180: hxc_generic_retrieval_pkg.t_detail_bld_blks,
2181: hxc_generic_retrieval_pkg.t_detail_attributes,
2182: hxc_generic_retrieval_pkg.t_old_detail_bld_blks,
2183: hxc_generic_retrieval_pkg.t_old_detail_attributes,
2184: l_supa_chunk_batch_id,
2185: l_supa_chunk_retro_batch_id
2186: );
2187: ELSE
2184: l_supa_chunk_batch_id,
2185: l_supa_chunk_retro_batch_id
2186: );
2187: ELSE
2188: hxc_generic_retrieval_pkg.update_transaction_status
2189: (p_process => 'BEE Retrieval Process',
2190: p_status => 'SUCCESS',
2191: p_exception_description => NULL
2192: );
2233:
2234: hr_utility.trace(dbms_utility.format_error_backtrace);
2235: set_sqlerror_trx (g_bee_retrieval_process);
2236: hxc_generic_retrieval_utils.set_parent_statuses;
2237: hxc_generic_retrieval_pkg.update_transaction_status
2238: (p_process => g_bee_retrieval_process,
2239: p_status => 'ERRORS',
2240: p_exception_description => SUBSTR
2241: (SQLERRM,
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
2295: hxc_generic_retrieval_pkg.g_ret_criteria.location_id := p_location_id;
2296: hxc_generic_retrieval_pkg.g_ret_criteria.payroll_id := p_payroll_id;
2297: hxc_generic_retrieval_pkg.g_ret_criteria.organization_id :=
2298: p_organization_id;
2299: hxc_generic_retrieval_pkg.g_ret_criteria.gre_id := p_gre_id;
2292: := fnd_profile.VALUE ('HXC_RETRIEVAL_OPTIONS');
2293: BEGIN
2294: -- Set session date
2295: hxc_generic_retrieval_pkg.g_ret_criteria.location_id := p_location_id;
2296: hxc_generic_retrieval_pkg.g_ret_criteria.payroll_id := p_payroll_id;
2297: hxc_generic_retrieval_pkg.g_ret_criteria.organization_id :=
2298: p_organization_id;
2299: hxc_generic_retrieval_pkg.g_ret_criteria.gre_id := p_gre_id;
2300: l_since_date := p_since_date;
2293: BEGIN
2294: -- Set session date
2295: hxc_generic_retrieval_pkg.g_ret_criteria.location_id := p_location_id;
2296: hxc_generic_retrieval_pkg.g_ret_criteria.payroll_id := p_payroll_id;
2297: hxc_generic_retrieval_pkg.g_ret_criteria.organization_id :=
2298: p_organization_id;
2299: hxc_generic_retrieval_pkg.g_ret_criteria.gre_id := p_gre_id;
2300: l_since_date := p_since_date;
2301: pay_db_pay_setup.set_session_date (SYSDATE);
2295: hxc_generic_retrieval_pkg.g_ret_criteria.location_id := p_location_id;
2296: hxc_generic_retrieval_pkg.g_ret_criteria.payroll_id := p_payroll_id;
2297: hxc_generic_retrieval_pkg.g_ret_criteria.organization_id :=
2298: p_organization_id;
2299: hxc_generic_retrieval_pkg.g_ret_criteria.gre_id := p_gre_id;
2300: l_since_date := p_since_date;
2301: pay_db_pay_setup.set_session_date (SYSDATE);
2302: l_batch_ref := NVL (p_old_batch_ref, p_new_batch_ref);
2303: l_where_clause :=
2376: l_sqlmsg VARCHAR2(2000);
2377:
2378: l_att_cnt NUMBER;
2379:
2380: tnull_old_detail_bld_blks hxc_generic_retrieval_pkg.t_building_blocks;
2381: tnull_old_detail_attributes hxc_generic_retrieval_pkg.t_time_attribute;
2382:
2383: l_adj_batch_id pay_batch_headers.batch_reference%TYPE := NULL;
2384: l_retro_adj_batch_id pay_batch_headers.batch_reference%TYPE := NULL;
2377:
2378: l_att_cnt NUMBER;
2379:
2380: tnull_old_detail_bld_blks hxc_generic_retrieval_pkg.t_building_blocks;
2381: tnull_old_detail_attributes hxc_generic_retrieval_pkg.t_time_attribute;
2382:
2383: l_adj_batch_id pay_batch_headers.batch_reference%TYPE := NULL;
2384: l_retro_adj_batch_id pay_batch_headers.batch_reference%TYPE := NULL;
2385:
2391: -- batch_source as Time Store.
2392: -- 2. Update hxc_bee_pref_adj_lines table with these values for
2393: -- the corresponding bb_ids and ovns.
2394: -- 3. Pull out these into a plsql table for the format prescribed in
2395: -- hxc_generic_retrieval_pkg, so that it can use the batch creation API.
2396:
2397:
2398: PROCEDURE create_bld_blk_table
2399: IS
2559: LOOP
2560: -- Loop thru all the field mappings ---
2561: -- You already have the mappings in this global pl/sql table for gen retrieval.
2562: -- Use it, no need to query again.
2563: FOR MAP IN hxc_generic_retrieval_pkg.g_field_mappings_table.FIRST..
2564: hxc_generic_retrieval_pkg.g_field_mappings_table.LAST
2565: LOOP
2566: IF (t_attr_info(i).bld_blk_info_type_id =
2567: hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).
2560: -- Loop thru all the field mappings ---
2561: -- You already have the mappings in this global pl/sql table for gen retrieval.
2562: -- Use it, no need to query again.
2563: FOR MAP IN hxc_generic_retrieval_pkg.g_field_mappings_table.FIRST..
2564: hxc_generic_retrieval_pkg.g_field_mappings_table.LAST
2565: LOOP
2566: IF (t_attr_info(i).bld_blk_info_type_id =
2567: hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).
2568: bld_blk_info_type_id)
2563: FOR MAP IN hxc_generic_retrieval_pkg.g_field_mappings_table.FIRST..
2564: hxc_generic_retrieval_pkg.g_field_mappings_table.LAST
2565: LOOP
2566: IF (t_attr_info(i).bld_blk_info_type_id =
2567: hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).
2568: bld_blk_info_type_id)
2569: -- If there is a valid mapping for the bld blk info type id --
2570: THEN
2571: l_att_cnt := l_att_cnt + 1;
2570: THEN
2571: l_att_cnt := l_att_cnt + 1;
2572: -- copy the the context,category AND the field name into the attribute info table --
2573: t_dtl_attributes(l_att_cnt).bb_id := t_attr_info(i).bb_id;
2574: t_dtl_attributes(l_att_cnt).field_name := hxc_generic_retrieval_pkg.
2575: g_field_mappings_table(MAP).field_name;
2576: t_dtl_attributes(l_att_cnt).context := hxc_generic_retrieval_pkg.
2577: g_field_mappings_table(MAP).context;
2578: t_dtl_attributes(l_att_cnt).category := hxc_generic_retrieval_pkg.
2572: -- copy the the context,category AND the field name into the attribute info table --
2573: t_dtl_attributes(l_att_cnt).bb_id := t_attr_info(i).bb_id;
2574: t_dtl_attributes(l_att_cnt).field_name := hxc_generic_retrieval_pkg.
2575: g_field_mappings_table(MAP).field_name;
2576: t_dtl_attributes(l_att_cnt).context := hxc_generic_retrieval_pkg.
2577: g_field_mappings_table(MAP).context;
2578: t_dtl_attributes(l_att_cnt).category := hxc_generic_retrieval_pkg.
2579: g_field_mappings_table(MAP).category;
2580: -- check which attribute this mapping belongs to AND copy down that attribute --
2574: t_dtl_attributes(l_att_cnt).field_name := hxc_generic_retrieval_pkg.
2575: g_field_mappings_table(MAP).field_name;
2576: t_dtl_attributes(l_att_cnt).context := hxc_generic_retrieval_pkg.
2577: g_field_mappings_table(MAP).context;
2578: t_dtl_attributes(l_att_cnt).category := hxc_generic_retrieval_pkg.
2579: g_field_mappings_table(MAP).category;
2580: -- check which attribute this mapping belongs to AND copy down that attribute --
2581:
2582: IF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).
2578: t_dtl_attributes(l_att_cnt).category := hxc_generic_retrieval_pkg.
2579: g_field_mappings_table(MAP).category;
2580: -- check which attribute this mapping belongs to AND copy down that attribute --
2581:
2582: IF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).
2583: ATTRIBUTE = 'ATTRIBUTE_CATEGORY')
2584: THEN
2585: t_dtl_attributes(l_att_cnt).value :=
2586: hxc_deposit_wrapper_utilities.get_dupdff_name(t_attr_info(i).attribute_category);
2583: ATTRIBUTE = 'ATTRIBUTE_CATEGORY')
2584: THEN
2585: t_dtl_attributes(l_att_cnt).value :=
2586: hxc_deposit_wrapper_utilities.get_dupdff_name(t_attr_info(i).attribute_category);
2587: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE1')
2588: THEN
2589: t_dtl_attributes(l_att_cnt).value :=
2590: t_attr_info(i).attribute1;
2591: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE2')
2587: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE1')
2588: THEN
2589: t_dtl_attributes(l_att_cnt).value :=
2590: t_attr_info(i).attribute1;
2591: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE2')
2592: THEN
2593: t_dtl_attributes(l_att_cnt).value :=
2594: t_attr_info(i).attribute2;
2595: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE3')
2591: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE2')
2592: THEN
2593: t_dtl_attributes(l_att_cnt).value :=
2594: t_attr_info(i).attribute2;
2595: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE3')
2596: THEN
2597: t_dtl_attributes(l_att_cnt).value :=
2598: t_attr_info(i).attribute3;
2599: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE4')
2595: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE3')
2596: THEN
2597: t_dtl_attributes(l_att_cnt).value :=
2598: t_attr_info(i).attribute3;
2599: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE4')
2600: THEN
2601: t_dtl_attributes(l_att_cnt).value :=
2602: t_attr_info(i).attribute4;
2603: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE5')
2599: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE4')
2600: THEN
2601: t_dtl_attributes(l_att_cnt).value :=
2602: t_attr_info(i).attribute4;
2603: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE5')
2604: THEN
2605: t_dtl_attributes(l_att_cnt).value :=
2606: t_attr_info(i).attribute5;
2607: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE6')
2603: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE5')
2604: THEN
2605: t_dtl_attributes(l_att_cnt).value :=
2606: t_attr_info(i).attribute5;
2607: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE6')
2608: THEN
2609: t_dtl_attributes(l_att_cnt).value :=
2610: t_attr_info(i).attribute6;
2611: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE7')
2607: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE6')
2608: THEN
2609: t_dtl_attributes(l_att_cnt).value :=
2610: t_attr_info(i).attribute6;
2611: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE7')
2612: THEN
2613: t_dtl_attributes(l_att_cnt).value :=
2614: t_attr_info(i).attribute7;
2615: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE8')
2611: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE7')
2612: THEN
2613: t_dtl_attributes(l_att_cnt).value :=
2614: t_attr_info(i).attribute7;
2615: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE8')
2616: THEN
2617: t_dtl_attributes(l_att_cnt).value :=
2618: t_attr_info(i).attribute8;
2619: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE9')
2615: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE8')
2616: THEN
2617: t_dtl_attributes(l_att_cnt).value :=
2618: t_attr_info(i).attribute8;
2619: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE9')
2620: THEN
2621: t_dtl_attributes(l_att_cnt).value :=
2622: t_attr_info(i).attribute9;
2623: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE10')
2619: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE9')
2620: THEN
2621: t_dtl_attributes(l_att_cnt).value :=
2622: t_attr_info(i).attribute9;
2623: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE10')
2624: THEN
2625: t_dtl_attributes(l_att_cnt).value :=
2626: t_attr_info(i).attribute10;
2627: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE11')
2623: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE10')
2624: THEN
2625: t_dtl_attributes(l_att_cnt).value :=
2626: t_attr_info(i).attribute10;
2627: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE11')
2628: THEN
2629: t_dtl_attributes(l_att_cnt).value :=
2630: t_attr_info(i).attribute11;
2631: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE12')
2627: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE11')
2628: THEN
2629: t_dtl_attributes(l_att_cnt).value :=
2630: t_attr_info(i).attribute11;
2631: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE12')
2632: THEN
2633: t_dtl_attributes(l_att_cnt).value :=
2634: t_attr_info(i).attribute12;
2635: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE13')
2631: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE12')
2632: THEN
2633: t_dtl_attributes(l_att_cnt).value :=
2634: t_attr_info(i).attribute12;
2635: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE13')
2636: THEN
2637: t_dtl_attributes(l_att_cnt).value :=
2638: t_attr_info(i).attribute13;
2639: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE14')
2635: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE13')
2636: THEN
2637: t_dtl_attributes(l_att_cnt).value :=
2638: t_attr_info(i).attribute13;
2639: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE14')
2640: THEN
2641: t_dtl_attributes(l_att_cnt).value :=
2642: t_attr_info(i).attribute14;
2643: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE15')
2639: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE14')
2640: THEN
2641: t_dtl_attributes(l_att_cnt).value :=
2642: t_attr_info(i).attribute14;
2643: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE15')
2644: THEN
2645: t_dtl_attributes(l_att_cnt).value :=
2646: t_attr_info(i).attribute15;
2647: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE16')
2643: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE15')
2644: THEN
2645: t_dtl_attributes(l_att_cnt).value :=
2646: t_attr_info(i).attribute15;
2647: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE16')
2648: THEN
2649: t_dtl_attributes(l_att_cnt).value :=
2650: t_attr_info(i).attribute16;
2651: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE17')
2647: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE16')
2648: THEN
2649: t_dtl_attributes(l_att_cnt).value :=
2650: t_attr_info(i).attribute16;
2651: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE17')
2652: THEN
2653: t_dtl_attributes(l_att_cnt).value :=
2654: t_attr_info(i).attribute17;
2655: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE18')
2651: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE17')
2652: THEN
2653: t_dtl_attributes(l_att_cnt).value :=
2654: t_attr_info(i).attribute17;
2655: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE18')
2656: THEN
2657: t_dtl_attributes(l_att_cnt).value :=
2658: t_attr_info(i).attribute18;
2659: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE19')
2655: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE18')
2656: THEN
2657: t_dtl_attributes(l_att_cnt).value :=
2658: t_attr_info(i).attribute18;
2659: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE19')
2660: THEN
2661: t_dtl_attributes(l_att_cnt).value :=
2662: t_attr_info(i).attribute19;
2663: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE20')
2659: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE19')
2660: THEN
2661: t_dtl_attributes(l_att_cnt).value :=
2662: t_attr_info(i).attribute19;
2663: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE20')
2664: THEN
2665: t_dtl_attributes(l_att_cnt).value :=
2666: t_attr_info(i).attribute20;
2667: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE21')
2663: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE20')
2664: THEN
2665: t_dtl_attributes(l_att_cnt).value :=
2666: t_attr_info(i).attribute20;
2667: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE21')
2668: THEN
2669: t_dtl_attributes(l_att_cnt).value :=
2670: t_attr_info(i).attribute21;
2671: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE22')
2667: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE21')
2668: THEN
2669: t_dtl_attributes(l_att_cnt).value :=
2670: t_attr_info(i).attribute21;
2671: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE22')
2672: THEN
2673: t_dtl_attributes(l_att_cnt).value :=
2674: t_attr_info(i).attribute22;
2675: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE23')
2671: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE22')
2672: THEN
2673: t_dtl_attributes(l_att_cnt).value :=
2674: t_attr_info(i).attribute22;
2675: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE23')
2676: THEN
2677: t_dtl_attributes(l_att_cnt).value :=
2678: t_attr_info(i).attribute23;
2679: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE24')
2675: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE23')
2676: THEN
2677: t_dtl_attributes(l_att_cnt).value :=
2678: t_attr_info(i).attribute23;
2679: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE24')
2680: THEN
2681: t_dtl_attributes(l_att_cnt).value :=
2682: t_attr_info(i).attribute24;
2683: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE25')
2679: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE24')
2680: THEN
2681: t_dtl_attributes(l_att_cnt).value :=
2682: t_attr_info(i).attribute24;
2683: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE25')
2684: THEN
2685: t_dtl_attributes(l_att_cnt).value :=
2686: t_attr_info(i).attribute25;
2687: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE26')
2683: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE25')
2684: THEN
2685: t_dtl_attributes(l_att_cnt).value :=
2686: t_attr_info(i).attribute25;
2687: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE26')
2688: THEN
2689: t_dtl_attributes(l_att_cnt).value :=
2690: t_attr_info(i).attribute26;
2691: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE27')
2687: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE26')
2688: THEN
2689: t_dtl_attributes(l_att_cnt).value :=
2690: t_attr_info(i).attribute26;
2691: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE27')
2692: THEN
2693: t_dtl_attributes(l_att_cnt).value :=
2694: t_attr_info(i).attribute27;
2695: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE28')
2691: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE27')
2692: THEN
2693: t_dtl_attributes(l_att_cnt).value :=
2694: t_attr_info(i).attribute27;
2695: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE28')
2696: THEN
2697: t_dtl_attributes(l_att_cnt).value :=
2698: t_attr_info(i).attribute28;
2699: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE29')
2695: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE28')
2696: THEN
2697: t_dtl_attributes(l_att_cnt).value :=
2698: t_attr_info(i).attribute28;
2699: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE29')
2700: THEN
2701: t_dtl_attributes(l_att_cnt).value :=
2702: t_attr_info(i).attribute29;
2703: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE30')
2699: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE29')
2700: THEN
2701: t_dtl_attributes(l_att_cnt).value :=
2702: t_attr_info(i).attribute29;
2703: ELSIF (hxc_generic_retrieval_pkg.g_field_mappings_table(MAP).ATTRIBUTE = 'ATTRIBUTE30')
2704: THEN
2705: t_dtl_attributes(l_att_cnt).value :=
2706: t_attr_info(i).attribute30;
2707: END IF;