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_BURDEN_COMPONENTS

Line 70: from gms_burden_components /Added for bug 5060427/

66: and event_num = -1 /*Added for bug 5060427*/
67: UNION ALL
68: select expenditure_item_id,adl_line_num
69: -- from gms_event_intersect /* Commented for bug 5060427 */
70: from gms_burden_components /*Added for bug 5060427*/
71: where award_project_id = p_award_project_id
72: and request_id = p_request_id
73: and event_type = p_calling_process
74: and event_num = -2 /*Added for bug 5060427*/ )

Line 88: Delete from gms_burden_components

84: and request_id = p_request_id
85: and event_type = p_calling_process;
86:
87: -- D. Delete gbc
88: Delete from gms_burden_components
89: where award_project_id = p_award_project_id
90: and event_num = -2
91: and request_id = p_request_id
92: and event_type = p_calling_process;

Line 743: DELETE /+INDEX(GMS_BURDEN_COMPONENTS GMS_BURDEN_COMPONENTS_U1) /

739: X_Err_Code := 0;
740:
741: If X_Calling_Process = 'Invoice' then
742:
743: DELETE /*+INDEX(GMS_BURDEN_COMPONENTS GMS_BURDEN_COMPONENTS_U1) */
744: from
745: GMS_BURDEN_COMPONENTS
746: where
747: expenditure_item_id = X_Expenditure_Item_Id

Line 745: GMS_BURDEN_COMPONENTS

741: If X_Calling_Process = 'Invoice' then
742:
743: DELETE /*+INDEX(GMS_BURDEN_COMPONENTS GMS_BURDEN_COMPONENTS_U1) */
744: from
745: GMS_BURDEN_COMPONENTS
746: where
747: expenditure_item_id = X_Expenditure_Item_Id
748: and award_project_Id = X_Award_Project_Id
749: and event_num = X_Event_Num

Line 774: DELETE /+INDEX(GMS_BURDEN_COMPONENTS GMS_BURDEN_COMPONENTS_U1) /

770: X_Err_Code := 0;
771: End If;
772:
773: Elsif X_Calling_Process = 'Revenue' then
774: DELETE /*+INDEX(GMS_BURDEN_COMPONENTS GMS_BURDEN_COMPONENTS_U1) */
775: from
776: GMS_BURDEN_COMPONENTS
777: where
778: expenditure_item_id = X_Expenditure_Item_Id

Line 776: GMS_BURDEN_COMPONENTS

772:
773: Elsif X_Calling_Process = 'Revenue' then
774: DELETE /*+INDEX(GMS_BURDEN_COMPONENTS GMS_BURDEN_COMPONENTS_U1) */
775: from
776: GMS_BURDEN_COMPONENTS
777: where
778: expenditure_item_id = X_Expenditure_Item_Id
779: and award_project_Id = X_Award_Project_Id
780: and event_num = X_Event_Num

Line 1206: GMS_BURDEN_COMPONENTS

1202: Burden_Cost_Code,
1203: Expenditure_Org_Id,
1204: request_id -- Added for bug 4594090
1205: from
1206: GMS_BURDEN_COMPONENTS
1207: where
1208: award_project_id = F_Award_Project_Id and
1209: event_num = F_Event_Num and
1210: event_type = 'INVOICE';

Line 1466: /* Deleting items from GMS_BURDEN_COMPONENTS table */

1462: RAISE FND_API.G_EXC_ERROR;
1463: End If;
1464: -- Bug 2477972, end
1465:
1466: /* Deleting items from GMS_BURDEN_COMPONENTS table */
1467:
1468: /* pa_billing_pub.insert_message(X_INSERTING_PROCEDURE_NAME => '6.3.2 - CANINV'
1469: ,x_message =>'Before DELETE_GMS_BURDEN_INTRSCT'
1470: ,x_error_message => X_Err_Msg

Line 1687: GMS_BURDEN_COMPONENTS

1683: Creation_Date,
1684: Revenue_Accumulated,
1685: request_id -- 4594090
1686: from
1687: GMS_BURDEN_COMPONENTS
1688: where
1689: award_project_id = F_Award_Project_Id and
1690: event_num = F_Event_Num and
1691: event_type = 'REVENUE';

Line 1887: /* Deleting items from GMS_BURDEN_COMPONENTS table */

1883: End If;
1884:
1885: -- Bug 2477972, end
1886:
1887: /* Deleting items from GMS_BURDEN_COMPONENTS table */
1888:
1889: DELETE_GMS_BURDEN_INTRSCT(F_Rev_Burd_Expend_Item_Id ,
1890: F_Award_Project_Id,
1891: F_Event_Num,