DBA Data[Home] [Help]

APPS.WSH_CC_REQUEST_SETUPS_PKG dependencies on FND_GLOBAL

Line 143: ,FND_GLOBAL.user_id

139: ,p_HTS_CATG_SET_ID
140: ,p_ADDL_CATG_SET_ID
141: ,p_ADDITIONAL_ECE_COUNTRY_CHECK
142: ,sysdate
143: ,FND_GLOBAL.user_id
144: ,sysdate
145: ,FND_GLOBAL.user_id
146: ,FND_GLOBAL.login_id
147: ) ;

Line 145: ,FND_GLOBAL.user_id

141: ,p_ADDITIONAL_ECE_COUNTRY_CHECK
142: ,sysdate
143: ,FND_GLOBAL.user_id
144: ,sysdate
145: ,FND_GLOBAL.user_id
146: ,FND_GLOBAL.login_id
147: ) ;
148: IF SQL%NOTFOUND THEN
149: FND_MESSAGE.SET_NAME('WSH', 'WSH_INSERT_FAILED');

Line 146: ,FND_GLOBAL.login_id

142: ,sysdate
143: ,FND_GLOBAL.user_id
144: ,sysdate
145: ,FND_GLOBAL.user_id
146: ,FND_GLOBAL.login_id
147: ) ;
148: IF SQL%NOTFOUND THEN
149: FND_MESSAGE.SET_NAME('WSH', 'WSH_INSERT_FAILED');
150: FND_MSG_PUB.ADD;

Line 313: ,LAST_UPDATED_BY = FND_GLOBAL.user_id

309: ,HTS_CATG_SET_ID = p_HTS_CATG_SET_ID
310: ,ADDL_CATG_SET_ID = p_ADDL_CATG_SET_ID
311: ,ADDITIONAL_ECE_COUNTRY_CHECK = p_ADDITIONAL_ECE_COUNTRY_CHECK
312: ,LAST_UPDATE_DATE = sysdate
313: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
314: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
315: where cc_request_sequence_id = p_cc_request_sequence_id ;
316: IF SQL%NOTFOUND THEN
317: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_FAILED');

Line 314: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

310: ,ADDL_CATG_SET_ID = p_ADDL_CATG_SET_ID
311: ,ADDITIONAL_ECE_COUNTRY_CHECK = p_ADDITIONAL_ECE_COUNTRY_CHECK
312: ,LAST_UPDATE_DATE = sysdate
313: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
314: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
315: where cc_request_sequence_id = p_cc_request_sequence_id ;
316: IF SQL%NOTFOUND THEN
317: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_FAILED');
318: FND_MSG_PUB.ADD;