APPS.GMD_CUSTOMER_TESTS_PVT dependencies on FND_GLOBAL

Line 39: NVL(X_CREATED_BY,FND_GLOBAL.USER_ID),

35: X_CUST_ID,
36: X_REPORT_PRECISION,
37: X_TEXT_CODE,
38: NVL(X_CREATION_DATE,SYSDATE),
39: NVL(X_CREATED_BY,FND_GLOBAL.USER_ID),
40: NVL(X_LAST_UPDATE_DATE,SYSDATE),
41: NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
42: NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID)
43: );

Line 41: NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),

37: X_TEXT_CODE,
38: NVL(X_CREATION_DATE,SYSDATE),
39: NVL(X_CREATED_BY,FND_GLOBAL.USER_ID),
40: NVL(X_LAST_UPDATE_DATE,SYSDATE),
41: NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
42: NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID)
43: );
44:
45: insert into GMD_CUSTOMER_TESTS_TL (

Line 42: NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID)

38: NVL(X_CREATION_DATE,SYSDATE),
39: NVL(X_CREATED_BY,FND_GLOBAL.USER_ID),
40: NVL(X_LAST_UPDATE_DATE,SYSDATE),
41: NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
42: NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID)
43: );
44:
45: insert into GMD_CUSTOMER_TESTS_TL (
46: TEST_ID,

Line 61: NVL(X_CREATED_BY,FND_GLOBAL.USER_ID),

57: X_TEST_ID,
58: X_CUST_ID,
59: X_CUST_TEST_DISPLAY,
60: NVL(X_CREATION_DATE,SYSDATE),
61: NVL(X_CREATED_BY,FND_GLOBAL.USER_ID),
62: NVL(X_LAST_UPDATE_DATE,SYSDATE),
63: NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
64: NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID),
65: L.LANGUAGE_CODE,

Line 63: NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),

59: X_CUST_TEST_DISPLAY,
60: NVL(X_CREATION_DATE,SYSDATE),
61: NVL(X_CREATED_BY,FND_GLOBAL.USER_ID),
62: NVL(X_LAST_UPDATE_DATE,SYSDATE),
63: NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
64: NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID),
65: L.LANGUAGE_CODE,
66: userenv('LANG')
67: from FND_LANGUAGES L

Line 64: NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID),

60: NVL(X_CREATION_DATE,SYSDATE),
61: NVL(X_CREATED_BY,FND_GLOBAL.USER_ID),
62: NVL(X_LAST_UPDATE_DATE,SYSDATE),
63: NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
64: NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID),
65: L.LANGUAGE_CODE,
66: userenv('LANG')
67: from FND_LANGUAGES L
68: where L.INSTALLED_FLAG in ('I', 'B')

Line 187: LAST_UPDATED_BY = NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),

183: update GMD_CUSTOMER_TESTS_B set
184: REPORT_PRECISION = X_REPORT_PRECISION,
185: TEXT_CODE = X_TEXT_CODE,
186: LAST_UPDATE_DATE = NVL(X_LAST_UPDATE_DATE,SYSDATE),
187: LAST_UPDATED_BY = NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
188: LAST_UPDATE_LOGIN = NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID)
189: where TEST_ID = X_TEST_ID
190: and CUST_ID = X_CUST_ID;
191:

Line 188: LAST_UPDATE_LOGIN = NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID)

184: REPORT_PRECISION = X_REPORT_PRECISION,
185: TEXT_CODE = X_TEXT_CODE,
186: LAST_UPDATE_DATE = NVL(X_LAST_UPDATE_DATE,SYSDATE),
187: LAST_UPDATED_BY = NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
188: LAST_UPDATE_LOGIN = NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID)
189: where TEST_ID = X_TEST_ID
190: and CUST_ID = X_CUST_ID;
191:
192: if (sql%notfound) then

Line 199: LAST_UPDATED_BY = NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),

195:
196: update GMD_CUSTOMER_TESTS_TL set
197: CUST_TEST_DISPLAY = X_CUST_TEST_DISPLAY,
198: LAST_UPDATE_DATE = NVL(X_LAST_UPDATE_DATE,SYSDATE),
199: LAST_UPDATED_BY = NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
200: LAST_UPDATE_LOGIN = NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID),
201: SOURCE_LANG = userenv('LANG')
202: where TEST_ID = X_TEST_ID
203: and CUST_ID = X_CUST_ID

Line 200: LAST_UPDATE_LOGIN = NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID),

196: update GMD_CUSTOMER_TESTS_TL set
197: CUST_TEST_DISPLAY = X_CUST_TEST_DISPLAY,
198: LAST_UPDATE_DATE = NVL(X_LAST_UPDATE_DATE,SYSDATE),
199: LAST_UPDATED_BY = NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),
200: LAST_UPDATE_LOGIN = NVL(X_LAST_UPDATE_LOGIN,FND_GLOBAL.LOGIN_ID),
201: SOURCE_LANG = userenv('LANG')
202: where TEST_ID = X_TEST_ID
203: and CUST_ID = X_CUST_ID
204: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);