APPS.QP_FORMULA_RULES_PVT dependencies on FND_PROFILE

Line 16: if nvl(fnd_profile.value('CONC_REQUEST_ID'),0) <> 0 then

12: BEGIN
13:
14: if g_conc_mode is null then
15:
16: if nvl(fnd_profile.value('CONC_REQUEST_ID'),0) <> 0 then
17: g_conc_mode := 'Y';
18: else
19: g_conc_mode := 'N';
20: end if;

Line 204: L_MAINT_DYN_SRC_VER VARCHAR2(1) := NVL(Fnd_Profile.value('QP_MAINTAIN_DYNAMIC_SOURCE_VERSIONS'),'N'); -- 13638721

200: from user_errors
201: where name = upper(l_pkg_name)
202: and type = decode(p_pkg_type,'SPEC','PACKAGE',
203: 'BODY','PACKAGE BODY');
204: L_MAINT_DYN_SRC_VER VARCHAR2(1) := NVL(Fnd_Profile.value('QP_MAINTAIN_DYNAMIC_SOURCE_VERSIONS'),'N'); -- 13638721
205: l_pkg_ver VARCHAR2(10):='1';
206: l_insert_row VARCHAR2(10):='N';
207: BEGIN
208:

Line 362: LAST_UPDATED_BY = nvl(TO_NUMBER (FND_PROFILE.VALUE ('USER_ID')),-1) ,

358: oe_debug_pub.add('found row in qp_params row updated with new version: ' || To_Char(To_Number(l_pkg_ver)+1));
359: UPDATE qp_parameters_b
360: SET SEEDED_VALUE=Decode(l_pkg_ver,'5','1',To_Char(To_Number(l_pkg_ver)+1)),
361: LAST_UPDATE_DATE = sysdate,
362: LAST_UPDATED_BY = nvl(TO_NUMBER (FND_PROFILE.VALUE ('USER_ID')),-1) ,
363: LAST_UPDATE_LOGIN = nvl(TO_NUMBER (FND_PROFILE.VALUE ('LOGIN_ ID')),-1)
364: WHERE parameter_code='BLD_FORMULA_ACTV_VER';
365: -- do not add any statements(even debug statements) in this area
366: IF SQL%ROWCOUNT = 0 THEN

Line 363: LAST_UPDATE_LOGIN = nvl(TO_NUMBER (FND_PROFILE.VALUE ('LOGIN_ ID')),-1)

359: UPDATE qp_parameters_b
360: SET SEEDED_VALUE=Decode(l_pkg_ver,'5','1',To_Char(To_Number(l_pkg_ver)+1)),
361: LAST_UPDATE_DATE = sysdate,
362: LAST_UPDATED_BY = nvl(TO_NUMBER (FND_PROFILE.VALUE ('USER_ID')),-1) ,
363: LAST_UPDATE_LOGIN = nvl(TO_NUMBER (FND_PROFILE.VALUE ('LOGIN_ ID')),-1)
364: WHERE parameter_code='BLD_FORMULA_ACTV_VER';
365: -- do not add any statements(even debug statements) in this area
366: IF SQL%ROWCOUNT = 0 THEN
367: INSERT INTO qp_parameters_b (parameter_id, parameter_level,parameter_code,value_set_id,