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_ACCEPTANCES

Line 514: l_acceptance_note PO_ACCEPTANCES.note%TYPE;

510: l_buyer_response VARCHAR2(20);
511: l_response VARCHAR2(20);
512: l_supplier_response VARCHAR2(20);
513: l_event_name VARCHAR2(50);
514: l_acceptance_note PO_ACCEPTANCES.note%TYPE;
515: l_document_number PO_HEADERS_ALL.segment1%TYPE;
516: l_orgid PO_HEADERS_ALL.org_id%TYPE;
517: l_revision PO_HEADERS_ALL.revision_num%TYPE;
518: l_return_status VARCHAR2(1);

Line 760: -- PO_ACCEPTANCES

756: --Name: post_signature
757: --Pre-reqs:
758: -- None.
759: --Modifies:
760: -- PO_ACCEPTANCES
761: -- PO_HEADERS_ALL
762: -- PO_LINE_LOCATIONS_ALL
763: -- PO_ACTION_HISTORY
764: --Locks:

Line 795: l_erecord_id PO_ACCEPTANCES.erecord_id%TYPE;

791:
792: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
793: l_document_type_code PO_DOCUMENT_TYPES.document_type_code%TYPE;
794: l_document_sub_type_code PO_DOCUMENT_TYPES.document_subtype%TYPE;
795: l_erecord_id PO_ACCEPTANCES.erecord_id%TYPE;
796: l_revision_num PO_HEADERS_ALL.revision_num%TYPE;
797: l_employee_id PO_ACCEPTANCES.employee_id%TYPE;
798: l_user_id NUMBER;
799: l_acceptance_note PO_ACCEPTANCES.note%TYPE;

Line 797: l_employee_id PO_ACCEPTANCES.employee_id%TYPE;

793: l_document_type_code PO_DOCUMENT_TYPES.document_type_code%TYPE;
794: l_document_sub_type_code PO_DOCUMENT_TYPES.document_subtype%TYPE;
795: l_erecord_id PO_ACCEPTANCES.erecord_id%TYPE;
796: l_revision_num PO_HEADERS_ALL.revision_num%TYPE;
797: l_employee_id PO_ACCEPTANCES.employee_id%TYPE;
798: l_user_id NUMBER;
799: l_acceptance_note PO_ACCEPTANCES.note%TYPE;
800: l_role PO_ACCEPTANCES.role%TYPE;
801: l_supplier_response VARCHAR2(20);

Line 799: l_acceptance_note PO_ACCEPTANCES.note%TYPE;

795: l_erecord_id PO_ACCEPTANCES.erecord_id%TYPE;
796: l_revision_num PO_HEADERS_ALL.revision_num%TYPE;
797: l_employee_id PO_ACCEPTANCES.employee_id%TYPE;
798: l_user_id NUMBER;
799: l_acceptance_note PO_ACCEPTANCES.note%TYPE;
800: l_role PO_ACCEPTANCES.role%TYPE;
801: l_supplier_response VARCHAR2(20);
802: l_buyer_response VARCHAR2(20);
803: l_action_code VARCHAR2(20);

Line 800: l_role PO_ACCEPTANCES.role%TYPE;

796: l_revision_num PO_HEADERS_ALL.revision_num%TYPE;
797: l_employee_id PO_ACCEPTANCES.employee_id%TYPE;
798: l_user_id NUMBER;
799: l_acceptance_note PO_ACCEPTANCES.note%TYPE;
800: l_role PO_ACCEPTANCES.role%TYPE;
801: l_supplier_response VARCHAR2(20);
802: l_buyer_response VARCHAR2(20);
803: l_action_code VARCHAR2(20);
804: l_response VARCHAR2(20);

Line 805: l_accepted_flag PO_ACCEPTANCES.accepted_flag%TYPE;

801: l_supplier_response VARCHAR2(20);
802: l_buyer_response VARCHAR2(20);
803: l_action_code VARCHAR2(20);
804: l_response VARCHAR2(20);
805: l_accepted_flag PO_ACCEPTANCES.accepted_flag%TYPE;
806: l_accepting_party PO_ACCEPTANCES.accepting_party%TYPE;
807: l_acceptance_id PO_ACCEPTANCES.acceptance_id%TYPE;
808: l_last_update_date PO_ACCEPTANCES.last_update_date%TYPE;
809: l_last_updated_by PO_ACCEPTANCES.last_updated_by%TYPE;

