DBA Data[Home] [Help]

APPS.CN_GET_TX_DATA_PUB dependencies on FND_PROFILE

Line 42: l_track_invoice := NVL(fnd_profile.value('CN_TRACK_INVOICE'),'N');

38: FUNCTION g_track_invoice
39: RETURN VARCHAR2 IS
40: l_track_invoice VARCHAR2(1) := 'N';
41: BEGIN
42: l_track_invoice := NVL(fnd_profile.value('CN_TRACK_INVOICE'),'N');
43: RETURN l_track_invoice;
44: EXCEPTION
45: WHEN OTHERS THEN
46: RETURN l_track_invoice;

Line 408: WHERE user_id = fnd_profile.value('USER_ID');

404: BEGIN
405: SELECT user_name
406: INTO l_adjusted_by
407: FROM fnd_user
408: WHERE user_id = fnd_profile.value('USER_ID');
409: RETURN l_adjusted_by;
410: EXCEPTION
411: WHEN OTHERS THEN
412: RETURN l_adjusted_by;