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 dependencies on FND_GLOBAL

Line 557: last_updated_by = fnd_global.user_id,

553:
554: UPDATE gms_award_distributions
555: SET revenue_distributed_flag = decode(x_event_num,NULL,'N','Z'),
556: last_update_date = SYSDATE,
557: last_updated_by = fnd_global.user_id,
558: last_update_login = fnd_global.login_id
559: WHERE expenditure_item_id = f_raw_exp_item_id
560: AND adl_line_num = f_raw_adl_line_num
561: AND document_type = 'EXP'

Line 558: last_update_login = fnd_global.login_id

554: UPDATE gms_award_distributions
555: SET revenue_distributed_flag = decode(x_event_num,NULL,'N','Z'),
556: last_update_date = SYSDATE,
557: last_updated_by = fnd_global.user_id,
558: last_update_login = fnd_global.login_id
559: WHERE expenditure_item_id = f_raw_exp_item_id
560: AND adl_line_num = f_raw_adl_line_num
561: AND document_type = 'EXP'
562: AND adl_status = 'A';

Line 568: last_updated_by = fnd_global.user_id,

564: THEN
565: UPDATE gms_award_distributions
566: SET billed_flag = decode(x_event_num,NULL,'N','Z'),
567: last_update_date = SYSDATE,
568: last_updated_by = fnd_global.user_id,
569: last_update_login = fnd_global.login_id
570: WHERE expenditure_item_id = f_raw_exp_item_id
571: AND adl_line_num = f_raw_adl_line_num
572: AND document_type = 'EXP'

Line 569: last_update_login = fnd_global.login_id

565: UPDATE gms_award_distributions
566: SET billed_flag = decode(x_event_num,NULL,'N','Z'),
567: last_update_date = SYSDATE,
568: last_updated_by = fnd_global.user_id,
569: last_update_login = fnd_global.login_id
570: WHERE expenditure_item_id = f_raw_exp_item_id
571: AND adl_line_num = f_raw_adl_line_num
572: AND document_type = 'EXP'
573: AND adl_status = 'A';

Line 941: fnd_global.user_id,

937: values('GMS_BLNG',
938: X_Award_Project_Id,
939: X_Request_Id,
940: sysdate,
941: fnd_global.user_id,
942: fnd_global.user_id,
943: sysdate,
944: fnd_global.login_id
945: );

Line 942: fnd_global.user_id,

938: X_Award_Project_Id,
939: X_Request_Id,
940: sysdate,
941: fnd_global.user_id,
942: fnd_global.user_id,
943: sysdate,
944: fnd_global.login_id
945: );
946:

Line 944: fnd_global.login_id

940: sysdate,
941: fnd_global.user_id,
942: fnd_global.user_id,
943: sysdate,
944: fnd_global.login_id
945: );
946:
947: commit;
948:

Line 1211: last_updated_by = fnd_global.user_id,

1207: UPDATE gms_award_distributions
1208: SET revenue_distributed_flag = decode(x_event_type,'REVENUE','N',revenue_distributed_flag),
1209: billed_flag = decode(x_event_type,'INVOICE','N',billed_flag),
1210: last_update_date = SYSDATE,
1211: last_updated_by = fnd_global.user_id,
1212: last_update_login = fnd_global.login_id
1213: WHERE expenditure_item_id = x_expenditure_item_id
1214: AND document_type = 'EXP'
1215: AND adl_status = 'A'

Line 1212: last_update_login = fnd_global.login_id