Line 806: l_accepting_party PO_ACCEPTANCES.accepting_party%TYPE;

802: l_buyer_response VARCHAR2(20);
803: l_action_code VARCHAR2(20);
804: l_response VARCHAR2(20);
805: l_accepted_flag PO_ACCEPTANCES.accepted_flag%TYPE;
806: l_accepting_party PO_ACCEPTANCES.accepting_party%TYPE;
807: l_acceptance_id PO_ACCEPTANCES.acceptance_id%TYPE;
808: l_last_update_date PO_ACCEPTANCES.last_update_date%TYPE;
809: l_last_updated_by PO_ACCEPTANCES.last_updated_by%TYPE;
810: l_last_update_login PO_ACCEPTANCES.last_update_login%TYPE;

Line 807: l_acceptance_id PO_ACCEPTANCES.acceptance_id%TYPE;

803: l_action_code VARCHAR2(20);
804: l_response VARCHAR2(20);
805: l_accepted_flag PO_ACCEPTANCES.accepted_flag%TYPE;
806: l_accepting_party PO_ACCEPTANCES.accepting_party%TYPE;
807: l_acceptance_id PO_ACCEPTANCES.acceptance_id%TYPE;
808: l_last_update_date PO_ACCEPTANCES.last_update_date%TYPE;
809: l_last_updated_by PO_ACCEPTANCES.last_updated_by%TYPE;
810: l_last_update_login PO_ACCEPTANCES.last_update_login%TYPE;
811: l_rowid ROWID;

Line 808: l_last_update_date PO_ACCEPTANCES.last_update_date%TYPE;

804: l_response VARCHAR2(20);
805: l_accepted_flag PO_ACCEPTANCES.accepted_flag%TYPE;
806: l_accepting_party PO_ACCEPTANCES.accepting_party%TYPE;
807: l_acceptance_id PO_ACCEPTANCES.acceptance_id%TYPE;
808: l_last_update_date PO_ACCEPTANCES.last_update_date%TYPE;
809: l_last_updated_by PO_ACCEPTANCES.last_updated_by%TYPE;
810: l_last_update_login PO_ACCEPTANCES.last_update_login%TYPE;
811: l_rowid ROWID;
812: l_progress VARCHAR2(300);

Line 809: l_last_updated_by PO_ACCEPTANCES.last_updated_by%TYPE;

805: l_accepted_flag PO_ACCEPTANCES.accepted_flag%TYPE;
806: l_accepting_party PO_ACCEPTANCES.accepting_party%TYPE;
807: l_acceptance_id PO_ACCEPTANCES.acceptance_id%TYPE;
808: l_last_update_date PO_ACCEPTANCES.last_update_date%TYPE;
809: l_last_updated_by PO_ACCEPTANCES.last_updated_by%TYPE;
810: l_last_update_login PO_ACCEPTANCES.last_update_login%TYPE;
811: l_rowid ROWID;
812: l_progress VARCHAR2(300);
813: l_doc_string VARCHAR2(200);

Line 810: l_last_update_login PO_ACCEPTANCES.last_update_login%TYPE;

806: l_accepting_party PO_ACCEPTANCES.accepting_party%TYPE;
807: l_acceptance_id PO_ACCEPTANCES.acceptance_id%TYPE;
808: l_last_update_date PO_ACCEPTANCES.last_update_date%TYPE;
809: l_last_updated_by PO_ACCEPTANCES.last_updated_by%TYPE;
810: l_last_update_login PO_ACCEPTANCES.last_update_login%TYPE;
811: l_rowid ROWID;
812: l_progress VARCHAR2(300);
813: l_doc_string VARCHAR2(200);
814: l_preparer_user_name WF_USERS.name%TYPE;

