APPS.PO_LINE_TYPES_SV1 dependencies on PO_LINE_TYPES_VAL_V

Line 19: po_line_types_val_v table */

15: BEGIN
16: x_progress := '010';
17:
18: /* check to see if there are x_line_type_id exists in
19: po_line_types_val_v table */
20:
21: SELECT count(*)
22: INTO x_temp
23: FROM po_line_types_val_v

Line 23: FROM po_line_types_val_v

19: po_line_types_val_v table */
20:
21: SELECT count(*)
22: INTO x_temp
23: FROM po_line_types_val_v
24: WHERE line_type_id = x_line_type_id;
25:
26: IF x_temp = 0 THEN
27: RETURN FALSE; /* validation fails */

Line 53: /* derive line_type_id from po_line_types_val_v view based on

49: BEGIN
50:
51: X_progress := '010';
52:
53: /* derive line_type_id from po_line_types_val_v view based on
54: line_type which is being provided from input parameter */
55:
56: SELECT line_type_id
57: INTO X_line_type_id_v

Line 58: FROM po_line_types_val_v

54: line_type which is being provided from input parameter */
55:
56: SELECT line_type_id
57: INTO X_line_type_id_v
58: FROM po_line_types_val_v
59: WHERE line_type = X_line_type;
60:
61: RETURN X_line_type_id_v;
62: