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 292: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;

288: AND TYPE = DECODE(p_pkg_type,'SPEC','PACKAGE',
289: 'BODY','PACKAGE BODY');
290: BEGIN
291:
292: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;
293: -- end statement.
294: Text('END '||p_pkg_name||';',0);
295:
296: -- Show errors.

Line 684: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;

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

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

980: --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');
981: Text('Loop');
982: Text ('If QP_BULK_PREQ_GRP.G_LINE_REC.header_id(i) IS NOT NULL Then',2);
983: Text ('If QP_BULK_PREQ_GRP.G_LINE_REC.header_id(i) = prev_header_id Then', 3);
984: Text ('QP_PREQ_GRP.G_NEW_PRICING_CALL := ''N'';', 4);
985: Text ('Else', 3);
986: Text ('QP_PREQ_GRP.G_NEW_PRICING_CALL := ''Y'';',4);
987: Text ('prev_header_id := QP_BULK_PREQ_GRP.G_LINE_REC.header_id(i);', 4);
988: Text ('End If;', 3);

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

982: Text ('If QP_BULK_PREQ_GRP.G_LINE_REC.header_id(i) IS NOT NULL Then',2);
983: Text ('If QP_BULK_PREQ_GRP.G_LINE_REC.header_id(i) = prev_header_id Then', 3);
984: Text ('QP_PREQ_GRP.G_NEW_PRICING_CALL := ''N'';', 4);
985: Text ('Else', 3);
986: Text ('QP_PREQ_GRP.G_NEW_PRICING_CALL := ''Y'';',4);
987: Text ('prev_header_id := QP_BULK_PREQ_GRP.G_LINE_REC.header_id(i);', 4);
988: Text ('End If;', 3);
989: Text ('Else', 2);
990: Text ('If QP_PREQ_GRP.G_NEW_PRICING_CALL = ''Y'' Then',3);

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

986: Text ('QP_PREQ_GRP.G_NEW_PRICING_CALL := ''Y'';',4);
987: Text ('prev_header_id := QP_BULK_PREQ_GRP.G_LINE_REC.header_id(i);', 4);
988: Text ('End If;', 3);
989: Text ('Else', 2);
990: Text ('If QP_PREQ_GRP.G_NEW_PRICING_CALL = ''Y'' Then',3);
991: Text ('QP_PREQ_GRP.G_NEW_PRICING_CALL := ''N'';', 4);
992: Text ('End If;', 3);
993: Text ('End If;' , 2);
994: ELSE

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

987: Text ('prev_header_id := QP_BULK_PREQ_GRP.G_LINE_REC.header_id(i);', 4);
988: Text ('End If;', 3);
989: Text ('Else', 2);
990: Text ('If QP_PREQ_GRP.G_NEW_PRICING_CALL = ''Y'' Then',3);
991: Text ('QP_PREQ_GRP.G_NEW_PRICING_CALL := ''N'';', 4);
992: Text ('End If;', 3);
993: Text ('End If;' , 2);
994: ELSE
995: Text('FOR i in QP_BULK_PREQ_GRP.G_HEADER_REC.header_id.first..QP_BULK_

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

1633: Text ('--oe_debug_pub.add (''this_header_id: ''|| nvl(QP_BULK_PREQ_GRP.G_LINE_REC.header_id(i),0));');
1634: Text ('If QP_BULK_PREQ_GRP.G_LINE_REC.header_id(i) IS NOT NULL Then',2
1635: );
1636: Text ('If QP_BULK_PREQ_GRP.G_LINE_REC.header_id(i) = prev_header_id Then', 3);
1637: Text ('QP_PREQ_GRP.G_NEW_PRICING_CALL := ''N'';', 4);
1638: Text ('Else', 3);
1639: Text ('QP_PREQ_GRP.G_NEW_PRICING_CALL := ''Y'';',4);
1640: Text ('prev_header_id := QP_BULK_PREQ_GRP.G_LINE_REC.header_id(i);');
1641: Text ('End If;', 3);

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

1635: );
1636: Text ('If QP_BULK_PREQ_GRP.G_LINE_REC.header_id(i) = prev_header_id Then', 3);
1637: Text ('QP_PREQ_GRP.G_NEW_PRICING_CALL := ''N'';', 4);
1638: Text ('Else', 3);
1639: Text ('QP_PREQ_GRP.G_NEW_PRICING_CALL := ''Y'';',4);
1640: Text ('prev_header_id := QP_BULK_PREQ_GRP.G_LINE_REC.header_id(i);');
1641: Text ('End If;', 3);
1642: Text ('Else', 2);
1643: Text ('If QP_PREQ_GRP.G_NEW_PRICING_CALL = ''Y'' Then',3);

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

1639: Text ('QP_PREQ_GRP.G_NEW_PRICING_CALL := ''Y'';',4);
1640: Text ('prev_header_id := QP_BULK_PREQ_GRP.G_LINE_REC.header_id(i);');
1641: Text ('End If;', 3);
1642: Text ('Else', 2);
1643: Text ('If QP_PREQ_GRP.G_NEW_PRICING_CALL = ''Y'' Then',3);
1644: Text ('QP_PREQ_GRP.G_NEW_PRICING_CALL := ''N'';', 4);
1645: Text ('--oe_debug_pub.add (''prev_header_id: ''|| prev_header_id);');
1646: Text ('End If;', 3);
1647: Text ('End If;' , 2);

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

1640: Text ('prev_header_id := QP_BULK_PREQ_GRP.G_LINE_REC.header_id(i);');
1641: Text ('End If;', 3);
1642: Text ('Else', 2);
1643: Text ('If QP_PREQ_GRP.G_NEW_PRICING_CALL = ''Y'' Then',3);
1644: Text ('QP_PREQ_GRP.G_NEW_PRICING_CALL := ''N'';', 4);
1645: Text ('--oe_debug_pub.add (''prev_header_id: ''|| prev_header_id);');
1646: Text ('End If;', 3);
1647: Text ('End If;' , 2);
1648: ELSE

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

2038:
2039: BEGIN
2040:
2041: --dbms_output.put_line('............1............');
2042: --l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
2043: IF l_debug = Fnd_Api.G_TRUE THEN
2044: Oe_Debug_Pub.ADD('##### Begin Build Sourcing #####');
2045:
2046: END IF;

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

2076: Text('BEGIN',0);
2077: Text('qp_debug_util.tstart(''FETCH_ATTRIBUTES'',''Fetching the Attribute Values'');',0);
2078: New_Line;
2079:
2080: Text('l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;',1);
2081:
2082: -- added for g_new_pricing_call for caching - hwong
2083: text('if p_pricing_type_code = ''H'' and qp_preq_grp.g_new_pricing_call = qp_preq_grp.g_no then', 0);
2084: text('qp_preq_grp.g_new_pricing_call := qp_preq_grp.g_yes;', 1);

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

2079:
2080: Text('l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;',1);
2081:
2082: -- added for g_new_pricing_call for caching - hwong
2083: text('if p_pricing_type_code = ''H'' and qp_preq_grp.g_new_pricing_call = qp_preq_grp.g_no then', 0);
2084: text('qp_preq_grp.g_new_pricing_call := qp_preq_grp.g_yes;', 1);
2085: Text('IF l_debug = FND_API.G_TRUE THEN',1);
2086: text('oe_debug_pub.add(''hw/src/H: change to g_yes'');',2);
2087: Text('END IF;',1);

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

