DBA Data[Home] [Help]

APPS.PO_HEADERS_SV1 dependencies on PO_HEADERS_SV1

Line 1: PACKAGE BODY PO_HEADERS_SV1 as

1: PACKAGE BODY PO_HEADERS_SV1 as
2: /* $Header: POXPOH1B.pls 120.9.12020000.2 2013/02/11 01:13:13 vegajula ship $*/
3:
4: /*Added Log Messages as part of bug 12405805 */
5: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;

Line 6: g_log_head CONSTANT VARCHAR2(50) :='po.plsql.PO_HEADERS_SV1';

2: /* $Header: POXPOH1B.pls 120.9.12020000.2 2013/02/11 01:13:13 vegajula ship $*/
3:
4: /*Added Log Messages as part of bug 12405805 */
5: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;
6: g_log_head CONSTANT VARCHAR2(50) :='po.plsql.PO_HEADERS_SV1';
7:
8:
9: /*===========================================================================
10:

Line 111: X_encumbered := po_headers_sv1.get_po_encumbered(X_po_header_id);

107: (X_type_lookup_code = 'CONTRACT') ) then
108:
109: X_progress := '005';
110:
111: X_encumbered := po_headers_sv1.get_po_encumbered(X_po_header_id);
112:
113: /* If the PO is encumbered, it has to be cancelled */
114:
115: if X_encumbered then

Line 165: --PO_HEADERS_SV1.delete_po calls this procedure to determine

161: WHERE po_header_id = X_po_header_id
162: AND nvl(encumbered_flag,'N') <> 'N';
163:
164: --BUG 3230237
165: --PO_HEADERS_SV1.delete_po calls this procedure to determine
166: --if a PO can be deleted. We need to prevent encumbered
167: --BPAs from getting deleted.
168: --AND distribution_type <> 'AGREEMENT'; --
169:

Line 218: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_HEADERS_SV1.delete_children';

214: l_deleted_line_list PO_TBL_NUMBER;
215: l_deleted_dist_list PO_TBL_NUMBER;
216: d_pos NUMBER := 10;
217: l_api_name CONSTANT VARCHAR2(30) := 'delete_children';
218: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_HEADERS_SV1.delete_children';
219: BEGIN
220: IF (PO_LOG.d_proc) THEN
221: PO_LOG.proc_begin(d_module); PO_LOG.proc_begin(d_module,'X_type_lookup_code', X_type_lookup_code);
222: PO_LOG.proc_begin(d_module,'X_po_header_id', X_po_header_id);

Line 325: -- po_headers_sv1.delete_this_release (X_po_header_id);

321: -- (X_type_lookup_code = 'BLANKET')) then
322: --
323: -- X_progress := '030';
324: -- --dbms_output.put_line('Before Delete all releases');
325: -- po_headers_sv1.delete_this_release (X_po_header_id);
326: --
327: -- end if;
328: --
329:

Line 371: -- PO_HEADERS_SV1.validate_delete_document

367:
368: --
369: -- If the calling source is HTML then we need not do the validations as we
370: -- would have already performed these validations in
371: -- PO_HEADERS_SV1.validate_delete_document
372: IF p_skip_validation = 'Y' THEN
373: x_progress := '012';
374: x_allow_delete := TRUE;
375: ELSE

Line 424: po_headers_sv1.delete_children(X_po_header_id, X_type_lookup_code);

420: fnd_attached_documents2_pkg.delete_attachments('PO_HEADERS',
421: x_po_header_id,
422: '', '', '', '', 'Y');
423:
424: po_headers_sv1.delete_children(X_po_header_id, X_type_lookup_code);
425:
426: -- delete uda data start
427: PO_MOD_CONTROL_PVT.delete_uda_data(
428: p_draft_id => -1,

Line 526: PROCEDURE NAME: insert_po()- Moved to po_headers_sv11

522: END delete_this_release;
523:
524: /*===========================================================================
525:
526: PROCEDURE NAME: insert_po()- Moved to po_headers_sv11
527: ===========================================================================*/
528:
529: /*===========================================================================
530:

Line 592: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_HEADERS_SV1.validate_delete_document';

588: IS
589: l_some_dists_reserved_flag VARCHAR2(1) := 'N';
590: d_pos NUMBER := 10;
591: l_api_name CONSTANT VARCHAR2(30) := 'validate_delete_document';
592: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_HEADERS_SV1.validate_delete_document';
593: BEGIN
594: IF (PO_LOG.d_proc) THEN
595: PO_LOG.proc_begin(d_module); PO_LOG.proc_begin(d_module,'p_doc_type', p_doc_type); PO_LOG.proc_begin(d_module,'p_doc_header_id', p_doc_header_id); PO_LOG.proc_begin(d_module,'p_doc_approved_date', p_doc_approved_date);
596: PO_LOG.proc_begin(d_module,'p_auth_status', p_auth_status); PO_LOG.proc_begin(d_module,'p_style_disp_name', p_style_disp_name);

Line 646: -- PO_HEADERS_SV1.validate_delete_document should be called to check if the

642: -----------------------------------------------------------------------------
643: --Start of Comments
644: --Name: delete_document
645: --Pre-reqs:
646: -- PO_HEADERS_SV1.validate_delete_document should be called to check if the
647: -- the delete action is a valid action on the document.
648: --Modifies:
649: -- None
650: --Locks:

Line 686: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_HEADERS_SV1.delete_document';

682: l_msg_count NUMBER;
683: l_msg_data VARCHAR2(2000);
684: d_pos NUMBER := 0;
685: l_api_name CONSTANT VARCHAR2(30) := 'delete_document';
686: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_HEADERS_SV1.delete_document';
687:
688: BEGIN
689: IF (PO_LOG.d_proc) THEN
690: PO_LOG.proc_begin(d_module); PO_LOG.proc_begin(d_module,'p_doc_type', p_doc_type); PO_LOG.proc_begin(d_module,'p_doc_header_id', p_doc_header_id); PO_LOG.proc_begin(d_module,'p_ga_flag', p_ga_flag);

Line 747: END IF;--PO_HEADERS_SV1.delete_po

743:
744: ELSE
745: d_pos := 80;
746: RAISE FND_API.g_exc_error;
747: END IF;--PO_HEADERS_SV1.delete_po
748:
749: IF (PO_LOG.d_proc) THEN
750: PO_LOG.proc_end(d_module);
751: END IF;

Line 962: END PO_HEADERS_SV1;

958: RAISE;
959: END delete_events_entities;
960:
961: --
962: END PO_HEADERS_SV1;