APPS.PO_APPROVED_SUPPLIER_LIST_SV dependencies on PO_ASL_ATTRIBUTES

Line 17: po_asl_attributes,po_asl_documents

13: /*==================================================================
14: PROCEDURE NAME: create_po_asl_entries()
15:
16: DESCRIPTION: This API inserts row into po_approved_supplier_list,
17: po_asl_attributes,po_asl_documents
18:
19: PARAMETERS: X_interface_header_id, X_interface_line_id -
20: Sequence number generated from po_headers_interface_s
21: and po_lines_interface_s.

Line 450: INSERT INTO po_asl_attributes(

446:
447: -- create global ASL in po_asl_documents
448:
449:
450: INSERT INTO po_asl_attributes(
451: asl_id,
452: using_organization_id,
453: last_update_date,
454: last_updated_by,

Line 546: from po_asl_attributes

542: select purchasing_unit_of_measure,
543: release_generation_method
544: into x_att_puom,
545: l_rel_gen_method
546: from po_asl_attributes
547: where asl_id = x_asl_id
548: and using_organization_id =l_using_organization_id --
549: and vendor_id = x_vendor_id
550: and vendor_site_id = x_vendor_site_id

Line 564: UPDATE po_asl_attributes

560: l_rel_gen_method := X_rel_gen_method;
561: end if;
562:
563:
564: UPDATE po_asl_attributes
565: set release_generation_method = l_rel_gen_method,
566: purchasing_unit_of_measure = x_att_puom,
567: last_update_date = x_last_update_date,
568: last_updated_by = x_last_updated_by,