DBA Data[Home] [Help]

APPS.PO_COMPARE_REVISIONS dependencies on PO_HAZARD_CLASSES

Line 170: * PO_HAZARD_CLASSES table.

166: * Resolves the hazard class.
167: *
168: * ARGUMENTS
169: * p_hazard_class_id Unique identifier for hazard class in
170: * PO_HAZARD_CLASSES table.
171: *
172: * NOTES
173: * Return NULL if an error occurs.
174: *

Line 182: v_hazard_class po_hazard_classes.hazard_class%TYPE;

178: ********************************************************************/
179: FUNCTION get_hazard_class( p_hazard_class_id IN NUMBER )
180: RETURN VARCHAR2 AS
181:
182: v_hazard_class po_hazard_classes.hazard_class%TYPE;
183: v_progress varchar2(3);
184:
185: BEGIN
186:

Line 191: FROM po_hazard_classes

187: v_progress := '040';
188:
189: SELECT hazard_class
190: INTO v_hazard_class
191: FROM po_hazard_classes
192: WHERE hazard_class_id = p_hazard_class_id;
193:
194: RETURN v_hazard_class;
195:

Line 219: * PO_HAZARD_CLASSES table.

215: * Resolves the payment terms.
216: *
217: * ARGUMENTS
218: * p_term_id Unique identifier for hazard class in
219: * PO_HAZARD_CLASSES table.
220: *
221: * NOTES
222: * Return NULL if no matching records were found.
223: *