APPS.PO_CHANGEORDERWF_PVT dependencies on PO_ACCEPTANCES

Line 824: l_Last_Update_Login PO_ACCEPTANCES.last_update_login%TYPE;

820: l_api_name varchar2(50) := 'Insert_Acc_Rejection_Row';
821: l_Acceptance_id number;
822: -- Bug 2850566
823: l_rowid ROWID;
824: l_Last_Update_Login PO_ACCEPTANCES.last_update_login%TYPE;
825: l_acc_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
826: -- End of Bug 2850566
827: l_Last_Update_Date date;
828: l_Last_Updated_By number;

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

837: l_Accepted_Flag varchar2(1) := p_flag;
838: -- l_Acceptance_Lookup_Code varchar2(25);
839: l_document_id number;
840: l_document_type_code po_document_types_all.DOCUMENT_TYPE_CODE%TYPE;
841: l_acceptance_note PO_ACCEPTANCES.note%TYPE; --bug 2178922
842: l_rspndr_usr_name fnd_user.user_name%TYPE := '';
843: l_accepting_party varchar2(1);
844: begin
845:

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

842: l_rspndr_usr_name fnd_user.user_name%TYPE := '';
843: l_accepting_party varchar2(1);
844: begin
845:
846: SELECT po_acceptances_s.nextval into l_Acceptance_id FROM sys.dual;
847:
848: -- commented out the usage of accptance_type (FPI)
849: /*
850: l_Acceptance_Lookup_Code := wf_engine.GetItemAttrText( itemtype => p_itemtype,

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

903: where po_release_id = l_document_id;
904: end if;
905:
906: -- Bug 2850566 RBAIRRAJ
907: -- Calling the Acceptances row handler to insert into the PO_ACCEPTANCES table
908: -- instead of writing an Insert statement.
909:
910: IF l_po_release_id IS NULL THEN
911: l_acc_po_header_id := l_po_header_id;

Line 933: PO_ACCEPTANCES_INS_PVT.insert_row(

929: end;
930: l_Last_Update_Login := l_Last_Updated_By;
931:
932:
933: PO_ACCEPTANCES_INS_PVT.insert_row(
934: x_rowid => l_rowid,
935: x_acceptance_id => l_Acceptance_id,
936: x_Last_Update_Date => l_Last_Update_Date,
937: x_Last_Updated_By => l_Last_Updated_By,

Line 1419: from po_acceptances

1415: and request_status = 'PENDING'
1416: and initiator = 'SUPPLIER'
1417: union all
1418: select acceptance_id
1419: from po_acceptances
1420: where po_header_id = hdr_id
1421: and revision_num = rev_num
1422: and po_line_location_id is not null;
1423:

Line 1433: from po_acceptances

1429: and request_status = 'PENDING'
1430: and initiator = 'SUPPLIER'
1431: union all
1432: select acceptance_id
1433: from po_acceptances
1434: where po_release_id = rel_id
1435: and revision_num = rev_num
1436: and po_line_location_id is not null;
1437:

Line 3370: po_acceptances pa,

3366: nvl(plla.unit_meas_lookup_code,pla.unit_meas_lookup_code) UOM,
3367: nvl(hla.location_code, substr(rtrim(hz.address1)||'-'||rtrim(hz.city),1,60)) SHIP_TO_LOCATION,
3368: pa.note NOTE
3369: from
3370: po_acceptances pa,
3371: po_lines_archive_all pla,
3372: po_line_locations_archive_all plla,
3373: hr_locations_all hla, hz_locations hz,
3374: mtl_system_items_kfv msi,

Line 3413: po_acceptances pa,

3409: nvl(plla.unit_meas_lookup_code,pla.unit_meas_lookup_code) UOM,
3410: nvl(hla.location_code, substr(rtrim(hz.address1)||'-'||rtrim(hz.city),1,60)) SHIP_TO_LOCATION,
3411: pa.NOTE NOTE
3412: from
3413: po_acceptances pa,
3414: po_lines_archive_all pla,
3415: po_line_locations_archive_all plla,
3416: hr_locations_all hla, hz_locations hz,
3417: mtl_system_items_kfv msi,