[Home] [Help]
PACKAGE: APPS.GME_SCALE_BATCH_PVT
Source
1 PACKAGE gme_scale_batch_pvt AUTHID CURRENT_USER AS
2 /* $Header: GMEVSCBS.pls 120.1 2005/06/03 13:53:21 appldev $ */
3
4 /***********************************************************/
5 /* Oracle Process Manufacturing Process Execution APIs */
6 /* */
7 /* File Name: GMEVSCBS.pls */
8 /* Contents: Private layer for Scale batch API */
9 /* Author: Oracle */
10 /* Date: January 2001 */
11 /* */
12 /* History */
13 /* ======= */
14 /***********************************************************/
15 PROCEDURE scale_batch (
16 p_batch_header_rec IN gme_batch_header%ROWTYPE
17 ,p_scale_factor IN NUMBER
18 ,p_primaries IN VARCHAR2
19 ,p_qty_type IN NUMBER
20 ,p_validity_rule_id IN NUMBER := NULL
21 ,p_enforce_vldt_check IN VARCHAR2 := 'T'
22 ,p_recalc_dates IN VARCHAR2
23 ,p_use_workday_cal IN VARCHAR2
24 ,p_contiguity_override IN VARCHAR2
25 ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab
26 ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
27 ,x_return_status OUT NOCOPY VARCHAR2);
28
29 PROCEDURE scale_batch (
30 p_batch_header_rec IN gme_batch_header%ROWTYPE
31 ,p_material_tbl IN gme_common_pvt.material_details_tab
32 ,p_scale_factor IN NUMBER
33 ,p_primaries IN VARCHAR2
34 ,p_qty_type IN NUMBER DEFAULT 1
35 ,p_validity_rule_id IN NUMBER DEFAULT NULL
36 ,p_enforce_vldt_check IN VARCHAR2
37 ,p_recalc_dates IN VARCHAR2
38 ,p_use_workday_cal IN VARCHAR2
39 ,p_contiguity_override IN VARCHAR2
40 ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab
41 ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
42 , -- Navin
43 x_material_tbl OUT NOCOPY gme_common_pvt.material_details_tab
44 ,x_return_status OUT NOCOPY VARCHAR2);
45
46 PROCEDURE theoretical_yield_batch (
47 p_batch_header_rec IN gme_batch_header%ROWTYPE
48 ,p_scale_factor IN NUMBER
49 ,x_return_status OUT NOCOPY VARCHAR2);
50
51 FUNCTION get_total_qty (
52 p_material_tab IN gme_common_pvt.material_details_tab
53 ,p_batch_header_rec IN gme_batch_header%ROWTYPE)
54 RETURN NUMBER;
55
56 PROCEDURE scale_step_and_rsrc (
57 p_batch_id IN gme_batch_header.batch_id%TYPE
58 ,p_routing_scale_factor IN NUMBER
59 ,x_return_status OUT NOCOPY VARCHAR2);
60 END gme_scale_batch_pvt;