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 891: -- PO_ACTION_HISTORY

887: --Modifies:
888: -- PO_ACCEPTANCES
889: -- PO_HEADERS_ALL
890: -- PO_LINE_LOCATIONS_ALL
891: -- PO_ACTION_HISTORY
892: --Locks:
893: -- None.
894: --Function:
895: -- This procedure updates the relavant PO tables after the suppliers

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

2574: l_signatures VARCHAR2(1) := 'N';
2575:
2576: BEGIN
2577:
2578: -- SQL What:Checks if there is any record in the PO_ACTION_HISTORY with the
2579: -- action code as 'SIGNED'
2580: -- SQL Why :To find out if the document was ever signed
2581:
2582: /*SELECT 'Y'

Line 2586: FROM PO_ACTION_HISTORY

2582: /*SELECT 'Y'
2583: INTO l_signatures
2584: FROM dual
2585: WHERE EXISTS (SELECT 1
2586: FROM PO_ACTION_HISTORY
2587: WHERE object_id = p_document_id
2588: AND object_type_code IN ('PO','PA')
2589: AND action_code = 'SIGNED');*/
2590: -- PO AME Project : Verify signauture exists on the basis of record in po_acceptances table for SUPPLIER siganture

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

2908: -- PO_HEADER_ID
2909: --p_status
2910: -- Indicates if the Document is 'ACCEPTED' or 'REJECTED' while signing
2911: --p_action_code
2912: -- Action code to be inserted in PO_ACTION_HISTORY table.
2913: -- Valid values 'SIGNED', 'BUYER REJECTED', 'SUPPLIER REJECTED'
2914: --p_object_type_code
2915: -- Document type - 'PO', 'PA' etc
2916: --p_object_subtype_code

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

2999: last_update_login = FND_GLOBAL.login_id,
3000: last_update_date = sysdate
3001: WHERE po_header_id = p_po_header_id;
3002:
3003: -- Insert a record in the PO_ACTION_HISTORY table with the Signature details
3004:
3005: -- bug 3568077
3006: -- Replaced PO_FORWARD_SV1.insert_action_history
3007: -- with PO_ACTION_HISTORY_SV.insert_action_history.

Line 3007: -- with PO_ACTION_HISTORY_SV.insert_action_history.

3003: -- Insert a record in the PO_ACTION_HISTORY table with the Signature details
3004:
3005: -- bug 3568077
3006: -- Replaced PO_FORWARD_SV1.insert_action_history
3007: -- with PO_ACTION_HISTORY_SV.insert_action_history.
3008:
3009: -- bug3738420
3010: -- We should pass p_employee_id to insert_action_history isntead of deriving
3011: -- it from PO_ACCEPTANCES table because the person who is logged in accetpance table may

