eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_ATTR_MAPPING_PUB dependencies on FND_PROFILE

Line 104: IF NVL(Fnd_Profile.value('CONC_REQUEST_ID'),0) <> 0 THEN

100: BEGIN
101:
102: IF g_conc_mode IS NULL THEN
103:
104: IF NVL(Fnd_Profile.value('CONC_REQUEST_ID'),0) <> 0 THEN
105: g_conc_mode := 'Y';
106: ELSE
107: g_conc_mode := 'N';
108: END IF;

Line 126: IF NVL(Fnd_Profile.value('CONC_REQUEST_ID'),0) <> 0 THEN

122: (Text VARCHAR2)
123: IS
124: BEGIN
125: IF g_conc_mode IS NULL THEN
126: IF NVL(Fnd_Profile.value('CONC_REQUEST_ID'),0) <> 0 THEN
127: g_conc_mode := 'Y';
128: ELSE
129: g_conc_mode := 'N';
130: END IF;

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

286: FROM user_errors
287: WHERE name = UPPER(l_pkg_name)
288: AND TYPE = DECODE(p_pkg_type,'SPEC','PACKAGE',
289: 'BODY','PACKAGE BODY');
290: L_MAINT_DYN_SRC_VER VARCHAR2(1) := NVL(Fnd_Profile.value('QP_MAINTAIN_DYNAMIC_SOURCE_VERSIONS'),'N'); -- 13638721
291: l_pkg_ver VARCHAR2(10):='1';
292: l_insert_row VARCHAR2(10):='N';
293: BEGIN
294:

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

497: oe_debug_pub.add('found row in qp_params row updated with new version: ' || To_Char(To_Number(l_pkg_ver)+1));
498: UPDATE qp_parameters_b
499: SET SEEDED_VALUE=Decode(l_pkg_ver,'5','1',To_Char(To_Number(l_pkg_ver)+1)) ,
500: LAST_UPDATE_DATE = sysdate,
501: LAST_UPDATED_BY = nvl(TO_NUMBER (FND_PROFILE.VALUE ('USER_ID')),-1) ,
502: LAST_UPDATE_LOGIN = nvl(TO_NUMBER (FND_PROFILE.VALUE ('LOGIN_ ID')),-1)
503: WHERE parameter_code='BLD_SRC_ATTR_ACTV_VER';
504: -- do not add any statements(even debug statements) in this area
505: IF SQL%ROWCOUNT = 0 THEN

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

