APPS.PO_DOCUMENT_ACTION_UTIL dependencies on PO_DOCUMENT_ACTION_UTIL

Line 1: PACKAGE BODY PO_DOCUMENT_ACTION_UTIL AS

1: PACKAGE BODY PO_DOCUMENT_ACTION_UTIL AS
2: -- $Header: POXDAULB.pls 120.15.12020000.7 2013/04/09 10:12:47 inagdeo ship $
3:
4: -- Private package constants
5:

Line 6: g_pkg_name CONSTANT varchar2(30) := 'PO_DOCUMENT_ACTION_UTIL';

2: -- $Header: POXDAULB.pls 120.15.12020000.7 2013/04/09 10:12:47 inagdeo ship $
3:
4: -- Private package constants
5:
6: g_pkg_name CONSTANT varchar2(30) := 'PO_DOCUMENT_ACTION_UTIL';
7: g_log_head CONSTANT VARCHAR2(50) := 'po.plsql.'|| g_pkg_name || '.';
8:
9:
10: -- Forward Declare Private Methods

Line 84: , p_allowed_states IN PO_DOCUMENT_ACTION_UTIL.DOC_STATE_REC_TYPE

80: p_document_id IN NUMBER
81: , p_document_type IN VARCHAR2
82: , p_line_id IN NUMBER DEFAULT NULL
83: , p_shipment_id IN NUMBER DEFAULT NULL
84: , p_allowed_states IN PO_DOCUMENT_ACTION_UTIL.DOC_STATE_REC_TYPE
85: , x_return_status OUT NOCOPY VARCHAR2
86: ) RETURN BOOLEAN
87: IS
88: BEGIN

Line 105: , p_allowed_states IN PO_DOCUMENT_ACTION_UTIL.DOC_STATE_REC_TYPE

101: , p_document_type IN VARCHAR2
102: , p_draft_id IN NUMBER --CLM Apprvl
103: , p_line_id IN NUMBER DEFAULT NULL
104: , p_shipment_id IN NUMBER DEFAULT NULL
105: , p_allowed_states IN PO_DOCUMENT_ACTION_UTIL.DOC_STATE_REC_TYPE
106: , x_return_status OUT NOCOPY VARCHAR2
107: ) RETURN BOOLEAN
108: IS
109:

Line 125: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_UTIL.check_doc_state';

121:
122: l_state_found BOOLEAN;
123:
124: d_progress NUMBER;
125: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_UTIL.check_doc_state';
126:
127: l_ret_sts VARCHAR2(1);
128: l_ret_val BOOLEAN;
129:

Line 594: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_UTIL.get_doc_preparer_id';

590: )
591: IS
592:
593: d_progress NUMBER;
594: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_UTIL.get_doc_preparer_id';
595:
596: l_ret_sts VARCHAR2(1);
597:
598: BEGIN

Line 732: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_UTIL.get_employee_info';

728: )
729: IS
730:
731: d_progress NUMBER;
732: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_UTIL.get_employee_info';
733:
734: l_temp_var VARCHAR2(1);
735:
736: BEGIN

Line 871: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_UTIL.get_employee_id';

867: )
868: IS
869:
870: d_progress NUMBER;
871: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_UTIL.get_employee_id';
872:
873: BEGIN
874:
875: d_progress := 0;

Line 997: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_UTIL.change_doc_auth_state';

993: l_creation_date PO_HEADERS.creation_date%TYPE;
994: l_revision_num PO_HEADERS.revision_num%TYPE;
995:
996: d_progress NUMBER;
997: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_UTIL.change_doc_auth_state';
998:
999: BEGIN
1000:
1001: d_progress := 0;

Line 1235: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_UTIL.handle_ctl_action_history';

1231: )
1232: IS
1233:
1234: d_progress NUMBER;
1235: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_UTIL.handle_ctl_action_history';
1236: d_msg VARCHAR2(200);
1237:
1238: l_ret_sts VARCHAR2(1);
1239:

Line 1557: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_UTIL.handle_auth_action_history';

1553:
1554: l_ret_sts VARCHAR2(1);
1555:
1556: d_progress NUMBER;
1557: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_UTIL.handle_auth_action_history';
1558:
1559: BEGIN
1560:
1561: d_progress := 0;

Line 1826: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_UTIL.update_doc_auth_status';

1822: l_msg_count NUMBER;
1823: l_msg_data VARCHAR2(2000);
1824:
1825: d_progress NUMBER;
1826: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_UTIL.update_doc_auth_status';
1827:
1828: l_is_clm_document VARCHAR2(1);
1829:
1830: BEGIN

Line 2231: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_UTIL.update_doc_notifications';

2227: )
2228: IS
2229:
2230: d_progress NUMBER;
2231: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_UTIL.update_doc_notifications';
2232:
2233: BEGIN
2234:
2235: d_progress := 0;

Line 2339: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_UTIL.insert_auth_action_history';

2335:
2336: l_sequence_num PO_ACTION_HISTORY.sequence_num%TYPE;
2337:
2338: d_progress NUMBER;
2339: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_UTIL.insert_auth_action_history';
2340:
2341: BEGIN
2342:
2343: d_progress := 0;

Line 2478: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_UTIL.update_auth_action_history';

2474: )
2475: IS
2476:
2477: d_progress NUMBER;
2478: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_UTIL.update_auth_action_history';
2479:
2480: BEGIN
2481:
2482: d_progress := 0;

Line 2869: END PO_DOCUMENT_ACTION_UTIL;

2865: END IF;
2866:
2867: END upd_idv_qty_amt_hdr;
2868:
2869: END PO_DOCUMENT_ACTION_UTIL;