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 QP_PREQ_GRP

Line 295: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;

291: l_pkg_ver VARCHAR2(10):='1';
292: l_insert_row VARCHAR2(10):='N';
293: BEGIN
294:
295: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;
296: -- end statement.
297: Text('END '||p_pkg_name||';',0);
298:
299: -- Show errors.

Line 751: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;

747: ORDER BY is_product,attribute_code;
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:

Line 1051: Text ('QP_PREQ_GRP.G_NEW_PRICING_CALL := ''N'';', 4);

1047: --dbms_output.put_line('FOR i in QP_BULK_PREQ_GRP.G_LINE_REC.line_id.first..QP_BULK_PREQ_GRP.G_LINE_REC.line_id.last');
1048: Text('Loop');
1049: Text ('If QP_BULK_PREQ_GRP.G_LINE_REC.header_id(i) IS NOT NULL Then',2);
1050: Text ('If QP_BULK_PREQ_GRP.G_LINE_REC.header_id(i) = prev_header_id Then', 3);
1051: Text ('QP_PREQ_GRP.G_NEW_PRICING_CALL := ''N'';', 4);
1052: Text ('Else', 3);
1053: Text ('QP_PREQ_GRP.G_NEW_PRICING_CALL := ''Y'';',4);
1054: Text ('prev_header_id := QP_BULK_PREQ_GRP.G_LINE_REC.header_id(i);', 4);
1055: Text ('End If;', 3);

Line 1053: Text ('QP_PREQ_GRP.G_NEW_PRICING_CALL := ''Y'';',4);

1049: Text ('If QP_BULK_PREQ_GRP.G_LINE_REC.header_id(i) IS NOT NULL Then',2);
1050: Text ('If QP_BULK_PREQ_GRP.G_LINE_REC.header_id(i) = prev_header_id Then', 3);
1051: Text ('QP_PREQ_GRP.G_NEW_PRICING_CALL := ''N'';', 4);
1052: Text ('Else', 3);
1053: Text ('QP_PREQ_GRP.G_NEW_PRICING_CALL := ''Y'';',4);
1054: Text ('prev_header_id := QP_BULK_PREQ_GRP.G_LINE_REC.header_id(i);', 4);
1055: Text ('End If;', 3);
1056: Text ('Else', 2);
1057: Text ('If QP_PREQ_GRP.G_NEW_PRICING_CALL = ''Y'' Then',3);

Line 1057: Text ('If QP_PREQ_GRP.G_NEW_PRICING_CALL = ''Y'' Then',3);

1053: Text ('QP_PREQ_GRP.G_NEW_PRICING_CALL := ''Y'';',4);
1054: Text ('prev_header_id := QP_BULK_PREQ_GRP.G_LINE_REC.header_id(i);', 4);
1055: Text ('End If;', 3);
1056: Text ('Else', 2);
1057: Text ('If QP_PREQ_GRP.G_NEW_PRICING_CALL = ''Y'' Then',3);
1058: Text ('QP_PREQ_GRP.G_NEW_PRICING_CALL := ''N'';', 4);
1059: Text ('End If;', 3);
1060: Text ('End If;' , 2);
1061: ELSE

Line 1058: Text ('QP_PREQ_GRP.G_NEW_PRICING_CALL := ''N'';', 4);

1054: Text ('prev_header_id := QP_BULK_PREQ_GRP.G_LINE_REC.header_id(i);', 4);
1055: Text ('End If;', 3);
1056: Text ('Else', 2);
1057: Text ('If QP_PREQ_GRP.G_NEW_PRICING_CALL = ''Y'' Then',3);
1058: Text ('QP_PREQ_GRP.G_NEW_PRICING_CALL := ''N'';', 4);
1059: Text ('End If;', 3);
1060: Text ('End If;' , 2);
1061: ELSE
1062: Text('FOR i in QP_BULK_PREQ_GRP.G_HEADER_REC.header_id.first..QP_BULK_

Line 1704: Text ('QP_PREQ_GRP.G_NEW_PRICING_CALL := ''N'';', 4);

1700: Text ('--oe_debug_pub.add (''this_header_id: ''|| nvl(QP_BULK_PREQ_GRP.G_LINE_REC.header_id(i),0));');
1701: Text ('If QP_BULK_PREQ_GRP.G_LINE_REC.header_id(i) IS NOT NULL Then',2
1702: );
1703: Text ('If QP_BULK_PREQ_GRP.G_LINE_REC.header_id(i) = prev_header_id Then', 3);
1704: Text ('QP_PREQ_GRP.G_NEW_PRICING_CALL := ''N'';', 4);
1705: Text ('Else', 3);
1706: Text ('QP_PREQ_GRP.G_NEW_PRICING_CALL := ''Y'';',4);
1707: Text ('prev_header_id := QP_BULK_PREQ_GRP.G_LINE_REC.header_id(i);');
1708: Text ('End If;', 3);

Line 1706: Text ('QP_PREQ_GRP.G_NEW_PRICING_CALL := ''Y'';',4);

1702: );
1703: Text ('If QP_BULK_PREQ_GRP.G_LINE_REC.header_id(i) = prev_header_id Then', 3);
1704: Text ('QP_PREQ_GRP.G_NEW_PRICING_CALL := ''N'';', 4);
1705: Text ('Else', 3);
1706: Text ('QP_PREQ_GRP.G_NEW_PRICING_CALL := ''Y'';',4);
1707: Text ('prev_header_id := QP_BULK_PREQ_GRP.G_LINE_REC.header_id(i);');
1708: Text ('End If;', 3);
1709: Text ('Else', 2);
1710: Text ('If QP_PREQ_GRP.G_NEW_PRICING_CALL = ''Y'' Then',3);

Line 1710: Text ('If QP_PREQ_GRP.G_NEW_PRICING_CALL = ''Y'' Then',3);

1706: Text ('QP_PREQ_GRP.G_NEW_PRICING_CALL := ''Y'';',4);
1707: Text ('prev_header_id := QP_BULK_PREQ_GRP.G_LINE_REC.header_id(i);');
1708: Text ('End If;', 3);
1709: Text ('Else', 2);
1710: Text ('If QP_PREQ_GRP.G_NEW_PRICING_CALL = ''Y'' Then',3);
1711: Text ('QP_PREQ_GRP.G_NEW_PRICING_CALL := ''N'';', 4);
1712: Text ('--oe_debug_pub.add (''prev_header_id: ''|| prev_header_id);');
1713: Text ('End If;', 3);
1714: Text ('End If;' , 2);

Line 1711: Text ('QP_PREQ_GRP.G_NEW_PRICING_CALL := ''N'';', 4);

1707: Text ('prev_header_id := QP_BULK_PREQ_GRP.G_LINE_REC.header_id(i);');
1708: Text ('End If;', 3);
1709: Text ('Else', 2);
1710: Text ('If QP_PREQ_GRP.G_NEW_PRICING_CALL = ''Y'' Then',3);
1711: Text ('QP_PREQ_GRP.G_NEW_PRICING_CALL := ''N'';', 4);
1712: Text ('--oe_debug_pub.add (''prev_header_id: ''|| prev_header_id);');
1713: Text ('End If;', 3);
1714: Text ('End If;' , 2);
1715: ELSE

Line 2110: --l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;

2106:
2107: BEGIN
2108:
2109: --dbms_output.put_line('............1............');
2110: --l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
2111: IF l_debug = Fnd_Api.G_TRUE THEN
2112: Oe_Debug_Pub.ADD('##### Begin Build Sourcing #####');
2113:
2114: END IF;

Line 2149: Text('l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;',1);

2145: Text('BEGIN',0);
2146: Text('qp_debug_util.tstart(''FETCH_ATTRIBUTES'',''Fetching the Attribute Values'');',0);
2147: New_Line;
2148:
2149: Text('l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;',1);
2150:
2151: -- added for g_new_pricing_call for caching - hwong
2152: text('if p_pricing_type_code = ''H'' and qp_preq_grp.g_new_pricing_call = qp_preq_grp.g_no then', 0);
2153: text('qp_preq_grp.g_new_pricing_call := qp_preq_grp.g_yes;', 1);

Line 2152: text('if p_pricing_type_code = ''H'' and qp_preq_grp.g_new_pricing_call = qp_preq_grp.g_no then', 0);

