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 345: select po_acceptances_s.nextval into l_acceptance_id from dual;

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

Line 399: PO_ACCEPTANCES_INS_PVT.insert_row(

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

Line 423: /* insert into po_acceptances (

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

Line 743: FROM PO_ACCEPTANCES PA

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

Line 764: FROM PO_ACCEPTANCES PA

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

Line 813: FROM PO_ACCEPTANCES PA

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

Line 834: FROM PO_ACCEPTANCES PA

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