1208: SET revenue_distributed_flag = decode(x_event_type,'REVENUE','N',revenue_distributed_flag),
1209: billed_flag = decode(x_event_type,'INVOICE','N',billed_flag),
1210: last_update_date = SYSDATE,
1211: last_updated_by = fnd_global.user_id,
1212: last_update_login = fnd_global.login_id
1213: WHERE expenditure_item_id = x_expenditure_item_id
1214: AND document_type = 'EXP'
1215: AND adl_status = 'A'
1216: AND ( expenditure_item_id,adl_line_num ) in ( select expenditure_item_id, adl_line_num

Line 1546: P_User_Id => fnd_global.user_id,

1542: P_Ship_to_site_use_id =>X_Ship_To_Site_Use_Id,
1543: P_Sets_of_books_id => X_Set_Of_Book_Id,
1544: P_Event_id => NULL, -- Event Number
1545: P_Expenditure_item_id =>F_Expenditure_Item_Id,
1546: P_User_Id => fnd_global.user_id,
1547: P_Request_id => X_Request_id,
1548: --S_Output_Vat_Tax_Id,
1549: X_Output_tax_exempt_flag => S_Output_Tax_Exempt_Flag,
1550: X_Output_tax_exempt_number => S_Output_Tax_Exempt_number,

Line 1569: last_update_login = fnd_global.login_id,

1565: output_tax_exempt_flag = S_Output_Tax_Exempt_Flag,
1566: output_tax_exempt_number = S_Output_Tax_Exempt_Number,
1567: output_tax_exempt_reason_code = S_Output_Exempt_Reason_Code,
1568: last_update_date = sysdate,
1569: last_update_login = fnd_global.login_id,
1570: last_updated_by = fnd_global.user_id
1571: where expenditure_item_id = F_Expenditure_Item_Id
1572: and adl_line_num = F_Adl_Line_Num
1573: and award_id = X_Award_Id

Line 1570: last_updated_by = fnd_global.user_id

1566: output_tax_exempt_number = S_Output_Tax_Exempt_Number,
1567: output_tax_exempt_reason_code = S_Output_Exempt_Reason_Code,
1568: last_update_date = sysdate,
1569: last_update_login = fnd_global.login_id,
1570: last_updated_by = fnd_global.user_id
1571: where expenditure_item_id = F_Expenditure_Item_Id
1572: and adl_line_num = F_Adl_Line_Num
1573: and award_id = X_Award_Id
1574: and document_type ='EXP'

Line 1778: fnd_global.user_id,

1774: X_EXPENDITURE_ORG_ID,
1775: NVL(X_BILL_AMOUNT,0),
1776: NVL(X_REVENUE_AMOUNT,0),
1777: 0, -- Write_Off_Amount
1778: fnd_global.user_id,
1779: sysdate,
1780: fnd_global.user_id,
1781: sysdate,
1782: fnd_global.login_id,

Line 1780: fnd_global.user_id,

1776: NVL(X_REVENUE_AMOUNT,0),
1777: 0, -- Write_Off_Amount
1778: fnd_global.user_id,
1779: sysdate,
1780: fnd_global.user_id,
1781: sysdate,
1782: fnd_global.login_id,
1783: 'N', -- Revenue_Accumulated
1784: NULL, -- RLMI

Line 1782: fnd_global.login_id,

1778: fnd_global.user_id,
1779: sysdate,
1780: fnd_global.user_id,
1781: sysdate,
1782: fnd_global.login_id,
1783: 'N', -- Revenue_Accumulated
1784: NULL, -- RLMI
1785: X_REQUEST_ID,
1786: X_EXPENDITURE_TYPE,

Line 1836: last_updated_by = fnd_global.user_id,

1832: expenditure_org_id = X_EXPENDITURE_ORG_ID,
1833: bill_amount = nvl(X_BILL_AMOUNT,0),
1834: revenue_amount = nvl(X_REVENUE_AMOUNT,0),
1835: expenditure_type = X_EXPENDITURE_TYPE,
1836: last_updated_by = fnd_global.user_id,
1837: last_update_date = sysdate,
1838: last_update_login = fnd_global.login_id,
1839: request_id = X_REQUEST_ID
1840: WHERE project_id = X_AWARD_PROJECT_ID

Line 1838: last_update_login = fnd_global.login_id,

1834: revenue_amount = nvl(X_REVENUE_AMOUNT,0),
1835: expenditure_type = X_EXPENDITURE_TYPE,
1836: last_updated_by = fnd_global.user_id,
1837: last_update_date = sysdate,
1838: last_update_login = fnd_global.login_id,
1839: request_id = X_REQUEST_ID
1840: WHERE project_id = X_AWARD_PROJECT_ID
1841: AND event_num = X_EVENT_NUM
1842: AND event_calling_process IS NULL; --Added for bug 2979125

Line 2845: fnd_global.user_id,

2841: X_Burden_Expenditure_Type,
2842: X_Expenditure_Org_Id,
2843: X_Burden_Cost_Code,
2844: SYSDATE,
2845: fnd_global.user_id,
2846: SYSDATE,
2847: fnd_global.user_id,
2848: fnd_global.login_id,
2849: decode(X_Calling_Process,'Invoice','X','Revenue','N'), -- Added decode for bug 5472366

Line 2847: fnd_global.user_id,

2843: X_Burden_Cost_Code,
2844: SYSDATE,
2845: fnd_global.user_id,
2846: SYSDATE,
2847: fnd_global.user_id,
2848: fnd_global.login_id,
2849: decode(X_Calling_Process,'Invoice','X','Revenue','N'), -- Added decode for bug 5472366
2850: null);
2851:

Line 2848: fnd_global.login_id,

2844: SYSDATE,
2845: fnd_global.user_id,
2846: SYSDATE,
2847: fnd_global.user_id,
2848: fnd_global.login_id,
2849: decode(X_Calling_Process,'Invoice','X','Revenue','N'), -- Added decode for bug 5472366
2850: null);
2851:
2852: X_Err_Num := 0;

Line 2941: fnd_global.user_id,