2148:
2149: Text('l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;',1);
2150:
2151: -- added for g_new_pricing_call for caching - hwong
2152: text('if p_pricing_type_code = ''H'' and qp_preq_grp.g_new_pricing_call = qp_preq_grp.g_no then', 0);
2153: text('qp_preq_grp.g_new_pricing_call := qp_preq_grp.g_yes;', 1);
2154: Text('IF l_debug = FND_API.G_TRUE THEN',1);
2155: text('oe_debug_pub.add(''hw/src/H: change to g_yes'');',2);
2156: Text('END IF;',1);

Line 2153: text('qp_preq_grp.g_new_pricing_call := qp_preq_grp.g_yes;', 1);

2149: Text('l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;',1);
2150:
2151: -- added for g_new_pricing_call for caching - hwong
2152: text('if p_pricing_type_code = ''H'' and qp_preq_grp.g_new_pricing_call = qp_preq_grp.g_no then', 0);
2153: text('qp_preq_grp.g_new_pricing_call := qp_preq_grp.g_yes;', 1);
2154: Text('IF l_debug = FND_API.G_TRUE THEN',1);
2155: text('oe_debug_pub.add(''hw/src/H: change to g_yes'');',2);
2156: Text('END IF;',1);
2157: text('end if;', 0);

Line 2197: text('if p_pricing_type_code = ''L'' and qp_preq_grp.g_new_pricing_call = qp_preq_grp.g_yes then', 1);

2193:
2194: -- added for g_new_pricing_call for caching - hwong
2195: new_line;
2196: Text ('If QP_Util_PUB.HVOP_Pricing_On= ''N'' Then');
2197: text('if p_pricing_type_code = ''L'' and qp_preq_grp.g_new_pricing_call = qp_preq_grp.g_yes then', 1);
2198: text('qp_preq_grp.g_new_pricing_call := qp_preq_grp.g_no;', 2);
2199: Text('IF l_debug = FND_API.G_TRUE THEN',2);
2200: text('oe_debug_pub.add(''hw/src/L: change to g_no'');',3);
2201: Text('END IF;',2);

Line 2198: text('qp_preq_grp.g_new_pricing_call := qp_preq_grp.g_no;', 2);

2194: -- added for g_new_pricing_call for caching - hwong
2195: new_line;
2196: Text ('If QP_Util_PUB.HVOP_Pricing_On= ''N'' Then');
2197: text('if p_pricing_type_code = ''L'' and qp_preq_grp.g_new_pricing_call = qp_preq_grp.g_yes then', 1);
2198: text('qp_preq_grp.g_new_pricing_call := qp_preq_grp.g_no;', 2);
2199: Text('IF l_debug = FND_API.G_TRUE THEN',2);
2200: text('oe_debug_pub.add(''hw/src/L: change to g_no'');',3);
2201: Text('END IF;',2);
2202: text('end if;', 1);

Line 2249: text('if p_pricing_type_code = ''L'' and qp_preq_grp.g_new_pricing_call = qp_preq_grp.g_yes then', 2);

2245:
2246: -- added for g_new_pricing_call for caching - hwong
2247: new_line;
2248: Text ('If QP_Util_PUB.HVOP_Pricing_On = ''N'' Then',1);
2249: text('if p_pricing_type_code = ''L'' and qp_preq_grp.g_new_pricing_call = qp_preq_grp.g_yes then', 2);
2250: text('qp_preq_grp.g_new_pricing_call := qp_preq_grp.g_no;', 3);
2251: Text('IF l_debug = FND_API.G_TRUE THEN',3);
2252: text('oe_debug_pub.add(''hw/src/L: change to g_no'');',4);
2253: Text('END IF;',3);

Line 2250: text('qp_preq_grp.g_new_pricing_call := qp_preq_grp.g_no;', 3);

2246: -- added for g_new_pricing_call for caching - hwong
2247: new_line;
2248: Text ('If QP_Util_PUB.HVOP_Pricing_On = ''N'' Then',1);
2249: text('if p_pricing_type_code = ''L'' and qp_preq_grp.g_new_pricing_call = qp_preq_grp.g_yes then', 2);
2250: text('qp_preq_grp.g_new_pricing_call := qp_preq_grp.g_no;', 3);
2251: Text('IF l_debug = FND_API.G_TRUE THEN',3);
2252: text('oe_debug_pub.add(''hw/src/L: change to g_no'');',4);
2253: Text('END IF;',3);
2254: text('end if;', 2);

Line 2360: Qp_Preq_Grp.Set_QP_Debug;

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;
2361:
2362: --added for MOAC
2363: --Set the Global variable G_ORG_ID
2364: G_ORG_ID := NVL(p_org_id, Qp_Util.get_org_id);

Line 2377: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;

2373: END IF;
2374: END IF;--MO_GLOBAL
2375:
2376:
2377: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;
2378:
2379: IF l_debug = Fnd_Api.G_TRUE THEN
2380: Oe_Debug_Pub.ADD('##### Begin Build Contexts #####');
2381: END IF;

Line 2620: l_line_index_tbl Qp_Preq_Grp.PLS_INTEGER_TYPE;

2616:
2617: v_price_contexts_result_tbl CONTEXTS_RESULT_TBL_TYPE;
2618: v_qual_contexts_result_tbl CONTEXTS_RESULT_TBL_TYPE;
2619:
2620: l_line_index_tbl Qp_Preq_Grp.PLS_INTEGER_TYPE;
2621: l_line_detail_index_tbl Qp_Preq_Grp.PLS_INTEGER_TYPE;
2622: l_attribute_type_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2623: l_context_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2624: l_attribute_tbl Qp_Preq_Grp.VARCHAR_TYPE;

Line 2621: l_line_detail_index_tbl Qp_Preq_Grp.PLS_INTEGER_TYPE;

2617: v_price_contexts_result_tbl CONTEXTS_RESULT_TBL_TYPE;
2618: v_qual_contexts_result_tbl CONTEXTS_RESULT_TBL_TYPE;
2619:
2620: l_line_index_tbl Qp_Preq_Grp.PLS_INTEGER_TYPE;
2621: l_line_detail_index_tbl Qp_Preq_Grp.PLS_INTEGER_TYPE;
2622: l_attribute_type_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2623: l_context_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2624: l_attribute_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2625: l_value_from_tbl Qp_Preq_Grp.VARCHAR_TYPE;

Line 2622: l_attribute_type_tbl Qp_Preq_Grp.VARCHAR_TYPE;

2618: v_qual_contexts_result_tbl CONTEXTS_RESULT_TBL_TYPE;
2619:
2620: l_line_index_tbl Qp_Preq_Grp.PLS_INTEGER_TYPE;
2621: l_line_detail_index_tbl Qp_Preq_Grp.PLS_INTEGER_TYPE;
2622: l_attribute_type_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2623: l_context_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2624: l_attribute_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2625: l_value_from_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2626: l_value_to_tbl Qp_Preq_Grp.VARCHAR_TYPE;

Line 2623: l_context_tbl Qp_Preq_Grp.VARCHAR_TYPE;

2619:
2620: l_line_index_tbl Qp_Preq_Grp.PLS_INTEGER_TYPE;
2621: l_line_detail_index_tbl Qp_Preq_Grp.PLS_INTEGER_TYPE;
2622: l_attribute_type_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2623: l_context_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2624: l_attribute_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2625: l_value_from_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2626: l_value_to_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2627: l_validated_flag_tbl Qp_Preq_Grp.VARCHAR_TYPE;

Line 2624: l_attribute_tbl Qp_Preq_Grp.VARCHAR_TYPE;

2620: l_line_index_tbl Qp_Preq_Grp.PLS_INTEGER_TYPE;
2621: l_line_detail_index_tbl Qp_Preq_Grp.PLS_INTEGER_TYPE;
2622: l_attribute_type_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2623: l_context_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2624: l_attribute_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2625: l_value_from_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2626: l_value_to_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2627: l_validated_flag_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2628: l_ATTRIBUTE_LEVEL_tbl Qp_Preq_Grp.varchar_type;

Line 2625: l_value_from_tbl Qp_Preq_Grp.VARCHAR_TYPE;