2080: Text('l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;',1);
2081:
2082: -- added for g_new_pricing_call for caching - hwong
2083: text('if p_pricing_type_code = ''H'' and qp_preq_grp.g_new_pricing_call = qp_preq_grp.g_no then', 0);
2084: text('qp_preq_grp.g_new_pricing_call := qp_preq_grp.g_yes;', 1);
2085: Text('IF l_debug = FND_API.G_TRUE THEN',1);
2086: text('oe_debug_pub.add(''hw/src/H: change to g_yes'');',2);
2087: Text('END IF;',1);
2088: text('end if;', 0);

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

2124:
2125: -- added for g_new_pricing_call for caching - hwong
2126: new_line;
2127: Text ('If QP_Util_PUB.HVOP_Pricing_On= ''N'' Then');
2128: text('if p_pricing_type_code = ''L'' and qp_preq_grp.g_new_pricing_call = qp_preq_grp.g_yes then', 1);
2129: text('qp_preq_grp.g_new_pricing_call := qp_preq_grp.g_no;', 2);
2130: Text('IF l_debug = FND_API.G_TRUE THEN',2);
2131: text('oe_debug_pub.add(''hw/src/L: change to g_no'');',3);
2132: Text('END IF;',2);

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

2125: -- added for g_new_pricing_call for caching - hwong
2126: new_line;
2127: Text ('If QP_Util_PUB.HVOP_Pricing_On= ''N'' Then');
2128: text('if p_pricing_type_code = ''L'' and qp_preq_grp.g_new_pricing_call = qp_preq_grp.g_yes then', 1);
2129: text('qp_preq_grp.g_new_pricing_call := qp_preq_grp.g_no;', 2);
2130: Text('IF l_debug = FND_API.G_TRUE THEN',2);
2131: text('oe_debug_pub.add(''hw/src/L: change to g_no'');',3);
2132: Text('END IF;',2);
2133: text('end if;', 1);

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

2175:
2176: -- added for g_new_pricing_call for caching - hwong
2177: new_line;
2178: Text ('If QP_Util_PUB.HVOP_Pricing_On = ''N'' Then',1);
2179: text('if p_pricing_type_code = ''L'' and qp_preq_grp.g_new_pricing_call = qp_preq_grp.g_yes then', 2);
2180: text('qp_preq_grp.g_new_pricing_call := qp_preq_grp.g_no;', 3);
2181: Text('IF l_debug = FND_API.G_TRUE THEN',3);
2182: text('oe_debug_pub.add(''hw/src/L: change to g_no'');',4);
2183: Text('END IF;',3);

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

2176: -- added for g_new_pricing_call for caching - hwong
2177: new_line;
2178: Text ('If QP_Util_PUB.HVOP_Pricing_On = ''N'' Then',1);
2179: text('if p_pricing_type_code = ''L'' and qp_preq_grp.g_new_pricing_call = qp_preq_grp.g_yes then', 2);
2180: text('qp_preq_grp.g_new_pricing_call := qp_preq_grp.g_no;', 3);
2181: Text('IF l_debug = FND_API.G_TRUE THEN',3);
2182: text('oe_debug_pub.add(''hw/src/L: change to g_no'');',4);
2183: Text('END IF;',3);
2184: text('end if;', 2);

Line 2289: Qp_Preq_Grp.Set_QP_Debug;

2285:
2286: BEGIN
2287:
2288: -- Set the global variable G_DEBUG_ENGINE
2289: Qp_Preq_Grp.Set_QP_Debug;
2290:
2291: --added for MOAC
2292: --Set the Global variable G_ORG_ID
2293: G_ORG_ID := NVL(p_org_id, Qp_Util.get_org_id);

Line 2306: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;

2302: END IF;
2303: END IF;--MO_GLOBAL
2304:
2305:
2306: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;
2307:
2308: IF l_debug = Fnd_Api.G_TRUE THEN
2309: Oe_Debug_Pub.ADD('##### Begin Build Contexts #####');
2310: END IF;

Line 2507: l_line_index_tbl Qp_Preq_Grp.PLS_INTEGER_TYPE;

2503:
2504: v_price_contexts_result_tbl CONTEXTS_RESULT_TBL_TYPE;
2505: v_qual_contexts_result_tbl CONTEXTS_RESULT_TBL_TYPE;
2506:
2507: l_line_index_tbl Qp_Preq_Grp.PLS_INTEGER_TYPE;
2508: l_line_detail_index_tbl Qp_Preq_Grp.PLS_INTEGER_TYPE;
2509: l_attribute_type_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2510: l_context_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2511: l_attribute_tbl Qp_Preq_Grp.VARCHAR_TYPE;

Line 2508: l_line_detail_index_tbl Qp_Preq_Grp.PLS_INTEGER_TYPE;

2504: v_price_contexts_result_tbl CONTEXTS_RESULT_TBL_TYPE;
2505: v_qual_contexts_result_tbl CONTEXTS_RESULT_TBL_TYPE;
2506:
2507: l_line_index_tbl Qp_Preq_Grp.PLS_INTEGER_TYPE;
2508: l_line_detail_index_tbl Qp_Preq_Grp.PLS_INTEGER_TYPE;
2509: l_attribute_type_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2510: l_context_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2511: l_attribute_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2512: l_value_from_tbl Qp_Preq_Grp.VARCHAR_TYPE;

Line 2509: l_attribute_type_tbl Qp_Preq_Grp.VARCHAR_TYPE;

2505: v_qual_contexts_result_tbl CONTEXTS_RESULT_TBL_TYPE;
2506:
2507: l_line_index_tbl Qp_Preq_Grp.PLS_INTEGER_TYPE;
2508: l_line_detail_index_tbl Qp_Preq_Grp.PLS_INTEGER_TYPE;
2509: l_attribute_type_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2510: l_context_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2511: l_attribute_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2512: l_value_from_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2513: l_value_to_tbl Qp_Preq_Grp.VARCHAR_TYPE;

Line 2510: l_context_tbl Qp_Preq_Grp.VARCHAR_TYPE;

2506:
2507: l_line_index_tbl Qp_Preq_Grp.PLS_INTEGER_TYPE;
2508: l_line_detail_index_tbl Qp_Preq_Grp.PLS_INTEGER_TYPE;
2509: l_attribute_type_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2510: l_context_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2511: l_attribute_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2512: l_value_from_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2513: l_value_to_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2514: l_validated_flag_tbl Qp_Preq_Grp.VARCHAR_TYPE;

Line 2511: l_attribute_tbl Qp_Preq_Grp.VARCHAR_TYPE;

2507: l_line_index_tbl Qp_Preq_Grp.PLS_INTEGER_TYPE;
2508: l_line_detail_index_tbl Qp_Preq_Grp.PLS_INTEGER_TYPE;
2509: l_attribute_type_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2510: l_context_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2511: l_attribute_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2512: l_value_from_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2513: l_value_to_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2514: l_validated_flag_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2515: l_ATTRIBUTE_LEVEL_tbl Qp_Preq_Grp.varchar_type;

Line 2512: l_value_from_tbl Qp_Preq_Grp.VARCHAR_TYPE;

2508: l_line_detail_index_tbl Qp_Preq_Grp.PLS_INTEGER_TYPE;
2509: l_attribute_type_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2510: l_context_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2511: l_attribute_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2512: l_value_from_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2513: l_value_to_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2514: l_validated_flag_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2515: l_ATTRIBUTE_LEVEL_tbl Qp_Preq_Grp.varchar_type;
2516: l_LIST_HEADER_ID_tbl Qp_Preq_Grp.number_type;

