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

Line 150: fnd_global.user_id,

146: LAST_UPDATE_LOGIN) =
147: (SELECT X_Award_Project_Id,
148: X_Agreement_Id,
149: SYSDATE,
150: fnd_global.user_id,
151: fnd_global.login_id
152: FROM dual)
153: WHERE AWARD_ID = X_Award_Id;
154:

Line 151: fnd_global.login_id

147: (SELECT X_Award_Project_Id,
148: X_Agreement_Id,
149: SYSDATE,
150: fnd_global.user_id,
151: fnd_global.login_id
152: FROM dual)
153: WHERE AWARD_ID = X_Award_Id;
154:
155: END UPDATE_GMS_AWARDS;

Line 176: last_UPDATEd_by = fnd_global.user_id,

172: non_labor_invoice_format_Id = X_Non_Labor_Invoice_Format_Id,
173: billing_cycle_id = X_Billing_Cycle_Id,
174: billing_offset = X_Billing_Offset,
175: last_UPDATE_date = sysdate,
176: last_UPDATEd_by = fnd_global.user_id,
177: last_UPDATE_login = fnd_global.login_id
178: WHERE project_id = X_Project_Id;
179:
180: X_Err_Code := 'S';

Line 177: last_UPDATE_login = fnd_global.login_id

173: billing_cycle_id = X_Billing_Cycle_Id,
174: billing_offset = X_Billing_Offset,
175: last_UPDATE_date = sysdate,
176: last_UPDATEd_by = fnd_global.user_id,
177: last_UPDATE_login = fnd_global.login_id
178: WHERE project_id = X_Project_Id;
179:
180: X_Err_Code := 'S';
181:

Line 287: fnd_global.user_id,

283: last_UPDATE_login)
284: SELECT x_award_project_id,
285: option_code,
286: SYSDATE,
287: fnd_global.user_id,
288: SYSDATE ,
289: fnd_global.user_id,
290: fnd_global.login_id
291: FROM pa_options

Line 289: fnd_global.user_id,

285: option_code,
286: SYSDATE,
287: fnd_global.user_id,
288: SYSDATE ,
289: fnd_global.user_id,
290: fnd_global.login_id
291: FROM pa_options
292: WHERE option_code NOT IN ( 'STRUCTURES', 'STRUCTURES_SS' );
293: */

Line 290: fnd_global.login_id

286: SYSDATE,
287: fnd_global.user_id,
288: SYSDATE ,
289: fnd_global.user_id,
290: fnd_global.login_id
291: FROM pa_options
292: WHERE option_code NOT IN ( 'STRUCTURES', 'STRUCTURES_SS' );
293: */
294:

Line 937: fnd_global.user_id,

933: X_Allocated_Amount,
934: X_Allocated_Amount,
935: -- Bug 2475640 Changes End
936: SYSDATE,
937: fnd_global.user_id,
938: SYSDATE ,
939: fnd_global.user_id,
940: fnd_global.login_id);
941:

Line 939: fnd_global.user_id,

935: -- Bug 2475640 Changes End
936: SYSDATE,
937: fnd_global.user_id,
938: SYSDATE ,
939: fnd_global.user_id,
940: fnd_global.login_id);
941:
942: -- Bug 2475640 : Added Following UPDATE statement to UPDATE funding_category
943:

Line 940: fnd_global.login_id);

936: SYSDATE,
937: fnd_global.user_id,
938: SYSDATE ,
939: fnd_global.user_id,
940: fnd_global.login_id);
941:
942: -- Bug 2475640 : Added Following UPDATE statement to UPDATE funding_category
943:
944: UPDATE pa_project_fundings proj

Line 1149: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

1145: INVPROC_UNBASELINED_AMOUNT = X_Total_Unbaselined_Amount,
1146: REVPROC_UNBASELINED_AMOUNT = X_Total_Unbaselined_Amount,
1147: -- Bug 2475640 changes End
1148: LAST_UPDATE_DATE = SYSDATE,
1149: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1150: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1151: WHERE AGREEMENT_ID = X_Agreement_Id
1152: AND PROJECT_ID = X_Award_Project_Id;
1153:

Line 1150: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

1146: REVPROC_UNBASELINED_AMOUNT = X_Total_Unbaselined_Amount,
1147: -- Bug 2475640 changes End
1148: LAST_UPDATE_DATE = SYSDATE,
1149: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1150: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1151: WHERE AGREEMENT_ID = X_Agreement_Id
1152: AND PROJECT_ID = X_Award_Project_Id;
1153:
1154: X_Err_Code := 'S';

Line 1219: fnd_global.user_id,

1215: X_Total_Unbaselined_Amount,
1216: X_Total_Unbaselined_Amount,
1217: -- Bug 2475640 Changes END
1218: SYSDATE,
1219: fnd_global.user_id,
1220: SYSDATE ,
1221: fnd_global.user_id,
1222: fnd_global.login_id);
1223: X_Err_Code := 'S';

Line 1221: fnd_global.user_id,

1217: -- Bug 2475640 Changes END
1218: SYSDATE,
1219: fnd_global.user_id,
1220: SYSDATE ,
1221: fnd_global.user_id,
1222: fnd_global.login_id);
1223: X_Err_Code := 'S';
1224: EXCEPTION
1225: WHEN OTHERS THEN

Line 1222: fnd_global.login_id);

1218: SYSDATE,
1219: fnd_global.user_id,
1220: SYSDATE ,
1221: fnd_global.user_id,
1222: fnd_global.login_id);
1223: X_Err_Code := 'S';
1224: EXCEPTION
1225: WHEN OTHERS THEN
1226: X_Err_Code := 'U';

Line 1339: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

1335: INVPROC_ALLOCATED_AMOUNT = X_New_Allocated_Amount,
1336: REVPROC_ALLOCATED_AMOUNT = X_New_Allocated_Amount,
1337: -- Bug 2475640 Changes End
1338: LAST_UPDATE_DATE = SYSDATE ,
1339: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1340: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1341: WHERE PROJECT_FUNDING_ID = X_Project_Funding_Id;
1342:
1343: X_Err_Code := 'S';

Line 1340: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

1336: REVPROC_ALLOCATED_AMOUNT = X_New_Allocated_Amount,
1337: -- Bug 2475640 Changes End
1338: LAST_UPDATE_DATE = SYSDATE ,
1339: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1340: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1341: WHERE PROJECT_FUNDING_ID = X_Project_Funding_Id;
1342:
1343: X_Err_Code := 'S';
1344:

Line 1364: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

1360:
1361: UPDATE PA_PROJECT_FUNDINGS
1362: SET DATE_ALLOCATED = X_New_Date_Allocated,
1363: LAST_UPDATE_DATE = SYSDATE ,
1364: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1365: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1366: WHERE PROJECT_FUNDING_ID = X_Project_Funding_Id;
1367:
1368: X_Err_Code := 'S';

Line 1365: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

1361: UPDATE PA_PROJECT_FUNDINGS
1362: SET DATE_ALLOCATED = X_New_Date_Allocated,
1363: LAST_UPDATE_DATE = SYSDATE ,
1364: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1365: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1366: WHERE PROJECT_FUNDING_ID = X_Project_Funding_Id;
1367:
1368: X_Err_Code := 'S';
1369:

Line 1582: X_LAST_UPDATED_BY => fnd_global.user_id,

1578: X_CUSTOMER_ID => X_Customer_Id,
1579: X_AGREEMENT_NUM => X_Agreement_Num,
1580: X_AGREEMENT_TYPE => X_Agreement_Type,
1581: X_LAST_UPDATE_DATE => sysdate,
1582: X_LAST_UPDATED_BY => fnd_global.user_id,
1583: X_CREATION_DATE => sysdate,
1584: X_CREATED_BY => fnd_global.user_id,
1585: X_LAST_UPDATE_LOGIN => fnd_global.login_id,
1586: X_OWNED_BY_PERSON_ID => X_Owned_By_Person_Id,

