177:
178: FUNCTION get_rsrc_offset (
179: p_batch_id IN pm_btch_hdr_bak.batch_id%TYPE,
180: p_batchstep_no IN pm_rout_dtl.batchstep_no%TYPE,
181: p_activity IN pm_oprn_dtl.activity%TYPE,
182: p_offset IN pm_oprn_dtl.offset_interval%TYPE
183: )
184: RETURN NUMBER;
185:
178: FUNCTION get_rsrc_offset (
179: p_batch_id IN pm_btch_hdr_bak.batch_id%TYPE,
180: p_batchstep_no IN pm_rout_dtl.batchstep_no%TYPE,
181: p_activity IN pm_oprn_dtl.activity%TYPE,
182: p_offset IN pm_oprn_dtl.offset_interval%TYPE
183: )
184: RETURN NUMBER;
185:
186: FUNCTION get_min_capacity (
184: RETURN NUMBER;
185:
186: FUNCTION get_min_capacity (
187: p_batch_id pm_btch_hdr_bak.batch_id%TYPE,
188: p_rsrc pm_oprn_dtl.resources%TYPE
189: )
190: RETURN NUMBER;
191:
192: FUNCTION get_max_capacity (
190: RETURN NUMBER;
191:
192: FUNCTION get_max_capacity (
193: p_batch_id pm_btch_hdr_bak.batch_id%TYPE,
194: p_rsrc pm_oprn_dtl.resources%TYPE
195: )
196: RETURN NUMBER;
197:
198: FUNCTION get_capacity_uom (
196: RETURN NUMBER;
197:
198: FUNCTION get_capacity_uom (
199: p_batch_id pm_btch_hdr_bak.batch_id%TYPE,
200: p_rsrc pm_oprn_dtl.resources%TYPE
201: )
202: RETURN VARCHAR2;
203:
204: PROCEDURE get_capacity (
202: RETURN VARCHAR2;
203:
204: PROCEDURE get_capacity (
205: p_batch_id IN pm_btch_hdr_bak.batch_id%TYPE,
206: p_resources IN pm_oprn_dtl.resources%TYPE,
207: x_min_capacity OUT NOCOPY NUMBER,
208: x_max_capacity OUT NOCOPY NUMBER,
209: x_capacity_uom OUT NOCOPY VARCHAR2,
210: x_return_status OUT NOCOPY VARCHAR2