DBA Data[Home] [Help]

APPS.PO_AME_WF_PVT dependencies on PO_ACCEPTANCES

Line 4767: FROM po_acceptances

4763:
4764: BEGIN
4765: SELECT acceptance_id
4766: INTO l_acceptance_id
4767: FROM po_acceptances
4768: WHERE po_header_id=p_document_id;
4769:
4770: IF g_debug_stmt THEN
4771: PO_DEBUG.debug_begin(p_log_head => l_log_head );

Line 5618: l_acceptance_note PO_ACCEPTANCES.note%TYPE;

5614: l_requester FND_USER.user_name%TYPE;
5615: l_esigner_response VARCHAR2(20);
5616: l_response VARCHAR2(20);
5617: l_event_name VARCHAR2(50);
5618: l_acceptance_note PO_ACCEPTANCES.note%TYPE;
5619: l_document_number PO_HEADERS_ALL.segment1%TYPE;
5620: l_orgid PO_HEADERS_ALL.org_id%TYPE;
5621: l_revision PO_HEADERS_ALL.revision_num%TYPE;
5622: l_return_status VARCHAR2(1);

Line 6090: FROM PO_ACCEPTANCES

6086: -- If yes process document in same way as it is doen PO_SIGNATURE_PVT.POST_SIGNATURE, UPDATE_PO_DETAILS
6087: BEGIN
6088: SELECT max(action_date)
6089: INTO l_acceptance_date
6090: FROM PO_ACCEPTANCES
6091: WHERE Po_Header_Id = l_document_id
6092: AND Revision_Num = l_revision_num
6093: AND Signature_Flag = 'Y'
6094: AND ACCEPTING_PARTY IN ('B','S')