Line 2513: l_value_to_tbl Qp_Preq_Grp.VARCHAR_TYPE;

2509: l_attribute_type_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2510: l_context_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2511: l_attribute_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2512: l_value_from_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2513: l_value_to_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2514: l_validated_flag_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2515: l_ATTRIBUTE_LEVEL_tbl Qp_Preq_Grp.varchar_type;
2516: l_LIST_HEADER_ID_tbl Qp_Preq_Grp.number_type;
2517: l_LIST_LINE_ID_tbl Qp_Preq_Grp.number_type;

Line 2514: l_validated_flag_tbl Qp_Preq_Grp.VARCHAR_TYPE;

2510: l_context_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2511: l_attribute_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2512: l_value_from_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2513: l_value_to_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2514: l_validated_flag_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2515: l_ATTRIBUTE_LEVEL_tbl Qp_Preq_Grp.varchar_type;
2516: l_LIST_HEADER_ID_tbl Qp_Preq_Grp.number_type;
2517: l_LIST_LINE_ID_tbl Qp_Preq_Grp.number_type;
2518: l_SETUP_VALUE_FROM_tbl Qp_Preq_Grp.varchar_type;

Line 2515: l_ATTRIBUTE_LEVEL_tbl Qp_Preq_Grp.varchar_type;

2511: l_attribute_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2512: l_value_from_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2513: l_value_to_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2514: l_validated_flag_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2515: l_ATTRIBUTE_LEVEL_tbl Qp_Preq_Grp.varchar_type;
2516: l_LIST_HEADER_ID_tbl Qp_Preq_Grp.number_type;
2517: l_LIST_LINE_ID_tbl Qp_Preq_Grp.number_type;
2518: l_SETUP_VALUE_FROM_tbl Qp_Preq_Grp.varchar_type;
2519: l_SETUP_VALUE_TO_tbl Qp_Preq_Grp.varchar_type;

Line 2516: l_LIST_HEADER_ID_tbl Qp_Preq_Grp.number_type;

2512: l_value_from_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2513: l_value_to_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2514: l_validated_flag_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2515: l_ATTRIBUTE_LEVEL_tbl Qp_Preq_Grp.varchar_type;
2516: l_LIST_HEADER_ID_tbl Qp_Preq_Grp.number_type;
2517: l_LIST_LINE_ID_tbl Qp_Preq_Grp.number_type;
2518: l_SETUP_VALUE_FROM_tbl Qp_Preq_Grp.varchar_type;
2519: l_SETUP_VALUE_TO_tbl Qp_Preq_Grp.varchar_type;
2520: l_GROUPING_NUMBER_tbl Qp_Preq_Grp.pls_integer_type;

Line 2517: l_LIST_LINE_ID_tbl Qp_Preq_Grp.number_type;

2513: l_value_to_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2514: l_validated_flag_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2515: l_ATTRIBUTE_LEVEL_tbl Qp_Preq_Grp.varchar_type;
2516: l_LIST_HEADER_ID_tbl Qp_Preq_Grp.number_type;
2517: l_LIST_LINE_ID_tbl Qp_Preq_Grp.number_type;
2518: l_SETUP_VALUE_FROM_tbl Qp_Preq_Grp.varchar_type;
2519: l_SETUP_VALUE_TO_tbl Qp_Preq_Grp.varchar_type;
2520: l_GROUPING_NUMBER_tbl Qp_Preq_Grp.pls_integer_type;
2521: l_NO_QUALIFIERS_IN_GRP_tbl Qp_Preq_Grp.pls_integer_type;

Line 2518: l_SETUP_VALUE_FROM_tbl Qp_Preq_Grp.varchar_type;

2514: l_validated_flag_tbl Qp_Preq_Grp.VARCHAR_TYPE;
2515: l_ATTRIBUTE_LEVEL_tbl Qp_Preq_Grp.varchar_type;
2516: l_LIST_HEADER_ID_tbl Qp_Preq_Grp.number_type;
2517: l_LIST_LINE_ID_tbl Qp_Preq_Grp.number_type;
2518: l_SETUP_VALUE_FROM_tbl Qp_Preq_Grp.varchar_type;
2519: l_SETUP_VALUE_TO_tbl Qp_Preq_Grp.varchar_type;
2520: l_GROUPING_NUMBER_tbl Qp_Preq_Grp.pls_integer_type;
2521: l_NO_QUALIFIERS_IN_GRP_tbl Qp_Preq_Grp.pls_integer_type;
2522: l_COMPARISON_OPERATOR_TYPE_tbl Qp_Preq_Grp.varchar_type;

Line 2519: l_SETUP_VALUE_TO_tbl Qp_Preq_Grp.varchar_type;

2515: l_ATTRIBUTE_LEVEL_tbl Qp_Preq_Grp.varchar_type;
2516: l_LIST_HEADER_ID_tbl Qp_Preq_Grp.number_type;
2517: l_LIST_LINE_ID_tbl Qp_Preq_Grp.number_type;
2518: l_SETUP_VALUE_FROM_tbl Qp_Preq_Grp.varchar_type;
2519: l_SETUP_VALUE_TO_tbl Qp_Preq_Grp.varchar_type;
2520: l_GROUPING_NUMBER_tbl Qp_Preq_Grp.pls_integer_type;
2521: l_NO_QUALIFIERS_IN_GRP_tbl Qp_Preq_Grp.pls_integer_type;
2522: l_COMPARISON_OPERATOR_TYPE_tbl Qp_Preq_Grp.varchar_type;
2523: l_APPLIED_FLAG_tbl Qp_Preq_Grp.varchar_type;

Line 2520: l_GROUPING_NUMBER_tbl Qp_Preq_Grp.pls_integer_type;

2516: l_LIST_HEADER_ID_tbl Qp_Preq_Grp.number_type;
2517: l_LIST_LINE_ID_tbl Qp_Preq_Grp.number_type;
2518: l_SETUP_VALUE_FROM_tbl Qp_Preq_Grp.varchar_type;
2519: l_SETUP_VALUE_TO_tbl Qp_Preq_Grp.varchar_type;
2520: l_GROUPING_NUMBER_tbl Qp_Preq_Grp.pls_integer_type;
2521: l_NO_QUALIFIERS_IN_GRP_tbl Qp_Preq_Grp.pls_integer_type;
2522: l_COMPARISON_OPERATOR_TYPE_tbl Qp_Preq_Grp.varchar_type;
2523: l_APPLIED_FLAG_tbl Qp_Preq_Grp.varchar_type;
2524: l_PRICING_STATUS_CODE_tbl Qp_Preq_Grp.varchar_type;

Line 2521: l_NO_QUALIFIERS_IN_GRP_tbl Qp_Preq_Grp.pls_integer_type;

2517: l_LIST_LINE_ID_tbl Qp_Preq_Grp.number_type;
2518: l_SETUP_VALUE_FROM_tbl Qp_Preq_Grp.varchar_type;
2519: l_SETUP_VALUE_TO_tbl Qp_Preq_Grp.varchar_type;
2520: l_GROUPING_NUMBER_tbl Qp_Preq_Grp.pls_integer_type;
2521: l_NO_QUALIFIERS_IN_GRP_tbl Qp_Preq_Grp.pls_integer_type;
2522: l_COMPARISON_OPERATOR_TYPE_tbl Qp_Preq_Grp.varchar_type;
2523: l_APPLIED_FLAG_tbl Qp_Preq_Grp.varchar_type;
2524: l_PRICING_STATUS_CODE_tbl Qp_Preq_Grp.varchar_type;
2525: l_PRICING_STATUS_TEXT_tbl Qp_Preq_Grp.varchar_type;

