APPS.PO_CHANGEORDERWF_PVT dependencies on PO_ACCEPTANCES

Line 919: l_Last_Update_Login PO_ACCEPTANCES.last_update_login%TYPE;

915: l_api_name varchar2(50) := 'Insert_Acc_Rejection_Row';
916: l_Acceptance_id number;
917: -- Bug 2850566
918: l_rowid ROWID;
919: l_Last_Update_Login PO_ACCEPTANCES.last_update_login%TYPE;
920: l_acc_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
921: -- End of Bug 2850566
922: l_Last_Update_Date date;
923: l_Last_Updated_By number;

Line 936: l_acceptance_note PO_ACCEPTANCES.note%TYPE; --bug 2178922

932: l_Accepted_Flag varchar2(1) := p_flag;
933: -- l_Acceptance_Lookup_Code varchar2(25);
934: l_document_id number;
935: l_document_type_code po_document_types_all.DOCUMENT_TYPE_CODE%TYPE;
936: l_acceptance_note PO_ACCEPTANCES.note%TYPE; --bug 2178922
937: l_rspndr_usr_name fnd_user.user_name%TYPE := '';
938: l_accepting_party varchar2(1);
939: begin
940:

Line 941: SELECT po_acceptances_s.nextval into l_Acceptance_id FROM sys.dual;

937: l_rspndr_usr_name fnd_user.user_name%TYPE := '';
938: l_accepting_party varchar2(1);
939: begin
940:
941: SELECT po_acceptances_s.nextval into l_Acceptance_id FROM sys.dual;
942:
943: -- commented out the usage of accptance_type (FPI)
944: /*
945: l_Acceptance_Lookup_Code := wf_engine.GetItemAttrText( itemtype => p_itemtype,

Line 1002: -- Calling the Acceptances row handler to insert into the PO_ACCEPTANCES table

998: where po_release_id = l_document_id;
999: end if;
1000:
1001: -- Bug 2850566 RBAIRRAJ
1002: -- Calling the Acceptances row handler to insert into the PO_ACCEPTANCES table
1003: -- instead of writing an Insert statement.
1004:
1005: IF l_po_release_id IS NULL THEN
1006: l_acc_po_header_id := l_po_header_id;

Line 1028: PO_ACCEPTANCES_INS_PVT.insert_row(

1024: end;
1025: l_Last_Update_Login := l_Last_Updated_By;
1026:
1027:
1028: PO_ACCEPTANCES_INS_PVT.insert_row(
1029: x_rowid => l_rowid,
1030: x_acceptance_id => l_Acceptance_id,
1031: x_Last_Update_Date => l_Last_Update_Date,
1032: x_Last_Updated_By => l_Last_Updated_By,

Line 1560: from po_acceptances

1556: and request_status = 'PENDING'
1557: and initiator = 'SUPPLIER'
1558: union all
1559: select acceptance_id
1560: from po_acceptances
1561: where po_header_id = hdr_id
1562: and revision_num = rev_num
1563: and po_line_location_id is not null;
1564:

Line 1574: from po_acceptances

1570: and request_status = 'PENDING'
1571: and initiator = 'SUPPLIER'
1572: union all
1573: select acceptance_id
1574: from po_acceptances
1575: where po_release_id = rel_id
1576: and revision_num = rev_num
1577: and po_line_location_id is not null;
1578:

Line 3522: po_acceptances pa,

3518: nvl(plla.unit_meas_lookup_code,pla.unit_meas_lookup_code) UOM,
3519: nvl(hla.location_code, substr(rtrim(hz.address1)||'-'||rtrim(hz.city),1,60)) SHIP_TO_LOCATION,
3520: pa.note NOTE
3521: from
3522: po_acceptances pa,
3523: po_lines_archive_all pla,
3524: po_line_locations_archive_all plla,
3525: hr_locations_all hla, hz_locations hz,
3526: mtl_system_items_kfv msi,

Line 3565: po_acceptances pa,

3561: nvl(plla.unit_meas_lookup_code,pla.unit_meas_lookup_code) UOM,
3562: nvl(hla.location_code, substr(rtrim(hz.address1)||'-'||rtrim(hz.city),1,60)) SHIP_TO_LOCATION,
3563: pa.NOTE NOTE
3564: from
3565: po_acceptances pa,
3566: po_lines_archive_all pla,
3567: po_line_locations_archive_all plla,
3568: hr_locations_all hla, hz_locations hz,
3569: mtl_system_items_kfv msi,