DBA Data[Home] [Help]

APPS.GME_INSERT_STEP_PVT dependencies on GME_BATCH_HEADER

Line 7: p_gme_batch_header IN gme_batch_header%ROWTYPE

3: g_debug VARCHAR2 (5) := fnd_profile.VALUE ('AFLOG_LEVEL');
4: g_pkg_name CONSTANT VARCHAR2 (30) := 'GME_API_INSERT_STEP';
5:
6: PROCEDURE insert_batch_step (
7: p_gme_batch_header IN gme_batch_header%ROWTYPE
8: ,p_gme_batch_step IN gme_batch_steps%ROWTYPE
9: ,x_gme_batch_step OUT NOCOPY gme_batch_steps%ROWTYPE
10: ,x_return_status OUT NOCOPY VARCHAR2)
11: IS

Line 94: NVL (p_gme_batch_step.batch_id, p_gme_batch_header.batch_id);

90:
91: x_return_status := fnd_api.g_ret_sts_success;
92: /* Bug 2397077 Use only one batch_id when batch IDs passed in both parameters. */
93: l_batch_id :=
94: NVL (p_gme_batch_step.batch_id, p_gme_batch_header.batch_id);
95:
96: /* End Bug 2397077 */
97: IF p_gme_batch_step.batchstep_no IS NULL THEN
98: gme_common_pvt.log_message ('GME_STEP_REQD'

Line 124: IF (p_gme_batch_header.batch_status = 4)

120: RAISE expected_error;
121: END IF;
122:
123: /* End Bug 2397077 */
124: IF (p_gme_batch_header.batch_status = 4)
125: OR (p_gme_batch_header.batch_status = -1) THEN
126: -- Closed or cancelled batch not valid for step insert...
127: RAISE error_inv_status_ins_step;
128: END IF;

Line 125: OR (p_gme_batch_header.batch_status = -1) THEN

121: END IF;
122:
123: /* End Bug 2397077 */
124: IF (p_gme_batch_header.batch_status = 4)
125: OR (p_gme_batch_header.batch_status = -1) THEN
126: -- Closed or cancelled batch not valid for step insert...
127: RAISE error_inv_status_ins_step;
128: END IF;
129:

Line 135: IF p_gme_batch_header.organization_id IS NULL THEN

131: RAISE error_no_oprn_defined;
132: END IF;
133:
134: /* Punit Kumar */
135: IF p_gme_batch_header.organization_id IS NULL THEN
136: RAISE error_no_organization_id;
137: END IF;
138:
139: /* Punit Kumar */

Line 140: OPEN get_orgn_code (p_gme_batch_header.organization_id);

136: RAISE error_no_organization_id;
137: END IF;
138:
139: /* Punit Kumar */
140: OPEN get_orgn_code (p_gme_batch_header.organization_id);
141:
142: FETCH get_orgn_code
143: INTO l_orgn_code;
144:

Line 155: , /* p_gme_batch_header.plant_code, */

151: (p_api_version => 1.0
152: ,p_init_msg_list => fnd_api.g_false
153: ,p_oprn_id => p_gme_batch_step.oprn_id
154: ,p_orgn_code => l_orgn_code
155: , /* p_gme_batch_header.plant_code, */
156: x_return_status => l_return_status
157: ,x_msg_count => l_message_count
158: ,x_msg_data => l_message_data
159: ,x_return_code => l_return_code

Line 235: IF (p_gme_batch_header.automatic_step_calculation = 1) THEN

231: l_recipe_rout_step (1).capacity_uom := l_recipe_rout_step (1).process_qty_uom;
232:
233: --bharati satpute bug2848936 Added
234: -- l_recipe_rout_step (1). minimum_transfer_qty := p_gme_batch_step.minimum_transfer_qty;
235: IF (p_gme_batch_header.automatic_step_calculation = 1) THEN
236: l_recipe_rout_step (1).step_qty := 0;
237: --NULL;
238: ELSE
239: IF p_gme_batch_step.plan_step_qty < 0 THEN

Line 273: ,p_gme_batch_header_rec => p_gme_batch_header

269: ,p_recipe_rout_resc_tbl => l_recipe_rout_resc
270: ,p_resc_parameters_tbl => l_resc_parameters
271: ,p_recipe_rout_matl_tbl => l_recipe_rout_matl
272: ,p_routing_depd_tbl => l_routing_depd
273: ,p_gme_batch_header_rec => p_gme_batch_header
274: ,p_use_workday_cal => fnd_api.g_true
275: ,p_contiguity_override => fnd_api.g_true
276: ,x_return_status => l_return_status
277: ,p_ignore_qty_below_cap => fnd_api.g_true