eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_HEADERS_SV1 dependencies on PO_HEADERS

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 19: FROM po_headers

15: PROCEDURE lock_row_for_status_update (x_po_header_id IN NUMBER)
16: IS
17: CURSOR C IS
18: SELECT *
19: FROM po_headers
20: WHERE po_header_id = x_po_header_id
21: FOR UPDATE of po_header_id NOWAIT;
22: Recinfo C%ROWTYPE;
23:

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 365: FROM PO_HEADERS_ALL poh /Bug6632095: using base table instead of view /

361:
362: /* Retrieve PO row_id */
363: SELECT poh.rowid
364: INTO X_rowid
365: FROM PO_HEADERS_ALL poh /*Bug6632095: using base table instead of view */
366: WHERE poh.po_header_id = X_po_header_id;
367:
368: --
369: -- If the calling source is HTML then we need not do the validations as we

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 393: FROM PO_HEADERS_ALL /Bug6632095: using base table instead of view /

389: /*po_notifications_sv1.delete_po_notif (x_type_lookup_code,
390: x_po_header_id); */
391: SELECT wf_item_type,wf_item_key
392: INTO x_item_type,x_item_key
393: FROM PO_HEADERS_ALL /*Bug6632095: using base table instead of view */
394: WHERE po_header_id = x_po_header_id;
395:
396: if ((x_item_type is null) and (x_item_key is null)) then
397: po_approval_reminder_sv.cancel_notif (x_type_lookup_code,

Line 420: fnd_attached_documents2_pkg.delete_attachments('PO_HEADERS',

416: OBJECT_ID = x_po_header_id;
417:
418: /* Delete header attachments */
419:
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);

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 440: po_headers_pkg_s2.delete_row(X_rowid);

436: -- Delete the exhibit details
437: DELETE po_exhibit_details
438: WHERE po_header_id = x_po_header_id;
439:
440: po_headers_pkg_s2.delete_row(X_rowid);
441:
442: if ((X_type_lookup_code = 'STANDARD') or
443: (X_type_lookup_code = 'PLANNED')) then
444:

Line 446: po_headers_sv2.update_req_link(X_po_header_id);

442: if ((X_type_lookup_code = 'STANDARD') or
443: (X_type_lookup_code = 'PLANNED')) then
444:
445: /* UPDATE REQ LINK */
446: po_headers_sv2.update_req_link(X_po_header_id);
447:
448: end if;
449:
450: X_deleted := TRUE;

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 833: SELECT org_id INTO l_org_id FROM po_headers_all WHERE po_header_id = p_doc_id;

829: IF ( p_doc_entity = 'RELEASE' ) THEN
830: SELECT org_id INTO l_org_id FROM po_releases_all WHERE po_release_id = p_doc_id;
831: l_doc_type := g_doc_type_RELEASE;
832: ELSIF(p_doc_entity ='PURCHASE_ORDER' ) THEN
833: SELECT org_id INTO l_org_id FROM po_headers_all WHERE po_header_id = p_doc_id;
834: l_doc_type := g_doc_type_PO;
835: ELSE /*p_doc_entity = 'REQUISITION' */
836: SELECT org_id INTO l_org_id FROM po_requisition_headers_all WHERE requisition_header_id = p_doc_id;
837: l_doc_type := g_doc_type_REQUISITION;

Line 962: END PO_HEADERS_SV1;

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