1 PACKAGE gme_create_step_pvt AUTHID CURRENT_USER AS
2 /* $Header: GMEVCRSS.pls 120.3 2011/12/13 18:13:12 gmurator ship $ */
3 TYPE gme_batch_steps_tab IS TABLE OF gme_batch_steps%ROWTYPE;
4
5 TYPE gme_batch_step_activities_tab IS TABLE OF gme_batch_step_activities%ROWTYPE;
6
7 TYPE gme_batch_step_resources_tab IS TABLE OF gme_batch_step_resources%ROWTYPE;
8
9 TYPE gme_batch_step_dep_tab IS TABLE OF gme_batch_step_dependencies%ROWTYPE;
10
11 TYPE gme_batch_step_items_tab IS TABLE OF gme_batch_step_items%ROWTYPE;
12
13 TYPE gme_resource_txns_tab IS TABLE OF gme_resource_txns%ROWTYPE;
14
15 TYPE gme_process_parameters_tab IS TABLE OF gme_process_parameters%ROWTYPE;
16
17 TYPE step_duration_tab IS TABLE OF NUMBER
18 INDEX BY BINARY_INTEGER;
19
20 TYPE step_tab IS TABLE OF gme_batch_steps.batchstep_id%TYPE
21 INDEX BY BINARY_INTEGER;
22
23 TYPE activities_tab IS TABLE OF gme_batch_step_activities%ROWTYPE
24 INDEX BY BINARY_INTEGER;
25
26 TYPE resources_tab IS TABLE OF gme_batch_step_resources%ROWTYPE
27 INDEX BY BINARY_INTEGER;
28
29 TYPE rsrc_txns_tab IS TABLE OF gme_resource_txns%ROWTYPE
30 INDEX BY BINARY_INTEGER;
31
32 TYPE step_charge_rec IS RECORD (
33 step_id gme_batch_steps.batchstep_id%TYPE
34 ,charge gme_batch_steps.plan_charges%TYPE
35 );
36
37 TYPE charge_tab IS TABLE OF step_charge_rec
38 INDEX BY BINARY_INTEGER;
39
40 TYPE step_charge_rsrc_rec IS RECORD (
41 resources gme_batch_step_resources.resources%TYPE
42 );
43
44 TYPE step_charge_rsrc_tab IS TABLE OF step_charge_rsrc_rec
45 INDEX BY BINARY_INTEGER;
46
47 PROCEDURE create_batch_steps (
48 p_recipe_rout_step_tbl IN gmd_recipe_fetch_pub.recipe_step_tbl
49 ,p_recipe_rout_act_tbl IN gmd_recipe_fetch_pub.oprn_act_tbl
50 ,p_recipe_rout_resc_tbl IN gmd_recipe_fetch_pub.oprn_resc_tbl
51 ,p_resc_parameters_tbl IN gmd_recipe_fetch_pub.recp_resc_proc_param_tbl
52 ,p_recipe_rout_matl_tbl IN gmd_recipe_fetch_pub.recipe_rout_matl_tbl
53 ,p_routing_depd_tbl IN gmd_recipe_fetch_pub.routing_depd_tbl
54 ,p_gme_batch_header_rec IN gme_batch_header%ROWTYPE
55 ,p_use_workday_cal IN VARCHAR2
56 ,p_contiguity_override IN VARCHAR2
57 ,x_return_status OUT NOCOPY VARCHAR2
58 ,p_ignore_qty_below_cap IN VARCHAR2 DEFAULT fnd_api.g_true
59 ,p_step_start_date IN DATE := NULL
60 ,p_step_cmplt_date IN DATE := NULL
61 ,p_step_due_date IN DATE := NULL);
62
63 PROCEDURE calc_dates (
64 p_gme_batch_header_rec IN gme_batch_header%ROWTYPE
65 ,p_use_workday_cal IN VARCHAR2
66 ,p_contiguity_override IN VARCHAR2
67 ,p_return_status OUT NOCOPY VARCHAR2
68 ,p_step_id IN gme_batch_steps.batchstep_id%TYPE
69 DEFAULT NULL
70 ,p_plan_start_date IN DATE DEFAULT NULL
71 ,p_plan_cmplt_date IN DATE DEFAULT NULL);
72
73 PROCEDURE update_charges (
74 p_batch_id IN NUMBER
75 ,p_step_charge_rsrc_tab IN gme_create_step_pvt.step_charge_rsrc_tab
76 ,x_return_status OUT NOCOPY VARCHAR2);
77
78 PROCEDURE calc_step_qty (
79 p_parent_id IN NUMBER
80 ,p_step_tbl OUT NOCOPY gmd_auto_step_calc.step_rec_tbl
81 ,p_return_status OUT NOCOPY VARCHAR2
82 ,p_called_from_batch IN NUMBER DEFAULT 1);
83
84 PROCEDURE copy_and_create_text (
85 p_gmd_text_code IN NUMBER
86 ,p_text_string IN gme_text_table.text%TYPE
87 ,x_gme_text_code OUT NOCOPY NUMBER
88 ,x_return_status OUT NOCOPY VARCHAR2);
89
90 -- G. Muratore Bug 7341534 - Frontport of 6774660/5618732
91 -- Keeping original r 12 reworked code for now.Added new function
92 PROCEDURE calc_longest_time_orig (
93 l_batch_id IN gme_batch_header.batch_id%TYPE
94 ,l_step_duration_tab IN step_duration_tab
95 ,x_batch_duration OUT NOCOPY NUMBER
96 ,x_return_status OUT NOCOPY VARCHAR2);
97
98 PROCEDURE get_usage_in_hours (
99 p_plan_rsrc_usage IN gme_batch_step_resources.plan_rsrc_usage%TYPE
100 ,p_usage_um IN gme_batch_step_resources.usage_um%TYPE
101 ,x_usage_hrs OUT NOCOPY gme_batch_step_resources.plan_rsrc_usage%TYPE
102 ,x_return_status OUT NOCOPY VARCHAR2);
103
104 FUNCTION get_max_duration (v_step_id IN NUMBER, v_batch_id IN NUMBER)
105 RETURN NUMBER;
106
107 -- Bug 9212573 - add parameter p_trans_count.
108 PROCEDURE insert_resource_txns (
109 p_gme_batch_header_rec IN gme_batch_header%ROWTYPE
110 ,p_doc_type IN VARCHAR2
111 ,p_batch_step_resources_rec IN gme_batch_step_resources%ROWTYPE
112 ,p_trans_count IN NUMBER
113 ,x_return_status OUT NOCOPY VARCHAR2);
114
115 FUNCTION get_max_step_date (
116 p_use_workday_cal IN VARCHAR2
117 ,p_calendar_code IN VARCHAR2
118 ,p_batchstep_id IN NUMBER
119 ,p_batch_id IN NUMBER
120 ,p_batch_start_date IN DATE)
121 RETURN DATE;
122
123 FUNCTION get_working_start_time (
124 p_start_date IN DATE
125 ,p_offset IN NUMBER
126 ,p_calendar_code IN VARCHAR2)
127 RETURN DATE;
128
129 -- G. Muratore Bug 7341534 - Frontport of 6774660/5618732 Reinstate rewritten 11i function
130 PROCEDURE calc_longest_time (
131 l_batch_id IN gme_batch_header.batch_id%TYPE
132 ,l_step_duration_tab IN step_duration_tab
133 ,x_batch_duration OUT NOCOPY NUMBER
134 ,x_return_status OUT NOCOPY VARCHAR2);
135
136 -- G. Muratore Bug 7341534 - Frontport of 6774660/5618732 Added new function
137 FUNCTION get_longest_in_branch (
138 node IN NUMBER,
139 l_step_duration_tab IN step_duration_tab)
140 RETURN NUMBER;
141
142 END gme_create_step_pvt;