Line 1584: X_CREATED_BY => fnd_global.user_id,

1580: X_AGREEMENT_TYPE => X_Agreement_Type,
1581: X_LAST_UPDATE_DATE => sysdate,
1582: X_LAST_UPDATED_BY => fnd_global.user_id,
1583: X_CREATION_DATE => sysdate,
1584: X_CREATED_BY => fnd_global.user_id,
1585: X_LAST_UPDATE_LOGIN => fnd_global.login_id,
1586: X_OWNED_BY_PERSON_ID => X_Owned_By_Person_Id,
1587: X_TERM_ID => X_Term_Id,
1588: X_REVENUE_LIMIT_FLAG => nvl(X_Revenue_Limit_Flag, 'N'),-- Bug 1841288 : Changed 'Y'to'N'

Line 1585: X_LAST_UPDATE_LOGIN => fnd_global.login_id,

1581: X_LAST_UPDATE_DATE => sysdate,
1582: X_LAST_UPDATED_BY => fnd_global.user_id,
1583: X_CREATION_DATE => sysdate,
1584: X_CREATED_BY => fnd_global.user_id,
1585: X_LAST_UPDATE_LOGIN => fnd_global.login_id,
1586: X_OWNED_BY_PERSON_ID => X_Owned_By_Person_Id,
1587: X_TERM_ID => X_Term_Id,
1588: X_REVENUE_LIMIT_FLAG => nvl(X_Revenue_Limit_Flag, 'N'),-- Bug 1841288 : Changed 'Y'to'N'
1589: X_AMOUNT => 0,

Line 1970: X_LAST_UPDATED_BY => fnd_global.user_id,

1966: X_CUSTOMER_ID => Store_Customer_Id,
1967: X_AGREEMENT_NUM => Store_Agreement_Num,
1968: X_AGREEMENT_TYPE => Store_Agreement_Type,
1969: X_LAST_UPDATE_DATE => SYSDATE,
1970: X_LAST_UPDATED_BY => fnd_global.user_id,
1971: X_LAST_UPDATE_LOGIN => fnd_global.login_id,
1972: X_OWNED_BY_PERSON_ID => Store_Owned_By_Person_Id,
1973: X_TERM_ID => Store_Term_Id,
1974: X_REVENUE_LIMIT_FLAG => Store_Revenue_Limit_Flag,

Line 1971: X_LAST_UPDATE_LOGIN => fnd_global.login_id,

1967: X_AGREEMENT_NUM => Store_Agreement_Num,
1968: X_AGREEMENT_TYPE => Store_Agreement_Type,
1969: X_LAST_UPDATE_DATE => SYSDATE,
1970: X_LAST_UPDATED_BY => fnd_global.user_id,
1971: X_LAST_UPDATE_LOGIN => fnd_global.login_id,
1972: X_OWNED_BY_PERSON_ID => Store_Owned_By_Person_Id,
1973: X_TERM_ID => Store_Term_Id,
1974: X_REVENUE_LIMIT_FLAG => Store_Revenue_Limit_Flag,
1975: X_AMOUNT => Store_Amount,

Line 2044: fnd_global.user_id,