Line 3014: PO_ACTION_HISTORY_SV.insert_action_history(

3010: -- We should pass p_employee_id to insert_action_history isntead of deriving
3011: -- it from PO_ACCEPTANCES table because the person who is logged in accetpance table may
3012: -- not be the one who performs the action.
3013:
3014: PO_ACTION_HISTORY_SV.insert_action_history(
3015: p_doc_id_tbl => po_tbl_number(p_po_header_id)
3016: , p_doc_type_tbl => po_tbl_varchar30(p_object_type_code)
3017: , p_doc_subtype_tbl => po_tbl_varchar30(p_object_subtype_code)
3018: , p_doc_revision_num_tbl => po_tbl_number(p_revision_num)

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

3142: -- DRAFt_ID
3143: --p_status
3144: -- Indicates if the Document is 'ACCEPTED' or 'REJECTED' while signing
3145: --p_action_code
3146: -- Action code to be inserted in PO_ACTION_HISTORY table.
3147: -- Valid values 'SIGNED', 'BUYER REJECTED', 'SUPPLIER REJECTED'
3148: --p_object_type_code
3149: -- Document type - 'PO', 'PA' etc
3150: --p_object_subtype_code

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

3206: last_update_login = FND_GLOBAL.login_id,
3207: last_update_date = sysdate
3208: WHERE po_header_id = p_po_header_id;
3209: end if;
3210: -- Insert a record in the PO_ACTION_HISTORY table with the Signature details
3211:
3212: -- bug 3568077
3213: -- Replaced PO_FORWARD_SV1.insert_action_history
3214: -- with PO_ACTION_HISTORY_SV.insert_action_history.

Line 3214: -- with PO_ACTION_HISTORY_SV.insert_action_history.

3210: -- Insert a record in the PO_ACTION_HISTORY table with the Signature details
3211:
3212: -- bug 3568077
3213: -- Replaced PO_FORWARD_SV1.insert_action_history
3214: -- with PO_ACTION_HISTORY_SV.insert_action_history.
3215:
3216: -- bug3738420
3217: -- We should pass p_employee_id to insert_action_history isntead of deriving
3218: -- it from PO_ACCEPTANCES table because the person who is logged in accetpance table may

Line 3220: -- CLM Apprvl. If the document is a modification we need to pass the draft_id as the object_id for inserting into po_action_history table

3216: -- bug3738420
3217: -- We should pass p_employee_id to insert_action_history isntead of deriving
3218: -- it from PO_ACCEPTANCES table because the person who is logged in accetpance table may
3219: -- not be the one who performs the action.
3220: -- CLM Apprvl. If the document is a modification we need to pass the draft_id as the object_id for inserting into po_action_history table
3221: if p_draft_id <> -1 then
3222:
3223: PO_ACTION_HISTORY_SV.insert_action_history(
3224: p_doc_id_tbl => po_tbl_number(p_draft_id)

Line 3223: PO_ACTION_HISTORY_SV.insert_action_history(

3219: -- not be the one who performs the action.
3220: -- CLM Apprvl. If the document is a modification we need to pass the draft_id as the object_id for inserting into po_action_history table
3221: if p_draft_id <> -1 then
3222:
3223: PO_ACTION_HISTORY_SV.insert_action_history(
3224: p_doc_id_tbl => po_tbl_number(p_draft_id)
3225: , p_doc_type_tbl => po_tbl_varchar30(p_object_type_code)
3226: , p_doc_subtype_tbl => po_tbl_varchar30(p_object_subtype_code)
3227: , p_doc_revision_num_tbl => po_tbl_number(p_revision_num)

Line 3233: PO_ACTION_HISTORY_SV.insert_action_history(

3229: , p_employee_id => p_employee_id -- bug3738420
3230: );
3231: else
3232:
3233: PO_ACTION_HISTORY_SV.insert_action_history(
3234: p_doc_id_tbl => po_tbl_number(p_po_header_id)
3235: , p_doc_type_tbl => po_tbl_varchar30(p_object_type_code)
3236: , p_doc_subtype_tbl => po_tbl_varchar30(p_object_subtype_code)
3237: , p_doc_revision_num_tbl => po_tbl_number(p_revision_num)

Line 3521: FROM PO_ACTION_HISTORY PAH

3517: -- #2 is necessary for the acceptances not required cases.
3518:
3519: CURSOR po_amd_csr(p_po_header_id NUMBER, p_revision_num NUMBER) IS
3520: SELECT object_revision_num
3521: FROM PO_ACTION_HISTORY PAH
3522: WHERE PAH.object_id = p_po_header_id
3523: AND PAH.object_type_code IN ('PO','PA')
3524: AND (
3525: (PAH.action_code = 'SIGNED')

Line 3531: FROM PO_ACTION_HISTORY PAH1

3527: (PAH.action_code = 'APPROVE'
3528: and
3529: not exists (
3530: SELECT 1
3531: FROM PO_ACTION_HISTORY PAH1
3532: WHERE PAH1.object_id = PAH.object_id
3533: AND PAH1.object_type_code = pah.object_type_code
3534: AND PAH1.action_code IN ('BUYER REJECTED','SUPPLIER REJECTED')
3535: AND PAH1.object_revision_num = PAH.object_revision_num

Line 3684: -- PO_HEADERS_ALL, PO_LINE_LOCATIONS_ALL, PO_ACTION_HISTORY

3680: --Name: Post_Forms_Commit
3681: --Pre-reqs:
3682: -- None.
3683: --Modifies:
3684: -- PO_HEADERS_ALL, PO_LINE_LOCATIONS_ALL, PO_ACTION_HISTORY
3685: --Locks:
3686: -- None.
3687: --Function:
3688: -- Checks the logic for completion of signatures and updates PO tables

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

3716: l_supplier_accepted_count PLS_INTEGER := 0;
3717: l_supplier_rejected_count PLS_INTEGER := 0;
3718: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
3719: l_agent_id PO_HEADERS_ALL.agent_id%TYPE;
3720: l_object_code PO_ACTION_HISTORY.object_type_code%TYPE := NULL;
3721: l_po_itemkey WF_ITEMS.item_key%TYPE;
3722: l_po_itemtype WF_ITEMS.item_type%TYPE;
3723: l_itemkey WF_ITEMS.item_key%TYPE;
3724: l_result VARCHAR2(1);

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

3759: END;
3760:
3761: BEGIN
3762: -- SQL What :selects the type_lookup_code and agent_id from PO_HEADERS_ALL
3763: -- SQL Why :To pass it po_action_history row handler for inserting a row
3764: -- SQL Join :PO_HEADER_ID
3765:
3766: -- bug 3568077
3767: -- PO_ACTION_HISTORY.object_type_code is:

Line 3767: -- PO_ACTION_HISTORY.object_type_code is:

3763: -- SQL Why :To pass it po_action_history row handler for inserting a row
3764: -- SQL Join :PO_HEADER_ID
3765:
3766: -- bug 3568077
3767: -- PO_ACTION_HISTORY.object_type_code is:
3768: -- PA for Contracts and BPAs
3769: -- PO for Standard/Planned POs
3770:
3771: SELECT