[Home] [Help]
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
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
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:
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);
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: