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 602: l_acceptance_note PO_ACCEPTANCES.note%TYPE;

598: l_response VARCHAR2(20);
599: l_supplier_response VARCHAR2(20);
600: l_ko_response VARCHAR2(20);
601: l_event_name VARCHAR2(50);
602: l_acceptance_note PO_ACCEPTANCES.note%TYPE;
603: l_document_number PO_HEADERS_ALL.clm_document_number%TYPE;
604: l_orgid PO_HEADERS_ALL.org_id%TYPE;
605: l_revision PO_HEADERS_ALL.revision_num%TYPE;
606: l_return_status VARCHAR2(1);

Line 888: -- PO_ACCEPTANCES

884: --Name: post_signature
885: --Pre-reqs:
886: -- None.
887: --Modifies:
888: -- PO_ACCEPTANCES
889: -- PO_HEADERS_ALL
890: -- PO_LINE_LOCATIONS_ALL
891: -- PO_ACTION_HISTORY
892: --Locks:

Line 923: l_erecord_id PO_ACCEPTANCES.erecord_id%TYPE;

919:
920: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
921: l_document_type_code PO_DOCUMENT_TYPES.document_type_code%TYPE;
922: l_document_sub_type_code PO_DOCUMENT_TYPES.document_subtype%TYPE;
923: l_erecord_id PO_ACCEPTANCES.erecord_id%TYPE;
924: l_revision_num PO_HEADERS_ALL.revision_num%TYPE;
925: l_employee_id PO_ACCEPTANCES.employee_id%TYPE;
926: l_user_id NUMBER;
927: l_acceptance_note PO_ACCEPTANCES.note%TYPE;

Line 925: l_employee_id PO_ACCEPTANCES.employee_id%TYPE;

921: l_document_type_code PO_DOCUMENT_TYPES.document_type_code%TYPE;
922: l_document_sub_type_code PO_DOCUMENT_TYPES.document_subtype%TYPE;
923: l_erecord_id PO_ACCEPTANCES.erecord_id%TYPE;
924: l_revision_num PO_HEADERS_ALL.revision_num%TYPE;
925: l_employee_id PO_ACCEPTANCES.employee_id%TYPE;
926: l_user_id NUMBER;
927: l_acceptance_note PO_ACCEPTANCES.note%TYPE;
928: l_role PO_ACCEPTANCES.role%TYPE;
929: l_supplier_response VARCHAR2(20);

Line 927: l_acceptance_note PO_ACCEPTANCES.note%TYPE;

923: l_erecord_id PO_ACCEPTANCES.erecord_id%TYPE;
924: l_revision_num PO_HEADERS_ALL.revision_num%TYPE;
925: l_employee_id PO_ACCEPTANCES.employee_id%TYPE;
926: l_user_id NUMBER;
927: l_acceptance_note PO_ACCEPTANCES.note%TYPE;
928: l_role PO_ACCEPTANCES.role%TYPE;
929: l_supplier_response VARCHAR2(20);
930: l_ko_response VARCHAR2(20);
931: l_ko_user_name FND_USER.user_name%TYPE;

Line 928: l_role PO_ACCEPTANCES.role%TYPE;

924: l_revision_num PO_HEADERS_ALL.revision_num%TYPE;
925: l_employee_id PO_ACCEPTANCES.employee_id%TYPE;
926: l_user_id NUMBER;
927: l_acceptance_note PO_ACCEPTANCES.note%TYPE;
928: l_role PO_ACCEPTANCES.role%TYPE;
929: l_supplier_response VARCHAR2(20);
930: l_ko_response VARCHAR2(20);
931: l_ko_user_name FND_USER.user_name%TYPE;
932: l_buyer_response VARCHAR2(20);

Line 935: l_accepted_flag PO_ACCEPTANCES.accepted_flag%TYPE;

931: l_ko_user_name FND_USER.user_name%TYPE;
932: l_buyer_response VARCHAR2(20);
933: l_action_code VARCHAR2(20);
934: l_response VARCHAR2(20);
935: l_accepted_flag PO_ACCEPTANCES.accepted_flag%TYPE;
936: l_accepting_party PO_ACCEPTANCES.accepting_party%TYPE;
937: l_acceptance_id PO_ACCEPTANCES.acceptance_id%TYPE;
938: l_last_update_date PO_ACCEPTANCES.last_update_date%TYPE;
939: l_last_updated_by PO_ACCEPTANCES.last_updated_by%TYPE;

Line 936: l_accepting_party PO_ACCEPTANCES.accepting_party%TYPE;

932: l_buyer_response VARCHAR2(20);
933: l_action_code VARCHAR2(20);
934: l_response VARCHAR2(20);
935: l_accepted_flag PO_ACCEPTANCES.accepted_flag%TYPE;
936: l_accepting_party PO_ACCEPTANCES.accepting_party%TYPE;
937: l_acceptance_id PO_ACCEPTANCES.acceptance_id%TYPE;
938: l_last_update_date PO_ACCEPTANCES.last_update_date%TYPE;
939: l_last_updated_by PO_ACCEPTANCES.last_updated_by%TYPE;
940: l_last_update_login PO_ACCEPTANCES.last_update_login%TYPE;

Line 937: l_acceptance_id PO_ACCEPTANCES.acceptance_id%TYPE;

933: l_action_code VARCHAR2(20);
934: l_response VARCHAR2(20);
935: l_accepted_flag PO_ACCEPTANCES.accepted_flag%TYPE;
936: l_accepting_party PO_ACCEPTANCES.accepting_party%TYPE;
937: l_acceptance_id PO_ACCEPTANCES.acceptance_id%TYPE;
938: l_last_update_date PO_ACCEPTANCES.last_update_date%TYPE;
939: l_last_updated_by PO_ACCEPTANCES.last_updated_by%TYPE;
940: l_last_update_login PO_ACCEPTANCES.last_update_login%TYPE;
941: l_rowid ROWID;

Line 938: l_last_update_date PO_ACCEPTANCES.last_update_date%TYPE;

934: l_response VARCHAR2(20);
935: l_accepted_flag PO_ACCEPTANCES.accepted_flag%TYPE;
936: l_accepting_party PO_ACCEPTANCES.accepting_party%TYPE;
937: l_acceptance_id PO_ACCEPTANCES.acceptance_id%TYPE;
938: l_last_update_date PO_ACCEPTANCES.last_update_date%TYPE;
939: l_last_updated_by PO_ACCEPTANCES.last_updated_by%TYPE;
940: l_last_update_login PO_ACCEPTANCES.last_update_login%TYPE;
941: l_rowid ROWID;
942: l_progress VARCHAR2(300);

Line 939: l_last_updated_by PO_ACCEPTANCES.last_updated_by%TYPE;

935: l_accepted_flag PO_ACCEPTANCES.accepted_flag%TYPE;
936: l_accepting_party PO_ACCEPTANCES.accepting_party%TYPE;
937: l_acceptance_id PO_ACCEPTANCES.acceptance_id%TYPE;
938: l_last_update_date PO_ACCEPTANCES.last_update_date%TYPE;
939: l_last_updated_by PO_ACCEPTANCES.last_updated_by%TYPE;
940: l_last_update_login PO_ACCEPTANCES.last_update_login%TYPE;
941: l_rowid ROWID;
942: l_progress VARCHAR2(300);
943: l_doc_string VARCHAR2(200);

Line 940: l_last_update_login PO_ACCEPTANCES.last_update_login%TYPE;

936: l_accepting_party PO_ACCEPTANCES.accepting_party%TYPE;
937: l_acceptance_id PO_ACCEPTANCES.acceptance_id%TYPE;
938: l_last_update_date PO_ACCEPTANCES.last_update_date%TYPE;
939: l_last_updated_by PO_ACCEPTANCES.last_updated_by%TYPE;
940: l_last_update_login PO_ACCEPTANCES.last_update_login%TYPE;
941: l_rowid ROWID;
942: l_progress VARCHAR2(300);
943: l_doc_string VARCHAR2(200);
944: l_preparer_user_name WF_USERS.name%TYPE;

Line 961: l_vendor_contact_name po_acceptances.vendor_contact_name%TYPE := NULL;

957: --
958: l_draft_id NUMBER; -- CLM Apprvl
959: l_is_clm_enabled varchar2(1); --bug9924585
960: l_acceptance_required VARCHAR2(1); -- CLM KO signature ER
961: l_vendor_contact_name po_acceptances.vendor_contact_name%TYPE := NULL;
962: l_vendor_contact_title po_acceptances.vendor_contact_title%TYPE := NULL;
963: l_vendor_signed_date po_acceptances.vendor_signed_date%TYPE := NULL;
964: BEGIN
965:

Line 962: l_vendor_contact_title po_acceptances.vendor_contact_title%TYPE := NULL;

958: l_draft_id NUMBER; -- CLM Apprvl
959: l_is_clm_enabled varchar2(1); --bug9924585
960: l_acceptance_required VARCHAR2(1); -- CLM KO signature ER
961: l_vendor_contact_name po_acceptances.vendor_contact_name%TYPE := NULL;
962: l_vendor_contact_title po_acceptances.vendor_contact_title%TYPE := NULL;
963: l_vendor_signed_date po_acceptances.vendor_signed_date%TYPE := NULL;
964: BEGIN
965:
966: IF (g_po_wf_debug = 'Y') THEN

Line 963: l_vendor_signed_date po_acceptances.vendor_signed_date%TYPE := NULL;

959: l_is_clm_enabled varchar2(1); --bug9924585
960: l_acceptance_required VARCHAR2(1); -- CLM KO signature ER
961: l_vendor_contact_name po_acceptances.vendor_contact_name%TYPE := NULL;
962: l_vendor_contact_title po_acceptances.vendor_contact_title%TYPE := NULL;
963: l_vendor_signed_date po_acceptances.vendor_signed_date%TYPE := NULL;
964: BEGIN
965:
966: IF (g_po_wf_debug = 'Y') THEN
967: l_progress := 'PO_SIGNATURE_PVT.Post_Signature: 01';

Line 999: /* In case of proxy signature mode the supplier contact name, title and signed date must be recorded in po_acceptances */

995: l_ko_response := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
996: itemkey => itemkey,
997: aname => 'KO_RESPONSE');
998:
999: /* In case of proxy signature mode the supplier contact name, title and signed date must be recorded in po_acceptances */
1000: l_acceptance_required := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
1001: itemkey => itemkey,
1002: aname => 'ACCEPTANCE_REQUIRED');
1003:

Line 1054: /* In case of proxy signature mode the supplier contact name, title and signed date must be recorded in po_acceptances */

1050: l_employee_id := FND_GLOBAL.employee_id;
1051:
1052: l_accepting_party := 'B';
1053: l_response := l_buyer_response;
1054: /* In case of proxy signature mode the supplier contact name, title and signed date must be recorded in po_acceptances */
1055: IF l_acceptance_required = 'P' THEN
1056: l_vendor_contact_name := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
1057: itemkey => itemkey,
1058: aname => 'SUPPLIER_CONTACT_NAME');

Line 1200: l_progress := 'PO_SIGNATURE_PVT.Post_Signature: before call to PO_ACCEPTANCES_INS_PVT.insert_row';

1196: POS_ACK_PO.Acknowledge_promise_date(null,l_document_id,null,l_revision_num,l_user_id);
1197: END IF;
1198: END IF;
1199: IF (g_po_wf_debug = 'Y') THEN
1200: l_progress := 'PO_SIGNATURE_PVT.Post_Signature: before call to PO_ACCEPTANCES_INS_PVT.insert_row';
1201: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1202: END IF;
1203: -- CLM Apprvl...added the parameter p_draft_id
1204: /* In case of proxy signature mode the supplier contact name, title and signed date must be recorded in po_acceptances */

Line 1204: /* In case of proxy signature mode the supplier contact name, title and signed date must be recorded in po_acceptances */