2621: l_line_detail_index_tbl Qp_Preq_Grp.PLS_INTEGER_TYPE;
2622: l_attribute_type_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2623: l_context_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2624: l_attribute_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2625: l_value_from_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2626: l_value_to_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2627: l_validated_flag_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2628: l_ATTRIBUTE_LEVEL_tbl Qp_Preq_Grp.varchar_type;
2629: l_LIST_HEADER_ID_tbl Qp_Preq_Grp.number_type;

Line 2626: l_value_to_tbl Qp_Preq_Grp.VARCHAR_TYPE;

2622: l_attribute_type_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2623: l_context_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2624: l_attribute_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2625: l_value_from_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2626: l_value_to_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2627: l_validated_flag_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2628: l_ATTRIBUTE_LEVEL_tbl Qp_Preq_Grp.varchar_type;
2629: l_LIST_HEADER_ID_tbl Qp_Preq_Grp.number_type;
2630: l_LIST_LINE_ID_tbl Qp_Preq_Grp.number_type;

Line 2627: l_validated_flag_tbl Qp_Preq_Grp.VARCHAR_TYPE;

2623: l_context_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2624: l_attribute_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2625: l_value_from_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2626: l_value_to_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2627: l_validated_flag_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2628: l_ATTRIBUTE_LEVEL_tbl Qp_Preq_Grp.varchar_type;
2629: l_LIST_HEADER_ID_tbl Qp_Preq_Grp.number_type;
2630: l_LIST_LINE_ID_tbl Qp_Preq_Grp.number_type;
2631: l_SETUP_VALUE_FROM_tbl Qp_Preq_Grp.varchar_type;

Line 2628: l_ATTRIBUTE_LEVEL_tbl Qp_Preq_Grp.varchar_type;

2624: l_attribute_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2625: l_value_from_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2626: l_value_to_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2627: l_validated_flag_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2628: l_ATTRIBUTE_LEVEL_tbl Qp_Preq_Grp.varchar_type;
2629: l_LIST_HEADER_ID_tbl Qp_Preq_Grp.number_type;
2630: l_LIST_LINE_ID_tbl Qp_Preq_Grp.number_type;
2631: l_SETUP_VALUE_FROM_tbl Qp_Preq_Grp.varchar_type;
2632: l_SETUP_VALUE_TO_tbl Qp_Preq_Grp.varchar_type;

Line 2629: l_LIST_HEADER_ID_tbl Qp_Preq_Grp.number_type;

2625: l_value_from_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2626: l_value_to_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2627: l_validated_flag_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2628: l_ATTRIBUTE_LEVEL_tbl Qp_Preq_Grp.varchar_type;
2629: l_LIST_HEADER_ID_tbl Qp_Preq_Grp.number_type;
2630: l_LIST_LINE_ID_tbl Qp_Preq_Grp.number_type;
2631: l_SETUP_VALUE_FROM_tbl Qp_Preq_Grp.varchar_type;
2632: l_SETUP_VALUE_TO_tbl Qp_Preq_Grp.varchar_type;
2633: l_GROUPING_NUMBER_tbl Qp_Preq_Grp.pls_integer_type;

Line 2630: l_LIST_LINE_ID_tbl Qp_Preq_Grp.number_type;

2626: l_value_to_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2627: l_validated_flag_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2628: l_ATTRIBUTE_LEVEL_tbl Qp_Preq_Grp.varchar_type;
2629: l_LIST_HEADER_ID_tbl Qp_Preq_Grp.number_type;
2630: l_LIST_LINE_ID_tbl Qp_Preq_Grp.number_type;
2631: l_SETUP_VALUE_FROM_tbl Qp_Preq_Grp.varchar_type;
2632: l_SETUP_VALUE_TO_tbl Qp_Preq_Grp.varchar_type;
2633: l_GROUPING_NUMBER_tbl Qp_Preq_Grp.pls_integer_type;
2634: l_NO_QUALIFIERS_IN_GRP_tbl Qp_Preq_Grp.pls_integer_type;

Line 2631: l_SETUP_VALUE_FROM_tbl Qp_Preq_Grp.varchar_type;

2627: l_validated_flag_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2628: l_ATTRIBUTE_LEVEL_tbl Qp_Preq_Grp.varchar_type;
2629: l_LIST_HEADER_ID_tbl Qp_Preq_Grp.number_type;
2630: l_LIST_LINE_ID_tbl Qp_Preq_Grp.number_type;
2631: l_SETUP_VALUE_FROM_tbl Qp_Preq_Grp.varchar_type;
2632: l_SETUP_VALUE_TO_tbl Qp_Preq_Grp.varchar_type;
2633: l_GROUPING_NUMBER_tbl Qp_Preq_Grp.pls_integer_type;
2634: l_NO_QUALIFIERS_IN_GRP_tbl Qp_Preq_Grp.pls_integer_type;
2635: l_COMPARISON_OPERATOR_TYPE_tbl Qp_Preq_Grp.varchar_type;

Line 2632: l_SETUP_VALUE_TO_tbl Qp_Preq_Grp.varchar_type;

2628: l_ATTRIBUTE_LEVEL_tbl Qp_Preq_Grp.varchar_type;
2629: l_LIST_HEADER_ID_tbl Qp_Preq_Grp.number_type;
2630: l_LIST_LINE_ID_tbl Qp_Preq_Grp.number_type;
2631: l_SETUP_VALUE_FROM_tbl Qp_Preq_Grp.varchar_type;
2632: l_SETUP_VALUE_TO_tbl Qp_Preq_Grp.varchar_type;
2633: l_GROUPING_NUMBER_tbl Qp_Preq_Grp.pls_integer_type;
2634: l_NO_QUALIFIERS_IN_GRP_tbl Qp_Preq_Grp.pls_integer_type;
2635: l_COMPARISON_OPERATOR_TYPE_tbl Qp_Preq_Grp.varchar_type;
2636: l_APPLIED_FLAG_tbl Qp_Preq_Grp.varchar_type;

Line 2633: l_GROUPING_NUMBER_tbl Qp_Preq_Grp.pls_integer_type;

2629: l_LIST_HEADER_ID_tbl Qp_Preq_Grp.number_type;
2630: l_LIST_LINE_ID_tbl Qp_Preq_Grp.number_type;
2631: l_SETUP_VALUE_FROM_tbl Qp_Preq_Grp.varchar_type;
2632: l_SETUP_VALUE_TO_tbl Qp_Preq_Grp.varchar_type;
2633: l_GROUPING_NUMBER_tbl Qp_Preq_Grp.pls_integer_type;
2634: l_NO_QUALIFIERS_IN_GRP_tbl Qp_Preq_Grp.pls_integer_type;
2635: l_COMPARISON_OPERATOR_TYPE_tbl Qp_Preq_Grp.varchar_type;
2636: l_APPLIED_FLAG_tbl Qp_Preq_Grp.varchar_type;
2637: l_PRICING_STATUS_CODE_tbl Qp_Preq_Grp.varchar_type;

Line 2634: l_NO_QUALIFIERS_IN_GRP_tbl Qp_Preq_Grp.pls_integer_type;

2630: l_LIST_LINE_ID_tbl Qp_Preq_Grp.number_type;
2631: l_SETUP_VALUE_FROM_tbl Qp_Preq_Grp.varchar_type;
2632: l_SETUP_VALUE_TO_tbl Qp_Preq_Grp.varchar_type;
2633: l_GROUPING_NUMBER_tbl Qp_Preq_Grp.pls_integer_type;
2634: l_NO_QUALIFIERS_IN_GRP_tbl Qp_Preq_Grp.pls_integer_type;
2635: l_COMPARISON_OPERATOR_TYPE_tbl Qp_Preq_Grp.varchar_type;
2636: l_APPLIED_FLAG_tbl Qp_Preq_Grp.varchar_type;
2637: l_PRICING_STATUS_CODE_tbl Qp_Preq_Grp.varchar_type;
2638: l_PRICING_STATUS_TEXT_tbl Qp_Preq_Grp.varchar_type;

Line 2635: l_COMPARISON_OPERATOR_TYPE_tbl Qp_Preq_Grp.varchar_type;

