1 PACKAGE gme_update_step_qty_pvt AS
2 /* $Header: GMEVUSQS.pls 120.2.12000000.2 2007/01/26 23:09:10 snene 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 PROCEDURE build_insert_resource_txn (
57 p_batch_hdr_rec IN gme_batch_header%ROWTYPE
58 ,p_batchstep_resource IN gme_batch_step_resources%ROWTYPE
59 ,p_usage IN NUMBER
60 ,p_completed IN NUMBER DEFAULT 1
61 ,x_return_status OUT NOCOPY VARCHAR2);
62
63 PROCEDURE adjust_pending_usage (
64 p_batch_step_resources_rec IN gme_batch_step_resources%ROWTYPE
65 ,x_return_status OUT NOCOPY VARCHAR2);
66
67 PROCEDURE adjust_actual_usage (
68 p_batch_step_resources_rec IN gme_batch_step_resources%ROWTYPE
69 ,x_return_status OUT NOCOPY VARCHAR2);
70
71 PROCEDURE reduce_pending_usage (
72 p_batch_step_resources_rec IN gme_batch_step_resources%ROWTYPE
73 ,x_return_status OUT NOCOPY VARCHAR2);
74
75 --Bug#5231180 added the following new procedure to calculate charges
76 PROCEDURE recalculate_charges(
77 p_batchstep_rec IN gme_batch_steps%ROWTYPE
78 ,p_cal_type IN VARCHAR2
79 ,x_batchstep_rec OUT NOCOPY gme_batch_steps%ROWTYPE
80 ,x_return_status OUT NOCOPY VARCHAR2);
81
82 END gme_update_step_qty_pvt;