1200: l_progress := 'PO_SIGNATURE_PVT.Post_Signature: before call to PO_ACCEPTANCES_INS_PVT.insert_row';
1201: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1202: END IF;
1203: -- CLM Apprvl...added the parameter p_draft_id
1204: /* In case of proxy signature mode the supplier contact name, title and signed date must be recorded in po_acceptances */
1205:
1206: PO_ACCEPTANCES_INS_PVT.insert_row(
1207: x_rowid => l_rowid,
1208: x_acceptance_id => l_acceptance_id,

Line 1206: PO_ACCEPTANCES_INS_PVT.insert_row(

1202: END IF;
1203: -- CLM Apprvl...added the parameter p_draft_id
1204: /* In case of proxy signature mode the supplier contact name, title and signed date must be recorded in po_acceptances */
1205:
1206: PO_ACCEPTANCES_INS_PVT.insert_row(
1207: x_rowid => l_rowid,
1208: x_acceptance_id => l_acceptance_id,
1209: p_creation_date => sysdate,
1210: p_created_by => fnd_global.user_id,

Line 1689: l_acceptance_note PO_ACCEPTANCES.note%TYPE;

1685: l_doc_string VARCHAR2(200);
1686: l_preparer_user_name WF_USERS.name%TYPE;
1687: l_progress VARCHAR2(300);
1688: l_binding_exception EXCEPTION;
1689: l_acceptance_note PO_ACCEPTANCES.note%TYPE;
1690: l_notif_id NUMBER;
1691: /* Added for the bug 6358219 to fetch the legal_entity name */
1692: l_legal_entity_id NUMBER;
1693: x_legalentity_info xle_utilities_grp.LegalEntity_Rec;

Line 2051: l_acceptance_note PO_ACCEPTANCES.note%TYPE;

2047: l_doc_string VARCHAR2(200);
2048: l_preparer_user_name WF_USERS.name%TYPE;
2049: l_progress VARCHAR2(300);
2050: l_binding_exception EXCEPTION;
2051: l_acceptance_note PO_ACCEPTANCES.note%TYPE;
2052: l_notif_id NUMBER;
2053: /* Added for the bug 6358219 to fetch the legal_entity name */
2054: l_legal_entity_id NUMBER;
2055: x_legalentity_info xle_utilities_grp.LegalEntity_Rec;

Line 2590: -- PO AME Project : Verify signauture exists on the basis of record in po_acceptances table for SUPPLIER siganture

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
2591: -- to avoid confusion between e-signature and supplier signature when using AME.
2592: SELECT 'Y'
2593: INTO l_signatures
2594: FROM dual

Line 2596: FROM PO_ACCEPTANCES

2592: SELECT 'Y'
2593: INTO l_signatures
2594: FROM dual
2595: WHERE EXISTS (SELECT 1
2596: FROM PO_ACCEPTANCES
2597: WHERE po_header_id = p_document_id
2598: AND accepting_party ='S'
2599: AND action = 'Accepted');
2600:

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

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

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

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

Line 3662: FROM PO_ACCEPTANCES

3658: SELECT 'Y'
3659: INTO x_erecord_exist
3660: FROM dual
3661: WHERE EXISTS (SELECT 1
3662: FROM PO_ACCEPTANCES
3663: WHERE po_header_id = p_po_header_id
3664: AND revision_num = p_revision_num
3665: AND signature_flag = 'Y'
3666: AND erecord_id IS NOT NULL);

Line 3752: FROM PO_ACCEPTANCES

3748: INTO l_buyer_accepted_count,
3749: l_buyer_rejected_count,
3750: l_supplier_accepted_count,
3751: l_supplier_rejected_count
3752: FROM PO_ACCEPTANCES
3753: WHERE Po_Header_Id = p_po_header_id
3754: AND Revision_Num = p_revision_num
3755: AND Signature_Flag = 'Y';
3756: EXCEPTION

Line 3879: FROM PO_ACCEPTANCES

3875: -- SQL Join :NONE
3876:
3877: SELECT max(action_date)
3878: INTO l_acceptance_date
3879: FROM PO_ACCEPTANCES
3880: WHERE Po_Header_Id = p_po_header_id
3881: AND Revision_Num = p_revision_num
3882: AND Signature_Flag = 'Y'
3883: AND ACCEPTING_PARTY IN ('B','S')

Line 3951: -- PO_ACCEPTANCES table.

3947: --Locks:
3948: -- None.
3949: --Function:
3950: -- Checks if there are more than one signature records exist in the
3951: -- PO_ACCEPTANCES table.
3952: --Parameters:
3953: --IN:
3954: --p_po_header_id
3955: -- PO_HEADER_ID

Line 3984: FROM PO_ACCEPTANCES

3980: -- SQL Join :PO_HEADER_ID, REVISION_NUM, SIGNATURE_FLAG, ERECORD_ID
3981:
3982: SELECT Count(Signature_Flag)
3983: INTO l_no_signatures
3984: FROM PO_ACCEPTANCES
3985: WHERE po_header_id = p_po_header_id
3986: AND revision_num = p_revision_num
3987: AND signature_flag = 'Y'
3988: AND accepting_party = 'B' --bug 3420562

Line 4012: FROM PO_ACCEPTANCES

4008: -- SQL Join :PO_HEADER_ID, REVISION_NUM, SIGNATURE_FLAG, ERECORD_ID
4009:
4010: SELECT Count(Signature_Flag)
4011: INTO l_no_signatures
4012: FROM PO_ACCEPTANCES
4013: WHERE po_header_id = p_po_header_id
4014: AND revision_num = p_revision_num
4015: AND signature_flag = 'Y'
4016: AND erecord_id IS NOT NULL;

Line 4067: FROM po_acceptances

4063:
4064: BEGIN
4065: SELECT DECODE(accepted_flag, 'N', 'Y', 'N')
4066: INTO x_supplier_rejected
4067: FROM po_acceptances
4068: WHERE po_header_id = p_po_header_id
4069: AND revision_num = p_revision_num
4070: AND accepting_party = 'S'
4071: AND signature_flag = 'Y';

Line 4087: FROM po_acceptances

4083:
4084: BEGIN
4085: SELECT 'Y'
4086: INTO x_buyer_rejected
4087: FROM po_acceptances
4088: WHERE po_header_id = p_po_header_id
4089: AND revision_num = p_revision_num
4090: AND accepting_party = 'B'
4091: AND accepted_flag = 'N'

Line 4321: from po_acceptances

4317: if l_draft_id IS NOT NULL AND l_draft_id <> -1 THEN
4318: begin
4319: select 'Y'
4320: into l_is_doc_signed
4321: from po_acceptances
4322: where po_header_id = l_document_id
4323: and draft_id = l_draft_id
4324: and action = 'Accepted'
4325: and rownum=1;

Line 4335: from po_acceptances

4331:
4332: begin
4333: select 'Y'
4334: into l_is_doc_signed
4335: from po_acceptances
4336: where po_header_id = l_document_id
4337: and action = 'Accepted'
4338: and rownum=1;
4339: exception