2631: l_SETUP_VALUE_FROM_tbl Qp_Preq_Grp.varchar_type;
2632: l_SETUP_VALUE_TO_tbl Qp_Preq_Grp.varchar_type;
2633: l_GROUPING_NUMBER_tbl Qp_Preq_Grp.pls_integer_type;
2634: l_NO_QUALIFIERS_IN_GRP_tbl Qp_Preq_Grp.pls_integer_type;
2635: l_COMPARISON_OPERATOR_TYPE_tbl Qp_Preq_Grp.varchar_type;
2636: l_APPLIED_FLAG_tbl Qp_Preq_Grp.varchar_type;
2637: l_PRICING_STATUS_CODE_tbl Qp_Preq_Grp.varchar_type;
2638: l_PRICING_STATUS_TEXT_tbl Qp_Preq_Grp.varchar_type;
2639: l_QUALIFIER_PRECEDENCE_tbl Qp_Preq_Grp.pls_integer_type;

Line 2636: l_APPLIED_FLAG_tbl Qp_Preq_Grp.varchar_type;

2632: l_SETUP_VALUE_TO_tbl Qp_Preq_Grp.varchar_type;
2633: l_GROUPING_NUMBER_tbl Qp_Preq_Grp.pls_integer_type;
2634: l_NO_QUALIFIERS_IN_GRP_tbl Qp_Preq_Grp.pls_integer_type;
2635: l_COMPARISON_OPERATOR_TYPE_tbl Qp_Preq_Grp.varchar_type;
2636: l_APPLIED_FLAG_tbl Qp_Preq_Grp.varchar_type;
2637: l_PRICING_STATUS_CODE_tbl Qp_Preq_Grp.varchar_type;
2638: l_PRICING_STATUS_TEXT_tbl Qp_Preq_Grp.varchar_type;
2639: l_QUALIFIER_PRECEDENCE_tbl Qp_Preq_Grp.pls_integer_type;
2640: l_DATATYPE_tbl Qp_Preq_Grp.varchar_type;

Line 2637: l_PRICING_STATUS_CODE_tbl Qp_Preq_Grp.varchar_type;

2633: l_GROUPING_NUMBER_tbl Qp_Preq_Grp.pls_integer_type;
2634: l_NO_QUALIFIERS_IN_GRP_tbl Qp_Preq_Grp.pls_integer_type;
2635: l_COMPARISON_OPERATOR_TYPE_tbl Qp_Preq_Grp.varchar_type;
2636: l_APPLIED_FLAG_tbl Qp_Preq_Grp.varchar_type;
2637: l_PRICING_STATUS_CODE_tbl Qp_Preq_Grp.varchar_type;
2638: l_PRICING_STATUS_TEXT_tbl Qp_Preq_Grp.varchar_type;
2639: l_QUALIFIER_PRECEDENCE_tbl Qp_Preq_Grp.pls_integer_type;
2640: l_DATATYPE_tbl Qp_Preq_Grp.varchar_type;
2641: l_PRICING_ATTR_FLAG_tbl Qp_Preq_Grp.varchar_type;

Line 2638: l_PRICING_STATUS_TEXT_tbl Qp_Preq_Grp.varchar_type;

2634: l_NO_QUALIFIERS_IN_GRP_tbl Qp_Preq_Grp.pls_integer_type;
2635: l_COMPARISON_OPERATOR_TYPE_tbl Qp_Preq_Grp.varchar_type;
2636: l_APPLIED_FLAG_tbl Qp_Preq_Grp.varchar_type;
2637: l_PRICING_STATUS_CODE_tbl Qp_Preq_Grp.varchar_type;
2638: l_PRICING_STATUS_TEXT_tbl Qp_Preq_Grp.varchar_type;
2639: l_QUALIFIER_PRECEDENCE_tbl Qp_Preq_Grp.pls_integer_type;
2640: l_DATATYPE_tbl Qp_Preq_Grp.varchar_type;
2641: l_PRICING_ATTR_FLAG_tbl Qp_Preq_Grp.varchar_type;
2642: l_QUALIFIER_type_tbl Qp_Preq_Grp.varchar_type;

Line 2639: l_QUALIFIER_PRECEDENCE_tbl Qp_Preq_Grp.pls_integer_type;

2635: l_COMPARISON_OPERATOR_TYPE_tbl Qp_Preq_Grp.varchar_type;
2636: l_APPLIED_FLAG_tbl Qp_Preq_Grp.varchar_type;
2637: l_PRICING_STATUS_CODE_tbl Qp_Preq_Grp.varchar_type;
2638: l_PRICING_STATUS_TEXT_tbl Qp_Preq_Grp.varchar_type;
2639: l_QUALIFIER_PRECEDENCE_tbl Qp_Preq_Grp.pls_integer_type;
2640: l_DATATYPE_tbl Qp_Preq_Grp.varchar_type;
2641: l_PRICING_ATTR_FLAG_tbl Qp_Preq_Grp.varchar_type;
2642: l_QUALIFIER_type_tbl Qp_Preq_Grp.varchar_type;
2643: l_PRODUCT_UOM_CODE_TBL Qp_Preq_Grp.varchar_type;

Line 2640: l_DATATYPE_tbl Qp_Preq_Grp.varchar_type;

2636: l_APPLIED_FLAG_tbl Qp_Preq_Grp.varchar_type;
2637: l_PRICING_STATUS_CODE_tbl Qp_Preq_Grp.varchar_type;
2638: l_PRICING_STATUS_TEXT_tbl Qp_Preq_Grp.varchar_type;
2639: l_QUALIFIER_PRECEDENCE_tbl Qp_Preq_Grp.pls_integer_type;
2640: l_DATATYPE_tbl Qp_Preq_Grp.varchar_type;
2641: l_PRICING_ATTR_FLAG_tbl Qp_Preq_Grp.varchar_type;
2642: l_QUALIFIER_type_tbl Qp_Preq_Grp.varchar_type;
2643: l_PRODUCT_UOM_CODE_TBL Qp_Preq_Grp.varchar_type;
2644: l_EXCLUDER_FLAG_TBL Qp_Preq_Grp.varchar_type ;

Line 2641: l_PRICING_ATTR_FLAG_tbl Qp_Preq_Grp.varchar_type;

2637: l_PRICING_STATUS_CODE_tbl Qp_Preq_Grp.varchar_type;
2638: l_PRICING_STATUS_TEXT_tbl Qp_Preq_Grp.varchar_type;
2639: l_QUALIFIER_PRECEDENCE_tbl Qp_Preq_Grp.pls_integer_type;
2640: l_DATATYPE_tbl Qp_Preq_Grp.varchar_type;
2641: l_PRICING_ATTR_FLAG_tbl Qp_Preq_Grp.varchar_type;
2642: l_QUALIFIER_type_tbl Qp_Preq_Grp.varchar_type;
2643: l_PRODUCT_UOM_CODE_TBL Qp_Preq_Grp.varchar_type;
2644: l_EXCLUDER_FLAG_TBL Qp_Preq_Grp.varchar_type ;
2645: l_PRICING_PHASE_ID_TBL Qp_Preq_Grp.pls_integer_type ;

Line 2642: l_QUALIFIER_type_tbl Qp_Preq_Grp.varchar_type;

2638: l_PRICING_STATUS_TEXT_tbl Qp_Preq_Grp.varchar_type;
2639: l_QUALIFIER_PRECEDENCE_tbl Qp_Preq_Grp.pls_integer_type;
2640: l_DATATYPE_tbl Qp_Preq_Grp.varchar_type;
2641: l_PRICING_ATTR_FLAG_tbl Qp_Preq_Grp.varchar_type;
2642: l_QUALIFIER_type_tbl Qp_Preq_Grp.varchar_type;
2643: l_PRODUCT_UOM_CODE_TBL Qp_Preq_Grp.varchar_type;
2644: l_EXCLUDER_FLAG_TBL Qp_Preq_Grp.varchar_type ;
2645: l_PRICING_PHASE_ID_TBL Qp_Preq_Grp.pls_integer_type ;
2646: l_INCOMPATABILITY_GRP_CODE_TBL Qp_Preq_Grp.varchar_type ;

Line 2643: l_PRODUCT_UOM_CODE_TBL Qp_Preq_Grp.varchar_type;