Line 2522: l_COMPARISON_OPERATOR_TYPE_tbl Qp_Preq_Grp.varchar_type;

2518: l_SETUP_VALUE_FROM_tbl Qp_Preq_Grp.varchar_type;
2519: l_SETUP_VALUE_TO_tbl Qp_Preq_Grp.varchar_type;
2520: l_GROUPING_NUMBER_tbl Qp_Preq_Grp.pls_integer_type;
2521: l_NO_QUALIFIERS_IN_GRP_tbl Qp_Preq_Grp.pls_integer_type;
2522: l_COMPARISON_OPERATOR_TYPE_tbl Qp_Preq_Grp.varchar_type;
2523: l_APPLIED_FLAG_tbl Qp_Preq_Grp.varchar_type;
2524: l_PRICING_STATUS_CODE_tbl Qp_Preq_Grp.varchar_type;
2525: l_PRICING_STATUS_TEXT_tbl Qp_Preq_Grp.varchar_type;
2526: l_QUALIFIER_PRECEDENCE_tbl Qp_Preq_Grp.pls_integer_type;

Line 2523: l_APPLIED_FLAG_tbl Qp_Preq_Grp.varchar_type;

2519: l_SETUP_VALUE_TO_tbl Qp_Preq_Grp.varchar_type;
2520: l_GROUPING_NUMBER_tbl Qp_Preq_Grp.pls_integer_type;
2521: l_NO_QUALIFIERS_IN_GRP_tbl Qp_Preq_Grp.pls_integer_type;
2522: l_COMPARISON_OPERATOR_TYPE_tbl Qp_Preq_Grp.varchar_type;
2523: l_APPLIED_FLAG_tbl Qp_Preq_Grp.varchar_type;
2524: l_PRICING_STATUS_CODE_tbl Qp_Preq_Grp.varchar_type;
2525: l_PRICING_STATUS_TEXT_tbl Qp_Preq_Grp.varchar_type;
2526: l_QUALIFIER_PRECEDENCE_tbl Qp_Preq_Grp.pls_integer_type;
2527: l_DATATYPE_tbl Qp_Preq_Grp.varchar_type;

Line 2524: l_PRICING_STATUS_CODE_tbl Qp_Preq_Grp.varchar_type;

2520: l_GROUPING_NUMBER_tbl Qp_Preq_Grp.pls_integer_type;
2521: l_NO_QUALIFIERS_IN_GRP_tbl Qp_Preq_Grp.pls_integer_type;
2522: l_COMPARISON_OPERATOR_TYPE_tbl Qp_Preq_Grp.varchar_type;
2523: l_APPLIED_FLAG_tbl Qp_Preq_Grp.varchar_type;
2524: l_PRICING_STATUS_CODE_tbl Qp_Preq_Grp.varchar_type;
2525: l_PRICING_STATUS_TEXT_tbl Qp_Preq_Grp.varchar_type;
2526: l_QUALIFIER_PRECEDENCE_tbl Qp_Preq_Grp.pls_integer_type;
2527: l_DATATYPE_tbl Qp_Preq_Grp.varchar_type;
2528: l_PRICING_ATTR_FLAG_tbl Qp_Preq_Grp.varchar_type;

Line 2525: l_PRICING_STATUS_TEXT_tbl Qp_Preq_Grp.varchar_type;

2521: l_NO_QUALIFIERS_IN_GRP_tbl Qp_Preq_Grp.pls_integer_type;
2522: l_COMPARISON_OPERATOR_TYPE_tbl Qp_Preq_Grp.varchar_type;
2523: l_APPLIED_FLAG_tbl Qp_Preq_Grp.varchar_type;
2524: l_PRICING_STATUS_CODE_tbl Qp_Preq_Grp.varchar_type;
2525: l_PRICING_STATUS_TEXT_tbl Qp_Preq_Grp.varchar_type;
2526: l_QUALIFIER_PRECEDENCE_tbl Qp_Preq_Grp.pls_integer_type;
2527: l_DATATYPE_tbl Qp_Preq_Grp.varchar_type;
2528: l_PRICING_ATTR_FLAG_tbl Qp_Preq_Grp.varchar_type;
2529: l_QUALIFIER_type_tbl Qp_Preq_Grp.varchar_type;

Line 2526: l_QUALIFIER_PRECEDENCE_tbl Qp_Preq_Grp.pls_integer_type;

2522: l_COMPARISON_OPERATOR_TYPE_tbl Qp_Preq_Grp.varchar_type;
2523: l_APPLIED_FLAG_tbl Qp_Preq_Grp.varchar_type;
2524: l_PRICING_STATUS_CODE_tbl Qp_Preq_Grp.varchar_type;
2525: l_PRICING_STATUS_TEXT_tbl Qp_Preq_Grp.varchar_type;
2526: l_QUALIFIER_PRECEDENCE_tbl Qp_Preq_Grp.pls_integer_type;
2527: l_DATATYPE_tbl Qp_Preq_Grp.varchar_type;
2528: l_PRICING_ATTR_FLAG_tbl Qp_Preq_Grp.varchar_type;
2529: l_QUALIFIER_type_tbl Qp_Preq_Grp.varchar_type;
2530: l_PRODUCT_UOM_CODE_TBL Qp_Preq_Grp.varchar_type;

Line 2527: l_DATATYPE_tbl Qp_Preq_Grp.varchar_type;

2523: l_APPLIED_FLAG_tbl Qp_Preq_Grp.varchar_type;
2524: l_PRICING_STATUS_CODE_tbl Qp_Preq_Grp.varchar_type;
2525: l_PRICING_STATUS_TEXT_tbl Qp_Preq_Grp.varchar_type;
2526: l_QUALIFIER_PRECEDENCE_tbl Qp_Preq_Grp.pls_integer_type;
2527: l_DATATYPE_tbl Qp_Preq_Grp.varchar_type;
2528: l_PRICING_ATTR_FLAG_tbl Qp_Preq_Grp.varchar_type;
2529: l_QUALIFIER_type_tbl Qp_Preq_Grp.varchar_type;
2530: l_PRODUCT_UOM_CODE_TBL Qp_Preq_Grp.varchar_type;
2531: l_EXCLUDER_FLAG_TBL Qp_Preq_Grp.varchar_type ;

Line 2528: l_PRICING_ATTR_FLAG_tbl Qp_Preq_Grp.varchar_type;

2524: l_PRICING_STATUS_CODE_tbl Qp_Preq_Grp.varchar_type;
2525: l_PRICING_STATUS_TEXT_tbl Qp_Preq_Grp.varchar_type;
2526: l_QUALIFIER_PRECEDENCE_tbl Qp_Preq_Grp.pls_integer_type;
2527: l_DATATYPE_tbl Qp_Preq_Grp.varchar_type;
2528: l_PRICING_ATTR_FLAG_tbl Qp_Preq_Grp.varchar_type;
2529: l_QUALIFIER_type_tbl Qp_Preq_Grp.varchar_type;
2530: l_PRODUCT_UOM_CODE_TBL Qp_Preq_Grp.varchar_type;
2531: l_EXCLUDER_FLAG_TBL Qp_Preq_Grp.varchar_type ;
2532: l_PRICING_PHASE_ID_TBL Qp_Preq_Grp.pls_integer_type ;

