APPS.GMS_BILLING_ADJUSTMENTS dependencies on FND_GLOBAL

Line 676: ,spf.last_update_login = fnd_global.login_id

672: update GMS_SUMMARY_PROJECT_FUNDINGS spf
673: set
674: spf.Total_Billed_Amount = X_Amt_To_Update
675: ,spf.last_update_date = sysdate
676: ,spf.last_update_login = fnd_global.login_id
677: ,spf.last_updated_by = fnd_global.user_id
678: where
679: spf.installment_id = F_Installment_id
680: and spf.project_id = F_actual_project_id

Line 677: ,spf.last_updated_by = fnd_global.user_id

673: set
674: spf.Total_Billed_Amount = X_Amt_To_Update
675: ,spf.last_update_date = sysdate
676: ,spf.last_update_login = fnd_global.login_id
677: ,spf.last_updated_by = fnd_global.user_id
678: where
679: spf.installment_id = F_Installment_id
680: and spf.project_id = F_actual_project_id
681: and (

Line 694: ,spf.last_update_login = fnd_global.login_id

690: update GMS_SUMMARY_PROJECT_FUNDINGS spf
691: set
692: spf.Total_Revenue_Amount = X_Amt_To_Update
693: ,spf.last_update_date = sysdate
694: ,spf.last_update_login = fnd_global.login_id
695: ,spf.last_updated_by = fnd_global.user_id
696: where
697: spf.installment_id = F_Installment_id
698: and spf.project_id = F_actual_project_id

Line 695: ,spf.last_updated_by = fnd_global.user_id

691: set
692: spf.Total_Revenue_Amount = X_Amt_To_Update
693: ,spf.last_update_date = sysdate
694: ,spf.last_update_login = fnd_global.login_id
695: ,spf.last_updated_by = fnd_global.user_id
696: where
697: spf.installment_id = F_Installment_id
698: and spf.project_id = F_actual_project_id
699: and (

Line 896: ,last_updated_by = fnd_global.user_id

892: UPDATE GMS_AWARD_DISTRIBUTIONS
893: set
894: billed_flag = 'N'
895: ,last_update_date = sysdate
896: ,last_updated_by = fnd_global.user_id
897: ,last_update_login = fnd_global.login_id
898: where expenditure_item_id = X_Expenditure_Item_Id
899: and adl_line_num = X_Adl_Line_No
900: and award_id=

Line 897: ,last_update_login = fnd_global.login_id

893: set
894: billed_flag = 'N'
895: ,last_update_date = sysdate
896: ,last_updated_by = fnd_global.user_id
897: ,last_update_login = fnd_global.login_id
898: where expenditure_item_id = X_Expenditure_Item_Id
899: and adl_line_num = X_Adl_Line_No
900: and award_id=
901: (select award_id

Line 932: ,last_updated_by = fnd_global.user_id

928: UPDATE PA_EXPENDITURE_ITEMS_ALL
929: set
930: revenue_distributed_flag = 'N'
931: ,last_update_date = sysdate
932: ,last_updated_by = fnd_global.user_id
933: ,last_update_login = fnd_global.login_id
934: where
935: expenditure_item_id = X_Expenditure_Item_Id;
936:

Line 933: ,last_update_login = fnd_global.login_id

929: set
930: revenue_distributed_flag = 'N'
931: ,last_update_date = sysdate
932: ,last_updated_by = fnd_global.user_id
933: ,last_update_login = fnd_global.login_id
934: where
935: expenditure_item_id = X_Expenditure_Item_Id;
936:
937: If SQL%NOTFOUND THEN

Line 957: ,last_updated_by = fnd_global.user_id

953: UPDATE GMS_AWARD_DISTRIBUTIONS
954: set
955: revenue_distributed_flag = 'N'
956: ,last_update_date = sysdate
957: ,last_updated_by = fnd_global.user_id
958: ,last_update_login = fnd_global.login_id
959: where expenditure_item_id = X_Expenditure_Item_Id
960: and adl_line_num = X_Adl_Line_No
961: and award_id=

Line 958: ,last_update_login = fnd_global.login_id

954: set
955: revenue_distributed_flag = 'N'
956: ,last_update_date = sysdate
957: ,last_updated_by = fnd_global.user_id
958: ,last_update_login = fnd_global.login_id
959: where expenditure_item_id = X_Expenditure_Item_Id
960: and adl_line_num = X_Adl_Line_No
961: and award_id=
962: (select award_id