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_DOCUMENT_ACTION_CHECK dependencies on PO_DOCUMENT_ACTION_CHECK

Line 1: PACKAGE BODY PO_DOCUMENT_ACTION_CHECK AS

1: PACKAGE BODY PO_DOCUMENT_ACTION_CHECK AS
2: -- $Header: POXDACKB.pls 120.8.12010000.1 2008/07/24 14:12:09 appldev ship $
3:
4: -- Private package constants
5:

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

2: -- $Header: POXDACKB.pls 120.8.12010000.1 2008/07/24 14:12:09 appldev ship $
3:
4: -- Private package constants
5:
6: g_pkg_name CONSTANT varchar2(30) := 'PO_DOCUMENT_ACTION_CHECK';
7: g_log_head CONSTANT VARCHAR2(50) := 'po.plsql.'|| g_pkg_name || '.';
8:
9: g_chktype_DOC_TOTAL_LIMIT CONSTANT VARCHAR2(20) := 'DOC TOTAL LIMIT';
10: g_chktype_ACCOUNT_LIMIT CONSTANT VARCHAR2(20) := 'ACCOUNT LIMIT';

Line 164: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_CHECK.approve_status_check';

160: )
161: IS
162:
163: d_progress NUMBER;
164: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_CHECK.approve_status_check';
165:
166: l_allowed_states PO_DOCUMENT_ACTION_UTIL.doc_state_rec_type;
167: l_doc_state_ok BOOLEAN;
168: l_ret_sts VARCHAR2(1);

Line 272: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_CHECK.reject_status_check';

268: )
269: IS
270:
271: d_progress NUMBER;
272: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_CHECK.reject_status_check';
273:
274: l_allowed_states PO_DOCUMENT_ACTION_UTIL.doc_state_rec_type;
275: l_doc_state_ok BOOLEAN;
276: l_ret_sts VARCHAR2(1);

Line 375: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_CHECK.authority_check';

371: )
372: IS
373:
374: d_progress NUMBER;
375: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_CHECK.authority_check';
376:
377: l_authority_verified VARCHAR2(1);
378: l_action_to_verify VARCHAR2(30) := PO_DOCUMENT_ACTION_PVT.g_doc_action_APPROVE;
379: l_auth_checks_to_do AUTH_CHECK_TYPES_REC;

Line 730: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_CHECK.authority_checks_setup';

726: )
727: IS
728:
729: d_progress NUMBER;
730: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_CHECK.authority_checks_setup';
731:
732: l_ret_sts VARCHAR2(1);
733: d_msg VARCHAR2(200);
734:

Line 1035: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_CHECK.check_doc_total_limit';

1031: )
1032: IS
1033:
1034: d_progress NUMBER;
1035: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_CHECK.check_doc_total_limit';
1036:
1037: l_result NUMBER;
1038: l_amt_limit_nvl NUMBER;
1039:

Line 1153: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_CHECK.check_location_limit';

1149: )
1150: IS
1151:
1152: d_progress NUMBER;
1153: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_CHECK.check_location_limit';
1154:
1155: l_result NUMBER;
1156:
1157: BEGIN

Line 1252: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_CHECK.check_account_limit';

1248: )
1249: IS
1250:
1251: d_progress NUMBER;
1252: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_CHECK.check_account_limit';
1253:
1254: l_sql VARCHAR2(8000);
1255: l_result NUMBER;
1256: l_ret_sts VARCHAR2(1);

Line 1367: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_CHECK.check_account_exists';

1363: )
1364: IS
1365:
1366: d_progress NUMBER;
1367: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_CHECK.check_account_exists';
1368:
1369: l_sql VARCHAR2(8000);
1370: l_result NUMBER;
1371: l_ret_sts VARCHAR2(1);

Line 1487: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_CHECK.check_item_limit';

1483: l_result NUMBER;
1484: l_ret_sts VARCHAR2(1);
1485:
1486: d_progress NUMBER;
1487: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_CHECK.check_item_limit';
1488:
1489: d_msg VARCHAR2(200);
1490:
1491: BEGIN

Line 1604: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_CHECK.check_category_limit';

1600: l_result NUMBER;
1601: l_ret_sts VARCHAR2(1);
1602:
1603: d_progress NUMBER;
1604: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_CHECK.check_category_limit';
1605:
1606: d_msg VARCHAR2(200);
1607:
1608: BEGIN

Line 1719: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_CHECK.get_range_limit_sql';

1715:
1716: -- x_range_check_sql buffer size should be at least 8000 characters.
1717:
1718: d_progress NUMBER;
1719: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_CHECK.get_range_limit_sql';
1720:
1721: l_flex_segment_where VARCHAR2(4000);
1722:
1723: l_sum_col VARCHAR2(80);

Line 1907: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_CHECK.get_range_exists_sql';

1903: l_ret_sts VARCHAR2(1);
1904:
1905: d_msg VARCHAR2(200);
1906: d_progress NUMBER;
1907: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_CHECK.get_range_exists_sql';
1908:
1909: BEGIN
1910:
1911: d_progress := 0;

Line 2058: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_CHECK.get_flex_where_sql';

2054: l_segment VARCHAR2(160);
2055:
2056: d_msg VARCHAR2(200);
2057: d_progress NUMBER;
2058: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_CHECK.get_flex_where_sql';
2059:
2060: BEGIN
2061:
2062: d_progress := 0;

Line 2189: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_CHECK.populate_session_gt';

2185: )
2186: IS
2187:
2188: d_progress NUMBER;
2189: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_CHECK.populate_session_gt';
2190:
2191: BEGIN
2192:
2193: d_progress := 0;

Line 2438: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_CHECK.decode_result';

2434: )
2435: IS
2436:
2437: l_result NUMBER;
2438: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_CHECK.decode_result';
2439: BEGIN
2440:
2441: IF (PO_LOG.d_proc) THEN
2442: PO_LOG.proc_begin(d_module);

Line 2471: END PO_DOCUMENT_ACTION_CHECK;

2467:
2468: END decode_result;
2469:
2470:
2471: END PO_DOCUMENT_ACTION_CHECK;