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

Line 763: -- PO_ACTION_HISTORY

759: --Modifies:
760: -- PO_ACCEPTANCES
761: -- PO_HEADERS_ALL
762: -- PO_LINE_LOCATIONS_ALL
763: -- PO_ACTION_HISTORY
764: --Locks:
765: -- None.
766: --Function:
767: -- This procedure updates the relavant PO tables after the suppliers

Line 2201: -- SQL What:Checks if there is any record in the PO_ACTION_HISTORY with the

2197: l_signatures VARCHAR2(1) := 'N';
2198:
2199: BEGIN
2200:
2201: -- SQL What:Checks if there is any record in the PO_ACTION_HISTORY with the
2202: -- action code as 'SIGNED'
2203: -- SQL Why :To find out if the document was ever signed
2204:
2205: SELECT 'Y'

Line 2209: FROM PO_ACTION_HISTORY

2205: SELECT 'Y'
2206: INTO l_signatures
2207: FROM dual
2208: WHERE EXISTS (SELECT 1
2209: FROM PO_ACTION_HISTORY
2210: WHERE object_id = p_document_id
2211: AND object_type_code IN ('PO','PA')
2212: AND action_code = 'SIGNED');
2213:

Line 2362: -- Action code to be inserted in PO_ACTION_HISTORY table.

2358: -- PO_HEADER_ID
2359: --p_status
2360: -- Indicates if the Document is 'ACCEPTED' or 'REJECTED' while signing
2361: --p_action_code
2362: -- Action code to be inserted in PO_ACTION_HISTORY table.
2363: -- Valid values 'SIGNED', 'BUYER REJECTED', 'SUPPLIER REJECTED'
2364: --p_object_type_code
2365: -- Document type - 'PO', 'PA' etc
2366: --p_object_subtype_code

Line 2454: -- Insert a record in the PO_ACTION_HISTORY table with the Signature details

2450: last_update_login = FND_GLOBAL.login_id,
2451: last_update_date = sysdate
2452: WHERE po_header_id = p_po_header_id;
2453:
2454: -- Insert a record in the PO_ACTION_HISTORY table with the Signature details
2455:
2456: -- bug 3568077
2457: -- Replaced PO_FORWARD_SV1.insert_action_history
2458: -- with PO_ACTION_HISTORY_SV.insert_action_history.

Line 2458: -- with PO_ACTION_HISTORY_SV.insert_action_history.

2454: -- Insert a record in the PO_ACTION_HISTORY table with the Signature details
2455:
2456: -- bug 3568077
2457: -- Replaced PO_FORWARD_SV1.insert_action_history
2458: -- with PO_ACTION_HISTORY_SV.insert_action_history.
2459:
2460: -- bug3738420
2461: -- We should pass p_employee_id to insert_action_history isntead of deriving
2462: -- it from PO_ACCEPTANCES table because the person who is logged in accetpance table may

Line 2465: PO_ACTION_HISTORY_SV.insert_action_history(

2461: -- We should pass p_employee_id to insert_action_history isntead of deriving
2462: -- it from PO_ACCEPTANCES table because the person who is logged in accetpance table may
2463: -- not be the one who performs the action.
2464:
2465: PO_ACTION_HISTORY_SV.insert_action_history(
2466: p_doc_id_tbl => po_tbl_number(p_po_header_id)
2467: , p_doc_type_tbl => po_tbl_varchar30(p_object_type_code)
2468: , p_doc_subtype_tbl => po_tbl_varchar30(p_object_subtype_code)
2469: , p_doc_revision_num_tbl => po_tbl_number(p_revision_num)

Line 2778: FROM PO_ACTION_HISTORY PAH

2774: -- #2 is necessary for the acceptances not required cases.
2775:
2776: CURSOR po_amd_csr(p_po_header_id NUMBER, p_revision_num NUMBER) IS
2777: SELECT object_revision_num
2778: FROM PO_ACTION_HISTORY PAH
2779: WHERE PAH.object_id = p_po_header_id
2780: AND PAH.object_type_code IN ('PO','PA')
2781: AND (
2782: (PAH.action_code = 'SIGNED')

Line 2788: FROM PO_ACTION_HISTORY PAH1

2784: (PAH.action_code = 'APPROVE'
2785: and
2786: not exists (
2787: SELECT 1
2788: FROM PO_ACTION_HISTORY PAH1
2789: WHERE PAH1.object_id = PAH.object_id
2790: AND PAH1.object_type_code = pah.object_type_code
2791: AND PAH1.action_code IN ('BUYER REJECTED','SUPPLIER REJECTED')
2792: AND PAH1.object_revision_num = PAH.object_revision_num

Line 2941: -- PO_HEADERS_ALL, PO_LINE_LOCATIONS_ALL, PO_ACTION_HISTORY

2937: --Name: Post_Forms_Commit
2938: --Pre-reqs:
2939: -- None.
2940: --Modifies:
2941: -- PO_HEADERS_ALL, PO_LINE_LOCATIONS_ALL, PO_ACTION_HISTORY
2942: --Locks:
2943: -- None.
2944: --Function:
2945: -- Checks the logic for completion of signatures and updates PO tables

Line 2977: l_object_code PO_ACTION_HISTORY.object_type_code%TYPE := NULL;

2973: l_supplier_accepted_count PLS_INTEGER := 0;
2974: l_supplier_rejected_count PLS_INTEGER := 0;
2975: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
2976: l_agent_id PO_HEADERS_ALL.agent_id%TYPE;
2977: l_object_code PO_ACTION_HISTORY.object_type_code%TYPE := NULL;
2978: l_po_itemkey WF_ITEMS.item_key%TYPE;
2979: l_po_itemtype WF_ITEMS.item_type%TYPE;
2980: l_itemkey WF_ITEMS.item_key%TYPE;
2981: l_result VARCHAR2(1);

Line 3020: -- SQL Why :To pass it po_action_history row handler for inserting a row

3016: END;
3017:
3018: BEGIN
3019: -- SQL What :selects the type_lookup_code and agent_id from PO_HEADERS_ALL
3020: -- SQL Why :To pass it po_action_history row handler for inserting a row
3021: -- SQL Join :PO_HEADER_ID
3022:
3023: -- bug 3568077
3024: -- PO_ACTION_HISTORY.object_type_code is:

Line 3024: -- PO_ACTION_HISTORY.object_type_code is:

3020: -- SQL Why :To pass it po_action_history row handler for inserting a row
3021: -- SQL Join :PO_HEADER_ID
3022:
3023: -- bug 3568077
3024: -- PO_ACTION_HISTORY.object_type_code is:
3025: -- PA for Contracts and BPAs
3026: -- PO for Standard/Planned POs
3027:
3028: SELECT