APPS.GMS_BILLING_ADJUSTMENTS dependencies on GMS_EVENT_INTERSECT

Line 62: from gms_event_intersect

58: adl.revenue_distributed_flag = decode(p_calling_process,'INVOICE',
59: adl.revenue_distributed_flag,'N')
60: where (expenditure_item_id,adl_line_num) in
61: (select expenditure_item_id,adl_line_num
62: from gms_event_intersect
63: where award_project_id = p_award_project_id
64: and request_id = p_request_id
65: and event_type = p_calling_process
66: and event_num = -1 /*Added for bug 5060427*/

Line 69: -- from gms_event_intersect /* Commented for bug 5060427 */

65: and event_type = p_calling_process
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

Line 81: Delete from gms_event_intersect

77:
78: IF SQL%ROWCOUNT > 0 then
79: -- there are some records to process ..
80: -- C. Delete gei
81: Delete from gms_event_intersect
82: where award_project_id = p_award_project_id
83: and event_num = -1
84: and request_id = p_request_id
85: and event_type = p_calling_process;

Line 819: DELETE /*+INDEX(GMS_EVENT_INTERSECT GMS_EVENT_INTERSECT_U1) */

815:
816: X_Err_Code := 0;
817:
818: If X_Calling_Process = 'Invoice' then
819: DELETE /*+INDEX(GMS_EVENT_INTERSECT GMS_EVENT_INTERSECT_U1) */
820: from
821: GMS_EVENT_INTERSECT
822: where
823: expenditure_item_id = X_Expenditure_Item_Id

Line 821: GMS_EVENT_INTERSECT

817:
818: If X_Calling_Process = 'Invoice' then
819: DELETE /*+INDEX(GMS_EVENT_INTERSECT GMS_EVENT_INTERSECT_U1) */
820: from
821: GMS_EVENT_INTERSECT
822: where
823: expenditure_item_id = X_Expenditure_Item_Id
824: and award_project_Id = X_Award_Project_Id
825: and event_num = X_Event_Num

Line 848: DELETE /*+INDEX(GMS_EVENT_INTERSECT GMS_EVENT_INTERSECT_U1) */

844: Else
845: X_Err_Code := 0;
846: End If;
847: Elsif X_Calling_Process = 'Revenue' then
848: DELETE /*+INDEX(GMS_EVENT_INTERSECT GMS_EVENT_INTERSECT_U1) */
849: from
850: GMS_EVENT_INTERSECT
851: where
852: expenditure_item_id = X_Expenditure_Item_Id

Line 850: GMS_EVENT_INTERSECT

846: End If;
847: Elsif X_Calling_Process = 'Revenue' then
848: DELETE /*+INDEX(GMS_EVENT_INTERSECT GMS_EVENT_INTERSECT_U1) */
849: from
850: GMS_EVENT_INTERSECT
851: where
852: expenditure_item_id = X_Expenditure_Item_Id
853: and award_project_Id = X_Award_Project_Id
854: and event_num = X_Event_Num

Line 1183: gms_event_intersect

1179: expenditure_item_id,
1180: adl_line_num,
1181: request_id -- for bug 4594090
1182: from
1183: gms_event_intersect
1184: where
1185: award_project_id = F_Award_Project_Id and
1186: event_num = F_Event_Num and
1187: event_type = 'INVOICE';

Line 1373: /* Deleting Items From GMS_EVENT_INTERSECT Table */

1369: If X_Err_Code <> 0 then
1370: RAISE FND_API.G_EXC_ERROR;
1371: End If;
1372:
1373: /* Deleting Items From GMS_EVENT_INTERSECT Table */
1374: DELETE_GMS_INTERSECT(F_Expenditure_Item_Id,
1375: F_Award_Project_Id,
1376: F_Event_Num,
1377: F_Adl_Line_No,

Line 1660: gms_event_intersect

1656: amount,
1657: revenue_accumulated,
1658: request_id -- 4594090
1659: from
1660: gms_event_intersect
1661: where
1662: award_project_id = F_Award_Project_Id and
1663: event_num = F_Event_Num and
1664: event_type = 'REVENUE';

Line 1767: /* Deleting Items From GMS_EVENT_INTERSECT Table */

1763: If X_Err_Code <> 0 then
1764: RAISE FND_API.G_EXC_ERROR;
1765: End If;
1766:
1767: /* Deleting Items From GMS_EVENT_INTERSECT Table */
1768: DELETE_GMS_INTERSECT(F_Expenditure_Item_Id,
1769: F_Award_Project_Id,
1770: F_Event_Num,
1771: F_Adl_Line_No,