2040: END_DATE_ACTIVE)
2041: --AWARD_FLAG )--11i change
2042: VALUES(X_Budget_Type_Code,
2043: SYSDATE,
2044: fnd_global.user_id,
2045: SYSDATE,
2046: fnd_global.user_id,
2047: fnd_global.login_id,
2048: X_Budget_Type,

Line 2046: fnd_global.user_id,

2042: VALUES(X_Budget_Type_Code,
2043: SYSDATE,
2044: fnd_global.user_id,
2045: SYSDATE,
2046: fnd_global.user_id,
2047: fnd_global.login_id,
2048: X_Budget_Type,
2049: X_Start_Date,
2050: 'C',

Line 2047: fnd_global.login_id,

2043: SYSDATE,
2044: fnd_global.user_id,
2045: SYSDATE,
2046: fnd_global.user_id,
2047: fnd_global.login_id,
2048: X_Budget_Type,
2049: X_Start_Date,
2050: 'C',
2051: X_Predefined_Flag,

Line 2471: ,fnd_global.user_id

2467: ,NVL(X_Bill_to_Customer_id,X_Customer_Id)
2468: ,'BILL_TO'
2469: ,'Y'
2470: ,SYSDATE
2471: ,fnd_global.user_id
2472: ,SYSDATE
2473: ,fnd_global.user_id
2474: ,fnd_global.login_id);
2475:

Line 2473: ,fnd_global.user_id

2469: ,'Y'
2470: ,SYSDATE
2471: ,fnd_global.user_id
2472: ,SYSDATE
2473: ,fnd_global.user_id
2474: ,fnd_global.login_id);
2475:
2476: Elsif X_Cust_Bill_Cont_Exists = 1 THEN
2477: UPDATE GMS_AWARDS_CONTACTS

Line 2474: ,fnd_global.login_id);

2470: ,SYSDATE
2471: ,fnd_global.user_id
2472: ,SYSDATE
2473: ,fnd_global.user_id
2474: ,fnd_global.login_id);
2475:
2476: Elsif X_Cust_Bill_Cont_Exists = 1 THEN
2477: UPDATE GMS_AWARDS_CONTACTS
2478: set

Line 2533: ,fnd_global.user_id

2529: ,NVL(X_Bill_to_customer_id,X_Customer_Id)
2530: ,'SHIP_TO'
2531: ,'Y'
2532: ,SYSDATE
2533: ,fnd_global.user_id
2534: ,SYSDATE
2535: ,fnd_global.user_id
2536: ,fnd_global.login_id);
2537: Elsif X_Cust_Bill_Cont_Exists = 1 THEN

Line 2535: ,fnd_global.user_id

2531: ,'Y'
2532: ,SYSDATE
2533: ,fnd_global.user_id
2534: ,SYSDATE
2535: ,fnd_global.user_id
2536: ,fnd_global.login_id);
2537: Elsif X_Cust_Bill_Cont_Exists = 1 THEN
2538:
2539: UPDATE GMS_AWARDS_CONTACTS

Line 2536: ,fnd_global.login_id);

2532: ,SYSDATE
2533: ,fnd_global.user_id
2534: ,SYSDATE
2535: ,fnd_global.user_id
2536: ,fnd_global.login_id);
2537: Elsif X_Cust_Bill_Cont_Exists = 1 THEN
2538:
2539: UPDATE GMS_AWARDS_CONTACTS
2540: set

Line 2733: ,LAST_UPDATED_BY = fnd_global.user_id

2729: IF X_Bill_To_Address_Id_IN IS NOT NULL THEN
2730: UPDATE PA_PROJECT_CUSTOMERS
2731: set BILL_TO_ADDRESS_ID = X_Bill_To_Address_Id_IN
2732: ,LAST_UPDATE_DATE = SYSDATE
2733: ,LAST_UPDATED_BY = fnd_global.user_id
2734: ,LAST_UPDATE_LOGIN = fnd_global.login_id
2735: WHERE project_id = Store_Project_Id
2736: and customer_id = X_Customer_Id;
2737: END IF;

Line 2734: ,LAST_UPDATE_LOGIN = fnd_global.login_id

