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_ADJUSTMENTS dependencies on GMS_EVENT_ATTRIBUTE

Line 22: from gms_event_attribute gea,

18: gea.actual_project_id,
19: gea.actual_task_id,
20: pt.top_task_id,
21: sum(gea.bill_amount) billed_amount -- null handling not reqd.
22: from gms_event_attribute gea,
23: pa_tasks pt
24: where gea.project_id = P_AWARD_PROJECT_ID
25: and gea.event_num in ( -1,-2)
26: and gea.request_id = P_REQUEST_ID

Line 95: Delete from gms_event_attribute

91: and request_id = p_request_id
92: and event_type = p_calling_process;
93:
94: -- E. Delete gea
95: Delete from gms_event_attribute
96: where project_id = p_award_project_id
97: and event_num in ( -1,-2)
98: and request_id = p_request_id
99: and event_calling_process = INITCAP(p_calling_process);

Line 253: from gms_event_attribute gea

249: gea.actual_Project_Id,
250: gea.Actual_Task_id,
251: gea.bill_amount,
252: gea.rowid
253: from gms_event_attribute gea
254: where gea.project_id = p_award_project_id
255: and gea.event_num = p_event_num;
256:
257: F_Total_Bill_Amt gms_event_attribute.bill_amount%type :=0;

Line 257: F_Total_Bill_Amt gms_event_attribute.bill_amount%type :=0;

253: from gms_event_attribute gea
254: where gea.project_id = p_award_project_id
255: and gea.event_num = p_event_num;
256:
257: F_Total_Bill_Amt gms_event_attribute.bill_amount%type :=0;
258: F_prorate_amt gms_event_attribute.bill_amount%type :=0;
259: F_Amount_written_off gms_event_attribute.bill_amount%type :=0;
260:
261: F_Event_Count Number := 0;

Line 258: F_prorate_amt gms_event_attribute.bill_amount%type :=0;

254: where gea.project_id = p_award_project_id
255: and gea.event_num = p_event_num;
256:
257: F_Total_Bill_Amt gms_event_attribute.bill_amount%type :=0;
258: F_prorate_amt gms_event_attribute.bill_amount%type :=0;
259: F_Amount_written_off gms_event_attribute.bill_amount%type :=0;
260:
261: F_Event_Count Number := 0;
262: F_Counter Number := 0;

Line 259: F_Amount_written_off gms_event_attribute.bill_amount%type :=0;

255: and gea.event_num = p_event_num;
256:
257: F_Total_Bill_Amt gms_event_attribute.bill_amount%type :=0;
258: F_prorate_amt gms_event_attribute.bill_amount%type :=0;
259: F_Amount_written_off gms_event_attribute.bill_amount%type :=0;
260:
261: F_Event_Count Number := 0;
262: F_Counter Number := 0;
263: F_Stage VARCHAR2(25);

Line 275: from gms_event_attribute

271: Loop
272: F_Stage := 'Get Total Event Inv Amt';
273: select sum(bill_amount),count(*)
274: into F_Total_Bill_Amt,F_Event_Count
275: from gms_event_attribute
276: where project_id = X_award_project_id
277: and event_num = Invoice_line.event_num;
278:
279: F_Stage := 'Main Processing';

Line 306: Update gms_event_attribute

302: End If;
303:
304: -- 2. Update gea
305: Begin
306: Update gms_event_attribute
307: set bill_amount = bill_amount - F_prorate_amt,
308: write_off_amount = nvl(write_off_amount,0) + F_prorate_amt
309: where rowid = event_attribute.rowid;
310:

Line 398: from gms_event_attribute

394: write_off_amount,
395: actual_project_id,
396: actual_task_id,
397: rowid
398: from gms_event_attribute
399: where project_id = F_invoice_Project_id
400: and event_num = F_invoice_Event_Num;
401:
402: F_project_id gms_event_attribute.project_id%type;

Line 402: F_project_id gms_event_attribute.project_id%type;