2639: l_QUALIFIER_PRECEDENCE_tbl Qp_Preq_Grp.pls_integer_type;
2640: l_DATATYPE_tbl Qp_Preq_Grp.varchar_type;
2641: l_PRICING_ATTR_FLAG_tbl Qp_Preq_Grp.varchar_type;
2642: l_QUALIFIER_type_tbl Qp_Preq_Grp.varchar_type;
2643: l_PRODUCT_UOM_CODE_TBL Qp_Preq_Grp.varchar_type;
2644: l_EXCLUDER_FLAG_TBL Qp_Preq_Grp.varchar_type ;
2645: l_PRICING_PHASE_ID_TBL Qp_Preq_Grp.pls_integer_type ;
2646: l_INCOMPATABILITY_GRP_CODE_TBL Qp_Preq_Grp.varchar_type ;
2647: l_LINE_DETAIL_type_CODE_TBL Qp_Preq_Grp.varchar_type ;

Line 2644: l_EXCLUDER_FLAG_TBL Qp_Preq_Grp.varchar_type ;

2640: l_DATATYPE_tbl Qp_Preq_Grp.varchar_type;
2641: l_PRICING_ATTR_FLAG_tbl Qp_Preq_Grp.varchar_type;
2642: l_QUALIFIER_type_tbl Qp_Preq_Grp.varchar_type;
2643: l_PRODUCT_UOM_CODE_TBL Qp_Preq_Grp.varchar_type;
2644: l_EXCLUDER_FLAG_TBL Qp_Preq_Grp.varchar_type ;
2645: l_PRICING_PHASE_ID_TBL Qp_Preq_Grp.pls_integer_type ;
2646: l_INCOMPATABILITY_GRP_CODE_TBL Qp_Preq_Grp.varchar_type ;
2647: l_LINE_DETAIL_type_CODE_TBL Qp_Preq_Grp.varchar_type ;
2648: l_MODIFIER_LEVEL_CODE_TBL Qp_Preq_Grp.varchar_type ;

Line 2645: l_PRICING_PHASE_ID_TBL Qp_Preq_Grp.pls_integer_type ;

2641: l_PRICING_ATTR_FLAG_tbl Qp_Preq_Grp.varchar_type;
2642: l_QUALIFIER_type_tbl Qp_Preq_Grp.varchar_type;
2643: l_PRODUCT_UOM_CODE_TBL Qp_Preq_Grp.varchar_type;
2644: l_EXCLUDER_FLAG_TBL Qp_Preq_Grp.varchar_type ;
2645: l_PRICING_PHASE_ID_TBL Qp_Preq_Grp.pls_integer_type ;
2646: l_INCOMPATABILITY_GRP_CODE_TBL Qp_Preq_Grp.varchar_type ;
2647: l_LINE_DETAIL_type_CODE_TBL Qp_Preq_Grp.varchar_type ;
2648: l_MODIFIER_LEVEL_CODE_TBL Qp_Preq_Grp.varchar_type ;
2649: l_PRIMARY_UOM_FLAG_TBL Qp_Preq_Grp.varchar_type ;

Line 2646: l_INCOMPATABILITY_GRP_CODE_TBL Qp_Preq_Grp.varchar_type ;

2642: l_QUALIFIER_type_tbl Qp_Preq_Grp.varchar_type;
2643: l_PRODUCT_UOM_CODE_TBL Qp_Preq_Grp.varchar_type;
2644: l_EXCLUDER_FLAG_TBL Qp_Preq_Grp.varchar_type ;
2645: l_PRICING_PHASE_ID_TBL Qp_Preq_Grp.pls_integer_type ;
2646: l_INCOMPATABILITY_GRP_CODE_TBL Qp_Preq_Grp.varchar_type ;
2647: l_LINE_DETAIL_type_CODE_TBL Qp_Preq_Grp.varchar_type ;
2648: l_MODIFIER_LEVEL_CODE_TBL Qp_Preq_Grp.varchar_type ;
2649: l_PRIMARY_UOM_FLAG_TBL Qp_Preq_Grp.varchar_type ;
2650:

Line 2647: l_LINE_DETAIL_type_CODE_TBL Qp_Preq_Grp.varchar_type ;

2643: l_PRODUCT_UOM_CODE_TBL Qp_Preq_Grp.varchar_type;
2644: l_EXCLUDER_FLAG_TBL Qp_Preq_Grp.varchar_type ;
2645: l_PRICING_PHASE_ID_TBL Qp_Preq_Grp.pls_integer_type ;
2646: l_INCOMPATABILITY_GRP_CODE_TBL Qp_Preq_Grp.varchar_type ;
2647: l_LINE_DETAIL_type_CODE_TBL Qp_Preq_Grp.varchar_type ;
2648: l_MODIFIER_LEVEL_CODE_TBL Qp_Preq_Grp.varchar_type ;
2649: l_PRIMARY_UOM_FLAG_TBL Qp_Preq_Grp.varchar_type ;
2650:
2651: l_pricing_type_code VARCHAR2(1) := Fnd_Api.G_MISS_CHAR;

Line 2648: l_MODIFIER_LEVEL_CODE_TBL Qp_Preq_Grp.varchar_type ;

2644: l_EXCLUDER_FLAG_TBL Qp_Preq_Grp.varchar_type ;
2645: l_PRICING_PHASE_ID_TBL Qp_Preq_Grp.pls_integer_type ;
2646: l_INCOMPATABILITY_GRP_CODE_TBL Qp_Preq_Grp.varchar_type ;
2647: l_LINE_DETAIL_type_CODE_TBL Qp_Preq_Grp.varchar_type ;
2648: l_MODIFIER_LEVEL_CODE_TBL Qp_Preq_Grp.varchar_type ;
2649: l_PRIMARY_UOM_FLAG_TBL Qp_Preq_Grp.varchar_type ;
2650:
2651: l_pricing_type_code VARCHAR2(1) := Fnd_Api.G_MISS_CHAR;
2652: K PLS_INTEGER;

Line 2649: l_PRIMARY_UOM_FLAG_TBL Qp_Preq_Grp.varchar_type ;

2645: l_PRICING_PHASE_ID_TBL Qp_Preq_Grp.pls_integer_type ;
2646: l_INCOMPATABILITY_GRP_CODE_TBL Qp_Preq_Grp.varchar_type ;
2647: l_LINE_DETAIL_type_CODE_TBL Qp_Preq_Grp.varchar_type ;
2648: l_MODIFIER_LEVEL_CODE_TBL Qp_Preq_Grp.varchar_type ;
2649: l_PRIMARY_UOM_FLAG_TBL Qp_Preq_Grp.varchar_type ;
2650:
2651: l_pricing_type_code VARCHAR2(1) := Fnd_Api.G_MISS_CHAR;
2652: K PLS_INTEGER;
2653:

Line 2674: Qp_Preq_Grp.Set_QP_Debug;

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;
2675:
2676: --added for MOAC
2677: --Set the Global variable G_ORG_ID
2678: G_ORG_ID := NVL(p_org_id, Qp_Util.get_org_id);

Line 2690: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;

2686: Mo_Global.set_policy_context('S', G_ORG_ID);
2687: END IF;
2688: END IF;--MO_GLOBAL
2689:
2690: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;
2691:
2692: --setting time
2693: l_sourcing_start_time := dbms_utility.get_time;
2694:

Line 2731: Qp_Preq_Grp.ENGINE_DEBUG('Begin Build contexts');

2727: l_MODIFIER_LEVEL_CODE_tbl.DELETE;
2728: l_PRIMARY_UOM_FLAG_tbl.DELETE;
2729:
2730: IF l_debug = Fnd_Api.G_TRUE THEN
2731: Qp_Preq_Grp.ENGINE_DEBUG('Begin Build contexts');
2732:
2733: END IF;
2734: K := 0;
2735: Qp_Attr_Mapping_Pub.G_REQ_TYPE_CODE := p_request_type_code; --bug3848849

Line 2739: Qp_Preq_Grp.ENGINE_DEBUG('Called Build Sourcing at line level----------');

