DBA Data[Home] [Help]

APPS.GME_DELETE_BATCH_STEP_PVT dependencies on GME_COMMON_PVT

Line 32: l_material_ids gme_common_pvt.number_tab;

28: IS
29: l_api_name CONSTANT VARCHAR2 (30) := 'delete_step';
30: /* Collections for details etc */
31: l_gme_batchstep_activities gme_batch_step_activities%ROWTYPE;
32: l_material_ids gme_common_pvt.number_tab;
33: l_batch_header gme_batch_header%ROWTYPE;
34: l_batch_step gme_batch_steps%ROWTYPE;
35: l_batchstep_dependency gme_batch_step_dependencies%ROWTYPE;
36: l_batchstep_items gme_batch_step_items%ROWTYPE;

Line 254: gme_common_pvt.log_message ('GME_STEP_NOT_PENDING');

250: EXCEPTION
251: WHEN invalid_step THEN
252: ROLLBACK TO SAVEPOINT delete_batch_step;
253: x_return_status := fnd_api.g_ret_sts_error;
254: gme_common_pvt.log_message ('GME_STEP_NOT_PENDING');
255: /* FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
256: P_data => x_message_list); */
257: WHEN error_calc_step_qty THEN
258: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

Line 266: gme_common_pvt.log_message ('GME_ONE_STEP_REQD');

262: x_return_status := fnd_api.g_ret_sts_error;
263: WHEN one_step_reqd THEN
264: ROLLBACK TO SAVEPOINT delete_batch_step;
265: x_return_status := fnd_api.g_ret_sts_error;
266: gme_common_pvt.log_message ('GME_ONE_STEP_REQD');
267: /* FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
268: P_data => x_message_list); */
269: WHEN step_activity_delete_error OR error_load_trans OR batch_step_fetch_error OR batch_header_fetch_error OR step_dependency_delete_error OR step_item_delete_error OR step_delete_error THEN
270: x_return_status := fnd_api.g_ret_sts_error;

Line 306: l_batchstep_resource_ids gme_common_pvt.number_tab;

302: ,x_return_status OUT NOCOPY VARCHAR2)
303: IS
304: l_api_name CONSTANT VARCHAR2 (30) := 'delete_activity';
305: /* Collections for details etc */
306: l_batchstep_resource_ids gme_common_pvt.number_tab;
307: l_gme_batchstep_resources gme_batch_step_resources%ROWTYPE;
308:
309: CURSOR cur_step_resource_ids (v_batchstep_activity_id NUMBER)
310: IS

Line 632: l_resource_tab gme_common_pvt.resource_transactions_tab;

628: p_batch_step_resources_rec gme_batch_step_resources%ROWTYPE
629: ,x_return_status OUT NOCOPY VARCHAR2)
630: IS
631: l_resource_txns gme_resource_txns_gtmp%ROWTYPE;
632: l_resource_tab gme_common_pvt.resource_transactions_tab;
633: l_api_name CONSTANT VARCHAR2 (30) := 'delete_resource_transactions';
634: l_return_status VARCHAR2 (1);
635: BEGIN
636: IF g_debug <= gme_debug.g_log_procedure THEN