APPS.PO_VENDORS_SV1 dependencies on PO_SUPPLIERS_VAL_V

Line 25: /* make sure that the vendor_id is valid in po_suppliers_val_v

21:
22: BEGIN
23: x_progress := '010';
24:
25: /* make sure that the vendor_id is valid in po_suppliers_val_v
26: view */
27:
28: SELECT count(*)
29: INTO x_temp_1

Line 30: FROM po_suppliers_val_v

26: view */
27:
28: SELECT count(*)
29: INTO x_temp_1
30: FROM po_suppliers_val_v
31: WHERE vendor_id = X_vendor_id;
32:
33: IF x_temp_1 = 0 THEN
34: X_error_code := 'PO_PDOI_INVALID_VENDOR';

Line 109: /* We will select the vendor id from the po_suppliers_val_v view

105:
106: BEGIN
107:
108: X_progress := '010';
109: /* We will select the vendor id from the po_suppliers_val_v view
110: based on the input vendor name. */
111:
112: SELECT COUNT(*)
113: INTO X_vendor_count

Line 114: FROM po_suppliers_val_v

110: based on the input vendor name. */
111:
112: SELECT COUNT(*)
113: INTO X_vendor_count
114: FROM po_suppliers_val_v
115: WHERE (vendor_name = X_vendor_name
116: OR
117: segment1 = X_vendor_num);
118:

Line 124: FROM po_suppliers_val_v

120: X_progress := '020';
121:
122: SELECT vendor_id
123: INTO X_vendor_name_v
124: FROM po_suppliers_val_v
125: WHERE (vendor_name = X_vendor_name
126: OR
127: segment1 = X_vendor_num);
128: