eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GME_BATCH_STEP_CHG_PVT dependencies on GME_BATCH_STEP_CHARGES

Line 441: FROM gme_batch_step_charges

437: v_batch_id NUMBER
438: ,v_batchstep_id NUMBER)
439: IS
440: SELECT 1
441: FROM gme_batch_step_charges
442: WHERE batch_id = v_batch_id
443: AND batchstep_id = v_batchstep_id
444: AND ROWNUM = 1;
445:

Line 472: UPDATE gme_batch_step_charges

468:
469: IF cur_is_charge_associated%FOUND THEN
470: CLOSE cur_is_charge_associated;
471:
472: UPDATE gme_batch_step_charges
473: SET plan_start_date = NULL
474: ,plan_cmplt_date = NULL
475: ,last_update_date = gme_common_pvt.g_timestamp
476: ,last_updated_by = gme_common_pvt.g_user_ident

Line 509: UPDATE gme_batch_step_charges

505:
506: IF cur_is_charge_associated%FOUND THEN
507: CLOSE cur_is_charge_associated;
508:
509: UPDATE gme_batch_step_charges
510: SET plan_start_date = NULL
511: ,plan_cmplt_date = NULL
512: ,last_update_date = gme_common_pvt.g_timestamp
513: ,last_updated_by = gme_common_pvt.g_user_ident

Line 561: FROM gme_batch_step_charges

557: v_batch_id NUMBER
558: ,v_batchstep_id NUMBER)
559: IS
560: SELECT 1
561: FROM gme_batch_step_charges
562: WHERE batch_id = v_batch_id
563: AND batchstep_id = v_batchstep_id
564: AND ROWNUM = 1;
565:

Line 569: l_batch_step_charges_in gme_batch_step_charges%ROWTYPE;

565:
566: l_gme_batchstep_ids_tab gme_batch_step_chg_pvt.gme_batchstep_ids_tab;
567: l_cur_is_charge_associated cur_is_charge_associated%ROWTYPE;
568: l_return_status VARCHAR2 (1);
569: l_batch_step_charges_in gme_batch_step_charges%ROWTYPE;
570: clear_chg_error EXCEPTION;
571: BEGIN
572: /* Set the return status to success initially */
573: x_return_status := fnd_api.g_ret_sts_success;

Line 663: This procedure calcualates the activity_sequence_number of gme_batch_step_charges table

659: /*===========================================================================================
660: Procedure
661: calc_activity_sequence_number
662: Description
663: This procedure calcualates the activity_sequence_number of gme_batch_step_charges table
664: Parameters
665: p_batchstep_id Batchstep id of the step for whose charge details,the activity
666: sequence is to be calculated.
667: p_resoures Resource associated with the charges for the step represented by

Line 734: This procedure populates the charge details table gme_batch_step_charges.

730: /*===========================================================================================
731: Procedure
732: populate_charges_table
733: Description
734: This procedure populates the charge details table gme_batch_step_charges.
735: Parameters
736: p_batchstep_charges_in The gme_batch_step_charges%ROWTYPE variable used to populate the
737: table.
738: p_no_of_charges The number of calculated charges.

Line 736: p_batchstep_charges_in The gme_batch_step_charges%ROWTYPE variable used to populate the

732: populate_charges_table
733: Description
734: This procedure populates the charge details table gme_batch_step_charges.
735: Parameters
736: p_batchstep_charges_in The gme_batch_step_charges%ROWTYPE variable used to populate the
737: table.
738: p_no_of_charges The number of calculated charges.
739: p_remaining_quantity The quantity for the last charge.
740: x_return_status outcome of the API call

Line 751: p_batchstep_charges_in IN gme_batch_step_charges%ROWTYPE

747: Rishi Varma B3718176 23-07-2004
748: Created.
749: =============================================================================================*/
750: PROCEDURE populate_charges_table (
751: p_batchstep_charges_in IN gme_batch_step_charges%ROWTYPE
752: ,p_no_of_charges IN NUMBER
753: ,p_remaining_quantity IN NUMBER
754: ,x_return_status OUT NOCOPY VARCHAR2)
755: IS

Line 757: l_batchstep_charges_in gme_batch_step_charges%ROWTYPE;

753: ,p_remaining_quantity IN NUMBER
754: ,x_return_status OUT NOCOPY VARCHAR2)
755: IS
756: l_api_name CONSTANT VARCHAR2 (30) := 'POPULATE_CHARGES_TABLE';
757: l_batchstep_charges_in gme_batch_step_charges%ROWTYPE;
758: l_activity_sequence_number NUMBER;
759: l_return_status VARCHAR2 (1);
760: error_act_seq_num_calc EXCEPTION;
761: error_charge_insert EXCEPTION;