398: from gms_event_attribute
399: where project_id = F_invoice_Project_id
400: and event_num = F_invoice_Event_Num;
401:
402: F_project_id gms_event_attribute.project_id%type;
403: F_event_num gms_event_attribute.event_num%type;
404: F_installment_id gms_event_attribute.installment_id%type;
405: F_write_off_amount gms_event_attribute.write_off_amount%type;
406: F_actual_project_id gms_event_attribute.actual_project_id%type;

Line 403: F_event_num gms_event_attribute.event_num%type;

399: where project_id = F_invoice_Project_id
400: and event_num = F_invoice_Event_Num;
401:
402: F_project_id gms_event_attribute.project_id%type;
403: F_event_num gms_event_attribute.event_num%type;
404: F_installment_id gms_event_attribute.installment_id%type;
405: F_write_off_amount gms_event_attribute.write_off_amount%type;
406: F_actual_project_id gms_event_attribute.actual_project_id%type;
407: F_actual_task_id gms_event_attribute.actual_task_id%type;

Line 404: F_installment_id gms_event_attribute.installment_id%type;

400: and event_num = F_invoice_Event_Num;
401:
402: F_project_id gms_event_attribute.project_id%type;
403: F_event_num gms_event_attribute.event_num%type;
404: F_installment_id gms_event_attribute.installment_id%type;
405: F_write_off_amount gms_event_attribute.write_off_amount%type;
406: F_actual_project_id gms_event_attribute.actual_project_id%type;
407: F_actual_task_id gms_event_attribute.actual_task_id%type;
408:

Line 405: F_write_off_amount gms_event_attribute.write_off_amount%type;

401:
402: F_project_id gms_event_attribute.project_id%type;
403: F_event_num gms_event_attribute.event_num%type;
404: F_installment_id gms_event_attribute.installment_id%type;
405: F_write_off_amount gms_event_attribute.write_off_amount%type;
406: F_actual_project_id gms_event_attribute.actual_project_id%type;
407: F_actual_task_id gms_event_attribute.actual_task_id%type;
408:
409: Upd_amount gms_event_attribute.write_off_amount%type;

Line 406: F_actual_project_id gms_event_attribute.actual_project_id%type;

402: F_project_id gms_event_attribute.project_id%type;
403: F_event_num gms_event_attribute.event_num%type;
404: F_installment_id gms_event_attribute.installment_id%type;
405: F_write_off_amount gms_event_attribute.write_off_amount%type;
406: F_actual_project_id gms_event_attribute.actual_project_id%type;
407: F_actual_task_id gms_event_attribute.actual_task_id%type;
408:
409: Upd_amount gms_event_attribute.write_off_amount%type;
410: X_Total_Write_Off_Amt gms_event_attribute.write_off_amount%type;

Line 407: F_actual_task_id gms_event_attribute.actual_task_id%type;

403: F_event_num gms_event_attribute.event_num%type;
404: F_installment_id gms_event_attribute.installment_id%type;
405: F_write_off_amount gms_event_attribute.write_off_amount%type;
406: F_actual_project_id gms_event_attribute.actual_project_id%type;
407: F_actual_task_id gms_event_attribute.actual_task_id%type;
408:
409: Upd_amount gms_event_attribute.write_off_amount%type;
410: X_Total_Write_Off_Amt gms_event_attribute.write_off_amount%type;
411: F_rowid varchar2(50);

Line 409: Upd_amount gms_event_attribute.write_off_amount%type;

405: F_write_off_amount gms_event_attribute.write_off_amount%type;
406: F_actual_project_id gms_event_attribute.actual_project_id%type;
407: F_actual_task_id gms_event_attribute.actual_task_id%type;
408:
409: Upd_amount gms_event_attribute.write_off_amount%type;
410: X_Total_Write_Off_Amt gms_event_attribute.write_off_amount%type;
411: F_rowid varchar2(50);
412: F_Event_Count Number := 0;
413: F_Counter Number := 0;

Line 410: X_Total_Write_Off_Amt gms_event_attribute.write_off_amount%type;

406: F_actual_project_id gms_event_attribute.actual_project_id%type;
407: F_actual_task_id gms_event_attribute.actual_task_id%type;
408:
409: Upd_amount gms_event_attribute.write_off_amount%type;
410: X_Total_Write_Off_Amt gms_event_attribute.write_off_amount%type;
411: F_rowid varchar2(50);
412: F_Event_Count Number := 0;
413: F_Counter Number := 0;
414: F_Amount_written_off gms_event_attribute.bill_amount%type :=0;

Line 414: F_Amount_written_off gms_event_attribute.bill_amount%type :=0;

410: X_Total_Write_Off_Amt gms_event_attribute.write_off_amount%type;
411: F_rowid varchar2(50);
412: F_Event_Count Number := 0;
413: F_Counter Number := 0;
414: F_Amount_written_off gms_event_attribute.bill_amount%type :=0;
415:
416: BEGIN
417:
418: X_Err_Code := 0;

Line 434: from gms_event_attribute

430: BEGIN
431:
432: select sum(nvl(write_off_amount,0)),count(*)
433: into X_Total_Write_Off_Amt,F_Event_Count
434: from gms_event_attribute
435: where project_id = F_invoice_project_id
436: and event_num = F_Invoice_event_num;
437:
438: X_Err_Code := 0;

Line 472: /* Start Update gms_event_attribute */

468: Upd_amount := pa_currency.round_currency_amt((F_write_off_amount * F_Invoice_Amount)/X_Total_Write_Off_Amt);
469: F_Amount_written_off := F_Amount_written_off + Upd_amount;
470: End If;
471:
472: /* Start Update gms_event_attribute */
473:
474: BEGIN
475:
476: Update gms_event_attribute

Line 476: Update gms_event_attribute

472: /* Start Update gms_event_attribute */
473:
474: BEGIN
475:
476: Update gms_event_attribute
477: set write_off_amount = write_off_amount - Upd_amount,
478: bill_amount = bill_amount + Upd_amount
479: where rowid = F_rowid;
480:

Line 500: /* End - Update gms_event_attribute */

496: End If;
497:
498: END;
499:
500: /* End - Update gms_event_attribute */
501:
502: /* Update gms_summary_project_fundings */
503:
504: UPD_GMS_SUMMARY_PRJ_FUNDS(F_actual_project_id,

Line 530: -- Procedure DELETE_GMS_EVENT_ATTRIBUTE deletes the gms_event_attribute records

526: End Loop; -- get_invoice_items;
527:
528: END WRITE_OFF_DELETION;
529:
530: -- Procedure DELETE_GMS_EVENT_ATTRIBUTE deletes the gms_event_attribute records
531: -- Bug 2979125 : added parameter calling_process
532: Procedure DELETE_GMS_EVENT_ATTRIBUTE(X_Award_Project_Id IN NUMBER,
533: X_Event_Num IN NUMBER,
534: X_calling_process IN VARCHAR2,

Line 532: Procedure DELETE_GMS_EVENT_ATTRIBUTE(X_Award_Project_Id IN NUMBER,

528: END WRITE_OFF_DELETION;
529:
530: -- Procedure DELETE_GMS_EVENT_ATTRIBUTE deletes the gms_event_attribute records
531: -- Bug 2979125 : added parameter calling_process
532: Procedure DELETE_GMS_EVENT_ATTRIBUTE(X_Award_Project_Id IN NUMBER,
533: X_Event_Num IN NUMBER,
534: X_calling_process IN VARCHAR2,
535: X_Err_Code IN OUT NOCOPY NUMBER,
536: X_Err_Buff IN OUT NOCOPY VARCHAR2) IS

Line 541: FROM gms_event_attribute

537:
538: Begin
539:
540: DELETE
541: FROM gms_event_attribute
542: WHERE project_id=X_Award_Project_id
543: AND event_num=X_Event_Num
544: AND event_calling_process= x_calling_process ; -- Bug 2979125 : added filter calling_process
545:

Line 560: End DELETE_GMS_EVENT_ATTRIBUTE;

556: Else
557: X_Err_Code := 0;
558: End If;
559:
560: End DELETE_GMS_EVENT_ATTRIBUTE;
561:
562: Procedure GET_SUMM_REV_BILL_AMT(X_Installment_Id IN NUMBER,
563: X_Act_Project_Id IN NUMBER,
564: X_Act_Task_Id IN NUMBER,

Line 630: from gms_event_attribute

626: select installment_id,
627: actual_project_id,
628: actual_task_id,
629: decode(X_calling_Process,'Invoice',bill_amount,'Revenue',revenue_amount) Amount
630: from gms_event_attribute
631: where project_id = X_Award_Project_id
632: and event_num = X_Event_Num;
633:
634: F_Installment_id gms_event_attribute.installment_id%type;

Line 634: F_Installment_id gms_event_attribute.installment_id%type;

630: from gms_event_attribute
631: where project_id = X_Award_Project_id
632: and event_num = X_Event_Num;
633:
634: F_Installment_id gms_event_attribute.installment_id%type;
635: F_actual_project_id gms_event_attribute.actual_project_id%type;
636: F_actual_task_id gms_event_attribute.actual_task_id%type;
637: F_amount gms_event_attribute.bill_amount%type;
638:

Line 635: F_actual_project_id gms_event_attribute.actual_project_id%type;

631: where project_id = X_Award_Project_id
632: and event_num = X_Event_Num;
633:
634: F_Installment_id gms_event_attribute.installment_id%type;
635: F_actual_project_id gms_event_attribute.actual_project_id%type;
636: F_actual_task_id gms_event_attribute.actual_task_id%type;
637: F_amount gms_event_attribute.bill_amount%type;
638:
639: Begin

Line 636: F_actual_task_id gms_event_attribute.actual_task_id%type;

632: and event_num = X_Event_Num;
633:
634: F_Installment_id gms_event_attribute.installment_id%type;
635: F_actual_project_id gms_event_attribute.actual_project_id%type;
636: F_actual_task_id gms_event_attribute.actual_task_id%type;
637: F_amount gms_event_attribute.bill_amount%type;
638:
639: Begin
640:

Line 637: F_amount gms_event_attribute.bill_amount%type;

633:
634: F_Installment_id gms_event_attribute.installment_id%type;
635: F_actual_project_id gms_event_attribute.actual_project_id%type;
636: F_actual_task_id gms_event_attribute.actual_task_id%type;
637: F_amount gms_event_attribute.bill_amount%type;
638:
639: Begin
640:
641: X_Err_Code := 0;

Line 1246: F_request_id gms_event_attribute.request_id%TYPE; -- Added for bug 4594090

1242: X_Burden_Evt_Flag VARCHAR2(1);
1243:
1244: X_Concession_flag VARCHAR2(1);
1245:
1246: F_request_id gms_event_attribute.request_id%TYPE; -- Added for bug 4594090
1247:
1248: Begin
1249:
1250: If X_Adj_Action in ('CANCEL','DELETE') then

Line 1410: /* Delete entries from GMS_EVENT_ATTRIBUTE */

1406: If X_Err_Code <> 0 then
1407: RAISE FND_API.G_EXC_ERROR;
1408: End If;
1409:
1410: /* Delete entries from GMS_EVENT_ATTRIBUTE */
1411: /* Bug 2979125: added parameter calling_process */
1412: DELETE_GMS_EVENT_ATTRIBUTE(F_Award_Project_id,
1413: F_Event_Num,
1414: X_Calling_Process,

Line 1412: DELETE_GMS_EVENT_ATTRIBUTE(F_Award_Project_id,

1408: End If;
1409:
1410: /* Delete entries from GMS_EVENT_ATTRIBUTE */
1411: /* Bug 2979125: added parameter calling_process */
1412: DELETE_GMS_EVENT_ATTRIBUTE(F_Award_Project_id,
1413: F_Event_Num,
1414: X_Calling_Process,
1415: X_Err_Code,
1416: X_Err_Buff);

Line 1419: ,x_message =>'After DELETE_GMS_EVENT_ATTRIBUTE '||'-'||St_Err_Code

1415: X_Err_Code,
1416: X_Err_Buff);
1417:
1418: /* pa_billing_pub.insert_message(X_INSERTING_PROCEDURE_NAME => '6.2.5 - CANINV'
1419: ,x_message =>'After DELETE_GMS_EVENT_ATTRIBUTE '||'-'||St_Err_Code
1420: ,x_error_message => X_Err_Msg
1421: ,x_status => X_Status); */
1422:
1423: If X_Err_Code <> 0 then

Line 1510: /* Delete entries from GMS_EVENT_ATTRIBUTE */

1506: If X_Err_Code <> 0 then
1507: RAISE FND_API.G_EXC_ERROR;
1508: End If;
1509:
1510: /* Delete entries from GMS_EVENT_ATTRIBUTE */
1511: /* Bug 2979125 : added parameter calling_process */
1512: DELETE_GMS_EVENT_ATTRIBUTE(F_Award_Project_id,
1513: F_Event_Num,
1514: X_Calling_Process,

Line 1512: DELETE_GMS_EVENT_ATTRIBUTE(F_Award_Project_id,

1508: End If;
1509:
1510: /* Delete entries from GMS_EVENT_ATTRIBUTE */
1511: /* Bug 2979125 : added parameter calling_process */
1512: DELETE_GMS_EVENT_ATTRIBUTE(F_Award_Project_id,
1513: F_Event_Num,
1514: X_Calling_Process,
1515: X_Err_Code,
1516: X_Err_Buff);

Line 1519: ,x_message =>'After DELETE_GMS_EVENT_ATTRIBUTE '||'-'||St_Err_Code

1515: X_Err_Code,
1516: X_Err_Buff);
1517:
1518: /* pa_billing_pub.insert_message(X_INSERTING_PROCEDURE_NAME => '6.3.5 - CANINV'
1519: ,x_message =>'After DELETE_GMS_EVENT_ATTRIBUTE '||'-'||St_Err_Code
1520: ,x_error_message => X_Err_Msg
1521: ,x_status => X_Status); */
1522:
1523: If X_Err_Code <> 0 then

Line 1713: F_request_id gms_event_attribute.request_id%TYPE; -- 4594090

1709: X_Creation_Date DATE;
1710:
1711: X_Burden_Evt_Flag VARCHAR2(1);
1712:
1713: F_request_id gms_event_attribute.request_id%TYPE; -- 4594090
1714:
1715: Begin
1716: OPEN GET_REV_ITEMS_RDL;
1717: LOOP

Line 1839: /* Delete entries from GMS_EVENT_ATTRIBUTE */

1835: If X_Err_Code <> 0 then
1836: RAISE FND_API.G_EXC_ERROR;
1837: End If;
1838:
1839: /* Delete entries from GMS_EVENT_ATTRIBUTE */
1840: /* Bug 2979125 : added parameter calling_process */
1841: DELETE_GMS_EVENT_ATTRIBUTE(F_Award_Project_id,
1842: F_Event_Num,
1843: X_Calling_Process,

Line 1841: DELETE_GMS_EVENT_ATTRIBUTE(F_Award_Project_id,

1837: End If;
1838:
1839: /* Delete entries from GMS_EVENT_ATTRIBUTE */
1840: /* Bug 2979125 : added parameter calling_process */
1841: DELETE_GMS_EVENT_ATTRIBUTE(F_Award_Project_id,
1842: F_Event_Num,
1843: X_Calling_Process,
1844: X_Err_Code,
1845: X_Err_Buff);

Line 1944: /* Delete entries from GMS_EVENT_ATTRIBUTE */

1940: If X_Err_Code <> 0 then
1941: RAISE FND_API.G_EXC_ERROR;
1942: End If;
1943:
1944: /* Delete entries from GMS_EVENT_ATTRIBUTE */
1945: /* Bug 2979125 : added parameter calling_process */
1946: DELETE_GMS_EVENT_ATTRIBUTE(F_Award_Project_id,
1947: F_Event_Num,
1948: X_Calling_Process,

Line 1946: DELETE_GMS_EVENT_ATTRIBUTE(F_Award_Project_id,

1942: End If;
1943:
1944: /* Delete entries from GMS_EVENT_ATTRIBUTE */
1945: /* Bug 2979125 : added parameter calling_process */
1946: DELETE_GMS_EVENT_ATTRIBUTE(F_Award_Project_id,
1947: F_Event_Num,
1948: X_Calling_Process,
1949: X_Err_Code,
1950: X_Err_Buff);