2937: X_Amount_To_Insert,
2938: X_request_id,
2939: decode(X_Calling_Process,'Invoice','INVOICE','Revenue','REVENUE'),
2940: SYSDATE,
2941: fnd_global.user_id,
2942: SYSDATE,
2943: fnd_global.user_id,
2944: fnd_global.login_id,
2945: decode(X_Calling_Process,'Invoice','X','Revenue','N')); -- Added decode for bug 5472366

Line 2943: fnd_global.user_id,

2939: decode(X_Calling_Process,'Invoice','INVOICE','Revenue','REVENUE'),
2940: SYSDATE,
2941: fnd_global.user_id,
2942: SYSDATE,
2943: fnd_global.user_id,
2944: fnd_global.login_id,
2945: decode(X_Calling_Process,'Invoice','X','Revenue','N')); -- Added decode for bug 5472366
2946: X_Err_Num := 0;
2947: X_UPD_BILLING_FLAG := TRUE; -- Bug 3254097

Line 2944: fnd_global.login_id,

2940: SYSDATE,
2941: fnd_global.user_id,
2942: SYSDATE,
2943: fnd_global.user_id,
2944: fnd_global.login_id,
2945: decode(X_Calling_Process,'Invoice','X','Revenue','N')); -- Added decode for bug 5472366
2946: X_Err_Num := 0;
2947: X_UPD_BILLING_FLAG := TRUE; -- Bug 3254097
2948:

Line 3007: ,gei.last_updated_by = fnd_global.user_id

3003: update GMS_EVENT_INTERSECT gei
3004: set
3005: gei.EVENT_NUM = X_Event_Num
3006: ,gei.last_update_date = sysdate
3007: ,gei.last_updated_by = fnd_global.user_id
3008: ,gei.last_update_login = fnd_global.login_id
3009: where gei.REQUEST_ID = X_Request_id and
3010: gei.award_project_id = X_Award_Project_Id and
3011: gei.EVENT_NUM IS NULL

Line 3008: ,gei.last_update_login = fnd_global.login_id

