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 511: FROM gme_batch_step_charges

507: v_batch_id NUMBER
508: ,v_batchstep_id NUMBER)
509: IS
510: SELECT 1
511: FROM gme_batch_step_charges
512: WHERE batch_id = v_batch_id
513: AND batchstep_id = v_batchstep_id
514: AND ROWNUM = 1;
515:

Line 542: UPDATE gme_batch_step_charges

538:
539: IF cur_is_charge_associated%FOUND THEN
540: CLOSE cur_is_charge_associated;
541:
542: UPDATE gme_batch_step_charges
543: SET plan_start_date = NULL
544: ,plan_cmplt_date = NULL
545: ,last_update_date = gme_common_pvt.g_timestamp
546: ,last_updated_by = gme_common_pvt.g_user_ident

Line 579: UPDATE gme_batch_step_charges

575:
576: IF cur_is_charge_associated%FOUND THEN
577: CLOSE cur_is_charge_associated;
578:
579: UPDATE gme_batch_step_charges
580: SET plan_start_date = NULL
581: ,plan_cmplt_date = NULL
582: ,last_update_date = gme_common_pvt.g_timestamp
583: ,last_updated_by = gme_common_pvt.g_user_ident

Line 631: FROM gme_batch_step_charges

627: v_batch_id NUMBER
628: ,v_batchstep_id NUMBER)
629: IS
630: SELECT 1
631: FROM gme_batch_step_charges
632: WHERE batch_id = v_batch_id
633: AND batchstep_id = v_batchstep_id
634: AND ROWNUM = 1;
635:

Line 639: l_batch_step_charges_in gme_batch_step_charges%ROWTYPE;

635:
636: l_gme_batchstep_ids_tab gme_batch_step_chg_pvt.gme_batchstep_ids_tab;
637: l_cur_is_charge_associated cur_is_charge_associated%ROWTYPE;
638: l_return_status VARCHAR2 (1);
639: l_batch_step_charges_in gme_batch_step_charges%ROWTYPE;
640: clear_chg_error EXCEPTION;
641: BEGIN
642: /* Set the return status to success initially */
643: x_return_status := fnd_api.g_ret_sts_success;

Line 733: This procedure calcualates the activity_sequence_number of gme_batch_step_charges table

729: /*===========================================================================================
730: Procedure
731: calc_activity_sequence_number
732: Description
733: This procedure calcualates the activity_sequence_number of gme_batch_step_charges table
734: Parameters
735: p_batchstep_id Batchstep id of the step for whose charge details,the activity
736: sequence is to be calculated.
737: p_resoures Resource associated with the charges for the step represented by

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

800: /*===========================================================================================
801: Procedure
802: populate_charges_table
803: Description
804: This procedure populates the charge details table gme_batch_step_charges.
805: Parameters
806: p_batchstep_charges_in The gme_batch_step_charges%ROWTYPE variable used to populate the
807: table.
808: p_no_of_charges The number of calculated charges.

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

802: populate_charges_table
803: Description
804: This procedure populates the charge details table gme_batch_step_charges.
805: Parameters
806: p_batchstep_charges_in The gme_batch_step_charges%ROWTYPE variable used to populate the
807: table.
808: p_no_of_charges The number of calculated charges.
809: p_remaining_quantity The quantity for the last charge.
810: x_return_status outcome of the API call

Line 821: p_batchstep_charges_in IN gme_batch_step_charges%ROWTYPE

817: Rishi Varma B3718176 23-07-2004
818: Created.
819: =============================================================================================*/
820: PROCEDURE populate_charges_table (
821: p_batchstep_charges_in IN gme_batch_step_charges%ROWTYPE
822: ,p_no_of_charges IN NUMBER
823: ,p_remaining_quantity IN NUMBER
824: ,x_return_status OUT NOCOPY VARCHAR2)
825: IS

Line 827: l_batchstep_charges_in gme_batch_step_charges%ROWTYPE;

823: ,p_remaining_quantity IN NUMBER
824: ,x_return_status OUT NOCOPY VARCHAR2)
825: IS
826: l_api_name CONSTANT VARCHAR2 (30) := 'POPULATE_CHARGES_TABLE';
827: l_batchstep_charges_in gme_batch_step_charges%ROWTYPE;
828: l_activity_sequence_number NUMBER;
829: l_return_status VARCHAR2 (1);
830: error_act_seq_num_calc EXCEPTION;
831: error_charge_insert EXCEPTION;