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 3442: -- events stored in temporary global table gms_events_temp_format.

3438:
3439: ------------------------------------------------------------------------------------------
3440: -- Bug 3235390 : Introduced the following procedure
3441: -- PROCESS_TEMP_EVENTS : This procedure is used to insert / update the temporary
3442: -- events stored in temporary global table gms_events_temp_format.
3443: ------------------------------------------------------------------------------------------
3444: PROCEDURE PROCESS_TEMP_EVENTS (p_act_project_id IN NUMBER,
3445: p_task_id IN NUMBER,
3446: p_invfmt_incl_task IN VARCHAR2, /* Bug 3523930*/

Line 3463: FROM gms_events_temp_format

3459:
3460: /* Added below 2 cursors for 3523930*/
3461: CURSOR C_event_exists_PTF IS
3462: SELECT event_num
3463: FROM gms_events_temp_format
3464: WHERE act_project_id = p_act_project_id
3465: AND task_id = p_task_id
3466: AND NVL(format,'X') = NVL(p_format,'X');
3467:

Line 3470: FROM gms_events_temp_format

3466: AND NVL(format,'X') = NVL(p_format,'X');
3467:
3468: CURSOR C_event_exists_F IS
3469: SELECT event_num
3470: FROM gms_events_temp_format
3471: WHERE NVL(format,'X') = NVL(p_format,'X');
3472:
3473: BEGIN
3474:

Line 3497: UPDATE gms_events_temp_format

3493: THEN
3494: --If there exists a temporary event with exact match then we dont need to bother about the p_invfmt_incl_task = 'N'
3495: --and update the event with the amount
3496:
3497: UPDATE gms_events_temp_format
3498: SET amount = amount + p_amount,
3499: quantity = quantity + p_quantity,
3500: description = decode(p_calling_place,'Revenue',p_description || '- '|| to_char(quantity + p_quantity) || ' ' ||p_units,p_description)
3501: WHERE event_num = p_Event_num

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

3503: AND task_id = p_task_id
3504: AND nvl(format,'X') = nvl(p_format,'X'); -- for bug 5413530
3505:
3506: IF L_DEBUG = 'Y' THEN
3507: gms_error_pkg.gms_debug('IN PROCESS_TEMP_EVENTS - After updating '||p_event_num||' in gms_events_temp_format with amount '||p_amount ,'C');
3508: END IF;
3509:
3510: ELSE
3511:

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

3510: ELSE
3511:
3512: IF p_invfmt_incl_task = 'N' THEN
3513: --If there exists no temporary event with exact match and task id is not a format column then fetch
3514: --the event_num which is already creatd for this format and insert new line into gms_events_temp_format with
3515: --same event_num but with new task_id
3516:
3517: OPEN C_event_exists_F;
3518: FETCH C_event_exists_F INTO p_event_num ;

Line 3535: INSERT INTO gms_events_temp_format(Event_num ,

3531: p_Event_num := x_temp_negative_evt_num;
3532: X_temp_negative_evt_num :=x_temp_negative_evt_num-1;
3533: END If;
3534:
3535: INSERT INTO gms_events_temp_format(Event_num ,
3536: ACT_PROJECT_ID,
3537: TASK_ID,
3538: QUANTITY,
3539: AMOUNT,

Line 3551: 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');

3547: p_format,
3548: l_description );
3549:
3550: IF L_DEBUG = 'Y' THEN
3551: 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');
3552: END IF;
3553:
3554: END IF;
3555: CLOSE C_event_exists_PTF;

Line 3624: FROM gms_events_temp_format

3620: SELECT event_num,
3621: format,
3622: description,
3623: SUM(amount) amount
3624: FROM gms_events_temp_format
3625: GROUP BY event_num,format,description
3626: ORDER BY event_num desc;
3627:
3628: CURSOR C_get_temp_gms_events (p_evt_num NUMBER,

Line 3634: FROM gms_events_temp_format

3630: p_description VARCHAR2 ) IS
3631: SELECT act_project_id,
3632: task_id,
3633: SUM(amount) amount
3634: FROM gms_events_temp_format
3635: WHERE event_num = p_evt_num
3636: AND NVL(format,'X') = NVL(p_format,'X')
3637: AND description = p_description
3638: GROUP BY act_project_id,task_id;

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

6878:
6879: EXIT WHEN GET_INSTALLMENTS%NOTFOUND;
6880:
6881:
6882: -- BUG 3235390 : Deleting data from gms_events_temp_format
6883: DELETE gms_events_temp_format;
6884:
6885: /* For bug 5026657 */
6886: f_dummy := 0;

Line 6883: DELETE gms_events_temp_format;

6879: EXIT WHEN GET_INSTALLMENTS%NOTFOUND;
6880:
6881:
6882: -- BUG 3235390 : Deleting data from gms_events_temp_format
6883: DELETE gms_events_temp_format;
6884:
6885: /* For bug 5026657 */
6886: f_dummy := 0;
6887:

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

7270: END IF;
7271:
7272: f_dummy := 0 ; --For Bug 5026657
7273:
7274: -- BUG 3235390 : Deleting data from gms_events_temp_format
7275: DELETE gms_events_temp_format;
7276:
7277: WHILE f_dummy<2 LOOP /* dummy loop for re-processing , bug 5026657 */
7278:

Line 7275: DELETE gms_events_temp_format;

7271:
7272: f_dummy := 0 ; --For Bug 5026657
7273:
7274: -- BUG 3235390 : Deleting data from gms_events_temp_format
7275: DELETE gms_events_temp_format;
7276:
7277: WHILE f_dummy<2 LOOP /* dummy loop for re-processing , bug 5026657 */
7278:
7279: f_dummy := f_dummy + 1;