Line 2529: l_QUALIFIER_type_tbl Qp_Preq_Grp.varchar_type;

2525: l_PRICING_STATUS_TEXT_tbl Qp_Preq_Grp.varchar_type;
2526: l_QUALIFIER_PRECEDENCE_tbl Qp_Preq_Grp.pls_integer_type;
2527: l_DATATYPE_tbl Qp_Preq_Grp.varchar_type;
2528: l_PRICING_ATTR_FLAG_tbl Qp_Preq_Grp.varchar_type;
2529: l_QUALIFIER_type_tbl Qp_Preq_Grp.varchar_type;
2530: l_PRODUCT_UOM_CODE_TBL Qp_Preq_Grp.varchar_type;
2531: l_EXCLUDER_FLAG_TBL Qp_Preq_Grp.varchar_type ;
2532: l_PRICING_PHASE_ID_TBL Qp_Preq_Grp.pls_integer_type ;
2533: l_INCOMPATABILITY_GRP_CODE_TBL Qp_Preq_Grp.varchar_type ;

Line 2530: l_PRODUCT_UOM_CODE_TBL Qp_Preq_Grp.varchar_type;

2526: l_QUALIFIER_PRECEDENCE_tbl Qp_Preq_Grp.pls_integer_type;
2527: l_DATATYPE_tbl Qp_Preq_Grp.varchar_type;
2528: l_PRICING_ATTR_FLAG_tbl Qp_Preq_Grp.varchar_type;
2529: l_QUALIFIER_type_tbl Qp_Preq_Grp.varchar_type;
2530: l_PRODUCT_UOM_CODE_TBL Qp_Preq_Grp.varchar_type;
2531: l_EXCLUDER_FLAG_TBL Qp_Preq_Grp.varchar_type ;
2532: l_PRICING_PHASE_ID_TBL Qp_Preq_Grp.pls_integer_type ;
2533: l_INCOMPATABILITY_GRP_CODE_TBL Qp_Preq_Grp.varchar_type ;
2534: l_LINE_DETAIL_type_CODE_TBL Qp_Preq_Grp.varchar_type ;

Line 2531: l_EXCLUDER_FLAG_TBL Qp_Preq_Grp.varchar_type ;

2527: l_DATATYPE_tbl Qp_Preq_Grp.varchar_type;
2528: l_PRICING_ATTR_FLAG_tbl Qp_Preq_Grp.varchar_type;
2529: l_QUALIFIER_type_tbl Qp_Preq_Grp.varchar_type;
2530: l_PRODUCT_UOM_CODE_TBL Qp_Preq_Grp.varchar_type;
2531: l_EXCLUDER_FLAG_TBL Qp_Preq_Grp.varchar_type ;
2532: l_PRICING_PHASE_ID_TBL Qp_Preq_Grp.pls_integer_type ;
2533: l_INCOMPATABILITY_GRP_CODE_TBL Qp_Preq_Grp.varchar_type ;
2534: l_LINE_DETAIL_type_CODE_TBL Qp_Preq_Grp.varchar_type ;
2535: l_MODIFIER_LEVEL_CODE_TBL Qp_Preq_Grp.varchar_type ;

Line 2532: l_PRICING_PHASE_ID_TBL Qp_Preq_Grp.pls_integer_type ;

2528: l_PRICING_ATTR_FLAG_tbl Qp_Preq_Grp.varchar_type;
2529: l_QUALIFIER_type_tbl Qp_Preq_Grp.varchar_type;
2530: l_PRODUCT_UOM_CODE_TBL Qp_Preq_Grp.varchar_type;
2531: l_EXCLUDER_FLAG_TBL Qp_Preq_Grp.varchar_type ;
2532: l_PRICING_PHASE_ID_TBL Qp_Preq_Grp.pls_integer_type ;
2533: l_INCOMPATABILITY_GRP_CODE_TBL Qp_Preq_Grp.varchar_type ;
2534: l_LINE_DETAIL_type_CODE_TBL Qp_Preq_Grp.varchar_type ;
2535: l_MODIFIER_LEVEL_CODE_TBL Qp_Preq_Grp.varchar_type ;
2536: l_PRIMARY_UOM_FLAG_TBL Qp_Preq_Grp.varchar_type ;

Line 2533: l_INCOMPATABILITY_GRP_CODE_TBL Qp_Preq_Grp.varchar_type ;

2529: l_QUALIFIER_type_tbl Qp_Preq_Grp.varchar_type;
2530: l_PRODUCT_UOM_CODE_TBL Qp_Preq_Grp.varchar_type;
2531: l_EXCLUDER_FLAG_TBL Qp_Preq_Grp.varchar_type ;
2532: l_PRICING_PHASE_ID_TBL Qp_Preq_Grp.pls_integer_type ;
2533: l_INCOMPATABILITY_GRP_CODE_TBL Qp_Preq_Grp.varchar_type ;
2534: l_LINE_DETAIL_type_CODE_TBL Qp_Preq_Grp.varchar_type ;
2535: l_MODIFIER_LEVEL_CODE_TBL Qp_Preq_Grp.varchar_type ;
2536: l_PRIMARY_UOM_FLAG_TBL Qp_Preq_Grp.varchar_type ;
2537:

Line 2534: l_LINE_DETAIL_type_CODE_TBL Qp_Preq_Grp.varchar_type ;

2530: l_PRODUCT_UOM_CODE_TBL Qp_Preq_Grp.varchar_type;
2531: l_EXCLUDER_FLAG_TBL Qp_Preq_Grp.varchar_type ;
2532: l_PRICING_PHASE_ID_TBL Qp_Preq_Grp.pls_integer_type ;
2533: l_INCOMPATABILITY_GRP_CODE_TBL Qp_Preq_Grp.varchar_type ;
2534: l_LINE_DETAIL_type_CODE_TBL Qp_Preq_Grp.varchar_type ;
2535: l_MODIFIER_LEVEL_CODE_TBL Qp_Preq_Grp.varchar_type ;
2536: l_PRIMARY_UOM_FLAG_TBL Qp_Preq_Grp.varchar_type ;
2537:
2538: l_pricing_type_code VARCHAR2(1) := Fnd_Api.G_MISS_CHAR;

Line 2535: l_MODIFIER_LEVEL_CODE_TBL Qp_Preq_Grp.varchar_type ;

2531: l_EXCLUDER_FLAG_TBL Qp_Preq_Grp.varchar_type ;
2532: l_PRICING_PHASE_ID_TBL Qp_Preq_Grp.pls_integer_type ;
2533: l_INCOMPATABILITY_GRP_CODE_TBL Qp_Preq_Grp.varchar_type ;
2534: l_LINE_DETAIL_type_CODE_TBL Qp_Preq_Grp.varchar_type ;
2535: l_MODIFIER_LEVEL_CODE_TBL Qp_Preq_Grp.varchar_type ;
2536: l_PRIMARY_UOM_FLAG_TBL Qp_Preq_Grp.varchar_type ;
2537:
2538: l_pricing_type_code VARCHAR2(1) := Fnd_Api.G_MISS_CHAR;
2539: K PLS_INTEGER;

Line 2536: l_PRIMARY_UOM_FLAG_TBL Qp_Preq_Grp.varchar_type ;

