437: p_price_diffs IN PO_PDOI_TYPES.price_diffs_rec_type := NULL
438: )
439: IS
440:
441: l_intf_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
442: l_intf_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
443: l_intf_line_loc_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
444: l_intf_dist_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
445: l_intf_price_diff_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
438: )
439: IS
440:
441: l_intf_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
442: l_intf_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
443: l_intf_line_loc_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
444: l_intf_dist_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
445: l_intf_price_diff_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
446:
439: IS
440:
441: l_intf_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
442: l_intf_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
443: l_intf_line_loc_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
444: l_intf_dist_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
445: l_intf_price_diff_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
446:
447: d_api_name CONSTANT VARCHAR2(30) := 'process_val_type_errors';
440:
441: l_intf_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
442: l_intf_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
443: l_intf_line_loc_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
444: l_intf_dist_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
445: l_intf_price_diff_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
446:
447: d_api_name CONSTANT VARCHAR2(30) := 'process_val_type_errors';
448: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
441: l_intf_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
442: l_intf_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
443: l_intf_line_loc_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
444: l_intf_dist_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
445: l_intf_price_diff_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
446:
447: d_api_name CONSTANT VARCHAR2(30) := 'process_val_type_errors';
448: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
449: d_position NUMBER;
587: --End of Comments
588: ------------------------------------------------------------------------
589: PROCEDURE derive_parent_interface_ids
590: ( p_table_name IN VARCHAR2,
591: p_table_id_tbl IN PO_TBL_NUMBER,
592: x_intf_header_id_tbl OUT NOCOPY PO_TBL_NUMBER,
593: x_intf_line_id_tbl OUT NOCOPY PO_TBL_NUMBER,
594: x_intf_line_loc_id_tbl OUT NOCOPY PO_TBL_NUMBER,
595: x_intf_dist_id_tbl OUT NOCOPY PO_TBL_NUMBER,
588: ------------------------------------------------------------------------
589: PROCEDURE derive_parent_interface_ids
590: ( p_table_name IN VARCHAR2,
591: p_table_id_tbl IN PO_TBL_NUMBER,
592: x_intf_header_id_tbl OUT NOCOPY PO_TBL_NUMBER,
593: x_intf_line_id_tbl OUT NOCOPY PO_TBL_NUMBER,
594: x_intf_line_loc_id_tbl OUT NOCOPY PO_TBL_NUMBER,
595: x_intf_dist_id_tbl OUT NOCOPY PO_TBL_NUMBER,
596: x_intf_price_diff_id_tbl OUT NOCOPY PO_TBL_NUMBER
589: PROCEDURE derive_parent_interface_ids
590: ( p_table_name IN VARCHAR2,
591: p_table_id_tbl IN PO_TBL_NUMBER,
592: x_intf_header_id_tbl OUT NOCOPY PO_TBL_NUMBER,
593: x_intf_line_id_tbl OUT NOCOPY PO_TBL_NUMBER,
594: x_intf_line_loc_id_tbl OUT NOCOPY PO_TBL_NUMBER,
595: x_intf_dist_id_tbl OUT NOCOPY PO_TBL_NUMBER,
596: x_intf_price_diff_id_tbl OUT NOCOPY PO_TBL_NUMBER
597: ) IS
590: ( p_table_name IN VARCHAR2,
591: p_table_id_tbl IN PO_TBL_NUMBER,
592: x_intf_header_id_tbl OUT NOCOPY PO_TBL_NUMBER,
593: x_intf_line_id_tbl OUT NOCOPY PO_TBL_NUMBER,
594: x_intf_line_loc_id_tbl OUT NOCOPY PO_TBL_NUMBER,
595: x_intf_dist_id_tbl OUT NOCOPY PO_TBL_NUMBER,
596: x_intf_price_diff_id_tbl OUT NOCOPY PO_TBL_NUMBER
597: ) IS
598:
591: p_table_id_tbl IN PO_TBL_NUMBER,
592: x_intf_header_id_tbl OUT NOCOPY PO_TBL_NUMBER,
593: x_intf_line_id_tbl OUT NOCOPY PO_TBL_NUMBER,
594: x_intf_line_loc_id_tbl OUT NOCOPY PO_TBL_NUMBER,
595: x_intf_dist_id_tbl OUT NOCOPY PO_TBL_NUMBER,
596: x_intf_price_diff_id_tbl OUT NOCOPY PO_TBL_NUMBER
597: ) IS
598:
599: l_key NUMBER;
592: x_intf_header_id_tbl OUT NOCOPY PO_TBL_NUMBER,
593: x_intf_line_id_tbl OUT NOCOPY PO_TBL_NUMBER,
594: x_intf_line_loc_id_tbl OUT NOCOPY PO_TBL_NUMBER,
595: x_intf_dist_id_tbl OUT NOCOPY PO_TBL_NUMBER,
596: x_intf_price_diff_id_tbl OUT NOCOPY PO_TBL_NUMBER
597: ) IS
598:
599: l_key NUMBER;
600: l_seq PO_TBL_NUMBER := PO_TBL_NUMBER();
596: x_intf_price_diff_id_tbl OUT NOCOPY PO_TBL_NUMBER
597: ) IS
598:
599: l_key NUMBER;
600: l_seq PO_TBL_NUMBER := PO_TBL_NUMBER();
601:
602: d_api_name CONSTANT VARCHAR2(30) := 'derive_parent_interface_ids';
603: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
604: d_position NUMBER;
609: IF (PO_LOG.d_proc) THEN
610: PO_LOG.proc_begin(d_module, 'table_name', p_table_name);
611: END IF;
612:
613: x_intf_header_id_tbl := PO_TBL_NUMBER();
614: x_intf_line_id_tbl := PO_TBL_NUMBER();
615: x_intf_line_loc_id_tbl := PO_TBL_NUMBER();
616: x_intf_dist_id_tbl := PO_TBL_NUMBER();
617: x_intf_price_diff_id_tbl := PO_TBL_NUMBER();
610: PO_LOG.proc_begin(d_module, 'table_name', p_table_name);
611: END IF;
612:
613: x_intf_header_id_tbl := PO_TBL_NUMBER();
614: x_intf_line_id_tbl := PO_TBL_NUMBER();
615: x_intf_line_loc_id_tbl := PO_TBL_NUMBER();
616: x_intf_dist_id_tbl := PO_TBL_NUMBER();
617: x_intf_price_diff_id_tbl := PO_TBL_NUMBER();
618:
611: END IF;
612:
613: x_intf_header_id_tbl := PO_TBL_NUMBER();
614: x_intf_line_id_tbl := PO_TBL_NUMBER();
615: x_intf_line_loc_id_tbl := PO_TBL_NUMBER();
616: x_intf_dist_id_tbl := PO_TBL_NUMBER();
617: x_intf_price_diff_id_tbl := PO_TBL_NUMBER();
618:
619: l_key := PO_CORE_S.get_session_gt_nextval;
612:
613: x_intf_header_id_tbl := PO_TBL_NUMBER();
614: x_intf_line_id_tbl := PO_TBL_NUMBER();
615: x_intf_line_loc_id_tbl := PO_TBL_NUMBER();
616: x_intf_dist_id_tbl := PO_TBL_NUMBER();
617: x_intf_price_diff_id_tbl := PO_TBL_NUMBER();
618:
619: l_key := PO_CORE_S.get_session_gt_nextval;
620:
613: x_intf_header_id_tbl := PO_TBL_NUMBER();
614: x_intf_line_id_tbl := PO_TBL_NUMBER();
615: x_intf_line_loc_id_tbl := PO_TBL_NUMBER();
616: x_intf_dist_id_tbl := PO_TBL_NUMBER();
617: x_intf_price_diff_id_tbl := PO_TBL_NUMBER();
618:
619: l_key := PO_CORE_S.get_session_gt_nextval;
620:
621: l_seq.extend (p_table_id_tbl.COUNT);