DBA Data[Home] [Help]

APPS.POA_DBI_ITEMS_PKG dependencies on POA_ITEMS_S

Line 109: values (poa_items_s.nextval,p_item_id,p_org_id,p_category_id,p_vendor_product_num, p_vendor_id, p_description)

105: l_item_key NUMBER ;
106: begin
107: --lock table poa_items in exclusive mode;
108: insert into poa_items (po_item_id, item_id, organization_id, category_id, vendor_product_num, vendor_id, description)
109: values (poa_items_s.nextval,p_item_id,p_org_id,p_category_id,p_vendor_product_num, p_vendor_id, p_description)
110: returning po_item_id INTO l_item_key;
111: commit;
112: return l_item_key;
113: EXCEPTION