APPS.PO_ASL_UPGRADE_SV2 dependencies on PO_APPROVED_SUPPLIER_LIST

Line 261: SELECT PO_APPROVED_SUPPLIER_LIST_S.NEXTVAL

257:
258:
259:
260: CURSOR I2 is
261: SELECT PO_APPROVED_SUPPLIER_LIST_S.NEXTVAL
262: FROM SYS.DUAL;
263:
264: BEGIN
265:

Line 320: -- insert new record in po_approved_supplier_list.

316: -- The reason we are doing the above is because we do not do
317: -- anything with the owning org hence any owning org is fine.(R11)
318:
319: -- If supplier-item relationship has not yet been created,
320: -- insert new record in po_approved_supplier_list.
321: -- Temporarily set request_id to -99 so that we can identify
322: -- the ASL records created in this upgrade.
323:
324: x_progress := '020';

Line 345: INSERT INTO PO_APPROVED_SUPPLIER_LIST(

341: fnd_file.put_line(fnd_file.log, 'owning_org '||to_char(x_owning_organization_id));
342: fnd_file.put_line(fnd_file.log, 'update by '|| to_char(x_last_updated_by) );
343: fnd_file.put_line(fnd_file.log, 'created by '||to_char(x_created_by) );
344:
345: INSERT INTO PO_APPROVED_SUPPLIER_LIST(
346: asl_id ,
347: using_organization_id ,
348: owning_organization_id ,
349: vendor_business_type ,

Line 510: FROM po_approved_supplier_list pasl

506:
507: x_progress := '050';
508: SELECT asl_id
509: INTO x_asl_id
510: FROM po_approved_supplier_list pasl
511: WHERE pasl.vendor_id = x_vendor_id
512: AND pasl.item_id = x_item_id
513: AND using_organization_id = -1;
514:

Line 579: FROM po_approved_supplier_list

575: -- documents to it.
576:
577: SELECT request_id
578: INTO x_request_id
579: FROM po_approved_supplier_list
580: WHERE asl_id = x_asl_id;
581:
582: IF (x_request_id IS NULL OR x_request_id <> -99) THEN
583: null;