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.GMS_BILLING dependencies on GMS_EVENTS_TEMP_FORMAT

Line 3467: -- events stored in temporary global table gms_events_temp_format.

3463:
3464: ------------------------------------------------------------------------------------------
3465: -- Bug 3235390 : Introduced the following procedure
3466: -- PROCESS_TEMP_EVENTS : This procedure is used to insert / update the temporary
3467: -- events stored in temporary global table gms_events_temp_format.
3468: ------------------------------------------------------------------------------------------
3469: PROCEDURE PROCESS_TEMP_EVENTS (p_act_project_id IN NUMBER,
3470: p_task_id IN NUMBER,
3471: p_invfmt_incl_task IN VARCHAR2, /* Bug 3523930*/

Line 3488: FROM gms_events_temp_format

3484:
3485: /* Added below 2 cursors for 3523930*/
3486: CURSOR C_event_exists_PTF IS
3487: SELECT event_num
3488: FROM gms_events_temp_format
3489: WHERE act_project_id = p_act_project_id
3490: AND task_id = p_task_id
3491: AND NVL(format,'X') = NVL(p_format,'X');
3492:

Line 3495: FROM gms_events_temp_format

3491: AND NVL(format,'X') = NVL(p_format,'X');
3492:
3493: CURSOR C_event_exists_F IS
3494: SELECT event_num
3495: FROM gms_events_temp_format
3496: WHERE NVL(format,'X') = NVL(p_format,'X');
3497:
3498: BEGIN
3499:

Line 3522: UPDATE gms_events_temp_format

3518: THEN
3519: --If there exists a temporary event with exact match then we dont need to bother about the p_invfmt_incl_task = 'N'
3520: --and update the event with the amount
3521:
3522: UPDATE gms_events_temp_format
3523: SET amount = amount + p_amount,
3524: quantity = quantity + p_quantity,
3525: description = decode(p_calling_place,'Revenue',p_description || '- '|| to_char(quantity + p_quantity) || ' ' ||p_units,p_description)
3526: WHERE event_num = p_Event_num

Line 3532: gms_error_pkg.gms_debug('IN PROCESS_TEMP_EVENTS - After updating '||p_event_num||' in gms_events_temp_format with amount '||p_amount ,'C');

3528: AND task_id = p_task_id
3529: AND nvl(format,'X') = nvl(p_format,'X'); -- for bug 5413530
3530:
3531: IF L_DEBUG = 'Y' THEN
3532: gms_error_pkg.gms_debug('IN PROCESS_TEMP_EVENTS - After updating '||p_event_num||' in gms_events_temp_format with amount '||p_amount ,'C');
3533: END IF;
3534:
3535: ELSE
3536:

Line 3539: --the event_num which is already creatd for this format and insert new line into gms_events_temp_format with

3535: ELSE
3536:
3537: IF p_invfmt_incl_task = 'N' THEN
3538: --If there exists no temporary event with exact match and task id is not a format column then fetch
3539: --the event_num which is already creatd for this format and insert new line into gms_events_temp_format with
3540: --same event_num but with new task_id
3541:
3542: OPEN C_event_exists_F;
3543: FETCH C_event_exists_F INTO p_event_num ;

Line 3560: INSERT INTO gms_events_temp_format(Event_num ,

3556: p_Event_num := x_temp_negative_evt_num;
3557: X_temp_negative_evt_num :=x_temp_negative_evt_num-1;
3558: END If;
3559:
3560: INSERT INTO gms_events_temp_format(Event_num ,
3561: ACT_PROJECT_ID,
3562: TASK_ID,
3563: QUANTITY,
3564: AMOUNT,

Line 3576: gms_error_pkg.gms_debug('IN PROCESS_TEMP_EVENTS - After inserting event '||p_event_num||' into gms_events_temp_format for task '||p_task_id ||' with amount '||p_amount,'C');

3572: p_format,
3573: l_description );
3574:
3575: IF L_DEBUG = 'Y' THEN
3576: gms_error_pkg.gms_debug('IN PROCESS_TEMP_EVENTS - After inserting event '||p_event_num||' into gms_events_temp_format for task '||p_task_id ||' with amount '||p_amount,'C');
3577: END IF;
3578:
3579: END IF;
3580: CLOSE C_event_exists_PTF;

Line 3649: FROM gms_events_temp_format

3645: SELECT event_num,
3646: format,
3647: description,
3648: SUM(amount) amount
3649: FROM gms_events_temp_format
3650: GROUP BY event_num,format,description
3651: ORDER BY event_num desc;
3652:
3653: CURSOR C_get_temp_gms_events (p_evt_num NUMBER,

Line 3659: FROM gms_events_temp_format

3655: p_description VARCHAR2 ) IS
3656: SELECT act_project_id,
3657: task_id,
3658: SUM(amount) amount
3659: FROM gms_events_temp_format
3660: WHERE event_num = p_evt_num
3661: AND NVL(format,'X') = NVL(p_format,'X')
3662: AND description = p_description
3663: GROUP BY act_project_id,task_id;

Line 6913: -- BUG 3235390 : Deleting data from gms_events_temp_format

6909:
6910: EXIT WHEN GET_INSTALLMENTS%NOTFOUND;
6911:
6912:
6913: -- BUG 3235390 : Deleting data from gms_events_temp_format
6914: DELETE gms_events_temp_format;
6915:
6916: /* For bug 5026657 */
6917: f_dummy := 0;

Line 6914: DELETE gms_events_temp_format;

6910: EXIT WHEN GET_INSTALLMENTS%NOTFOUND;
6911:
6912:
6913: -- BUG 3235390 : Deleting data from gms_events_temp_format
6914: DELETE gms_events_temp_format;
6915:
6916: /* For bug 5026657 */
6917: f_dummy := 0;
6918:

Line 7305: -- BUG 3235390 : Deleting data from gms_events_temp_format

7301: END IF;
7302:
7303: f_dummy := 0 ; --For Bug 5026657
7304:
7305: -- BUG 3235390 : Deleting data from gms_events_temp_format
7306: DELETE gms_events_temp_format;
7307:
7308: WHILE f_dummy<2 LOOP /* dummy loop for re-processing , bug 5026657 */
7309:

Line 7306: DELETE gms_events_temp_format;

7302:
7303: f_dummy := 0 ; --For Bug 5026657
7304:
7305: -- BUG 3235390 : Deleting data from gms_events_temp_format
7306: DELETE gms_events_temp_format;
7307:
7308: WHILE f_dummy<2 LOOP /* dummy loop for re-processing , bug 5026657 */
7309:
7310: f_dummy := f_dummy + 1;