DBA Data[Home] [Help]

APPS.GMS_EVT_BILLING dependencies on GMS_SUMMARY_PROJECT_FUNDINGS

Line 87: GMS_SUMMARY_PROJECT_FUNDINGS gmf

83: decode(X_calling_process,'Invoice',nvl(gmf.total_billed_amount,0),'Revenue',nvl(gmf.total_revenue_amount,0),NULL)
84: into
85: X_BillRev_Amount
86: from
87: GMS_SUMMARY_PROJECT_FUNDINGS gmf
88: where
89: gmf.project_id = X_Actual_Project_Id
90: and
91: (

Line 138: Update GMS_SUMMARY_PROJECT_FUNDINGS gmf

134: X_Total_BillRev_Amount := X_Bill_Rev_Amount + X_Curr_BillRev_Amount;
135:
136: If X_calling_process = 'Invoice' then
137:
138: Update GMS_SUMMARY_PROJECT_FUNDINGS gmf
139: set
140: gmf.total_billed_amount = X_Total_BillRev_Amount
141: ,gmf.last_update_date = sysdate
142: ,gmf.last_updated_by = fnd_global.user_id

Line 157: Update GMS_SUMMARY_PROJECT_FUNDINGS gmf

153: installment_id = X_Installment_Id;
154:
155: Elsif X_calling_process = 'Revenue' then
156:
157: Update GMS_SUMMARY_PROJECT_FUNDINGS gmf
158: set
159: gmf.total_revenue_amount = X_Total_BillRev_Amount
160: ,gmf.last_update_date = sysdate
161: ,gmf.last_updated_by = fnd_global.user_id