2730: UPDATE PA_PROJECT_CUSTOMERS
2731: set BILL_TO_ADDRESS_ID = X_Bill_To_Address_Id_IN
2732: ,LAST_UPDATE_DATE = SYSDATE
2733: ,LAST_UPDATED_BY = fnd_global.user_id
2734: ,LAST_UPDATE_LOGIN = fnd_global.login_id
2735: WHERE project_id = Store_Project_Id
2736: and customer_id = X_Customer_Id;
2737: END IF;
2738:

Line 2744: ,LAST_UPDATED_BY = fnd_global.user_id

2740: IF X_Ship_To_Address_Id_IN IS NOT NULL THEN
2741: UPDATE PA_PROJECT_CUSTOMERS
2742: set SHIP_TO_ADDRESS_ID = X_Ship_To_Address_Id_IN
2743: ,LAST_UPDATE_DATE = SYSDATE
2744: ,LAST_UPDATED_BY = fnd_global.user_id
2745: ,LAST_UPDATE_LOGIN = fnd_global.login_id
2746: WHERE project_id = Store_Project_Id
2747: and customer_id = X_Customer_Id;
2748: END IF;

Line 2745: ,LAST_UPDATE_LOGIN = fnd_global.login_id

2741: UPDATE PA_PROJECT_CUSTOMERS
2742: set SHIP_TO_ADDRESS_ID = X_Ship_To_Address_Id_IN
2743: ,LAST_UPDATE_DATE = SYSDATE
2744: ,LAST_UPDATED_BY = fnd_global.user_id
2745: ,LAST_UPDATE_LOGIN = fnd_global.login_id
2746: WHERE project_id = Store_Project_Id
2747: and customer_id = X_Customer_Id;
2748: END IF;
2749: ---------------------------------------------------------------------------

Line 2759: ,LAST_UPDATED_BY = fnd_global.user_id

2755:
2756: UPDATE PA_PROJECT_CONTACTS
2757: set contact_id = X_Bill_To_Contact_Id_IN
2758: ,LAST_UPDATE_DATE = SYSDATE
2759: ,LAST_UPDATED_BY = fnd_global.user_id
2760: ,LAST_UPDATE_LOGIN = fnd_global.login_id
2761: WHERE project_id = Store_Project_Id
2762: and customer_id = X_Customer_Id
2763: and project_contact_type_code = 'BILLING';

Line 2760: ,LAST_UPDATE_LOGIN = fnd_global.login_id

2756: UPDATE PA_PROJECT_CONTACTS
2757: set contact_id = X_Bill_To_Contact_Id_IN
2758: ,LAST_UPDATE_DATE = SYSDATE
2759: ,LAST_UPDATED_BY = fnd_global.user_id
2760: ,LAST_UPDATE_LOGIN = fnd_global.login_id
2761: WHERE project_id = Store_Project_Id
2762: and customer_id = X_Customer_Id
2763: and project_contact_type_code = 'BILLING';
2764:

Line 2773: ,LAST_UPDATED_BY = fnd_global.user_id

2769:
2770: UPDATE PA_PROJECT_CONTACTS
2771: set contact_id = X_Ship_To_Contact_Id_IN
2772: ,LAST_UPDATE_DATE = SYSDATE
2773: ,LAST_UPDATED_BY = fnd_global.user_id
2774: ,LAST_UPDATE_LOGIN = fnd_global.login_id
2775: WHERE project_id = Store_Project_Id
2776: and customer_id = X_Customer_Id
2777: and project_contact_type_code = 'SHIPPING';

Line 2774: ,LAST_UPDATE_LOGIN = fnd_global.login_id

2770: UPDATE PA_PROJECT_CONTACTS
2771: set contact_id = X_Ship_To_Contact_Id_IN
2772: ,LAST_UPDATE_DATE = SYSDATE
2773: ,LAST_UPDATED_BY = fnd_global.user_id
2774: ,LAST_UPDATE_LOGIN = fnd_global.login_id
2775: WHERE project_id = Store_Project_Id
2776: and customer_id = X_Customer_Id
2777: and project_contact_type_code = 'SHIPPING';
2778: