APPS.POS_ACK_PO dependencies on PO_ACCEPTANCES

Line 52: l_Last_Update_Login PO_ACCEPTANCES.last_update_login%TYPE;

48: x_row_id varchar2(30);
49: x_Acceptance_id number;
50: x_Last_Update_Date date ;
51: x_Last_Updated_By number;
52: l_Last_Update_Login PO_ACCEPTANCES.last_update_login%TYPE;
53: x_Creation_Date date := TRUNC(SYSDATE);
54: x_Created_By number := fnd_global.user_id;
55: x_Po_Header_Id number;
56: x_Po_Release_Id number;

Line 346: select po_acceptances_s.nextval into l_acceptance_id from dual;

342: --Bug 6772960 - End
343:
344: --dbms_output.put_line('No Notification found ');
345: l_progress := '4';
346: select po_acceptances_s.nextval into l_acceptance_id from dual;
347:
348: if l_po_release_id is null then
349: l_doc := l_po_header_id;
350: x_po_header_id := l_po_header_id;

Line 400: PO_ACCEPTANCES_INS_PVT.insert_row(

396: IF(l_po_accept_reject = 'Y' AND g_default_promise_date = 'Y') THEN
397: POS_ACK_PO.Acknowledge_promise_date (null,l_po_header_id,l_po_release_id,l_revision_num,l_user_id); -- RDP
398: END IF;
399:
400: PO_ACCEPTANCES_INS_PVT.insert_row(
401: x_rowid => x_row_id,
402: x_acceptance_id => l_acceptance_id,
403: x_Last_Update_Date => x_Last_Update_Date,
404: x_Last_Updated_By => x_Last_Updated_By,

Line 424: /* insert into po_acceptances (

420:
421: l_progress := '8';
422: /* Use PO API As Above */
423: /* Bug 2807782, set employee_id to NULL. */
424: /* insert into po_acceptances (
425: acceptance_id,
426: last_update_Date,
427: last_updated_by,
428: last_update_login,

Line 744: FROM PO_ACCEPTANCES PA

740: WHERE pll.po_header_id = p_po_header_id
741: AND pll.promised_date is null
742: /* AND exists (
743: SELECT 1
744: FROM PO_ACCEPTANCES PA
745: WHERE pa.po_header_id = p_po_header_id
746: AND pa.revision_num = p_revision_num
747: AND pa.po_line_location_id = pll.line_location_id ) */
748: AND nvl(pll.cancel_flag, 'N') = 'N'

Line 765: FROM PO_ACCEPTANCES PA

761: WHERE plla2.line_location_id = plla.line_location_id
762: AND plla.revision_num <= p_revision_num)
763: /* AND exists (
764: SELECT 1
765: FROM PO_ACCEPTANCES PA
766: WHERE pa.po_header_id = p_po_header_id
767: AND pa.revision_num = p_revision_num
768: AND pa.po_line_location_id = plla.line_location_id ) */
769: AND nvl(plla.cancel_flag, 'N') = 'N'

Line 814: FROM PO_ACCEPTANCES PA

810: AND pll.po_release_id = p_po_release_id
811: AND pll.promised_date is null
812: /* AND exists (
813: SELECT 1
814: FROM PO_ACCEPTANCES PA
815: WHERE pa.po_release_id = p_po_release_id
816: AND pa.po_header_id = p_po_header_id
817: AND pa.revision_num = p_revision_num
818: AND pa.po_line_location_id = PLL.line_location_id ) */

Line 835: FROM PO_ACCEPTANCES PA

831: WHERE plla2.line_location_id = plla.line_location_id
832: AND plla.revision_num <= p_revision_num)
833: /* AND exists (
834: SELECT 1
835: FROM PO_ACCEPTANCES PA
836: WHERE pa.po_release_id = p_po_release_id
837: AND pa.po_header_id = p_po_header_id
838: AND pa.revision_num = p_revision_num
839: AND pa.po_line_location_id = PLLA.line_location_id ) */