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.4.12010000.1 2008/07/24 14:12:17 appldev ship $
3:
4: -- Private package constants
5:

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

2: -- $Header: POXDAULB.pls 120.4.12010000.1 2008/07/24 14:12:17 appldev 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 85: , p_allowed_states IN PO_DOCUMENT_ACTION_UTIL.DOC_STATE_REC_TYPE

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

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

101:
102: l_state_found BOOLEAN;
103:
104: d_progress NUMBER;
105: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_UTIL.check_doc_state';
106:
107: l_ret_sts VARCHAR2(1);
108: l_ret_val BOOLEAN;
109:

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

490: )
491: IS
492:
493: d_progress NUMBER;
494: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_UTIL.get_doc_preparer_id';
495:
496: l_ret_sts VARCHAR2(1);
497:
498: BEGIN

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

603: )
604: IS
605:
606: d_progress NUMBER;
607: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_UTIL.get_employee_info';
608:
609: l_temp_var VARCHAR2(1);
610:
611: BEGIN

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

742: )
743: IS
744:
745: d_progress NUMBER;
746: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_UTIL.get_employee_id';
747:
748: BEGIN
749:
750: d_progress := 0;

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

833: l_creation_date PO_HEADERS.creation_date%TYPE;
834: l_revision_num PO_HEADERS.revision_num%TYPE;
835:
836: d_progress NUMBER;
837: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_UTIL.change_doc_auth_state';
838:
839: BEGIN
840:
841: d_progress := 0;

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

1053: )
1054: IS
1055:
1056: d_progress NUMBER;
1057: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_UTIL.handle_ctl_action_history';
1058: d_msg VARCHAR2(200);
1059:
1060: l_ret_sts VARCHAR2(1);
1061:

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

1374:
1375: l_ret_sts VARCHAR2(1);
1376:
1377: d_progress NUMBER;
1378: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_UTIL.handle_auth_action_history';
1379:
1380: BEGIN
1381:
1382: d_progress := 0;

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

1630: l_msg_count NUMBER;
1631: l_msg_data VARCHAR2(2000);
1632:
1633: d_progress NUMBER;
1634: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_UTIL.update_doc_auth_status';
1635:
1636: BEGIN
1637:
1638: d_progress := 0;

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

1923: )
1924: IS
1925:
1926: d_progress NUMBER;
1927: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_UTIL.update_doc_notifications';
1928:
1929: BEGIN
1930:
1931: d_progress := 0;

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

2030:
2031: l_sequence_num PO_ACTION_HISTORY.sequence_num%TYPE;
2032:
2033: d_progress NUMBER;
2034: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_UTIL.insert_auth_action_history';
2035:
2036: BEGIN
2037:
2038: d_progress := 0;

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

2158: )
2159: IS
2160:
2161: d_progress NUMBER;
2162: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_UTIL.update_auth_action_history';
2163:
2164: BEGIN
2165:
2166: d_progress := 0;

Line 2217: END PO_DOCUMENT_ACTION_UTIL;

2213:
2214: END update_auth_action_history;
2215:
2216:
2217: END PO_DOCUMENT_ACTION_UTIL;