DBA Data[Home] [Help]

APPS.PO_PDOI_ERR_UTL dependencies on PO_TBL_NUMBER

Line 426: l_intf_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

422: p_price_diffs IN PO_PDOI_TYPES.price_diffs_rec_type := NULL
423: )
424: IS
425:
426: l_intf_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
427: l_intf_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
428: l_intf_line_loc_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
429: l_intf_dist_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
430: l_intf_price_diff_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

Line 427: l_intf_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

423: )
424: IS
425:
426: l_intf_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
427: l_intf_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
428: l_intf_line_loc_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
429: l_intf_dist_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
430: l_intf_price_diff_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
431:

Line 428: l_intf_line_loc_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

424: IS
425:
426: l_intf_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
427: l_intf_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
428: l_intf_line_loc_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
429: l_intf_dist_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
430: l_intf_price_diff_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
431:
432: d_api_name CONSTANT VARCHAR2(30) := 'process_val_type_errors';

Line 429: l_intf_dist_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

425:
426: l_intf_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
427: l_intf_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
428: l_intf_line_loc_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
429: l_intf_dist_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
430: l_intf_price_diff_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
431:
432: d_api_name CONSTANT VARCHAR2(30) := 'process_val_type_errors';
433: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 430: l_intf_price_diff_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

426: l_intf_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
427: l_intf_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
428: l_intf_line_loc_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
429: l_intf_dist_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
430: l_intf_price_diff_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
431:
432: d_api_name CONSTANT VARCHAR2(30) := 'process_val_type_errors';
433: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
434: d_position NUMBER;

Line 576: p_table_id_tbl IN PO_TBL_NUMBER,

572: --End of Comments
573: ------------------------------------------------------------------------
574: PROCEDURE derive_parent_interface_ids
575: ( p_table_name IN VARCHAR2,
576: p_table_id_tbl IN PO_TBL_NUMBER,
577: x_intf_header_id_tbl OUT NOCOPY PO_TBL_NUMBER,
578: x_intf_line_id_tbl OUT NOCOPY PO_TBL_NUMBER,
579: x_intf_line_loc_id_tbl OUT NOCOPY PO_TBL_NUMBER,
580: x_intf_dist_id_tbl OUT NOCOPY PO_TBL_NUMBER,

Line 577: x_intf_header_id_tbl OUT NOCOPY PO_TBL_NUMBER,

573: ------------------------------------------------------------------------
574: PROCEDURE derive_parent_interface_ids
575: ( p_table_name IN VARCHAR2,
576: p_table_id_tbl IN PO_TBL_NUMBER,
577: x_intf_header_id_tbl OUT NOCOPY PO_TBL_NUMBER,
578: x_intf_line_id_tbl OUT NOCOPY PO_TBL_NUMBER,
579: x_intf_line_loc_id_tbl OUT NOCOPY PO_TBL_NUMBER,
580: x_intf_dist_id_tbl OUT NOCOPY PO_TBL_NUMBER,
581: x_intf_price_diff_id_tbl OUT NOCOPY PO_TBL_NUMBER

Line 578: x_intf_line_id_tbl OUT NOCOPY PO_TBL_NUMBER,

574: PROCEDURE derive_parent_interface_ids
575: ( p_table_name IN VARCHAR2,
576: p_table_id_tbl IN PO_TBL_NUMBER,
577: x_intf_header_id_tbl OUT NOCOPY PO_TBL_NUMBER,
578: x_intf_line_id_tbl OUT NOCOPY PO_TBL_NUMBER,
579: x_intf_line_loc_id_tbl OUT NOCOPY PO_TBL_NUMBER,
580: x_intf_dist_id_tbl OUT NOCOPY PO_TBL_NUMBER,
581: x_intf_price_diff_id_tbl OUT NOCOPY PO_TBL_NUMBER
582: ) IS

Line 579: x_intf_line_loc_id_tbl OUT NOCOPY PO_TBL_NUMBER,

575: ( p_table_name IN VARCHAR2,
576: p_table_id_tbl IN PO_TBL_NUMBER,
577: x_intf_header_id_tbl OUT NOCOPY PO_TBL_NUMBER,
578: x_intf_line_id_tbl OUT NOCOPY PO_TBL_NUMBER,
579: x_intf_line_loc_id_tbl OUT NOCOPY PO_TBL_NUMBER,
580: x_intf_dist_id_tbl OUT NOCOPY PO_TBL_NUMBER,
581: x_intf_price_diff_id_tbl OUT NOCOPY PO_TBL_NUMBER
582: ) IS
583:

Line 580: x_intf_dist_id_tbl OUT NOCOPY PO_TBL_NUMBER,

576: p_table_id_tbl IN PO_TBL_NUMBER,
577: x_intf_header_id_tbl OUT NOCOPY PO_TBL_NUMBER,
578: x_intf_line_id_tbl OUT NOCOPY PO_TBL_NUMBER,
579: x_intf_line_loc_id_tbl OUT NOCOPY PO_TBL_NUMBER,
580: x_intf_dist_id_tbl OUT NOCOPY PO_TBL_NUMBER,
581: x_intf_price_diff_id_tbl OUT NOCOPY PO_TBL_NUMBER
582: ) IS
583:
584: l_key NUMBER;

Line 581: x_intf_price_diff_id_tbl OUT NOCOPY PO_TBL_NUMBER

577: x_intf_header_id_tbl OUT NOCOPY PO_TBL_NUMBER,
578: x_intf_line_id_tbl OUT NOCOPY PO_TBL_NUMBER,
579: x_intf_line_loc_id_tbl OUT NOCOPY PO_TBL_NUMBER,
580: x_intf_dist_id_tbl OUT NOCOPY PO_TBL_NUMBER,
581: x_intf_price_diff_id_tbl OUT NOCOPY PO_TBL_NUMBER
582: ) IS
583:
584: l_key NUMBER;
585: l_seq PO_TBL_NUMBER := PO_TBL_NUMBER();

