APPS.GME_DELETE_BATCH_STEP_PVT dependencies on GME_BATCH_STEP_RESOURCES

Line 140: FROM gme_batch_step_resources

136: UPDATE gme_resource_txns_gtmp
137: SET action_code = 'DEL'
138: WHERE line_id IN (
139: SELECT batchstep_resource_id
140: FROM gme_batch_step_resources
141: WHERE batch_id = l_batch_step.batch_id
142: AND batchstep_id = l_batch_step.batchstep_id)
143: AND action_code NOT IN ('REVS', 'REVL', 'DEL')
144: AND delete_mark <> 1;

Line 152: DELETE gme_batch_step_resources

148: WHERE batch_id = l_batch_step.batch_id
149: AND batchstep_id = l_batch_step.batchstep_id;
150:
151: -- 3. Delete all the resources
152: DELETE gme_batch_step_resources
153: WHERE batch_id = l_batch_step.batch_id
154: AND batchstep_id = l_batch_step.batchstep_id;
155:
156: -- 4. Delete all the activities

Line 307: l_gme_batchstep_resources gme_batch_step_resources%ROWTYPE;

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
311: SELECT batchstep_resource_id

Line 312: FROM gme_batch_step_resources

308:
309: CURSOR cur_step_resource_ids (v_batchstep_activity_id NUMBER)
310: IS
311: SELECT batchstep_resource_id
312: FROM gme_batch_step_resources
313: WHERE batchstep_activity_id = v_batchstep_activity_id;
314:
315: --Rishi Varma bug 3307549 13-May-2004 start
316: CURSOR cur_get_batch_id (v_batchstep_activity_id NUMBER)

Line 443: p_batch_step_resources_rec gme_batch_step_resources%ROWTYPE

439: Added code to remove the charges assocaited with a chargeable resource only if its the
440: last instance of the resource present in the step.
441: =============================================================================================*/
442: PROCEDURE delete_resource (
443: p_batch_step_resources_rec gme_batch_step_resources%ROWTYPE
444: ,x_return_status OUT NOCOPY VARCHAR2)
445: IS
446: /* 2841929: Added parameters to the cursor and passing proper parameters */
447: CURSOR cur_get_update_inventory (v_batch_id IN NUMBER)

Line 455: v_resources gme_batch_step_resources.resources%TYPE

451: WHERE batch_id = v_batch_id;
452:
453: --Rishi Varma bug# 3307549 10-05-2004
454: CURSOR cur_is_charge_associated (
455: v_resources gme_batch_step_resources.resources%TYPE
456: ,v_batchstep_id NUMBER)
457: IS
458: SELECT 1
459: FROM DUAL

Line 471: v_resources gme_batch_step_resources.resources%TYPE

467: resource_charge_delete_error EXCEPTION;
468:
469: --Rishi Varma B3718176 20-07-2004.
470: CURSOR cur_check_last_rsrc_instance (
471: v_resources gme_batch_step_resources.resources%TYPE
472: ,v_batchstep_id NUMBER)
473: IS
474: SELECT COUNT (1)
475: FROM gme_batch_step_resources

Line 475: FROM gme_batch_step_resources

471: v_resources gme_batch_step_resources.resources%TYPE
472: ,v_batchstep_id NUMBER)
473: IS
474: SELECT COUNT (1)
475: FROM gme_batch_step_resources
476: WHERE resources = v_resources AND batchstep_id = v_batchstep_id;
477:
478: l_rsrc_count NUMBER := -1;
479: l_api_name CONSTANT VARCHAR2 (30) := 'Delete_resource';

Line 484: l_batch_step_resource gme_batch_step_resources%ROWTYPE;

480: /* Local variables */
481: l_return_status VARCHAR2 (1);
482: l_update_inventory_ind VARCHAR2 (1);
483: l_rsrc_parameters gme_process_parameters%ROWTYPE;
484: l_batch_step_resource gme_batch_step_resources%ROWTYPE;
485: /* Exceptions */
486: trans_delete_error EXCEPTION;
487: activity_resource_delete_error EXCEPTION;
488: rsrc_param_delete_error EXCEPTION;

Line 499: IF NOT (gme_batch_step_resources_dbl.fetch_row

495: /* Set the return status to success initially */
496: x_return_status := fnd_api.g_ret_sts_success;
497:
498: /* 2841929: populate local variable with the current batchstep record */
499: IF NOT (gme_batch_step_resources_dbl.fetch_row
500: (p_batch_step_resources_rec
501: ,l_batch_step_resource) ) THEN
502: RAISE activity_resource_delete_error;
503: END IF;

Line 585: IF NOT (gme_batch_step_resources_dbl.delete_row

581: RAISE trans_delete_error;
582: END IF;
583: END IF;
584:
585: IF NOT (gme_batch_step_resources_dbl.delete_row
586: (p_batch_step_resources_rec) ) THEN
587: RAISE activity_resource_delete_error;
588: END IF;
589:

Line 628: p_batch_step_resources_rec gme_batch_step_resources%ROWTYPE

624: E - Error
625: U - Unexpected error
626: =============================================================================================*/
627: PROCEDURE delete_resource_transactions (
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;