APPS.CN_COLLECTIONS_V_PKG dependencies on FND_PROFILE

Line 56: l_user_id := nvl(fnd_profile.value('USER_ID'),-1);

52: SELECT sysdate
53: INTO l_date
54: FROM dual;
55:
56: l_user_id := nvl(fnd_profile.value('USER_ID'),-1);
57: l_login_id := nvl(fnd_profile.value('LOGIN_ID'),-1);
58:
59: cn_modules_pkg.insert_row(
60: X_ROWID => l_rowid,

Line 57: l_login_id := nvl(fnd_profile.value('LOGIN_ID'),-1);

53: INTO l_date
54: FROM dual;
55:
56: l_user_id := nvl(fnd_profile.value('USER_ID'),-1);
57: l_login_id := nvl(fnd_profile.value('LOGIN_ID'),-1);
58:
59: cn_modules_pkg.insert_row(
60: X_ROWID => l_rowid,
61: X_MODULE_ID => X_module_id,

Line 116: l_user_id := nvl(fnd_profile.value('USER_ID'),-1);

112: SELECT sysdate
113: INTO l_date
114: FROM dual;
115:
116: l_user_id := nvl(fnd_profile.value('USER_ID'),-1);
117: l_login_id := nvl(fnd_profile.value('LOGIN_ID'),-1);
118:
119: cn_modules_pkg.insert_row(
120: X_ROWID => l_rowid ,

Line 117: l_login_id := nvl(fnd_profile.value('LOGIN_ID'),-1);

113: INTO l_date
114: FROM dual;
115:
116: l_user_id := nvl(fnd_profile.value('USER_ID'),-1);
117: l_login_id := nvl(fnd_profile.value('LOGIN_ID'),-1);
118:
119: cn_modules_pkg.insert_row(
120: X_ROWID => l_rowid ,
121: X_MODULE_ID => X_module_id,