498: UPDATE qp_parameters_b
499: SET SEEDED_VALUE=Decode(l_pkg_ver,'5','1',To_Char(To_Number(l_pkg_ver)+1)) ,
500: LAST_UPDATE_DATE = sysdate,
501: LAST_UPDATED_BY = nvl(TO_NUMBER (FND_PROFILE.VALUE ('USER_ID')),-1) ,
502: LAST_UPDATE_LOGIN = nvl(TO_NUMBER (FND_PROFILE.VALUE ('LOGIN_ ID')),-1)
503: WHERE parameter_code='BLD_SRC_ATTR_ACTV_VER';
504: -- do not add any statements(even debug statements) in this area
505: IF SQL%ROWCOUNT = 0 THEN
506: INSERT INTO qp_parameters_b (parameter_id, parameter_level,parameter_code,value_set_id,

Line 752: L_CHECK_ACTIVE_FLAG := NVL(Fnd_Profile.value('QP_BUILD_ATTRIBUTES_MAPPING_OPTIONS'),'N');

748:
749: BEGIN
750:
751: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;
752: L_CHECK_ACTIVE_FLAG := NVL(Fnd_Profile.value('QP_BUILD_ATTRIBUTES_MAPPING_OPTIONS'),'N');
753: --fix for 2491269
754: Text('QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;',1);
755:
756: IF NVL(G_ATTRMGR_INSTALLED,'N') = 'N' THEN

Line 1142: Text('v_attr_value := fnd_profile.value( ''' || v_attr_src_string || ''');', 3);

1138: v_attr_src_string := v_src_profile_option;
1139:
1140:
1141: Text('BEGIN',2);
1142: Text('v_attr_value := fnd_profile.value( ''' || v_attr_src_string || ''');', 3);
1143: Text('EXCEPTION',2);
1144: Text('WHEN OTHERS THEN',3);
1145: Text('v_attr_value := NULL;',4);
1146: Text('END;',2);

Line 1828: Text('v_attr_value := fnd_profile.value( ''' || v_attr_src_string || ''');', 3);

1824: IF v_src_type = 'PROFILE_OPTION' THEN
1825:
1826: v_attr_src_string := v_value_string;
1827: Text('BEGIN',2);
1828: Text('v_attr_value := fnd_profile.value( ''' || v_attr_src_string || ''');', 3);
1829: Text('EXCEPTION',2);
1830: Text('WHEN OTHERS THEN',3);
1831: Text('v_attr_value := NULL;',4);
1832: Text('END;',2);

Line 2115: --FND_PROFILE.GET('QP_ATTRIBUTE_MANAGER_INSTALLED',G_ATTRMGR_INSTALLED);

2111: IF l_debug = Fnd_Api.G_TRUE THEN
2112: Oe_Debug_Pub.ADD('##### Begin Build Sourcing #####');
2113:
2114: END IF;
2115: --FND_PROFILE.GET('QP_ATTRIBUTE_MANAGER_INSTALLED',G_ATTRMGR_INSTALLED);
2116: --dbms_output.put_line('............11............');
2117: G_ATTRMGR_INSTALLED := Qp_Util.Attrmgr_Installed;
2118: --dbms_output.put_line('............111............');
2119: --dbms_output.put_line('Profile value is : ' || G_ATTRMGR_INSTALLED);

Line 2346: l_custom_sourced VARCHAR2(1) := Fnd_Profile.VALUE('QP_CUSTOM_SOURCED');

2342:
2343: v_count NUMBER := 0;
2344: l_count NUMBER := 0;
2345:
2346: l_custom_sourced VARCHAR2(1) := Fnd_Profile.VALUE('QP_CUSTOM_SOURCED');
2347:
2348: l_req_type_code VARCHAR2(30);
2349: l_pricing_type_code VARCHAR2(1);
2350: l_qual_contexts_result_tbl Qp_Attr_Mapping_Pub.CONTEXTS_RESULT_TBL_TYPE;

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

2352:
2353: l_sourcing_start_time NUMBER;
2354: l_sourcing_end_time NUMBER;
2355: l_time_difference NUMBER;
2356: L_MAINT_DYN_SRC_VER VARCHAR2(1) := NVL(Fnd_Profile.value('QP_MAINTAIN_DYNAMIC_SOURCE_VERSIONS'),'N'); -- 13638721
2357: l_pkg_ver VARCHAR2(10);
2358: BEGIN
2359: -- Set the global variable G_DEBUG_ENGINE
2360: Qp_Preq_Grp.Set_QP_Debug;

Line 2654: l_custom_sourced VARCHAR2(1) := Fnd_Profile.VALUE('QP_CUSTOM_SOURCED');

2650:
2651: l_pricing_type_code VARCHAR2(1) := Fnd_Api.G_MISS_CHAR;
2652: K PLS_INTEGER;
2653:
2654: l_custom_sourced VARCHAR2(1) := Fnd_Profile.VALUE('QP_CUSTOM_SOURCED');
2655:
2656: l_sourcing_start_time NUMBER;
2657: l_sourcing_end_time NUMBER;
2658: l_time_difference NUMBER;

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

2666: l_default_price_list_id NUMBER;
2667: l_ignore VARCHAR2(1) :='N';
2668: l_ignore_cnt NUMBER :=1;
2669: --ignore_pricing
2670: L_MAINT_DYN_SRC_VER VARCHAR2(1) := NVL(Fnd_Profile.value('QP_MAINTAIN_DYNAMIC_SOURCE_VERSIONS'),'N'); -- 13638721
2671: l_pkg_ver VARCHAR2(10);
2672: BEGIN
2673: -- Set the global variable G_DEBUG_ENGINE
2674: Qp_Preq_Grp.Set_QP_Debug;

Line 2746: IF ( NVL(Fnd_Profile.value('QP_CUSTOM_IGNORE_PRICING'),'N') = 'Y') THEN

2742: l_pricing_type_code := 'L';
2743:
2744: IF (p_pricing_type_code = 'L') THEN
2745: --ignore_pricing start
2746: IF ( NVL(Fnd_Profile.value('QP_CUSTOM_IGNORE_PRICING'),'N') = 'Y') THEN
2747: IF l_debug = Fnd_Api.G_TRUE THEN
2748: Oe_Debug_Pub.ADD('ignore_pricing : QP Profile QP_CUSTOM_IGNORE_PRICING is ON' );
2749: END IF;
2750: BEGIN

Line 3570: --FND_PROFILE.GET('QP_ATTRIBUTE_MANAGER_INSTALLED',G_ATTRMGR_INSTALLED);

3566:
3567: BEGIN
3568:
3569: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;
3570: --FND_PROFILE.GET('QP_ATTRIBUTE_MANAGER_INSTALLED',G_ATTRMGR_INSTALLED);
3571: G_ATTRMGR_INSTALLED := Qp_Util.Attrmgr_Installed;
3572:
3573: IF NVL(G_ATTRMGR_INSTALLED,'N') = 'N' THEN
3574: OPEN l_pricing_attribs;

Line 3747: --FND_PROFILE.GET('QP_ATTRIBUTE_MANAGER_INSTALLED',G_ATTRMGR_INSTALLED);

3743:
3744: BEGIN
3745:
3746: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;
3747: --FND_PROFILE.GET('QP_ATTRIBUTE_MANAGER_INSTALLED',G_ATTRMGR_INSTALLED);
3748: G_ATTRMGR_INSTALLED := Qp_Util.Attrmgr_Installed;
3749:
3750: IF NVL(G_ATTRMGR_INSTALLED,'N') = 'N' THEN
3751: OPEN l_pricing_attribs;

Line 3925: --FND_PROFILE.GET('QP_ATTRIBUTE_MANAGER_INSTALLED',G_ATTRMGR_INSTALLED);

3921: qppteseg.user_sourcing_method = 'USER ENTERED';
3922: BEGIN
3923:
3924: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;
3925: --FND_PROFILE.GET('QP_ATTRIBUTE_MANAGER_INSTALLED',G_ATTRMGR_INSTALLED);
3926: G_ATTRMGR_INSTALLED := Qp_Util.Attrmgr_Installed;
3927:
3928: IF NVL(G_ATTRMGR_INSTALLED,'N') = 'N' THEN
3929: OPEN l_pricing_contexts;

Line 4056: l_QP_CUSTOM_HOOK4_ADV_MOD varchar2(1):=nvl(fnd_profile.value('QP_CUSTOM_HOOK_ADV_MOD'),'N'); -- 10120089

4052: l_prod_exists VARCHAR2(1) := 'N';
4053: l_all_items_exist VARCHAR2(1) := 'N';
4054: l_pass_line VARCHAR2(1); -- 10120089
4055: l_request_type_code VARCHAR2(10):=QP_PREQ_GRP.g_request_type_code; -- 10120089
4056: l_QP_CUSTOM_HOOK4_ADV_MOD varchar2(1):=nvl(fnd_profile.value('QP_CUSTOM_HOOK_ADV_MOD'),'N'); -- 10120089
4057: BEGIN
4058: -- start of 10120089
4059: IF (l_QP_CUSTOM_HOOK4_ADV_MOD='Y') THEN -- for profile on
4060: QP_ADV_MOD_CUSTOM_HOOK.check_line(l_request_type_code, l_pass_line);

Line 4363: RETURN Fnd_Profile.value(p_profile_option);

4359:
4360: BEGIN
4361:
4362: p_successful := TRUE;
4363: RETURN Fnd_Profile.value(p_profile_option);
4364:
4365: EXCEPTION
4366: WHEN NO_DATA_FOUND THEN
4367: RETURN NULL;