DBA Data[Home] [Help]

APPS.PO_PDOI_UTL dependencies on PO_TBL_NUMBER

Line 12: ( p_intf_header_id_tbl IN PO_TBL_NUMBER

8: ----------- PRIVATE PROCEDURES PROTOTYPE --------------
9: -------------------------------------------------------
10:
11: PROCEDURE set_doc_has_errors
12: ( p_intf_header_id_tbl IN PO_TBL_NUMBER
13: );
14:
15: -------------------------------------------------------
16: -------------- PUBLIC PROCEDURES ----------------------

Line 175: p_id_tbl IN PO_TBL_NUMBER,

171: --End of Comments
172: ------------------------------------------------------------------------
173: PROCEDURE reject_headers_intf
174: ( p_id_param_type IN VARCHAR2,
175: p_id_tbl IN PO_TBL_NUMBER,
176: p_cascade IN VARCHAR2
177: ) IS
178:
179: d_api_name CONSTANT VARCHAR2(30) := 'reject_headers_intf';

Line 258: p_id_tbl IN PO_TBL_NUMBER,

254: --End of Comments
255: ------------------------------------------------------------------------
256: PROCEDURE reject_lines_intf
257: ( p_id_param_type IN VARCHAR2,
258: p_id_tbl IN PO_TBL_NUMBER,
259: p_cascade IN VARCHAR2
260: ) IS
261:
262: d_api_name CONSTANT VARCHAR2(30) := 'reject_lines_intf';

Line 266: l_intf_line_id_tbl PO_TBL_NUMBER;

262: d_api_name CONSTANT VARCHAR2(30) := 'reject_lines_intf';
263: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
264: d_position NUMBER;
265:
266: l_intf_line_id_tbl PO_TBL_NUMBER;
267: l_intf_header_id_tbl PO_TBL_NUMBER;
268: BEGIN
269: d_position := 0;
270:

Line 267: l_intf_header_id_tbl PO_TBL_NUMBER;

263: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
264: d_position NUMBER;
265:
266: l_intf_line_id_tbl PO_TBL_NUMBER;
267: l_intf_header_id_tbl PO_TBL_NUMBER;
268: BEGIN
269: d_position := 0;
270:
271: IF (PO_LOG.d_proc) THEN

Line 376: p_id_tbl IN PO_TBL_NUMBER,

372: --End of Comments
373: ------------------------------------------------------------------------
374: PROCEDURE reject_line_locations_intf
375: ( p_id_param_type IN VARCHAR2,
376: p_id_tbl IN PO_TBL_NUMBER,
377: p_cascade IN VARCHAR2
378: ) IS
379:
380: d_api_name CONSTANT VARCHAR2(30) := 'reject_line_locations_intf';

Line 384: l_intf_line_loc_id_tbl PO_TBL_NUMBER;

380: d_api_name CONSTANT VARCHAR2(30) := 'reject_line_locations_intf';
381: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
382: d_position NUMBER;
383:
384: l_intf_line_loc_id_tbl PO_TBL_NUMBER;
385: l_intf_header_id_tbl PO_TBL_NUMBER;
386:
387: BEGIN
388: d_position := 0;

Line 385: l_intf_header_id_tbl PO_TBL_NUMBER;

381: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
382: d_position NUMBER;
383:
384: l_intf_line_loc_id_tbl PO_TBL_NUMBER;
385: l_intf_header_id_tbl PO_TBL_NUMBER;
386:
387: BEGIN
388: d_position := 0;
389:

Line 480: p_id_tbl IN PO_TBL_NUMBER

476: --End of Comments
477: ------------------------------------------------------------------------
478: PROCEDURE reject_distributions_intf
479: ( p_id_param_type IN VARCHAR2,
480: p_id_tbl IN PO_TBL_NUMBER
481: ) IS
482:
483: d_api_name CONSTANT VARCHAR2(30) := 'reject_distributions_intf';
484: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 487: l_intf_header_id_tbl PO_TBL_NUMBER;

483: d_api_name CONSTANT VARCHAR2(30) := 'reject_distributions_intf';
484: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
485: d_position NUMBER;
486:
487: l_intf_header_id_tbl PO_TBL_NUMBER;
488: BEGIN
489: d_position := 0;
490:
491: IF (PO_LOG.d_proc) THEN

Line 566: p_id_tbl IN PO_TBL_NUMBER

562: --End of Comments
563: ------------------------------------------------------------------------
564: PROCEDURE reject_price_diff_intf
565: ( p_id_param_type IN VARCHAR2,
566: p_id_tbl IN PO_TBL_NUMBER
567: ) IS
568:
569: d_api_name CONSTANT VARCHAR2(30) := 'reject_price_diff_intf';
570: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 573: l_intf_header_id_tbl PO_TBL_NUMBER;

569: d_api_name CONSTANT VARCHAR2(30) := 'reject_price_diff_intf';
570: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
571: d_position NUMBER;
572:
573: l_intf_header_id_tbl PO_TBL_NUMBER;
574:
575: BEGIN
576: d_position := 0;
577: IF (PO_LOG.d_proc) THEN

Line 657: p_id_tbl IN PO_TBL_NUMBER

653: --End of Comments
654: ------------------------------------------------------------------------
655: PROCEDURE reject_attr_values_intf
656: ( p_id_param_type IN VARCHAR2,
657: p_id_tbl IN PO_TBL_NUMBER
658: ) IS
659:
660: d_api_name CONSTANT VARCHAR2(30) := 'reject_attr_values_intf';
661: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 664: l_intf_header_id_tbl PO_TBL_NUMBER;

660: d_api_name CONSTANT VARCHAR2(30) := 'reject_attr_values_intf';
661: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
662: d_position NUMBER;
663:
664: l_intf_header_id_tbl PO_TBL_NUMBER;
665:
666: BEGIN
667: d_position := 0;
668:

Line 743: p_id_tbl IN PO_TBL_NUMBER

739: --End of Comments
740: ------------------------------------------------------------------------
741: PROCEDURE reject_attr_values_tlp_intf
742: ( p_id_param_type IN VARCHAR2,
743: p_id_tbl IN PO_TBL_NUMBER
744: ) IS
745:
746: d_api_name CONSTANT VARCHAR2(30) := 'reject_attr_values_tlp_intf';
747: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 750: l_intf_header_id_tbl PO_TBL_NUMBER;

746: d_api_name CONSTANT VARCHAR2(30) := 'reject_attr_values_tlp_intf';
747: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
748: d_position NUMBER;
749:
750: l_intf_header_id_tbl PO_TBL_NUMBER;
751:
752: BEGIN
753: d_position := 0;
754:

Line 853: p_id_tbl => PO_TBL_NUMBER(p_interface_header_id),

849:
850: -- reject interface records
851: reject_headers_intf
852: ( p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_HEADER_ID,
853: p_id_tbl => PO_TBL_NUMBER(p_interface_header_id),
854: p_cascade => FND_API.G_TRUE
855: );
856:
857: d_position := 10;

Line 1111: ( p_intf_header_id_tbl IN PO_TBL_NUMBER

1107: --OUT:
1108: --End of Comments
1109: ------------------------------------------------------------------------
1110: PROCEDURE set_doc_has_errors
1111: ( p_intf_header_id_tbl IN PO_TBL_NUMBER
1112: ) IS
1113:
1114: d_api_name CONSTANT VARCHAR2(30) := 'set_doc_has_errors';
1115: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';