DBA Data[Home] [Help]

APPS.GME_UPDATE_STEP_QTY_PVT dependencies on GME_BATCH_STEPS

Line 5: p_batch_step_rec IN gme_batch_steps%ROWTYPE

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

Line 9: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE

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);

Line 16: p_batch_step_rec IN OUT NOCOPY gme_batch_steps%ROWTYPE);

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

Line 20: ,p_batch_step_rec IN OUT NOCOPY gme_batch_steps%ROWTYPE

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);

Line 27: p_step_id IN gme_batch_steps.batchstep_id%TYPE

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

Line 30: ,p_mass_qty IN gme_batch_steps.plan_mass_qty%TYPE

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

Line 31: ,p_vol_qty IN gme_batch_steps.plan_volume_qty%TYPE

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);

Line 34: ,x_charge OUT NOCOPY gme_batch_steps.plan_charges%TYPE

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

Line 39: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

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

Line 48: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

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

Line 77: p_batchstep_rec IN gme_batch_steps%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:

Line 79: ,x_batchstep_rec OUT NOCOPY gme_batch_steps%ROWTYPE

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;