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 685: L_CHECK_ACTIVE_FLAG := NVL(Fnd_Profile.value('QP_BUILD_ATTRIBUTES_MAPPING_OPTIONS'),'N');

681:
682: BEGIN
683:
684: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;
685: L_CHECK_ACTIVE_FLAG := NVL(Fnd_Profile.value('QP_BUILD_ATTRIBUTES_MAPPING_OPTIONS'),'N');
686: --fix for 2491269
687: Text('QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;',1);
688:
689: IF NVL(G_ATTRMGR_INSTALLED,'N') = 'N' THEN

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

1071: v_attr_src_string := v_src_profile_option;
1072:
1073:
1074: Text('BEGIN',2);
1075: Text('v_attr_value := fnd_profile.value( ''' || v_attr_src_string || ''');', 3);
1076: Text('EXCEPTION',2);
1077: Text('WHEN OTHERS THEN',3);
1078: Text('v_attr_value := NULL;',4);
1079: Text('END;',2);

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

1756: IF v_src_type = 'PROFILE_OPTION' THEN
1757:
1758: v_attr_src_string := v_value_string;
1759: Text('BEGIN',2);
1760: Text('v_attr_value := fnd_profile.value( ''' || v_attr_src_string || ''');', 3);
1761: Text('EXCEPTION',2);
1762: Text('WHEN OTHERS THEN',3);
1763: Text('v_attr_value := NULL;',4);
1764: Text('END;',2);

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

2043: IF l_debug = Fnd_Api.G_TRUE THEN
2044: Oe_Debug_Pub.ADD('##### Begin Build Sourcing #####');
2045:
2046: END IF;
2047: --FND_PROFILE.GET('QP_ATTRIBUTE_MANAGER_INSTALLED',G_ATTRMGR_INSTALLED);
2048: --dbms_output.put_line('............11............');
2049: G_ATTRMGR_INSTALLED := Qp_Util.Attrmgr_Installed;
2050: --dbms_output.put_line('............111............');
2051: --dbms_output.put_line('Profile value is : ' || G_ATTRMGR_INSTALLED);

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

2271:
2272: v_count NUMBER := 0;
2273: l_count NUMBER := 0;
2274:
2275: l_custom_sourced VARCHAR2(1) := Fnd_Profile.VALUE('QP_CUSTOM_SOURCED');
2276:
2277: l_req_type_code VARCHAR2(30);
2278: l_pricing_type_code VARCHAR2(1);
2279: l_qual_contexts_result_tbl Qp_Attr_Mapping_Pub.CONTEXTS_RESULT_TBL_TYPE;

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

2537:
2538: l_pricing_type_code VARCHAR2(1) := Fnd_Api.G_MISS_CHAR;
2539: K PLS_INTEGER;
2540:
2541: l_custom_sourced VARCHAR2(1) := Fnd_Profile.VALUE('QP_CUSTOM_SOURCED');
2542:
2543: l_sourcing_start_time NUMBER;
2544: l_sourcing_end_time NUMBER;
2545: l_time_difference NUMBER;

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

3308:
3309: BEGIN
3310:
3311: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;
3312: --FND_PROFILE.GET('QP_ATTRIBUTE_MANAGER_INSTALLED',G_ATTRMGR_INSTALLED);
3313: G_ATTRMGR_INSTALLED := Qp_Util.Attrmgr_Installed;
3314:
3315: IF NVL(G_ATTRMGR_INSTALLED,'N') = 'N' THEN
3316: OPEN l_pricing_attribs;

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

3485:
3486: BEGIN
3487:
3488: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;
3489: --FND_PROFILE.GET('QP_ATTRIBUTE_MANAGER_INSTALLED',G_ATTRMGR_INSTALLED);
3490: G_ATTRMGR_INSTALLED := Qp_Util.Attrmgr_Installed;
3491:
3492: IF NVL(G_ATTRMGR_INSTALLED,'N') = 'N' THEN
3493: OPEN l_pricing_attribs;

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

3663: qppteseg.user_sourcing_method = 'USER ENTERED';
3664: BEGIN
3665:
3666: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;
3667: --FND_PROFILE.GET('QP_ATTRIBUTE_MANAGER_INSTALLED',G_ATTRMGR_INSTALLED);
3668: G_ATTRMGR_INSTALLED := Qp_Util.Attrmgr_Installed;
3669:
3670: IF NVL(G_ATTRMGR_INSTALLED,'N') = 'N' THEN
3671: OPEN l_pricing_contexts;

Line 4090: RETURN Fnd_Profile.value(p_profile_option);

4086:
4087: BEGIN
4088:
4089: p_successful := TRUE;
4090: RETURN Fnd_Profile.value(p_profile_option);
4091:
4092: EXCEPTION
4093: WHEN NO_DATA_FOUND THEN
4094: RETURN NULL;