APPS.PO_REQ_LINES_SV dependencies on PO_REQ_LINES_SV

Line 1: PACKAGE BODY PO_REQ_LINES_SV as

1: PACKAGE BODY PO_REQ_LINES_SV as
2: /* $Header: POXRQL1B.pls 120.20.12020000.8 2013/04/18 12:38:39 rparise ship $ */
3: /*========================== po_req_lines_sv ============================*/
4:
5:

Line 3: /*========================== po_req_lines_sv ============================*/

1: PACKAGE BODY PO_REQ_LINES_SV as
2: /* $Header: POXRQL1B.pls 120.20.12020000.8 2013/04/18 12:38:39 rparise ship $ */
3: /*========================== po_req_lines_sv ============================*/
4:
5:
6: -- Constants :
7: -- Read the profile option that enables/disables the debug log

Line 83: po_req_lines_sv.delete_children(X_line_id, X_mode);

79: */
80:
81: x_progress := '020';
82:
83: po_req_lines_sv.delete_children(X_line_id, X_mode);
84:
85: -- dbms_output.put_line('After call to delete children');
86:
87: /*

Line 713: l_api_name CONSTANT VARCHAR(60) := 'po.plsql.PO_REQ_LINES_SV.REMOVE_REQ_FROM_PO';

709: l_req_dist_id PO_TBL_NUMBER;
710: l_return_status VARCHAR2(30);
711: l_msg_data VARCHAR2(3000);
712: l_msg_count NUMBER;
713: l_api_name CONSTANT VARCHAR(60) := 'po.plsql.PO_REQ_LINES_SV.REMOVE_REQ_FROM_PO';
714:
715: --
716:
717: BEGIN

Line 1533: l_api_name CONSTANT VARCHAR(60) := 'po.plsql.PO_REQ_LINES_SV.UPDATE_REQ_FOR_LINKED_PO_COUNT';

1529:
1530:
1531: l_clm_document VARCHAR2(1);
1532:
1533: l_api_name CONSTANT VARCHAR(60) := 'po.plsql.PO_REQ_LINES_SV.UPDATE_REQ_FOR_LINKED_PO_COUNT';
1534: x_progress VARCHAR2(3) := NULL;
1535:
1536: BEGIN
1537:

Line 1880: ( p_pkg_name => 'PO_REQ_LINES_SV',

1876: EXCEPTION WHEN OTHERS THEN
1877:
1878: RAISE;
1879: PO_MESSAGE_S.add_exc_msg
1880: ( p_pkg_name => 'PO_REQ_LINES_SV',
1881: p_procedure_name => 'update_req_for_linked_po_count' || '.' || x_progress
1882: );
1883:
1884: END update_req_for_linked_po_count;

Line 1899: l_api_name CONSTANT VARCHAR(60) := 'po.plsql.PO_REQ_LINES_SV.update_par_draft_line_status';

1895: (p_reqLine_ids IN PO_TBL_NUMBER,
1896: p_reqHeader_ids IN PO_TBL_NUMBER
1897: )
1898: IS
1899: l_api_name CONSTANT VARCHAR(60) := 'po.plsql.PO_REQ_LINES_SV.update_par_draft_line_status';
1900: x_progress VARCHAR2(3) := '000';
1901: BEGIN
1902: x_progress := 10;
1903:

Line 1952: l_api_name CONSTANT VARCHAR(60) := 'po.plsql.PO_REQ_LINES_SV.UPDATE_REQS_IN_POOL_FLAG';

1948: ===========================================================================*/
1949: PROCEDURE update_reqs_in_pool_flag
1950: IS
1951:
1952: l_api_name CONSTANT VARCHAR(60) := 'po.plsql.PO_REQ_LINES_SV.UPDATE_REQS_IN_POOL_FLAG';
1953: x_progress VARCHAR2(3) := '000';
1954:
1955: l_eligible_reqLine_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;
1956: l_eligible_reqHeader_ids PO_TBL_NUMBER := PO_TBL_NUMBER() ;

Line 2058: ( p_pkg_name => 'PO_REQ_LINES_SV',

2054: EXCEPTION WHEN OTHERS THEN
2055:
2056: x_progress := 100;
2057: PO_MESSAGE_S.add_exc_msg
2058: ( p_pkg_name => 'PO_REQ_LINES_SV',
2059: p_procedure_name => 'update_reqs_in_pool_flag' || '.' || x_progress
2060: );
2061: DELETE po_session_gt WHERE index_char1 = 'UNLINKED_REQUISITIONS';
2062:

Line 2065: END po_req_lines_sv;

2061: DELETE po_session_gt WHERE index_char1 = 'UNLINKED_REQUISITIONS';
2062:
2063: END update_reqs_in_pool_flag ;
2064:
2065: END po_req_lines_sv;