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_REQAPPROVAL_ACTION dependencies on PO_ACTION_HISTORY

Line 1168: l_note po_action_history.note%TYPE;

1164: l_preparer_user_name varchar2(100);
1165: doc_manager_exception exception;
1166:
1167: /* Bug 12360278 */
1168: l_note po_action_history.note%TYPE;
1169: l_document_type varchar2(25);
1170: /*Bug 12360278 */
1171:
1172:

Line 1939: If the document is self approved, add a new blank row in PO_ACTION_HISTORY

1935:
1936: END DocCompleteCheck;
1937:
1938: /*
1939: If the document is self approved, add a new blank row in PO_ACTION_HISTORY
1940: for doc mgr call.
1941: */
1942: PROCEDURE InsertHistForOwnerApprove (itemtype VARCHAR2,
1943: itemkey VARCHAR2,

Line 1949: l_action_code PO_ACTION_HISTORY.ACTION_CODE%TYPE;

1945: p_document_type VARCHAR2,
1946: p_document_subtype VARCHAR2) IS
1947: pragma AUTONOMOUS_TRANSACTION;
1948:
1949: l_action_code PO_ACTION_HISTORY.ACTION_CODE%TYPE;
1950: l_sequence_num NUMBER;
1951: l_employee_id NUMBER;
1952: l_object_rev_num NUMBER;
1953: l_approval_path_id NUMBER;

Line 1965: -- get data from last entry in po_action_history

1961: IF (g_po_wf_debug = 'Y') THEN
1962: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1963: END IF;
1964:
1965: -- get data from last entry in po_action_history
1966: SELECT sequence_num,
1967: action_code,
1968: object_revision_num,
1969: approval_path_id

Line 1974: FROM po_action_history

1970: INTO l_sequence_num,
1971: l_action_code,
1972: l_object_rev_num,
1973: l_approval_path_id
1974: FROM po_action_history
1975: WHERE object_id = p_document_id
1976: AND object_type_code = p_document_type
1977: AND sequence_num = (SELECT max(sequence_num)
1978: FROM po_action_history

Line 1978: FROM po_action_history

1974: FROM po_action_history
1975: WHERE object_id = p_document_id
1976: AND object_type_code = p_document_type
1977: AND sequence_num = (SELECT max(sequence_num)
1978: FROM po_action_history
1979: WHERE object_id = p_document_id
1980: AND Object_Type_Code = P_Document_Type
1981: AND object_sub_type_code = p_document_subtype)
1982: AND Object_Sub_Type_Code = P_Document_Subtype;

Line 1990: -- if last entry into po_action_history is submit or reserve, then

1986: IF (g_po_wf_debug = 'Y') THEN
1987: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, x_progress);
1988: END IF;
1989:
1990: -- if last entry into po_action_history is submit or reserve, then
1991: -- req is self-approved. Insert approval entry.
1992: --Bug 13444730 Adding Signed action. In case of Signed take employee_id corresponding to Submit.
1993: if (l_action_code in ('SUBMIT', 'RESERVE', 'NO ACTION','SIGNED')) THEN
1994:

Line 1995: -- get data from last SUBMIT entry in po_action_history (req submission)

1991: -- req is self-approved. Insert approval entry.
1992: --Bug 13444730 Adding Signed action. In case of Signed take employee_id corresponding to Submit.
1993: if (l_action_code in ('SUBMIT', 'RESERVE', 'NO ACTION','SIGNED')) THEN
1994:
1995: -- get data from last SUBMIT entry in po_action_history (req submission)
1996:
1997: /*Bug 12701382 - In case of Timeout employee id corresponding to last Approve action should be taken.
1998: In case of timeout and document is self approved, employee id corresponding to Submit action should be taken.*/
1999:

Line 2006: FROM po_action_history

