APPS.PO_ASL_THS dependencies on PO_APPROVED_SUPPLIER_LIST

Line 55: FROM PO_APPROVED_SUPPLIER_LIST

51: x_last_update_login NUMBER,
52: x_disable_flag VARCHAR2) is
53:
54: cursor row_id is SELECT rowid
55: FROM PO_APPROVED_SUPPLIER_LIST
56: WHERE x_asl_id = asl_id;
57:
58: x_record_unique BOOLEAN;
59:

Line 93: SELECT po_approved_supplier_list_s.nextval

89: end if;
90:
91: if (x_asl_id is null) then
92:
93: SELECT po_approved_supplier_list_s.nextval
94: INTO x_asl_id
95: FROM sys.dual;
96:
97: end if;

Line 99: INSERT INTO PO_APPROVED_SUPPLIER_LIST(

95: FROM sys.dual;
96:
97: end if;
98:
99: INSERT INTO PO_APPROVED_SUPPLIER_LIST(
100: asl_id ,
101: using_organization_id ,
102: owning_organization_id ,
103: vendor_business_type ,