2532: l_PRICING_PHASE_ID_TBL Qp_Preq_Grp.pls_integer_type ;
2533: l_INCOMPATABILITY_GRP_CODE_TBL Qp_Preq_Grp.varchar_type ;
2534: l_LINE_DETAIL_type_CODE_TBL Qp_Preq_Grp.varchar_type ;
2535: l_MODIFIER_LEVEL_CODE_TBL Qp_Preq_Grp.varchar_type ;
2536: l_PRIMARY_UOM_FLAG_TBL Qp_Preq_Grp.varchar_type ;
2537:
2538: l_pricing_type_code VARCHAR2(1) := Fnd_Api.G_MISS_CHAR;
2539: K PLS_INTEGER;
2540:

Line 2556: Qp_Preq_Grp.Set_QP_Debug;

2552:
2553: BEGIN
2554:
2555: -- Set the global variable G_DEBUG_ENGINE
2556: Qp_Preq_Grp.Set_QP_Debug;
2557:
2558: --added for MOAC
2559: --Set the Global variable G_ORG_ID
2560: G_ORG_ID := NVL(p_org_id, Qp_Util.get_org_id);

Line 2572: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;

2568: Mo_Global.set_policy_context('S', G_ORG_ID);
2569: END IF;
2570: END IF;--MO_GLOBAL
2571:
2572: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;
2573:
2574: --setting time
2575: l_sourcing_start_time := dbms_utility.get_time;
2576:

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

2609: l_MODIFIER_LEVEL_CODE_tbl.DELETE;
2610: l_PRIMARY_UOM_FLAG_tbl.DELETE;
2611:
2612: IF l_debug = Fnd_Api.G_TRUE THEN
2613: Qp_Preq_Grp.ENGINE_DEBUG('Begin Build contexts');
2614:
2615: END IF;
2616: K := 0;
2617: Qp_Attr_Mapping_Pub.G_REQ_TYPE_CODE := p_request_type_code; --bug3848849

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

2617: Qp_Attr_Mapping_Pub.G_REQ_TYPE_CODE := p_request_type_code; --bug3848849
2618:
2619: --Called Build Sourcing at line level
2620: IF l_debug = Fnd_Api.G_TRUE THEN
2621: Qp_Preq_Grp.ENGINE_DEBUG('Called Build Sourcing at line level----------');
2622:
2623: END IF;
2624: l_pricing_type_code := 'L';
2625:

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

2638: profile option ' QP_CUSTOM_SOURCED' is set to 'Y' -- GTIPPIRE
2639: */
2640:
2641: IF l_debug = Fnd_Api.G_TRUE THEN
2642: Qp_Preq_Grp.ENGINE_DEBUG('Number of qual attrs got from Get_Attribute_Values - ' || l_qual_contexts_result_tbl.COUNT );
2643: Qp_Preq_Grp.ENGINE_DEBUG('Number of pricing attrs got from Get_Attribute_Values - ' || l_price_contexts_result_tbl.COUNT );
2644:
2645: END IF;
2646: IF NVL(l_custom_sourced,'N') = 'Y' THEN

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

2639: */
2640:
2641: IF l_debug = Fnd_Api.G_TRUE THEN
2642: Qp_Preq_Grp.ENGINE_DEBUG('Number of qual attrs got from Get_Attribute_Values - ' || l_qual_contexts_result_tbl.COUNT );
2643: Qp_Preq_Grp.ENGINE_DEBUG('Number of pricing attrs got from Get_Attribute_Values - ' || l_price_contexts_result_tbl.COUNT );
2644:
2645: END IF;
2646: IF NVL(l_custom_sourced,'N') = 'Y' THEN
2647: IF l_debug = Fnd_Api.G_TRUE THEN

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

