DBA Data[Home] [Help]

APPS.PO_PAR_REQ_CREATE_UTIL dependencies on PO_PAR_REQ_CREATE_UTIL

Line 1: PACKAGE BODY po_par_req_create_util AS

1: PACKAGE BODY po_par_req_create_util AS
2: /* $Header: PO_PAR_REQ_CREATE_UTIL.plb 120.1.12020000.10 2013/05/10 10:04:30 akyanama noship $ */
3: d_pkg_name CONSTANT VARCHAR2(50) :=
4: po_log.Get_package_base('PO_PAR_REQ_CREATE_UTIL');
5: PROCEDURE Create_dummy_req(p_po_header_id IN NUMBER,

Line 2: /* $Header: PO_PAR_REQ_CREATE_UTIL.plb 120.1.12020000.10 2013/05/10 10:04:30 akyanama noship $ */

1: PACKAGE BODY po_par_req_create_util AS
2: /* $Header: PO_PAR_REQ_CREATE_UTIL.plb 120.1.12020000.10 2013/05/10 10:04:30 akyanama noship $ */
3: d_pkg_name CONSTANT VARCHAR2(50) :=
4: po_log.Get_package_base('PO_PAR_REQ_CREATE_UTIL');
5: PROCEDURE Create_dummy_req(p_po_header_id IN NUMBER,
6: p_par_draft_id IN NUMBER,

Line 4: po_log.Get_package_base('PO_PAR_REQ_CREATE_UTIL');

1: PACKAGE BODY po_par_req_create_util AS
2: /* $Header: PO_PAR_REQ_CREATE_UTIL.plb 120.1.12020000.10 2013/05/10 10:04:30 akyanama noship $ */
3: d_pkg_name CONSTANT VARCHAR2(50) :=
4: po_log.Get_package_base('PO_PAR_REQ_CREATE_UTIL');
5: PROCEDURE Create_dummy_req(p_po_header_id IN NUMBER,
6: p_par_draft_id IN NUMBER,
7: x_par_req_header_id OUT nocopy NUMBER)
8: IS

Line 15: l_module VARCHAR2(40) := 'PO.PLSQL.PO_PAR_REQ_CREATE_UTIL';

11: l_req_line_id NUMBER;
12: l_req_distribution_id NUMBER;
13: l_po_line_id_tbl PO_TBL_NUMBER;
14: l_count NUMBER;
15: l_module VARCHAR2(40) := 'PO.PLSQL.PO_PAR_REQ_CREATE_UTIL';
16: l_api_name VARCHAR2(30) := 'CREATE_DUMMY_REQ';
17: l_progress VARCHAR2(3) := '000';
18: l_vendor_id NUMBER;
19: l_vendor_site_id NUMBER;

Line 549: l_progress := 'po_par_req_create_util.create_dummy_req_wf Start';

545: l_par_draft_id NUMBER;
546: l_document_id NUMBER;
547: x_par_req_header_id NUMBER;
548: BEGIN
549: l_progress := 'po_par_req_create_util.create_dummy_req_wf Start';
550:
551: po_wf_debug_pkg.Insert_debug(itemtype, itemkey, l_progress);
552:
553: l_par_draft_id := po_wf_util_pkg.Getitemattrnumber (itemtype => itemtype,

Line 571: l_progress := 'po_par_req_create_util.create_dummy_req_wf Req created is '

567: po_wf_util_pkg.Setitemattrnumber (itemtype => itemtype, itemkey => itemkey
568: ,
569: aname => 'PAR_REQ_HEADER_ID', avalue => x_par_req_header_id);
570:
571: l_progress := 'po_par_req_create_util.create_dummy_req_wf Req created is '
572: || x_par_req_header_id;
573:
574: po_wf_debug_pkg.Insert_debug(itemtype, itemkey, l_progress);
575:

Line 578: l_progress := 'po_par_req_create_util.create_dummy_req_wf End';

574: po_wf_debug_pkg.Insert_debug(itemtype, itemkey, l_progress);
575:
576: resultout := wf_engine.eng_completed;
577:
578: l_progress := 'po_par_req_create_util.create_dummy_req_wf End';
579:
580: po_wf_debug_pkg.Insert_debug(itemtype, itemkey, l_progress);
581: END create_dummy_req_wf;
582: PROCEDURE par_reserve_funds(p_par_req_header_id IN NUMBER,

Line 593: l_module VARCHAR2(40) := 'PO.PLSQL.PO_PAR_REQ_CREATE_UTIL';

589: L_DETAILED_RESULTS PO_FCOUT_TYPE :=NULL;
590: l_fc_result_status VARCHAR2(1) := '';
591: L_PO_RETURN_CODE VARCHAR2(25) := '';
592: p_preparer_id NUMBER := NULL;
593: l_module VARCHAR2(40) := 'PO.PLSQL.PO_PAR_REQ_CREATE_UTIL';
594: l_api_name VARCHAR2(30) := 'PAR_RESERVE_FUNDS';
595:
596: BEGIN
597: l_progress := '001';

Line 746: END po_par_req_create_util;

742: WHERE requisition_header_id = l_par_req_header_id;
743:
744: COMMIT;
745: END par_req_status_update;
746: END po_par_req_create_util;