DBA Data[Home] [Help]

APPS.PO_REQAPPROVAL_ACTION dependencies on PO_DOCUMENT_TYPES

Line 658: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;

654: l_doc_string varchar2(200);
655: l_preparer_user_name varchar2(100);
656: doc_manager_exception exception;
657:
658: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;
659: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;
660: l_document_id NUMBER;
661:
662: BEGIN

Line 659: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;

655: l_preparer_user_name varchar2(100);
656: doc_manager_exception exception;
657:
658: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;
659: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;
660: l_document_id NUMBER;
661:
662: BEGIN
663:

Line 1427: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;

1423: FUNCTION StateCheckApprove(itemtype VARCHAR2, itemkey VARCHAR2) RETURN VARCHAR2 is
1424:
1425: --
1426:
1427: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;
1428: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;
1429: l_document_id NUMBER;
1430:
1431: l_ret_sts VARCHAR2(1);

Line 1428: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;

1424:
1425: --
1426:
1427: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;
1428: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;
1429: l_document_id NUMBER;
1430:
1431: l_ret_sts VARCHAR2(1);
1432: l_exc_msg VARCHAR2(2000);

Line 1524: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;

1520: FUNCTION StateCheckReject(itemtype VARCHAR2, itemkey VARCHAR2) RETURN VARCHAR2 is
1521:
1522: --
1523:
1524: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;
1525: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;
1526: l_document_id NUMBER;
1527:
1528: l_ret_sts VARCHAR2(1);

Line 1525: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;

1521:
1522: --
1523:
1524: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;
1525: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;
1526: l_document_id NUMBER;
1527:
1528: l_ret_sts VARCHAR2(1);
1529: l_exc_msg VARCHAR2(2000);

Line 1946: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;

1942: RETURN VARCHAR2
1943: IS
1944:
1945: --
1946: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;
1947: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;
1948: l_document_id NUMBER;
1949: l_note PO_ACTION_HISTORY.note%TYPE;
1950: l_approval_path_id NUMBER;

Line 1947: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;

1943: IS
1944:
1945: --
1946: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;
1947: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;
1948: l_document_id NUMBER;
1949: l_note PO_ACTION_HISTORY.note%TYPE;
1950: l_approval_path_id NUMBER;
1951:

Line 2062: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;

2058: --
2059: FUNCTION ApproveAndForward(itemtype VARCHAR2, itemkey VARCHAR2) RETURN VARCHAR2 is
2060:
2061: --
2062: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;
2063: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;
2064: l_document_id NUMBER;
2065: l_note PO_ACTION_HISTORY.note%TYPE;
2066: l_approval_path_id NUMBER;

Line 2063: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;

2059: FUNCTION ApproveAndForward(itemtype VARCHAR2, itemkey VARCHAR2) RETURN VARCHAR2 is
2060:
2061: --
2062: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;
2063: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;
2064: l_document_id NUMBER;
2065: l_note PO_ACTION_HISTORY.note%TYPE;
2066: l_approval_path_id NUMBER;
2067: l_forward_to_id NUMBER;

Line 2173: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;

2169: FUNCTION ForwardDocInProcess(itemtype VARCHAR2, itemkey VARCHAR2) RETURN VARCHAR2 is
2170:
2171: --
2172:
2173: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;
2174: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;
2175: l_document_id NUMBER;
2176: l_note PO_ACTION_HISTORY.note%TYPE;
2177: l_approval_path_id NUMBER;

Line 2174: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;

2170:
2171: --
2172:
2173: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;
2174: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;
2175: l_document_id NUMBER;
2176: l_note PO_ACTION_HISTORY.note%TYPE;
2177: l_approval_path_id NUMBER;
2178: l_forward_to_id NUMBER;

Line 2283: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;

2279: FUNCTION ForwardDocPreApproved(itemtype VARCHAR2, itemkey VARCHAR2) RETURN VARCHAR2 is
2280:
2281: --
2282:
2283: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;
2284: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;
2285: l_document_id NUMBER;
2286: l_note PO_ACTION_HISTORY.note%TYPE;
2287: l_approval_path_id NUMBER;

Line 2284: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;

2280:
2281: --
2282:
2283: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;
2284: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;
2285: l_document_id NUMBER;
2286: l_note PO_ACTION_HISTORY.note%TYPE;
2287: l_approval_path_id NUMBER;
2288: l_forward_to_id NUMBER;

Line 2394: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;

2390: --
2391: FUNCTION RejectDoc(itemtype VARCHAR2, itemkey VARCHAR2) RETURN VARCHAR2 is
2392:
2393: --
2394: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;
2395: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;
2396: l_document_id NUMBER;
2397: l_note PO_ACTION_HISTORY.note%TYPE;
2398: l_approval_path_id NUMBER;

Line 2395: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;

2391: FUNCTION RejectDoc(itemtype VARCHAR2, itemkey VARCHAR2) RETURN VARCHAR2 is
2392:
2393: --
2394: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;
2395: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;
2396: l_document_id NUMBER;
2397: l_note PO_ACTION_HISTORY.note%TYPE;
2398: l_approval_path_id NUMBER;
2399:

Line 2546: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;

2542: FUNCTION VerifyAuthority(itemtype VARCHAR2, itemkey VARCHAR2) RETURN VARCHAR2 is
2543:
2544: --
2545:
2546: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;
2547: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;
2548: l_document_id NUMBER;
2549: l_employee_id NUMBER;
2550:

Line 2547: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;

2543:
2544: --
2545:
2546: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;
2547: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;
2548: l_document_id NUMBER;
2549: l_employee_id NUMBER;
2550:
2551: l_ret_sts VARCHAR2(1);

Line 2644: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;

2640: --
2641: FUNCTION OpenDocumentState(itemtype VARCHAR2, itemkey VARCHAR2) RETURN VARCHAR2 is
2642:
2643: --
2644: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;
2645: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;
2646: l_document_id NUMBER;
2647:
2648: l_ret_code VARCHAR2(25);

Line 2645: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;

2641: FUNCTION OpenDocumentState(itemtype VARCHAR2, itemkey VARCHAR2) RETURN VARCHAR2 is
2642:
2643: --
2644: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;
2645: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;
2646: l_document_id NUMBER;
2647:
2648: l_ret_code VARCHAR2(25);
2649: l_ret_sts VARCHAR2(1);

Line 2755: l_doc_type PO_DOCUMENT_TYPES.document_type_code%TYPE;

2751: -- varchar2(200) was unable to hold the debug message
2752:
2753: x_progress varchar2(1000);
2754:
2755: l_doc_type PO_DOCUMENT_TYPES.document_type_code%TYPE;
2756: l_doc_subtype PO_DOCUMENT_TYPES.document_subtype%TYPE;
2757: l_doc_id NUMBER;
2758: l_employee_id NUMBER;
2759: l_po_return_code VARCHAR2(10);

Line 2756: l_doc_subtype PO_DOCUMENT_TYPES.document_subtype%TYPE;

2752:
2753: x_progress varchar2(1000);
2754:
2755: l_doc_type PO_DOCUMENT_TYPES.document_type_code%TYPE;
2756: l_doc_subtype PO_DOCUMENT_TYPES.document_subtype%TYPE;
2757: l_doc_id NUMBER;
2758: l_employee_id NUMBER;
2759: l_po_return_code VARCHAR2(10);
2760: l_online_report_id NUMBER;