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.12.12020000.3 2013/02/10 23:35:30 vegajula ship $
3:
4: -- Private package constants
5:

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

2: -- $Header: POXDACKB.pls 120.12.12020000.3 2013/02/10 23:35:30 vegajula 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 23: | PL/SQL body for package: PO_DOCUMENT_ACTION_CHECK

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

173: )
174: IS
175:
176: d_progress NUMBER;
177: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_CHECK.approve_status_check';
178:
179: l_allowed_states PO_DOCUMENT_ACTION_UTIL.doc_state_rec_type;
180: l_doc_state_ok BOOLEAN;
181: l_ret_sts VARCHAR2(1);

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

282: )
283: IS
284:
285: d_progress NUMBER;
286: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_CHECK.reject_status_check';
287:
288: l_allowed_states PO_DOCUMENT_ACTION_UTIL.doc_state_rec_type;
289: l_doc_state_ok BOOLEAN;
290: l_ret_sts VARCHAR2(1);

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

387: )
388: IS
389:
390: d_progress NUMBER;
391: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_CHECK.authority_check';
392:
393: l_authority_verified VARCHAR2(1);
394: l_action_to_verify VARCHAR2(30) := PO_DOCUMENT_ACTION_PVT.g_doc_action_APPROVE;
395: l_auth_checks_to_do AUTH_CHECK_TYPES_REC;

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

742: )
743: IS
744:
745: d_progress NUMBER;
746: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_CHECK.authority_checks_setup';
747:
748: l_ret_sts VARCHAR2(1);
749: d_msg VARCHAR2(200);
750:

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

1047: )
1048: IS
1049:
1050: d_progress NUMBER;
1051: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_CHECK.check_doc_total_limit';
1052:
1053: l_result NUMBER;
1054: l_amt_limit_nvl NUMBER;
1055:

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

1165: )
1166: IS
1167:
1168: d_progress NUMBER;
1169: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_CHECK.check_location_limit';
1170:
1171: l_result NUMBER;
1172:
1173: BEGIN

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

1264: )
1265: IS
1266:
1267: d_progress NUMBER;
1268: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_CHECK.check_account_limit';
1269:
1270: l_sql VARCHAR2(8000);
1271: l_result NUMBER;
1272: l_ret_sts VARCHAR2(1);

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

1379: )
1380: IS
1381:
1382: d_progress NUMBER;
1383: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_CHECK.check_account_exists';
1384:
1385: l_sql VARCHAR2(8000);
1386: l_result NUMBER;
1387: l_ret_sts VARCHAR2(1);

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

1499: l_result NUMBER;
1500: l_ret_sts VARCHAR2(1);
1501:
1502: d_progress NUMBER;
1503: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_CHECK.check_item_limit';
1504:
1505: d_msg VARCHAR2(200);
1506:
1507: BEGIN

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

1616: l_result NUMBER;
1617: l_ret_sts VARCHAR2(1);
1618:
1619: d_progress NUMBER;
1620: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_CHECK.check_category_limit';
1621:
1622: d_msg VARCHAR2(200);
1623:
1624: BEGIN

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

1731:
1732: -- x_range_check_sql buffer size should be at least 8000 characters.
1733:
1734: d_progress NUMBER;
1735: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_CHECK.get_range_limit_sql';
1736:
1737: l_flex_segment_where VARCHAR2(4000);
1738:
1739: l_sum_col VARCHAR2(80);

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

1929: l_ret_sts VARCHAR2(1);
1930:
1931: d_msg VARCHAR2(200);
1932: d_progress NUMBER;
1933: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_CHECK.get_range_exists_sql';
1934:
1935: BEGIN
1936:
1937: d_progress := 0;

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

2081: l_segment VARCHAR2(160);
2082:
2083: d_msg VARCHAR2(200);
2084: d_progress NUMBER;
2085: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_CHECK.get_flex_where_sql';
2086:
2087: BEGIN
2088:
2089: d_progress := 0;

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

2212: )
2213: IS
2214:
2215: d_progress NUMBER;
2216: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_CHECK.populate_session_gt';
2217: --add by Xiao Lv for PO Notification 14-Apr-2009, begin
2218: -------------------------------------------------------------
2219: lv_tax_region VARCHAR2(30);
2220:

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

2488: )
2489: IS
2490:
2491: l_result NUMBER;
2492: d_module VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_ACTION_CHECK.decode_result';
2493: BEGIN
2494:
2495: IF (PO_LOG.d_proc) THEN
2496: PO_LOG.proc_begin(d_module);

Line 2525: END PO_DOCUMENT_ACTION_CHECK;

2521:
2522: END decode_result;
2523:
2524:
2525: END PO_DOCUMENT_ACTION_CHECK;