Line 585: l_seq PO_TBL_NUMBER := PO_TBL_NUMBER();

581: x_intf_price_diff_id_tbl OUT NOCOPY PO_TBL_NUMBER
582: ) IS
583:
584: l_key NUMBER;
585: l_seq PO_TBL_NUMBER := PO_TBL_NUMBER();
586:
587: d_api_name CONSTANT VARCHAR2(30) := 'derive_parent_interface_ids';
588: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
589: d_position NUMBER;

Line 598: x_intf_header_id_tbl := PO_TBL_NUMBER();

594: IF (PO_LOG.d_proc) THEN
595: PO_LOG.proc_begin(d_module, 'table_name', p_table_name);
596: END IF;
597:
598: x_intf_header_id_tbl := PO_TBL_NUMBER();
599: x_intf_line_id_tbl := PO_TBL_NUMBER();
600: x_intf_line_loc_id_tbl := PO_TBL_NUMBER();
601: x_intf_dist_id_tbl := PO_TBL_NUMBER();
602: x_intf_price_diff_id_tbl := PO_TBL_NUMBER();

Line 599: x_intf_line_id_tbl := PO_TBL_NUMBER();

595: PO_LOG.proc_begin(d_module, 'table_name', p_table_name);
596: END IF;
597:
598: x_intf_header_id_tbl := PO_TBL_NUMBER();
599: x_intf_line_id_tbl := PO_TBL_NUMBER();
600: x_intf_line_loc_id_tbl := PO_TBL_NUMBER();
601: x_intf_dist_id_tbl := PO_TBL_NUMBER();
602: x_intf_price_diff_id_tbl := PO_TBL_NUMBER();
603:

Line 600: x_intf_line_loc_id_tbl := PO_TBL_NUMBER();

596: END IF;
597:
598: x_intf_header_id_tbl := PO_TBL_NUMBER();
599: x_intf_line_id_tbl := PO_TBL_NUMBER();
600: x_intf_line_loc_id_tbl := PO_TBL_NUMBER();
601: x_intf_dist_id_tbl := PO_TBL_NUMBER();
602: x_intf_price_diff_id_tbl := PO_TBL_NUMBER();
603:
604: l_key := PO_CORE_S.get_session_gt_nextval;

Line 601: x_intf_dist_id_tbl := PO_TBL_NUMBER();

597:
598: x_intf_header_id_tbl := PO_TBL_NUMBER();
599: x_intf_line_id_tbl := PO_TBL_NUMBER();
600: x_intf_line_loc_id_tbl := PO_TBL_NUMBER();
601: x_intf_dist_id_tbl := PO_TBL_NUMBER();
602: x_intf_price_diff_id_tbl := PO_TBL_NUMBER();
603:
604: l_key := PO_CORE_S.get_session_gt_nextval;
605:

Line 602: x_intf_price_diff_id_tbl := PO_TBL_NUMBER();

598: x_intf_header_id_tbl := PO_TBL_NUMBER();
599: x_intf_line_id_tbl := PO_TBL_NUMBER();
600: x_intf_line_loc_id_tbl := PO_TBL_NUMBER();
601: x_intf_dist_id_tbl := PO_TBL_NUMBER();
602: x_intf_price_diff_id_tbl := PO_TBL_NUMBER();
603:
604: l_key := PO_CORE_S.get_session_gt_nextval;
605:
606: l_seq.extend (p_table_id_tbl.COUNT);