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 461: INSERT INTO po_asl_attributes(

457:
458: -- create global ASL in po_asl_documents
459:
460:
461: INSERT INTO po_asl_attributes(
462: asl_id,
463: using_organization_id,
464: last_update_date,
465: last_updated_by,

Line 557: from po_asl_attributes

553: select purchasing_unit_of_measure,
554: release_generation_method
555: into x_att_puom,
556: l_rel_gen_method
557: from po_asl_attributes
558: where asl_id = x_asl_id
559: and using_organization_id =l_using_organization_id --
560: and vendor_id = x_vendor_id
561: and vendor_site_id = x_vendor_site_id

Line 575: UPDATE po_asl_attributes

571: l_rel_gen_method := X_rel_gen_method;
572: end if;
573:
574:
575: UPDATE po_asl_attributes
576: set release_generation_method = l_rel_gen_method,
577: purchasing_unit_of_measure = x_att_puom,
578: last_update_date = x_last_update_date,
579: last_updated_by = x_last_updated_by,