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 3006: ,gei.last_updated_by = fnd_global.user_id

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

Line 3007: ,gei.last_update_login = fnd_global.login_id

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

Line 3068: ,last_updated_by = fnd_global.user_id

3064: update /*+INDEX(GMS_BURDEN_COMPONENTS GMS_BURDEN_COMPONENTS_N3)*/ GMS_BURDEN_COMPONENTS
3065: set
3066: EVENT_NUM = X_Event_Num
3067: ,last_update_date = sysdate
3068: ,last_updated_by = fnd_global.user_id
3069: ,last_update_login = fnd_global.login_id
3070: where
3071: request_id = X_request_id and
3072: award_project_id = X_Award_Project_Id and

Line 3069: ,last_update_login = fnd_global.login_id

3065: set
3066: EVENT_NUM = X_Event_Num
3067: ,last_update_date = sysdate
3068: ,last_updated_by = fnd_global.user_id
3069: ,last_update_login = fnd_global.login_id
3070: where
3071: request_id = X_request_id and
3072: award_project_id = X_Award_Project_Id and
3073: EVENT_NUM IS NULL and

Line 3121: ,last_updated_by = fnd_global.user_id

3117: update GMS_EVENT_ATTRIBUTE
3118: set
3119: EVENT_NUM = X_Event_Num
3120: ,last_update_date = sysdate
3121: ,last_updated_by = fnd_global.user_id
3122: ,last_update_login = fnd_global.login_id
3123: where
3124: request_id = X_request_id and
3125: project_id = X_Award_Project_Id and

Line 3122: ,last_update_login = fnd_global.login_id

3118: set
3119: EVENT_NUM = X_Event_Num
3120: ,last_update_date = sysdate
3121: ,last_updated_by = fnd_global.user_id
3122: ,last_update_login = fnd_global.login_id
3123: where
3124: request_id = X_request_id and
3125: project_id = X_Award_Project_Id and
3126: EVENT_NUM IS NULL;

Line 3215: spf.last_updated_by = fnd_global.user_id,

3211: update GMS_SUMMARY_PROJECT_FUNDINGS spf
3212: set
3213: spf.TOTAL_BILLED_AMOUNT = (X_Rev_Bill_Amount + X_Total_Rev_Bill_Amount),
3214: spf.last_update_date = sysdate,
3215: spf.last_updated_by = fnd_global.user_id,
3216: spf.last_update_login = fnd_global.login_id
3217: where
3218: spf.INSTALLMENT_ID = X_Installment_Id
3219: and (

Line 3216: spf.last_update_login = fnd_global.login_id

3212: set
3213: spf.TOTAL_BILLED_AMOUNT = (X_Rev_Bill_Amount + X_Total_Rev_Bill_Amount),
3214: spf.last_update_date = sysdate,
3215: spf.last_updated_by = fnd_global.user_id,
3216: spf.last_update_login = fnd_global.login_id
3217: where
3218: spf.INSTALLMENT_ID = X_Installment_Id
3219: and (
3220: (spf.TASK_ID = X_Task_Id)

Line 3235: spf.last_updated_by = fnd_global.user_id,

3231: update GMS_SUMMARY_PROJECT_FUNDINGS spf
3232: set
3233: spf.TOTAL_REVENUE_AMOUNT = (X_Rev_Bill_Amount + X_Total_Rev_Bill_Amount),
3234: spf.last_update_date = sysdate,
3235: spf.last_updated_by = fnd_global.user_id,
3236: spf.last_update_login = fnd_global.login_id
3237: where
3238: spf.INSTALLMENT_ID = X_Installment_Id
3239: and (

Line 3236: spf.last_update_login = fnd_global.login_id

3232: set
3233: spf.TOTAL_REVENUE_AMOUNT = (X_Rev_Bill_Amount + X_Total_Rev_Bill_Amount),
3234: spf.last_update_date = sysdate,
3235: spf.last_updated_by = fnd_global.user_id,
3236: spf.last_update_login = fnd_global.login_id
3237: where
3238: spf.INSTALLMENT_ID = X_Installment_Id
3239: and (
3240: (spf.TASK_ID = X_Task_Id)

Line 3374: ,last_updated_by = fnd_global.user_id

3370: GMS_AWARD_DISTRIBUTIONS
3371: set
3372: BILLED_FLAG = 'Y'
3373: ,last_update_date = sysdate
3374: ,last_updated_by = fnd_global.user_id
3375: ,last_update_login = fnd_global.login_id
3376: where expenditure_item_id = X_Expenditure_Item_Id
3377: and adl_line_num = X_Adl_Line_Num
3378: and document_type='EXP'

Line 3375: ,last_update_login = fnd_global.login_id

3371: set
3372: BILLED_FLAG = 'Y'
3373: ,last_update_date = sysdate
3374: ,last_updated_by = fnd_global.user_id
3375: ,last_update_login = fnd_global.login_id
3376: where expenditure_item_id = X_Expenditure_Item_Id
3377: and adl_line_num = X_Adl_Line_Num
3378: and document_type='EXP'
3379: and adl_status = 'A';

Line 3387: ,last_updated_by = fnd_global.user_id

3383: GMS_AWARD_DISTRIBUTIONS
3384: set
3385: revenue_distributed_flag = 'Y'
3386: ,last_update_date = sysdate
3387: ,last_updated_by = fnd_global.user_id
3388: ,last_update_login = fnd_global.login_id
3389: where expenditure_item_id = X_Expenditure_Item_Id
3390: and adl_line_num = X_Adl_Line_Num
3391: and document_type='EXP'

Line 3388: ,last_update_login = fnd_global.login_id

3384: set
3385: revenue_distributed_flag = 'Y'
3386: ,last_update_date = sysdate
3387: ,last_updated_by = fnd_global.user_id
3388: ,last_update_login = fnd_global.login_id
3389: where expenditure_item_id = X_Expenditure_Item_Id
3390: and adl_line_num = X_Adl_Line_Num
3391: and document_type='EXP'
3392: and adl_status = 'A';