1 PACKAGE gme_update_step_qty_pvt AUTHID CURRENT_USER AS
2 /* $Header: GMEVUSQS.pls 120.4.12010000.2 2010/03/22 15:40:38 gmurator ship $ */
3 --Bug#5606246 Added a new variable p_material_step_id to update_step_qty procedure.
4 PROCEDURE update_step_qty (
5 p_batch_step_rec IN gme_batch_steps%ROWTYPE
6 ,x_message_count OUT NOCOPY NUMBER
7 ,x_message_list OUT NOCOPY VARCHAR2
8 ,x_return_status OUT NOCOPY VARCHAR2
9 ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
10 ,p_routing_scale_factor IN NUMBER DEFAULT NULL
11 ,p_backflush_factor IN NUMBER DEFAULT NULL
12 ,p_dependency_type IN NUMBER DEFAULT NULL
13 ,p_material_step_id IN NUMBER DEFAULT NULL);
14
15 PROCEDURE calculate_mass_vol_qty (
16 p_batch_step_rec IN OUT NOCOPY gme_batch_steps%ROWTYPE);
17
18 PROCEDURE calculate_quantities (
19 p_batch_hdr_rec IN gme_batch_header%ROWTYPE
20 ,p_batch_step_rec IN OUT NOCOPY gme_batch_steps%ROWTYPE
21 ,x_return_status OUT NOCOPY VARCHAR2
22 ,p_routing_scale_factor IN NUMBER DEFAULT NULL
23 ,p_backflush_factor IN NUMBER DEFAULT NULL
24 ,p_dependency_type IN NUMBER DEFAULT NULL);
25
26 PROCEDURE calc_charge (
27 p_step_id IN gme_batch_steps.batchstep_id%TYPE
28 ,p_resources IN gme_batch_step_resources.resources%TYPE
29 DEFAULT NULL
30 ,p_mass_qty IN gme_batch_steps.plan_mass_qty%TYPE
31 ,p_vol_qty IN gme_batch_steps.plan_volume_qty%TYPE
32 ,p_step_qty IN NUMBER DEFAULT NULL --Bug#5231180
33 ,p_max_capacity IN NUMBER DEFAULT NULL --Bug#5231180
34 ,x_charge OUT NOCOPY gme_batch_steps.plan_charges%TYPE
35 ,x_return_status OUT NOCOPY VARCHAR2);
36
37 PROCEDURE update_activities (
38 p_batch_hdr_rec IN gme_batch_header%ROWTYPE
39 ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
40 ,x_return_status OUT NOCOPY VARCHAR2
41 ,p_routing_scale_factor IN NUMBER DEFAULT NULL
42 ,p_backflush_factor IN NUMBER DEFAULT NULL
43 ,p_charge_diff IN NUMBER
44 ,p_dependency_type IN NUMBER DEFAULT NULL);
45
46 PROCEDURE update_resources (
47 p_batch_hdr_rec IN gme_batch_header%ROWTYPE
48 ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
49 ,p_batchstep_activities_rec IN gme_batch_step_activities%ROWTYPE
50 ,x_return_status OUT NOCOPY VARCHAR2
51 ,p_routing_scale_factor IN NUMBER DEFAULT NULL
52 ,p_backflush_factor IN NUMBER DEFAULT NULL
53 ,p_charge_diff IN NUMBER DEFAULT NULL
54 ,p_dependency_type IN NUMBER DEFAULT NULL);
55
56 -- Bug 8751983 - Add trans_date parameter.
57 PROCEDURE build_insert_resource_txn (
58 p_batch_hdr_rec IN gme_batch_header%ROWTYPE
59 ,p_batchstep_resource IN gme_batch_step_resources%ROWTYPE
60 ,p_usage IN NUMBER
61 ,p_completed IN NUMBER DEFAULT 1
62 ,p_trans_date IN DATE DEFAULT NULL
63 ,x_return_status OUT NOCOPY VARCHAR2);
64
65 PROCEDURE adjust_pending_usage (
66 p_batch_step_resources_rec IN gme_batch_step_resources%ROWTYPE
67 ,x_return_status OUT NOCOPY VARCHAR2);
68
69 PROCEDURE adjust_actual_usage (
70 p_batch_step_resources_rec IN gme_batch_step_resources%ROWTYPE
71 ,x_return_status OUT NOCOPY VARCHAR2);
72
73 PROCEDURE reduce_pending_usage (
74 p_batch_step_resources_rec IN gme_batch_step_resources%ROWTYPE
75 ,x_return_status OUT NOCOPY VARCHAR2);
76
77 --Bug#5231180 added the following new procedure to calculate charges
78 PROCEDURE recalculate_charges(
79 p_batchstep_rec IN gme_batch_steps%ROWTYPE
80 ,p_cal_type IN VARCHAR2
81 ,x_batchstep_rec OUT NOCOPY gme_batch_steps%ROWTYPE
82 ,x_return_status OUT NOCOPY VARCHAR2);
83
84 END gme_update_step_qty_pvt;