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