3004: set
3005: gei.EVENT_NUM = X_Event_Num
3006: ,gei.last_update_date = sysdate
3007: ,gei.last_updated_by = fnd_global.user_id
3008: ,gei.last_update_login = fnd_global.login_id
3009: where gei.REQUEST_ID = X_Request_id and
3010: gei.award_project_id = X_Award_Project_Id and
3011: gei.EVENT_NUM IS NULL
3012: AND EXISTS ( -- Bug 3235390 : Added below conditions to check for project and task.

Line 3030: ,GEI.LAST_UPDATED_BY = FND_GLOBAL.USER_ID

3026:
3027: UPDATE GMS_EVENT_INTERSECT GEI
3028: SET GEI.EVENT_NUM = X_Event_Num
3029: ,GEI.LAST_UPDATE_DATE = SYSDATE
3030: ,GEI.LAST_UPDATED_BY = FND_GLOBAL.USER_ID
3031: ,GEI.LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
3032: WHERE GEI.REQUEST_ID = X_Request_id
3033: AND GEI.AWARD_PROJECT_ID = X_Award_Project_Id
3034: AND GEI.EVENT_NUM IS NULL

Line 3031: ,GEI.LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

3027: UPDATE GMS_EVENT_INTERSECT GEI
3028: SET GEI.EVENT_NUM = X_Event_Num
3029: ,GEI.LAST_UPDATE_DATE = SYSDATE
3030: ,GEI.LAST_UPDATED_BY = FND_GLOBAL.USER_ID
3031: ,GEI.LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
3032: WHERE GEI.REQUEST_ID = X_Request_id
3033: AND GEI.AWARD_PROJECT_ID = X_Award_Project_Id
3034: AND GEI.EVENT_NUM IS NULL
3035: AND EXISTS (

Line 3093: ,last_updated_by = fnd_global.user_id

3089: update /*+INDEX(GMS_BURDEN_COMPONENTS GMS_BURDEN_COMPONENTS_N3)*/ GMS_BURDEN_COMPONENTS
3090: set
3091: EVENT_NUM = X_Event_Num
3092: ,last_update_date = sysdate
3093: ,last_updated_by = fnd_global.user_id
3094: ,last_update_login = fnd_global.login_id
3095: where
3096: request_id = X_request_id and
3097: award_project_id = X_Award_Project_Id and

Line 3094: ,last_update_login = fnd_global.login_id

3090: set
3091: EVENT_NUM = X_Event_Num
3092: ,last_update_date = sysdate
3093: ,last_updated_by = fnd_global.user_id
3094: ,last_update_login = fnd_global.login_id
3095: where
3096: request_id = X_request_id and
3097: award_project_id = X_Award_Project_Id and
3098: EVENT_NUM IS NULL and

Line 3146: ,last_updated_by = fnd_global.user_id

3142: update GMS_EVENT_ATTRIBUTE
3143: set
3144: EVENT_NUM = X_Event_Num
3145: ,last_update_date = sysdate
3146: ,last_updated_by = fnd_global.user_id
3147: ,last_update_login = fnd_global.login_id
3148: where
3149: request_id = X_request_id and
3150: project_id = X_Award_Project_Id and

Line 3147: ,last_update_login = fnd_global.login_id

3143: set
3144: EVENT_NUM = X_Event_Num
3145: ,last_update_date = sysdate
3146: ,last_updated_by = fnd_global.user_id
3147: ,last_update_login = fnd_global.login_id
3148: where
3149: request_id = X_request_id and
3150: project_id = X_Award_Project_Id and
3151: EVENT_NUM IS NULL;

Line 3240: spf.last_updated_by = fnd_global.user_id,

3236: update GMS_SUMMARY_PROJECT_FUNDINGS spf
3237: set
3238: spf.TOTAL_BILLED_AMOUNT = (X_Rev_Bill_Amount + X_Total_Rev_Bill_Amount),
3239: spf.last_update_date = sysdate,
3240: spf.last_updated_by = fnd_global.user_id,
3241: spf.last_update_login = fnd_global.login_id
3242: where
3243: spf.INSTALLMENT_ID = X_Installment_Id
3244: and (

Line 3241: spf.last_update_login = fnd_global.login_id

3237: set
3238: spf.TOTAL_BILLED_AMOUNT = (X_Rev_Bill_Amount + X_Total_Rev_Bill_Amount),
3239: spf.last_update_date = sysdate,
3240: spf.last_updated_by = fnd_global.user_id,
3241: spf.last_update_login = fnd_global.login_id
3242: where
3243: spf.INSTALLMENT_ID = X_Installment_Id
3244: and (
3245: (spf.TASK_ID = X_Task_Id)

Line 3260: spf.last_updated_by = fnd_global.user_id,

3256: update GMS_SUMMARY_PROJECT_FUNDINGS spf
3257: set
3258: spf.TOTAL_REVENUE_AMOUNT = (X_Rev_Bill_Amount + X_Total_Rev_Bill_Amount),
3259: spf.last_update_date = sysdate,
3260: spf.last_updated_by = fnd_global.user_id,
3261: spf.last_update_login = fnd_global.login_id
3262: where
3263: spf.INSTALLMENT_ID = X_Installment_Id
3264: and (

Line 3261: spf.last_update_login = fnd_global.login_id

3257: set
3258: spf.TOTAL_REVENUE_AMOUNT = (X_Rev_Bill_Amount + X_Total_Rev_Bill_Amount),
3259: spf.last_update_date = sysdate,
3260: spf.last_updated_by = fnd_global.user_id,
3261: spf.last_update_login = fnd_global.login_id
3262: where
3263: spf.INSTALLMENT_ID = X_Installment_Id
3264: and (
3265: (spf.TASK_ID = X_Task_Id)

Line 3399: ,last_updated_by = fnd_global.user_id

3395: GMS_AWARD_DISTRIBUTIONS
3396: set
3397: BILLED_FLAG = 'Y'
3398: ,last_update_date = sysdate
3399: ,last_updated_by = fnd_global.user_id
3400: ,last_update_login = fnd_global.login_id
3401: where expenditure_item_id = X_Expenditure_Item_Id
3402: and adl_line_num = X_Adl_Line_Num
3403: and document_type='EXP'

Line 3400: ,last_update_login = fnd_global.login_id

3396: set
3397: BILLED_FLAG = 'Y'
3398: ,last_update_date = sysdate
3399: ,last_updated_by = fnd_global.user_id
3400: ,last_update_login = fnd_global.login_id
3401: where expenditure_item_id = X_Expenditure_Item_Id
3402: and adl_line_num = X_Adl_Line_Num
3403: and document_type='EXP'
3404: and adl_status = 'A';

Line 3412: ,last_updated_by = fnd_global.user_id

3408: GMS_AWARD_DISTRIBUTIONS
3409: set
3410: revenue_distributed_flag = 'Y'
3411: ,last_update_date = sysdate
3412: ,last_updated_by = fnd_global.user_id
3413: ,last_update_login = fnd_global.login_id
3414: where expenditure_item_id = X_Expenditure_Item_Id
3415: and adl_line_num = X_Adl_Line_Num
3416: and document_type='EXP'

Line 3413: ,last_update_login = fnd_global.login_id

3409: set
3410: revenue_distributed_flag = 'Y'
3411: ,last_update_date = sysdate
3412: ,last_updated_by = fnd_global.user_id
3413: ,last_update_login = fnd_global.login_id
3414: where expenditure_item_id = X_Expenditure_Item_Id
3415: and adl_line_num = X_Adl_Line_Num
3416: and document_type='EXP'
3417: and adl_status = 'A';