2644:
2645: END IF;
2646: IF NVL(l_custom_sourced,'N') = 'Y' THEN
2647: IF l_debug = Fnd_Api.G_TRUE THEN
2648: Qp_Preq_Grp.ENGINE_DEBUG('Before Calling Custom Sourcing Package ----------');
2649: END IF;
2650: Begin
2651: qp_debug_util.tstart('GET_CUSTOM_ATTRIBUTE_VALUES','Calling the QP_CUSTOM_SOURCE package to fetch the cutom attribute values');
2652: Qp_Custom_Source.Get_Custom_Attribute_Values(p_req_type_code => p_request_type_code,

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

2658: when others then
2659: qp_debug_util.tstop('GET_CUSTOM_ATTRIBUTE_VALUES');
2660: end;
2661: IF l_debug = Fnd_Api.G_TRUE THEN
2662: Qp_Preq_Grp.ENGINE_DEBUG('After Calling Custom Sourcing Package ----------');
2663:
2664: Qp_Preq_Grp.ENGINE_DEBUG('Number of qual attrs got from Get_Custom_Attribute_Values - ' || v_qual_contexts_result_tbl.COUNT );
2665: Qp_Preq_Grp.ENGINE_DEBUG('Number of pricing attrs got from Get_Custom_Attribute_Values - ' || v_price_contexts_result_tbl.COUNT );
2666:

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

2660: end;
2661: IF l_debug = Fnd_Api.G_TRUE THEN
2662: Qp_Preq_Grp.ENGINE_DEBUG('After Calling Custom Sourcing Package ----------');
2663:
2664: Qp_Preq_Grp.ENGINE_DEBUG('Number of qual attrs got from Get_Custom_Attribute_Values - ' || v_qual_contexts_result_tbl.COUNT );
2665: Qp_Preq_Grp.ENGINE_DEBUG('Number of pricing attrs got from Get_Custom_Attribute_Values - ' || v_price_contexts_result_tbl.COUNT );
2666:
2667: END IF;
2668: l_count := l_qual_contexts_result_tbl.COUNT;

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

2661: IF l_debug = Fnd_Api.G_TRUE THEN
2662: Qp_Preq_Grp.ENGINE_DEBUG('After Calling Custom Sourcing Package ----------');
2663:
2664: Qp_Preq_Grp.ENGINE_DEBUG('Number of qual attrs got from Get_Custom_Attribute_Values - ' || v_qual_contexts_result_tbl.COUNT );
2665: Qp_Preq_Grp.ENGINE_DEBUG('Number of pricing attrs got from Get_Custom_Attribute_Values - ' || v_price_contexts_result_tbl.COUNT );
2666:
2667: END IF;
2668: l_count := l_qual_contexts_result_tbl.COUNT;
2669:

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

2855: END IF;
2856:
2857: --Called Build Sourcing at header level
2858: IF l_debug = Fnd_Api.G_TRUE THEN
2859: Qp_Preq_Grp.ENGINE_DEBUG('Called Build Sourcing at header level----------');
2860:
2861: END IF;
2862: v_count := 0;
2863: l_count := 0;

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

2877: x_qual_ctxts_result_tbl => l_qual_contexts_result_tbl,
2878: x_price_ctxts_result_tbl => l_price_contexts_result_tbl);
2879:
2880: IF l_debug = Fnd_Api.G_TRUE THEN
2881: Qp_Preq_Grp.ENGINE_DEBUG('Number of qual attrs got from Get_Attribute_Values - ' || l_qual_contexts_result_tbl.COUNT );
2882: Qp_Preq_Grp.ENGINE_DEBUG('Number of pricing attrs got from Get_Attribute_Values - ' || l_price_contexts_result_tbl.COUNT );
2883:
2884: END IF;
2885: /*

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

2878: x_price_ctxts_result_tbl => l_price_contexts_result_tbl);
2879:
2880: IF l_debug = Fnd_Api.G_TRUE THEN
2881: Qp_Preq_Grp.ENGINE_DEBUG('Number of qual attrs got from Get_Attribute_Values - ' || l_qual_contexts_result_tbl.COUNT );
2882: Qp_Preq_Grp.ENGINE_DEBUG('Number of pricing attrs got from Get_Attribute_Values - ' || l_price_contexts_result_tbl.COUNT );
2883:
2884: END IF;
2885: /*
2886: If the attribute sourcing method is 'CUSTOM SOURCING' then user provides code to source

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

2891: */
2892:
2893: IF NVL(l_custom_sourced,'N') = 'Y' THEN
2894: IF l_debug = Fnd_Api.G_TRUE THEN
2895: Qp_Preq_Grp.ENGINE_DEBUG('Before Calling Custom Sourcing Package ----------');
2896: END IF;
2897: Begin
2898: qp_debug_util.tstart('GET_CUSTOM_ATTRIBUTE_VALUES','Calling the QP_CUSTOM_SOURCE package to fetch the cutom attribute values');
2899: Qp_Custom_Source.Get_Custom_Attribute_Values(p_req_type_code => p_request_type_code,

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

2906: qp_debug_util.tstop('GET_CUSTOM_ATTRIBUTE_VALUES');
2907: end;
2908:
2909: IF l_debug = Fnd_Api.G_TRUE THEN
2910: Qp_Preq_Grp.ENGINE_DEBUG('After Calling Custom Sourcing Package ----------');
2911:
2912: Qp_Preq_Grp.ENGINE_DEBUG('Number of qual attrs got from Get_Custom_Attribute_Values - ' || v_qual_contexts_result_tbl.COUNT );
2913: Qp_Preq_Grp.ENGINE_DEBUG('Number of pricing attrs got from Get_Custom_Attribute_Values - ' || v_price_contexts_result_tbl.COUNT );
2914:

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

2908:
2909: IF l_debug = Fnd_Api.G_TRUE THEN
2910: Qp_Preq_Grp.ENGINE_DEBUG('After Calling Custom Sourcing Package ----------');
2911:
2912: Qp_Preq_Grp.ENGINE_DEBUG('Number of qual attrs got from Get_Custom_Attribute_Values - ' || v_qual_contexts_result_tbl.COUNT );
2913: Qp_Preq_Grp.ENGINE_DEBUG('Number of pricing attrs got from Get_Custom_Attribute_Values - ' || v_price_contexts_result_tbl.COUNT );
2914:
2915: END IF;
2916: l_count := l_qual_contexts_result_tbl.COUNT;

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

2909: IF l_debug = Fnd_Api.G_TRUE THEN
2910: Qp_Preq_Grp.ENGINE_DEBUG('After Calling Custom Sourcing Package ----------');
2911:
2912: Qp_Preq_Grp.ENGINE_DEBUG('Number of qual attrs got from Get_Custom_Attribute_Values - ' || v_qual_contexts_result_tbl.COUNT );
2913: Qp_Preq_Grp.ENGINE_DEBUG('Number of pricing attrs got from Get_Custom_Attribute_Values - ' || v_price_contexts_result_tbl.COUNT );
2914:
2915: END IF;
2916: l_count := l_qual_contexts_result_tbl.COUNT;
2917:

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

3098: END IF;
3099:
3100: IF l_debug = Fnd_Api.G_TRUE THEN
3101:
3102: Qp_Preq_Grp.ENGINE_DEBUG('Printing line attributes ----------');
3103: FOR i IN 1..l_line_index_tbl.COUNT
3104: LOOP
3105: IF l_debug = Fnd_Api.G_TRUE THEN
3106: Qp_Preq_Grp.ENGINE_DEBUG('line index '||l_line_index_tbl(i));

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

3102: Qp_Preq_Grp.ENGINE_DEBUG('Printing line attributes ----------');
3103: FOR i IN 1..l_line_index_tbl.COUNT
3104: LOOP
3105: IF l_debug = Fnd_Api.G_TRUE THEN
3106: Qp_Preq_Grp.ENGINE_DEBUG('line index '||l_line_index_tbl(i));
3107: Qp_Preq_Grp.ENGINE_DEBUG('attribute type '||l_attribute_type_tbl(i));
3108: Qp_Preq_Grp.ENGINE_DEBUG('context '||l_context_tbl(i));
3109: Qp_Preq_Grp.ENGINE_DEBUG('attribute '||l_attribute_tbl(i));
3110: Qp_Preq_Grp.ENGINE_DEBUG('value from '||l_value_from_tbl(i));

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

3103: FOR i IN 1..l_line_index_tbl.COUNT
3104: LOOP
3105: IF l_debug = Fnd_Api.G_TRUE THEN
3106: Qp_Preq_Grp.ENGINE_DEBUG('line index '||l_line_index_tbl(i));
3107: Qp_Preq_Grp.ENGINE_DEBUG('attribute type '||l_attribute_type_tbl(i));
3108: Qp_Preq_Grp.ENGINE_DEBUG('context '||l_context_tbl(i));
3109: Qp_Preq_Grp.ENGINE_DEBUG('attribute '||l_attribute_tbl(i));
3110: Qp_Preq_Grp.ENGINE_DEBUG('value from '||l_value_from_tbl(i));
3111: Qp_Preq_Grp.ENGINE_DEBUG('validated flag '||l_validated_flag_tbl(i));

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

3104: LOOP
3105: IF l_debug = Fnd_Api.G_TRUE THEN
3106: Qp_Preq_Grp.ENGINE_DEBUG('line index '||l_line_index_tbl(i));
3107: Qp_Preq_Grp.ENGINE_DEBUG('attribute type '||l_attribute_type_tbl(i));
3108: Qp_Preq_Grp.ENGINE_DEBUG('context '||l_context_tbl(i));
3109: Qp_Preq_Grp.ENGINE_DEBUG('attribute '||l_attribute_tbl(i));
3110: Qp_Preq_Grp.ENGINE_DEBUG('value from '||l_value_from_tbl(i));
3111: Qp_Preq_Grp.ENGINE_DEBUG('validated flag '||l_validated_flag_tbl(i));
3112: Qp_Preq_Grp.ENGINE_DEBUG('-----------------------------------------');

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

3105: IF l_debug = Fnd_Api.G_TRUE THEN
3106: Qp_Preq_Grp.ENGINE_DEBUG('line index '||l_line_index_tbl(i));
3107: Qp_Preq_Grp.ENGINE_DEBUG('attribute type '||l_attribute_type_tbl(i));
3108: Qp_Preq_Grp.ENGINE_DEBUG('context '||l_context_tbl(i));
3109: Qp_Preq_Grp.ENGINE_DEBUG('attribute '||l_attribute_tbl(i));
3110: Qp_Preq_Grp.ENGINE_DEBUG('value from '||l_value_from_tbl(i));
3111: Qp_Preq_Grp.ENGINE_DEBUG('validated flag '||l_validated_flag_tbl(i));
3112: Qp_Preq_Grp.ENGINE_DEBUG('-----------------------------------------');
3113: END IF;

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

3106: Qp_Preq_Grp.ENGINE_DEBUG('line index '||l_line_index_tbl(i));
3107: Qp_Preq_Grp.ENGINE_DEBUG('attribute type '||l_attribute_type_tbl(i));
3108: Qp_Preq_Grp.ENGINE_DEBUG('context '||l_context_tbl(i));
3109: Qp_Preq_Grp.ENGINE_DEBUG('attribute '||l_attribute_tbl(i));
3110: Qp_Preq_Grp.ENGINE_DEBUG('value from '||l_value_from_tbl(i));
3111: Qp_Preq_Grp.ENGINE_DEBUG('validated flag '||l_validated_flag_tbl(i));
3112: Qp_Preq_Grp.ENGINE_DEBUG('-----------------------------------------');
3113: END IF;
3114: END LOOP;

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

3107: Qp_Preq_Grp.ENGINE_DEBUG('attribute type '||l_attribute_type_tbl(i));
3108: Qp_Preq_Grp.ENGINE_DEBUG('context '||l_context_tbl(i));
3109: Qp_Preq_Grp.ENGINE_DEBUG('attribute '||l_attribute_tbl(i));
3110: Qp_Preq_Grp.ENGINE_DEBUG('value from '||l_value_from_tbl(i));
3111: Qp_Preq_Grp.ENGINE_DEBUG('validated flag '||l_validated_flag_tbl(i));
3112: Qp_Preq_Grp.ENGINE_DEBUG('-----------------------------------------');
3113: END IF;
3114: END LOOP;
3115: END IF; --debug true

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

3108: Qp_Preq_Grp.ENGINE_DEBUG('context '||l_context_tbl(i));
3109: Qp_Preq_Grp.ENGINE_DEBUG('attribute '||l_attribute_tbl(i));
3110: Qp_Preq_Grp.ENGINE_DEBUG('value from '||l_value_from_tbl(i));
3111: Qp_Preq_Grp.ENGINE_DEBUG('validated flag '||l_validated_flag_tbl(i));
3112: Qp_Preq_Grp.ENGINE_DEBUG('-----------------------------------------');
3113: END IF;
3114: END LOOP;
3115: END IF; --debug true
3116:

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

3118: IF l_line_index_tbl.COUNT > 0
3119: THEN
3120: BEGIN
3121: IF l_debug = Fnd_Api.G_TRUE THEN
3122: Qp_Preq_Grp.ENGINE_DEBUG('Tata Inserting line attributes ----------');
3123: END IF;
3124:
3125: IF Qp_Java_Engine_Util_Pub.Java_Engine_Running = 'N' THEN
3126: IF l_debug = Fnd_Api.G_TRUE THEN

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

3123: END IF;
3124:
3125: IF Qp_Java_Engine_Util_Pub.Java_Engine_Running = 'N' THEN
3126: IF l_debug = Fnd_Api.G_TRUE THEN
3127: Qp_Preq_Grp.ENGINE_DEBUG('Java Engine not Installed ----------');
3128: END IF;
3129:
3130: FORALL i IN l_line_index_tbl.FIRST..l_line_index_tbl.LAST
3131: INSERT INTO qp_npreq_line_attrs_tmp

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

3152: Qp_Preq_Pub.G_YES
3153: );
3154: ELSE -- Java Engine path added by yangli
3155: IF l_debug = Fnd_Api.G_TRUE THEN
3156: Qp_Preq_Grp.ENGINE_DEBUG('Java Engine Installed path----------');
3157: END IF;
3158: /*QP_PREQ_GRP.INSERT_LINE_ATTRS_AT( l_line_index_tbl,
3159: QP_PREQ_PUB.G_LINE_LEVEL,
3160: l_attribute_type_tbl,

Line 3158: /*QP_PREQ_GRP.INSERT_LINE_ATTRS_AT( l_line_index_tbl,

3154: ELSE -- Java Engine path added by yangli
3155: IF l_debug = Fnd_Api.G_TRUE THEN
3156: Qp_Preq_Grp.ENGINE_DEBUG('Java Engine Installed path----------');
3157: END IF;
3158: /*QP_PREQ_GRP.INSERT_LINE_ATTRS_AT( l_line_index_tbl,
3159: QP_PREQ_PUB.G_LINE_LEVEL,
3160: l_attribute_type_tbl,
3161: l_context_tbl,
3162: l_attribute_tbl,

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

3175: l_LINE_DETAIL_INDEX_tbl (i) := NULL;
3176: l_value_to_tbl (i) := NULL;
3177: END LOOP;
3178:
3179: Qp_Preq_Grp.INSERT_LINE_ATTRS2 ( p_LINE_INDEX_tbl => l_line_index_tbl,
3180: p_LINE_DETAIL_INDEX_tbl => l_line_Detail_index_tbl,
3181: p_ATTRIBUTE_LEVEL_tbl=> l_ATTRIBUTE_LEVEL_tbl,
3182: p_ATTRIBUTE_TYPE_tbl => l_attribute_type_tbl,
3183: p_LIST_HEADER_ID_tbl=> l_LIST_HEADER_ID_tbl,

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

3213: END IF;
3214: END IF;
3215:
3216: IF l_debug = Fnd_Api.G_TRUE THEN
3217: Qp_Preq_Grp.ENGINE_DEBUG('End Inserting line attributes ----------');
3218: END IF;
3219: EXCEPTION
3220: WHEN E_ROUTINE_ERRORS THEN
3221: IF l_debug = Fnd_Api.G_TRUE THEN

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

3218: END IF;
3219: EXCEPTION
3220: WHEN E_ROUTINE_ERRORS THEN
3221: IF l_debug = Fnd_Api.G_TRUE THEN
3222: Qp_Preq_Grp.engine_debug('QP_ATTR_MAPPING_PUB:Bld Contxt Insert LINE_ATTR '||''||l_status_text);
3223: END IF;
3224: WHEN OTHERS THEN
3225: IF l_debug = Fnd_Api.G_TRUE THEN
3226: Qp_Preq_Grp.engine_debug('QP_ATTR_MAPPING_PUB:Bld Contxt Insert LINE_ATTR '||' '||SQLERRM);

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

3222: Qp_Preq_Grp.engine_debug('QP_ATTR_MAPPING_PUB:Bld Contxt Insert LINE_ATTR '||''||l_status_text);
3223: END IF;
3224: WHEN OTHERS THEN
3225: IF l_debug = Fnd_Api.G_TRUE THEN
3226: Qp_Preq_Grp.engine_debug('QP_ATTR_MAPPING_PUB:Bld Contxt Insert LINE_ATTR '||' '||SQLERRM);
3227: END IF;
3228: END;
3229:
3230: END IF;

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

3229:
3230: END IF;
3231:
3232: IF l_debug = Fnd_Api.G_TRUE THEN
3233: Qp_Preq_Grp.ENGINE_DEBUG('End Build contexts');
3234:
3235: END IF;
3236: --setting time
3237: l_sourcing_end_time := dbms_utility.get_time;

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

3243: END IF;
3244: EXCEPTION
3245: WHEN OTHERS THEN
3246: IF l_debug = Fnd_Api.G_TRUE THEN
3247: Qp_Preq_Grp.ENGINE_DEBUG('Exception in QP_ATTR_MAPPING_PUB.Build_context '||SQLERRM);
3248:
3249: END IF;
3250: END Build_Contexts;
3251:

Line 3311: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;

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

Line 3488: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;

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

Line 3666: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;

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

Line 3793: --l_prod_exists_tbl QP_PREQ_GRP.FLAG_TYPE;

3789: **********Changed lines API pass only dependent lines*********************
3790: *************************************************************************/
3791:
3792: PROCEDURE Check_line_group_items(p_pricing_type_code IN VARCHAR2) IS
3793: --l_prod_exists_tbl QP_PREQ_GRP.FLAG_TYPE;
3794: l_prod_exists VARCHAR2(1) := 'N';
3795: l_all_items_exist VARCHAR2(1) := 'N';
3796: BEGIN
3797: BEGIN