2735: Qp_Attr_Mapping_Pub.G_REQ_TYPE_CODE := p_request_type_code; --bug3848849
2736:
2737: --Called Build Sourcing at line level
2738: IF l_debug = Fnd_Api.G_TRUE THEN
2739: Qp_Preq_Grp.ENGINE_DEBUG('Called Build Sourcing at line level----------');
2740:
2741: END IF;
2742: l_pricing_type_code := 'L';
2743:

Line 2854: Qp_Preq_Grp.ENGINE_DEBUG('Number of qual attrs got from Get_Attribute_Values - ' || l_qual_contexts_result_tbl.COUNT );

2850: profile option ' QP_CUSTOM_SOURCED' is set to 'Y' -- GTIPPIRE
2851: */
2852:
2853: IF l_debug = Fnd_Api.G_TRUE THEN
2854: Qp_Preq_Grp.ENGINE_DEBUG('Number of qual attrs got from Get_Attribute_Values - ' || l_qual_contexts_result_tbl.COUNT );
2855: Qp_Preq_Grp.ENGINE_DEBUG('Number of pricing attrs got from Get_Attribute_Values - ' || l_price_contexts_result_tbl.COUNT );
2856:
2857: END IF;
2858: IF NVL(l_custom_sourced,'N') = 'Y' THEN

Line 2855: Qp_Preq_Grp.ENGINE_DEBUG('Number of pricing attrs got from Get_Attribute_Values - ' || l_price_contexts_result_tbl.COUNT );

2851: */
2852:
2853: IF l_debug = Fnd_Api.G_TRUE THEN
2854: Qp_Preq_Grp.ENGINE_DEBUG('Number of qual attrs got from Get_Attribute_Values - ' || l_qual_contexts_result_tbl.COUNT );
2855: Qp_Preq_Grp.ENGINE_DEBUG('Number of pricing attrs got from Get_Attribute_Values - ' || l_price_contexts_result_tbl.COUNT );
2856:
2857: END IF;
2858: IF NVL(l_custom_sourced,'N') = 'Y' THEN
2859: IF l_debug = Fnd_Api.G_TRUE THEN

Line 2860: Qp_Preq_Grp.ENGINE_DEBUG('Before Calling Custom Sourcing Package ----------');

