1 PACKAGE gme_create_step_pvt AS
2 /* $Header: GMEVCRSS.pls 120.1.12010000.1 2008/07/25 10:29:58 appldev 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 PROCEDURE calc_longest_time (
91 l_batch_id IN gme_batch_header.batch_id%TYPE
92 ,l_step_duration_tab IN step_duration_tab
93 ,x_batch_duration OUT NOCOPY NUMBER
94 ,x_return_status OUT NOCOPY VARCHAR2);
95
96 PROCEDURE get_usage_in_hours (
97 p_plan_rsrc_usage IN gme_batch_step_resources.plan_rsrc_usage%TYPE
98 ,p_usage_um IN gme_batch_step_resources.usage_um%TYPE
99 ,x_usage_hrs OUT NOCOPY gme_batch_step_resources.plan_rsrc_usage%TYPE
100 ,x_return_status OUT NOCOPY VARCHAR2);
101
102 FUNCTION get_max_duration (v_step_id IN NUMBER, v_batch_id IN NUMBER)
103 RETURN NUMBER;
104
105 PROCEDURE insert_resource_txns (
106 p_gme_batch_header_rec IN gme_batch_header%ROWTYPE
107 ,p_doc_type IN VARCHAR2
108 ,p_batch_step_resources_rec IN gme_batch_step_resources%ROWTYPE
109 ,x_return_status OUT NOCOPY VARCHAR2);
110
111 FUNCTION get_max_step_date (
112 p_use_workday_cal IN VARCHAR2
113 ,p_calendar_code IN VARCHAR2
114 ,p_batchstep_id IN NUMBER
115 ,p_batch_id IN NUMBER
116 ,p_batch_start_date IN DATE)
117 RETURN DATE;
118
119 FUNCTION get_working_start_time (
120 p_start_date IN DATE
121 ,p_offset IN NUMBER
122 ,p_calendar_code IN VARCHAR2)
123 RETURN DATE;
124 END gme_create_step_pvt;