Line 948: PO_ACCEPTANCES_INS_PVT.insert_row(

944: END IF;
945: END IF;
946:
947:
948: PO_ACCEPTANCES_INS_PVT.insert_row(
949: x_rowid => l_rowid,
950: x_acceptance_id => l_acceptance_id,
951: p_creation_date => sysdate,
952: p_created_by => fnd_global.user_id,

Line 1346: l_acceptance_note PO_ACCEPTANCES.note%TYPE;

1342: l_doc_string VARCHAR2(200);
1343: l_preparer_user_name WF_USERS.name%TYPE;
1344: l_progress VARCHAR2(300);
1345: l_binding_exception EXCEPTION;
1346: l_acceptance_note PO_ACCEPTANCES.note%TYPE;
1347: l_notif_id NUMBER;
1348: /* Added for the bug 6358219 to fetch the legal_entity name */
1349: l_legal_entity_id NUMBER;
1350: x_legalentity_info xle_utilities_grp.LegalEntity_Rec;

Line 1700: l_acceptance_note PO_ACCEPTANCES.note%TYPE;

1696: l_doc_string VARCHAR2(200);
1697: l_preparer_user_name WF_USERS.name%TYPE;
1698: l_progress VARCHAR2(300);
1699: l_binding_exception EXCEPTION;
1700: l_acceptance_note PO_ACCEPTANCES.note%TYPE;
1701: l_notif_id NUMBER;
1702: /* Added for the bug 6358219 to fetch the legal_entity name */
1703: l_legal_entity_id NUMBER;
1704: x_legalentity_info xle_utilities_grp.LegalEntity_Rec;

Line 2462: -- it from PO_ACCEPTANCES table because the person who is logged in accetpance table may

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
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)

Line 2919: FROM PO_ACCEPTANCES

2915: SELECT 'Y'
2916: INTO x_erecord_exist
2917: FROM dual
2918: WHERE EXISTS (SELECT 1
2919: FROM PO_ACCEPTANCES
2920: WHERE po_header_id = p_po_header_id
2921: AND revision_num = p_revision_num
2922: AND signature_flag = 'Y'
2923: AND erecord_id IS NOT NULL);

Line 3009: FROM PO_ACCEPTANCES

3005: INTO l_buyer_accepted_count,
3006: l_buyer_rejected_count,
3007: l_supplier_accepted_count,
3008: l_supplier_rejected_count
3009: FROM PO_ACCEPTANCES
3010: WHERE Po_Header_Id = p_po_header_id
3011: AND Revision_Num = p_revision_num
3012: AND Signature_Flag = 'Y';
3013: EXCEPTION

Line 3136: FROM PO_ACCEPTANCES

3132: -- SQL Join :NONE
3133:
3134: SELECT max(action_date)
3135: INTO l_acceptance_date
3136: FROM PO_ACCEPTANCES
3137: WHERE Po_Header_Id = p_po_header_id
3138: AND Revision_Num = p_revision_num
3139: AND Signature_Flag = 'Y'
3140: AND ACCEPTING_PARTY IN ('B','S')

Line 3208: -- PO_ACCEPTANCES table.

3204: --Locks:
3205: -- None.
3206: --Function:
3207: -- Checks if there are more than one signature records exist in the
3208: -- PO_ACCEPTANCES table.
3209: --Parameters:
3210: --IN:
3211: --p_po_header_id
3212: -- PO_HEADER_ID

Line 3241: FROM PO_ACCEPTANCES

3237: -- SQL Join :PO_HEADER_ID, REVISION_NUM, SIGNATURE_FLAG, ERECORD_ID
3238:
3239: SELECT Count(Signature_Flag)
3240: INTO l_no_signatures
3241: FROM PO_ACCEPTANCES
3242: WHERE po_header_id = p_po_header_id
3243: AND revision_num = p_revision_num
3244: AND signature_flag = 'Y'
3245: AND accepting_party = 'B' --bug 3420562

Line 3269: FROM PO_ACCEPTANCES

3265: -- SQL Join :PO_HEADER_ID, REVISION_NUM, SIGNATURE_FLAG, ERECORD_ID
3266:
3267: SELECT Count(Signature_Flag)
3268: INTO l_no_signatures
3269: FROM PO_ACCEPTANCES
3270: WHERE po_header_id = p_po_header_id
3271: AND revision_num = p_revision_num
3272: AND signature_flag = 'Y'
3273: AND erecord_id IS NOT NULL;

Line 3324: FROM po_acceptances

3320:
3321: BEGIN
3322: SELECT DECODE(accepted_flag, 'N', 'Y', 'N')
3323: INTO x_supplier_rejected
3324: FROM po_acceptances
3325: WHERE po_header_id = p_po_header_id
3326: AND revision_num = p_revision_num
3327: AND accepting_party = 'S'
3328: AND signature_flag = 'Y';

Line 3344: FROM po_acceptances

3340:
3341: BEGIN
3342: SELECT 'Y'
3343: INTO x_buyer_rejected
3344: FROM po_acceptances
3345: WHERE po_header_id = p_po_header_id
3346: AND revision_num = p_revision_num
3347: AND accepting_party = 'B'
3348: AND accepted_flag = 'N'