2002: BEGIN
2003:
2004: SELECT employee_id
2005: INTO l_employee_id
2006: FROM po_action_history
2007: WHERE object_id = p_document_id
2008: AND object_type_code = p_document_type
2009: AND sequence_num = (SELECT max(sequence_num)
2010: FROM po_action_history

Line 2010: FROM po_action_history

2006: FROM po_action_history
2007: WHERE object_id = p_document_id
2008: AND object_type_code = p_document_type
2009: AND sequence_num = (SELECT max(sequence_num)
2010: FROM po_action_history
2011: WHERE object_id = p_document_id
2012: AND action_code = 'APPROVE'
2013: AND Object_Type_Code = P_Document_Type
2014: AND Object_Sub_Type_Code = P_Document_Subtype)

Line 2023: FROM po_action_history

2019: WHEN No_Data_Found THEN
2020:
2021: SELECT employee_id
2022: INTO l_employee_id
2023: FROM po_action_history
2024: WHERE object_id = p_document_id
2025: AND object_type_code = p_document_type
2026: AND sequence_num = (SELECT max(sequence_num)
2027: FROM po_action_history

Line 2027: FROM po_action_history

2023: FROM po_action_history
2024: WHERE object_id = p_document_id
2025: AND object_type_code = p_document_type
2026: AND sequence_num = (SELECT max(sequence_num)
2027: FROM po_action_history
2028: WHERE object_id = p_document_id
2029: AND action_code = 'SUBMIT'
2030: AND Object_Type_Code = P_Document_Type
2031: AND Object_Sub_Type_Code = P_Document_Subtype)

Line 2040: FROM po_action_history

2036: ElSE
2037:
2038: SELECT employee_id
2039: INTO l_employee_id
2040: FROM po_action_history
2041: WHERE object_id = p_document_id
2042: AND object_type_code = p_document_type
2043: AND sequence_num = (SELECT max(sequence_num)
2044: FROM Po_Action_History

Line 2044: FROM Po_Action_History

2040: FROM po_action_history
2041: WHERE object_id = p_document_id
2042: AND object_type_code = p_document_type
2043: AND sequence_num = (SELECT max(sequence_num)
2044: FROM Po_Action_History
2045: WHERE object_id = p_document_id
2046: AND action_code = decode(l_action_code, 'SIGNED','SUBMIT',l_action_code) --Bug 13444730
2047: AND Object_Type_Code = P_Document_Type
2048: AND Object_Sub_Type_Code = P_Document_Subtype)

Line 2059: INSERT into PO_ACTION_HISTORY

2055: IF (g_po_wf_debug = 'Y') THEN
2056: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, x_progress);
2057: End If;
2058:
2059: INSERT into PO_ACTION_HISTORY
2060: (object_id,
2061: object_type_code,
2062: object_sub_type_code,
2063: sequence_num,

Line 2131: l_note PO_ACTION_HISTORY.note%TYPE;

2127: --
2128: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;
2129: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;
2130: l_document_id NUMBER;
2131: l_note PO_ACTION_HISTORY.note%TYPE;
2132: l_approval_path_id NUMBER;
2133:
2134:
2135: l_ret_sts VARCHAR2(1);

Line 2247: l_note PO_ACTION_HISTORY.note%TYPE;

2243: --
2244: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;
2245: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;
2246: l_document_id NUMBER;
2247: l_note PO_ACTION_HISTORY.note%TYPE;
2248: l_approval_path_id NUMBER;
2249: l_forward_to_id NUMBER;
2250:
2251: l_ret_sts VARCHAR2(1);

Line 2261: /* The action FORWARD_DOCUMENT creates a new row in PO_ACTION_HISTORY

2257: BEGIN
2258:
2259: --
2260:
2261: /* The action FORWARD_DOCUMENT creates a new row in PO_ACTION_HISTORY
2262: ** with an action_code that is NULL and it sets the status on the
2263: ** DOCUMENT to 'PRE-APPROVED' (PO_HEADERS, REQs or RELEASES).
2264: */
2265:

Line 2358: l_note PO_ACTION_HISTORY.note%TYPE;

2354:
2355: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;
2356: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;
2357: l_document_id NUMBER;
2358: l_note PO_ACTION_HISTORY.note%TYPE;
2359: l_approval_path_id NUMBER;
2360: l_forward_to_id NUMBER;
2361:
2362: l_ret_sts VARCHAR2(1);

Line 2372: /* The action FORWARD_DOCUMENT creates a new row in PO_ACTION_HISTORY

2368: BEGIN
2369:
2370: --
2371:
2372: /* The action FORWARD_DOCUMENT creates a new row in PO_ACTION_HISTORY
2373: ** with an action_code that is NULL and it sets the status on the
2374: ** DOCUMENT to 'IN PROCESS' (PO_HEADERS, REQs or RELEASES).
2375: */
2376:

Line 2468: l_note PO_ACTION_HISTORY.note%TYPE;

2464:
2465: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;
2466: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;
2467: l_document_id NUMBER;
2468: l_note PO_ACTION_HISTORY.note%TYPE;
2469: l_approval_path_id NUMBER;
2470: l_forward_to_id NUMBER;
2471:
2472: l_ret_sts VARCHAR2(1);

Line 2483: /* The action FORWARD_DOCUMENT creates a new row in PO_ACTION_HISTORY

2479: BEGIN
2480:
2481: --
2482:
2483: /* The action FORWARD_DOCUMENT creates a new row in PO_ACTION_HISTORY
2484: ** with an action_code that is NULL and it sets the status on the
2485: ** DOCUMENT to 'PRE-APPROVED' (PO_HEADERS, REQs or RELEASES).
2486: */
2487:

Line 2579: l_note PO_ACTION_HISTORY.note%TYPE;

2575: --
2576: l_document_type PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;
2577: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;
2578: l_document_id NUMBER;
2579: l_note PO_ACTION_HISTORY.note%TYPE;
2580: l_approval_path_id NUMBER;
2581:
2582: l_ret_sts VARCHAR2(1);
2583: l_exc_msg VARCHAR2(2000);