DBA Data[Home] [Help]

APPS.PO_PDOI_ERR_UTL dependencies on PO_TBL_NUMBER

Line 441: l_intf_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

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();

Line 442: l_intf_line_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:

Line 443: l_intf_line_loc_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

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

Line 444: l_intf_dist_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

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

Line 445: l_intf_price_diff_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

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;

Line 591: p_table_id_tbl IN PO_TBL_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,

Line 592: x_intf_header_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

Line 593: x_intf_line_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

Line 594: x_intf_line_loc_id_tbl OUT NOCOPY PO_TBL_NUMBER,

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:

Line 595: x_intf_dist_id_tbl OUT NOCOPY PO_TBL_NUMBER,

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;

Line 596: x_intf_price_diff_id_tbl OUT NOCOPY 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;
600: l_seq PO_TBL_NUMBER := PO_TBL_NUMBER();

Line 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;

Line 613: x_intf_header_id_tbl := PO_TBL_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();

Line 614: x_intf_line_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:

Line 615: x_intf_line_loc_id_tbl := PO_TBL_NUMBER();

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;

Line 616: x_intf_dist_id_tbl := PO_TBL_NUMBER();

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:

Line 617: x_intf_price_diff_id_tbl := PO_TBL_NUMBER();

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);