2856:
2857: END IF;
2858: IF NVL(l_custom_sourced,'N') = 'Y' THEN
2859: IF l_debug = Fnd_Api.G_TRUE THEN
2860: Qp_Preq_Grp.ENGINE_DEBUG('Before Calling Custom Sourcing Package ----------');
2861: END IF;
2862: Begin
2863: qp_debug_util.tstart('GET_CUSTOM_ATTRIBUTE_VALUES','Calling the QP_CUSTOM_SOURCE package to fetch the cutom attribute values');
2864: Qp_Custom_Source.Get_Custom_Attribute_Values(p_req_type_code => p_request_type_code,

Line 2874: Qp_Preq_Grp.ENGINE_DEBUG('After Calling Custom Sourcing Package ----------');

2870: when others then
2871: qp_debug_util.tstop('GET_CUSTOM_ATTRIBUTE_VALUES');
2872: end;
2873: IF l_debug = Fnd_Api.G_TRUE THEN
2874: Qp_Preq_Grp.ENGINE_DEBUG('After Calling Custom Sourcing Package ----------');
2875:
2876: Qp_Preq_Grp.ENGINE_DEBUG('Number of qual attrs got from Get_Custom_Attribute_Values - ' || v_qual_contexts_result_tbl.COUNT );
2877: Qp_Preq_Grp.ENGINE_DEBUG('Number of pricing attrs got from Get_Custom_Attribute_Values - ' || v_price_contexts_result_tbl.COUNT );
2878:

Line 2876: Qp_Preq_Grp.ENGINE_DEBUG('Number of qual attrs got from Get_Custom_Attribute_Values - ' || v_qual_contexts_result_tbl.COUNT );

2872: end;
2873: IF l_debug = Fnd_Api.G_TRUE THEN
2874: Qp_Preq_Grp.ENGINE_DEBUG('After Calling Custom Sourcing Package ----------');
2875:
2876: Qp_Preq_Grp.ENGINE_DEBUG('Number of qual attrs got from Get_Custom_Attribute_Values - ' || v_qual_contexts_result_tbl.COUNT );
2877: Qp_Preq_Grp.ENGINE_DEBUG('Number of pricing attrs got from Get_Custom_Attribute_Values - ' || v_price_contexts_result_tbl.COUNT );
2878:
2879: END IF;
2880: l_count := l_qual_contexts_result_tbl.COUNT;

Line 2877: Qp_Preq_Grp.ENGINE_DEBUG('Number of pricing attrs got from Get_Custom_Attribute_Values - ' || v_price_contexts_result_tbl.COUNT );

2873: IF l_debug = Fnd_Api.G_TRUE THEN
2874: Qp_Preq_Grp.ENGINE_DEBUG('After Calling Custom Sourcing Package ----------');
2875:
2876: Qp_Preq_Grp.ENGINE_DEBUG('Number of qual attrs got from Get_Custom_Attribute_Values - ' || v_qual_contexts_result_tbl.COUNT );
2877: Qp_Preq_Grp.ENGINE_DEBUG('Number of pricing attrs got from Get_Custom_Attribute_Values - ' || v_price_contexts_result_tbl.COUNT );
2878:
2879: END IF;
2880: l_count := l_qual_contexts_result_tbl.COUNT;
2881:

Line 3071: Qp_Preq_Grp.ENGINE_DEBUG('Called Build Sourcing at header level----------');

3067: END IF;
3068:
3069: --Called Build Sourcing at header level
3070: IF l_debug = Fnd_Api.G_TRUE THEN
3071: Qp_Preq_Grp.ENGINE_DEBUG('Called Build Sourcing at header level----------');
3072:
3073: END IF;
3074: v_count := 0;
3075: l_count := 0;

Line 3139: Qp_Preq_Grp.ENGINE_DEBUG('Number of qual attrs got from Get_Attribute_Values - ' || l_qual_contexts_result_tbl.COUNT );

3135: END IF;
3136: -- 13638721
3137:
3138: IF l_debug = Fnd_Api.G_TRUE THEN
3139: Qp_Preq_Grp.ENGINE_DEBUG('Number of qual attrs got from Get_Attribute_Values - ' || l_qual_contexts_result_tbl.COUNT );
3140: Qp_Preq_Grp.ENGINE_DEBUG('Number of pricing attrs got from Get_Attribute_Values - ' || l_price_contexts_result_tbl.COUNT );
3141:
3142: END IF;
3143: /*

Line 3140: Qp_Preq_Grp.ENGINE_DEBUG('Number of pricing attrs got from Get_Attribute_Values - ' || l_price_contexts_result_tbl.COUNT );

3136: -- 13638721
3137:
3138: IF l_debug = Fnd_Api.G_TRUE THEN
3139: Qp_Preq_Grp.ENGINE_DEBUG('Number of qual attrs got from Get_Attribute_Values - ' || l_qual_contexts_result_tbl.COUNT );
3140: Qp_Preq_Grp.ENGINE_DEBUG('Number of pricing attrs got from Get_Attribute_Values - ' || l_price_contexts_result_tbl.COUNT );
3141:
3142: END IF;
3143: /*
3144: If the attribute sourcing method is 'CUSTOM SOURCING' then user provides code to source

Line 3153: Qp_Preq_Grp.ENGINE_DEBUG('Before Calling Custom Sourcing Package ----------');

3149: */
3150:
3151: IF NVL(l_custom_sourced,'N') = 'Y' THEN
3152: IF l_debug = Fnd_Api.G_TRUE THEN
3153: Qp_Preq_Grp.ENGINE_DEBUG('Before Calling Custom Sourcing Package ----------');
3154: END IF;
3155: Begin
3156: qp_debug_util.tstart('GET_CUSTOM_ATTRIBUTE_VALUES','Calling the QP_CUSTOM_SOURCE package to fetch the cutom attribute values');
3157: Qp_Custom_Source.Get_Custom_Attribute_Values(p_req_type_code => p_request_type_code,

Line 3168: Qp_Preq_Grp.ENGINE_DEBUG('After Calling Custom Sourcing Package ----------');

3164: qp_debug_util.tstop('GET_CUSTOM_ATTRIBUTE_VALUES');
3165: end;
3166:
3167: IF l_debug = Fnd_Api.G_TRUE THEN
3168: Qp_Preq_Grp.ENGINE_DEBUG('After Calling Custom Sourcing Package ----------');
3169:
3170: Qp_Preq_Grp.ENGINE_DEBUG('Number of qual attrs got from Get_Custom_Attribute_Values - ' || v_qual_contexts_result_tbl.COUNT );
3171: Qp_Preq_Grp.ENGINE_DEBUG('Number of pricing attrs got from Get_Custom_Attribute_Values - ' || v_price_contexts_result_tbl.COUNT );
3172:

Line 3170: Qp_Preq_Grp.ENGINE_DEBUG('Number of qual attrs got from Get_Custom_Attribute_Values - ' || v_qual_contexts_result_tbl.COUNT );

3166:
3167: IF l_debug = Fnd_Api.G_TRUE THEN
3168: Qp_Preq_Grp.ENGINE_DEBUG('After Calling Custom Sourcing Package ----------');
3169:
3170: Qp_Preq_Grp.ENGINE_DEBUG('Number of qual attrs got from Get_Custom_Attribute_Values - ' || v_qual_contexts_result_tbl.COUNT );
3171: Qp_Preq_Grp.ENGINE_DEBUG('Number of pricing attrs got from Get_Custom_Attribute_Values - ' || v_price_contexts_result_tbl.COUNT );
3172:
3173: END IF;
3174: l_count := l_qual_contexts_result_tbl.COUNT;

Line 3171: Qp_Preq_Grp.ENGINE_DEBUG('Number of pricing attrs got from Get_Custom_Attribute_Values - ' || v_price_contexts_result_tbl.COUNT );

3167: IF l_debug = Fnd_Api.G_TRUE THEN
3168: Qp_Preq_Grp.ENGINE_DEBUG('After Calling Custom Sourcing Package ----------');
3169:
3170: Qp_Preq_Grp.ENGINE_DEBUG('Number of qual attrs got from Get_Custom_Attribute_Values - ' || v_qual_contexts_result_tbl.COUNT );
3171: Qp_Preq_Grp.ENGINE_DEBUG('Number of pricing attrs got from Get_Custom_Attribute_Values - ' || v_price_contexts_result_tbl.COUNT );
3172:
3173: END IF;
3174: l_count := l_qual_contexts_result_tbl.COUNT;
3175:

Line 3360: Qp_Preq_Grp.ENGINE_DEBUG('Printing line attributes ----------');

3356: END IF;
3357:
3358: IF l_debug = Fnd_Api.G_TRUE THEN
3359:
3360: Qp_Preq_Grp.ENGINE_DEBUG('Printing line attributes ----------');
3361: FOR i IN 1..l_line_index_tbl.COUNT
3362: LOOP
3363: IF l_debug = Fnd_Api.G_TRUE THEN
3364: Qp_Preq_Grp.ENGINE_DEBUG('line index '||l_line_index_tbl(i));

Line 3364: Qp_Preq_Grp.ENGINE_DEBUG('line index '||l_line_index_tbl(i));

3360: Qp_Preq_Grp.ENGINE_DEBUG('Printing line attributes ----------');
3361: FOR i IN 1..l_line_index_tbl.COUNT
3362: LOOP
3363: IF l_debug = Fnd_Api.G_TRUE THEN
3364: Qp_Preq_Grp.ENGINE_DEBUG('line index '||l_line_index_tbl(i));
3365: Qp_Preq_Grp.ENGINE_DEBUG('attribute type '||l_attribute_type_tbl(i));
3366: Qp_Preq_Grp.ENGINE_DEBUG('context '||l_context_tbl(i));
3367: Qp_Preq_Grp.ENGINE_DEBUG('attribute '||l_attribute_tbl(i));
3368: Qp_Preq_Grp.ENGINE_DEBUG('value from '||l_value_from_tbl(i));

Line 3365: Qp_Preq_Grp.ENGINE_DEBUG('attribute type '||l_attribute_type_tbl(i));

3361: FOR i IN 1..l_line_index_tbl.COUNT
3362: LOOP
3363: IF l_debug = Fnd_Api.G_TRUE THEN
3364: Qp_Preq_Grp.ENGINE_DEBUG('line index '||l_line_index_tbl(i));
3365: Qp_Preq_Grp.ENGINE_DEBUG('attribute type '||l_attribute_type_tbl(i));
3366: Qp_Preq_Grp.ENGINE_DEBUG('context '||l_context_tbl(i));
3367: Qp_Preq_Grp.ENGINE_DEBUG('attribute '||l_attribute_tbl(i));
3368: Qp_Preq_Grp.ENGINE_DEBUG('value from '||l_value_from_tbl(i));
3369: Qp_Preq_Grp.ENGINE_DEBUG('validated flag '||l_validated_flag_tbl(i));

Line 3366: Qp_Preq_Grp.ENGINE_DEBUG('context '||l_context_tbl(i));

3362: LOOP
3363: IF l_debug = Fnd_Api.G_TRUE THEN
3364: Qp_Preq_Grp.ENGINE_DEBUG('line index '||l_line_index_tbl(i));
3365: Qp_Preq_Grp.ENGINE_DEBUG('attribute type '||l_attribute_type_tbl(i));
3366: Qp_Preq_Grp.ENGINE_DEBUG('context '||l_context_tbl(i));
3367: Qp_Preq_Grp.ENGINE_DEBUG('attribute '||l_attribute_tbl(i));
3368: Qp_Preq_Grp.ENGINE_DEBUG('value from '||l_value_from_tbl(i));
3369: Qp_Preq_Grp.ENGINE_DEBUG('validated flag '||l_validated_flag_tbl(i));
3370: Qp_Preq_Grp.ENGINE_DEBUG('-----------------------------------------');

Line 3367: Qp_Preq_Grp.ENGINE_DEBUG('attribute '||l_attribute_tbl(i));

3363: IF l_debug = Fnd_Api.G_TRUE THEN
3364: Qp_Preq_Grp.ENGINE_DEBUG('line index '||l_line_index_tbl(i));
3365: Qp_Preq_Grp.ENGINE_DEBUG('attribute type '||l_attribute_type_tbl(i));
3366: Qp_Preq_Grp.ENGINE_DEBUG('context '||l_context_tbl(i));
3367: Qp_Preq_Grp.ENGINE_DEBUG('attribute '||l_attribute_tbl(i));
3368: Qp_Preq_Grp.ENGINE_DEBUG('value from '||l_value_from_tbl(i));
3369: Qp_Preq_Grp.ENGINE_DEBUG('validated flag '||l_validated_flag_tbl(i));
3370: Qp_Preq_Grp.ENGINE_DEBUG('-----------------------------------------');
3371: END IF;

Line 3368: Qp_Preq_Grp.ENGINE_DEBUG('value from '||l_value_from_tbl(i));

3364: Qp_Preq_Grp.ENGINE_DEBUG('line index '||l_line_index_tbl(i));
3365: Qp_Preq_Grp.ENGINE_DEBUG('attribute type '||l_attribute_type_tbl(i));
3366: Qp_Preq_Grp.ENGINE_DEBUG('context '||l_context_tbl(i));
3367: Qp_Preq_Grp.ENGINE_DEBUG('attribute '||l_attribute_tbl(i));
3368: Qp_Preq_Grp.ENGINE_DEBUG('value from '||l_value_from_tbl(i));
3369: Qp_Preq_Grp.ENGINE_DEBUG('validated flag '||l_validated_flag_tbl(i));
3370: Qp_Preq_Grp.ENGINE_DEBUG('-----------------------------------------');
3371: END IF;
3372: END LOOP;

Line 3369: Qp_Preq_Grp.ENGINE_DEBUG('validated flag '||l_validated_flag_tbl(i));

3365: Qp_Preq_Grp.ENGINE_DEBUG('attribute type '||l_attribute_type_tbl(i));
3366: Qp_Preq_Grp.ENGINE_DEBUG('context '||l_context_tbl(i));
3367: Qp_Preq_Grp.ENGINE_DEBUG('attribute '||l_attribute_tbl(i));
3368: Qp_Preq_Grp.ENGINE_DEBUG('value from '||l_value_from_tbl(i));
3369: Qp_Preq_Grp.ENGINE_DEBUG('validated flag '||l_validated_flag_tbl(i));
3370: Qp_Preq_Grp.ENGINE_DEBUG('-----------------------------------------');
3371: END IF;
3372: END LOOP;
3373: END IF; --debug true

Line 3370: Qp_Preq_Grp.ENGINE_DEBUG('-----------------------------------------');

3366: Qp_Preq_Grp.ENGINE_DEBUG('context '||l_context_tbl(i));
3367: Qp_Preq_Grp.ENGINE_DEBUG('attribute '||l_attribute_tbl(i));
3368: Qp_Preq_Grp.ENGINE_DEBUG('value from '||l_value_from_tbl(i));
3369: Qp_Preq_Grp.ENGINE_DEBUG('validated flag '||l_validated_flag_tbl(i));
3370: Qp_Preq_Grp.ENGINE_DEBUG('-----------------------------------------');
3371: END IF;
3372: END LOOP;
3373: END IF; --debug true
3374:

Line 3380: Qp_Preq_Grp.ENGINE_DEBUG('Tata Inserting line attributes ----------');

3376: IF l_line_index_tbl.COUNT > 0
3377: THEN
3378: BEGIN
3379: IF l_debug = Fnd_Api.G_TRUE THEN
3380: Qp_Preq_Grp.ENGINE_DEBUG('Tata Inserting line attributes ----------');
3381: END IF;
3382:
3383: IF Qp_Java_Engine_Util_Pub.Java_Engine_Running = 'N' THEN
3384: IF l_debug = Fnd_Api.G_TRUE THEN

Line 3385: Qp_Preq_Grp.ENGINE_DEBUG('Java Engine not Installed ----------');

3381: END IF;
3382:
3383: IF Qp_Java_Engine_Util_Pub.Java_Engine_Running = 'N' THEN
3384: IF l_debug = Fnd_Api.G_TRUE THEN
3385: Qp_Preq_Grp.ENGINE_DEBUG('Java Engine not Installed ----------');
3386: END IF;
3387:
3388: FORALL i IN l_line_index_tbl.FIRST..l_line_index_tbl.LAST
3389: INSERT INTO qp_npreq_line_attrs_tmp

Line 3414: Qp_Preq_Grp.ENGINE_DEBUG('Java Engine Installed path----------');

3410: Qp_Preq_Pub.G_YES
3411: );
3412: ELSE -- Java Engine path added by yangli
3413: IF l_debug = Fnd_Api.G_TRUE THEN
3414: Qp_Preq_Grp.ENGINE_DEBUG('Java Engine Installed path----------');
3415: END IF;
3416: /*QP_PREQ_GRP.INSERT_LINE_ATTRS_AT( l_line_index_tbl,
3417: QP_PREQ_PUB.G_LINE_LEVEL,
3418: l_attribute_type_tbl,

Line 3416: /*QP_PREQ_GRP.INSERT_LINE_ATTRS_AT( l_line_index_tbl,

3412: ELSE -- Java Engine path added by yangli
3413: IF l_debug = Fnd_Api.G_TRUE THEN
3414: Qp_Preq_Grp.ENGINE_DEBUG('Java Engine Installed path----------');
3415: END IF;
3416: /*QP_PREQ_GRP.INSERT_LINE_ATTRS_AT( l_line_index_tbl,
3417: QP_PREQ_PUB.G_LINE_LEVEL,
3418: l_attribute_type_tbl,
3419: l_context_tbl,
3420: l_attribute_tbl,

Line 3437: Qp_Preq_Grp.INSERT_LINE_ATTRS2 ( p_LINE_INDEX_tbl => l_line_index_tbl,

3433: l_LINE_DETAIL_INDEX_tbl (i) := NULL;
3434: l_value_to_tbl (i) := NULL;
3435: END LOOP;
3436:
3437: Qp_Preq_Grp.INSERT_LINE_ATTRS2 ( p_LINE_INDEX_tbl => l_line_index_tbl,
3438: p_LINE_DETAIL_INDEX_tbl => l_line_Detail_index_tbl,
3439: p_ATTRIBUTE_LEVEL_tbl=> l_ATTRIBUTE_LEVEL_tbl,
3440: p_ATTRIBUTE_TYPE_tbl => l_attribute_type_tbl,
3441: p_LIST_HEADER_ID_tbl=> l_LIST_HEADER_ID_tbl,

Line 3475: Qp_Preq_Grp.ENGINE_DEBUG('End Inserting line attributes ----------');

3471: END IF;
3472: END IF;
3473:
3474: IF l_debug = Fnd_Api.G_TRUE THEN
3475: Qp_Preq_Grp.ENGINE_DEBUG('End Inserting line attributes ----------');
3476: END IF;
3477: EXCEPTION
3478: WHEN E_ROUTINE_ERRORS THEN
3479: IF l_debug = Fnd_Api.G_TRUE THEN

Line 3480: Qp_Preq_Grp.engine_debug('QP_ATTR_MAPPING_PUB:Bld Contxt Insert LINE_ATTR '||''||l_status_text);

3476: END IF;
3477: EXCEPTION
3478: WHEN E_ROUTINE_ERRORS THEN
3479: IF l_debug = Fnd_Api.G_TRUE THEN
3480: Qp_Preq_Grp.engine_debug('QP_ATTR_MAPPING_PUB:Bld Contxt Insert LINE_ATTR '||''||l_status_text);
3481: END IF;
3482: WHEN OTHERS THEN
3483: IF l_debug = Fnd_Api.G_TRUE THEN
3484: Qp_Preq_Grp.engine_debug('QP_ATTR_MAPPING_PUB:Bld Contxt Insert LINE_ATTR '||' '||SQLERRM);

Line 3484: Qp_Preq_Grp.engine_debug('QP_ATTR_MAPPING_PUB:Bld Contxt Insert LINE_ATTR '||' '||SQLERRM);

3480: Qp_Preq_Grp.engine_debug('QP_ATTR_MAPPING_PUB:Bld Contxt Insert LINE_ATTR '||''||l_status_text);
3481: END IF;
3482: WHEN OTHERS THEN
3483: IF l_debug = Fnd_Api.G_TRUE THEN
3484: Qp_Preq_Grp.engine_debug('QP_ATTR_MAPPING_PUB:Bld Contxt Insert LINE_ATTR '||' '||SQLERRM);
3485: END IF;
3486: END;
3487:
3488: END IF;

Line 3491: Qp_Preq_Grp.ENGINE_DEBUG('End Build contexts');

3487:
3488: END IF;
3489:
3490: IF l_debug = Fnd_Api.G_TRUE THEN
3491: Qp_Preq_Grp.ENGINE_DEBUG('End Build contexts');
3492:
3493: END IF;
3494: --setting time
3495: l_sourcing_end_time := dbms_utility.get_time;

Line 3505: Qp_Preq_Grp.ENGINE_DEBUG('Exception in QP_ATTR_MAPPING_PUB.Build_context '||SQLERRM);

3501: END IF;
3502: EXCEPTION
3503: WHEN OTHERS THEN
3504: IF l_debug = Fnd_Api.G_TRUE THEN
3505: Qp_Preq_Grp.ENGINE_DEBUG('Exception in QP_ATTR_MAPPING_PUB.Build_context '||SQLERRM);
3506:
3507: END IF;
3508: END Build_Contexts;
3509:

Line 3569: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;

3565: qppteseg.user_sourcing_method = 'USER ENTERED';
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

Line 3746: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;

3742: qppteseg.user_sourcing_method = 'USER ENTERED';
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

Line 3924: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;

3920: qpptereq.pte_code = qppteseg.pte_code AND
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

Line 4051: --l_prod_exists_tbl QP_PREQ_GRP.FLAG_TYPE;

4047: **********Changed lines API pass only dependent lines*********************
4048: *************************************************************************/
4049:
4050: PROCEDURE Check_line_group_items(p_pricing_type_code IN VARCHAR2) IS
4051: --l_prod_exists_tbl QP_PREQ_GRP.FLAG_TYPE;
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

Line 4055: l_request_type_code VARCHAR2(10):=QP_PREQ_GRP.g_request_type_code; -- 10120089

4051: --l_prod_exists_tbl QP_PREQ_GRP.FLAG_TYPE;
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