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_ATTR_MAPPING_PUB

Line 1: PACKAGE BODY Qp_Attr_Mapping_Pub AS

1: PACKAGE BODY Qp_Attr_Mapping_Pub AS
2: /* $Header: QPXPSRCB.pls 120.14.12010000.4 2008/10/19 08:16:13 hmohamme ship $ */
3:
4: g_schema VARCHAR2(30);
5: g_conc_mode VARCHAR2(1);

Line 565: v_attribute_mvalue Qp_Attr_Mapping_Pub.t_MultiRecord;

561: l_context_name VARCHAR2(240); --4932085, 4960278
562: v_attribute_name VARCHAR2(240);
563: l_attribute_name VARCHAR2(240);
564: v_attribute_value VARCHAR2(240);
565: v_attribute_mvalue Qp_Attr_Mapping_Pub.t_MultiRecord;
566: v_attr_src_string VARCHAR2(2000);
567: v_src_type VARCHAR2(30);
568: l_src_type VARCHAR2(30);
569: v_src_api_pkg VARCHAR2(1000);

Line 687: Text('QP_ATTR_MAPPING_PUB.G_Product_Attr_Tbl.delete;',1);

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
690:
691: IF p_pricing_type = 'L' THEN

Line 1678: Text('IF QP_ATTR_MAPPING_PUB.G_CHECK_LINE_FLAG = ''Y'' THEN',2);

1674: THEN
1675: Text('IF l_debug = FND_API.G_TRUE THEN',2);
1676: text('oe_debug_pub.add(''In check to call line_group'');',3);
1677: Text('END IF;',2);
1678: Text('IF QP_ATTR_MAPPING_PUB.G_CHECK_LINE_FLAG = ''Y'' THEN',2);
1679: Text('BEGIN',3);
1680: Text('IF l_debug = FND_API.G_TRUE THEN',3);
1681: text('oe_debug_pub.add(''Before call line_group'');',4);
1682: Text('END IF;',3);

Line 1683: Text('QP_ATTR_MAPPING_PUB.Check_line_group_items(p_pricing_type_code);',3);

1679: Text('BEGIN',3);
1680: Text('IF l_debug = FND_API.G_TRUE THEN',3);
1681: text('oe_debug_pub.add(''Before call line_group'');',4);
1682: Text('END IF;',3);
1683: Text('QP_ATTR_MAPPING_PUB.Check_line_group_items(p_pricing_type_code);',3);
1684: Text('IF l_debug = FND_API.G_TRUE THEN',3);
1685: text('oe_debug_pub.add(''After call line_group'');',4);
1686: Text('END IF;',3);
1687: Text('EXCEPTION',3);

Line 1693: Text('ELSE--QP_ATTR_MAPPING_PUB.G_CHECK_LINE_FLAG',2);

1689: Text('IF l_debug = FND_API.G_TRUE THEN',4);
1690: Text('oe_debug_pub.add(''Error in Check_line_group_items'');',5);
1691: Text('END IF;',4);
1692: Text('END;',3);
1693: Text('ELSE--QP_ATTR_MAPPING_PUB.G_CHECK_LINE_FLAG',2);
1694: Text('QP_ATTR_MAPPING_PUB.G_PASS_THIS_LINE := ''Y'';',3);
1695: Text('END IF;--QP_ATTR_MAPPING_PUB.G_CHECK_LINE_FLAG',2);
1696: Text('IF QP_ATTR_MAPPING_PUB.G_PASS_THIS_LINE = '||'''N'''||' THEN',2);
1697: Text('IF l_debug = FND_API.G_TRUE THEN',3);

Line 1694: Text('QP_ATTR_MAPPING_PUB.G_PASS_THIS_LINE := ''Y'';',3);

1690: Text('oe_debug_pub.add(''Error in Check_line_group_items'');',5);
1691: Text('END IF;',4);
1692: Text('END;',3);
1693: Text('ELSE--QP_ATTR_MAPPING_PUB.G_CHECK_LINE_FLAG',2);
1694: Text('QP_ATTR_MAPPING_PUB.G_PASS_THIS_LINE := ''Y'';',3);
1695: Text('END IF;--QP_ATTR_MAPPING_PUB.G_CHECK_LINE_FLAG',2);
1696: Text('IF QP_ATTR_MAPPING_PUB.G_PASS_THIS_LINE = '||'''N'''||' THEN',2);
1697: Text('IF l_debug = FND_API.G_TRUE THEN',3);
1698: Text('oe_debug_pub.add(''Deleting sourced prod attr'');',4);

Line 1695: Text('END IF;--QP_ATTR_MAPPING_PUB.G_CHECK_LINE_FLAG',2);

1691: Text('END IF;',4);
1692: Text('END;',3);
1693: Text('ELSE--QP_ATTR_MAPPING_PUB.G_CHECK_LINE_FLAG',2);
1694: Text('QP_ATTR_MAPPING_PUB.G_PASS_THIS_LINE := ''Y'';',3);
1695: Text('END IF;--QP_ATTR_MAPPING_PUB.G_CHECK_LINE_FLAG',2);
1696: Text('IF QP_ATTR_MAPPING_PUB.G_PASS_THIS_LINE = '||'''N'''||' THEN',2);
1697: Text('IF l_debug = FND_API.G_TRUE THEN',3);
1698: Text('oe_debug_pub.add(''Deleting sourced prod attr'');',4);
1699: Text('END IF;',3);

Line 1696: Text('IF QP_ATTR_MAPPING_PUB.G_PASS_THIS_LINE = '||'''N'''||' THEN',2);

1692: Text('END;',3);
1693: Text('ELSE--QP_ATTR_MAPPING_PUB.G_CHECK_LINE_FLAG',2);
1694: Text('QP_ATTR_MAPPING_PUB.G_PASS_THIS_LINE := ''Y'';',3);
1695: Text('END IF;--QP_ATTR_MAPPING_PUB.G_CHECK_LINE_FLAG',2);
1696: Text('IF QP_ATTR_MAPPING_PUB.G_PASS_THIS_LINE = '||'''N'''||' THEN',2);
1697: Text('IF l_debug = FND_API.G_TRUE THEN',3);
1698: Text('oe_debug_pub.add(''Deleting sourced prod attr'');',4);
1699: Text('END IF;',3);
1700: Text('x_price_ctxts_result_tbl.delete;',3);

Line 1702: Text('END IF;--QP_ATTR_MAPPING_PUB.G_PASS_THIS_LINE',2);

1698: Text('oe_debug_pub.add(''Deleting sourced prod attr'');',4);
1699: Text('END IF;',3);
1700: Text('x_price_ctxts_result_tbl.delete;',3);
1701: Text('RETURN;',3);
1702: Text('END IF;--QP_ATTR_MAPPING_PUB.G_PASS_THIS_LINE',2);
1703: END IF;
1704: --End Fix for 2491269
1705:
1706:

Line 1864: Text('QP_ATTR_MAPPING_PUB.G_Product_attr_tbl(QP_ATTR_MAPPING_PUB.G_Product_attr_tbl.COUNT+1) := '

1860: text('oe_debug_pub.add(''Gathering product details'');',5);
1861: Text('END IF;',4);
1862: l_context_type_processed := v_context_type;
1863: Text('BEGIN',4);
1864: Text('QP_ATTR_MAPPING_PUB.G_Product_attr_tbl(QP_ATTR_MAPPING_PUB.G_Product_attr_tbl.COUNT+1) := '
1865: ||'x_price_ctxts_result_tbl(p_count-1);',5);
1866: Text('Exception',4);
1867: Text('When Others Then',4);
1868: Text('IF l_debug = FND_API.G_TRUE THEN',5);

Line 1982: Text('QP_ATTR_MAPPING_PUB.G_Product_attr_tbl(QP_ATTR_MAPPING_PUB.G_Product_attr_tbl.COUNT+1) := '

1978: text('oe_debug_pub.add(''Gathering product details'');',5);
1979: Text('END IF;',4);
1980: l_context_type_processed := v_context_type;
1981: Text('BEGIN',4);
1982: Text('QP_ATTR_MAPPING_PUB.G_Product_attr_tbl(QP_ATTR_MAPPING_PUB.G_Product_attr_tbl.COUNT+1) := '
1983: ||'x_price_ctxts_result_tbl(p_count-1);',5);
1984: Text('Exception',4);
1985: Text('When Others Then',4);
1986: Text('IF l_debug = FND_API.G_TRUE THEN',5);

Line 2063: Text(', x_qual_ctxts_result_tbl OUT NOCOPY QP_Attr_Mapping_PUB.CONTEXTS_RESULT_TBL_TYPE',0);

2059: New_Line;
2060: Text('PROCEDURE Get_Attribute_Values',0);
2061: Text('( p_req_type_code IN VARCHAR2',0);
2062: Text(', p_pricing_type_code IN VARCHAR2',0);
2063: Text(', x_qual_ctxts_result_tbl OUT NOCOPY QP_Attr_Mapping_PUB.CONTEXTS_RESULT_TBL_TYPE',0);
2064: Text(', x_price_ctxts_result_tbl OUT NOCOPY QP_Attr_Mapping_PUB.CONTEXTS_RESULT_TBL_TYPE',0);
2065: Text(')',0);
2066: Text('IS',0);
2067: New_line;

Line 2064: Text(', x_price_ctxts_result_tbl OUT NOCOPY QP_Attr_Mapping_PUB.CONTEXTS_RESULT_TBL_TYPE',0);

2060: Text('PROCEDURE Get_Attribute_Values',0);
2061: Text('( p_req_type_code IN VARCHAR2',0);
2062: Text(', p_pricing_type_code IN VARCHAR2',0);
2063: Text(', x_qual_ctxts_result_tbl OUT NOCOPY QP_Attr_Mapping_PUB.CONTEXTS_RESULT_TBL_TYPE',0);
2064: Text(', x_price_ctxts_result_tbl OUT NOCOPY QP_Attr_Mapping_PUB.CONTEXTS_RESULT_TBL_TYPE',0);
2065: Text(')',0);
2066: Text('IS',0);
2067: New_line;
2068: Text('v_attr_value VARCHAR2(240);',0); --4932085, 4960278

Line 2069: Text('v_attr_mvalue QP_Attr_Mapping_PUB.t_MultiRecord;',0);

2065: Text(')',0);
2066: Text('IS',0);
2067: New_line;
2068: Text('v_attr_value VARCHAR2(240);',0); --4932085, 4960278
2069: Text('v_attr_mvalue QP_Attr_Mapping_PUB.t_MultiRecord;',0);
2070: Text('q_count NUMBER := 1;',0);
2071: Text('p_count NUMBER := 1;',0);
2072: Text('v_index NUMBER := 1;',0);
2073: Text('prev_header_id NUMBER := FND_API.G_MISS_NUM;',0);

Line 2279: l_qual_contexts_result_tbl Qp_Attr_Mapping_Pub.CONTEXTS_RESULT_TBL_TYPE;

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;
2280: l_price_contexts_result_tbl Qp_Attr_Mapping_Pub.CONTEXTS_RESULT_TBL_TYPE;
2281:
2282: l_sourcing_start_time NUMBER;
2283: l_sourcing_end_time NUMBER;

Line 2280: l_price_contexts_result_tbl Qp_Attr_Mapping_Pub.CONTEXTS_RESULT_TBL_TYPE;

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;
2280: l_price_contexts_result_tbl Qp_Attr_Mapping_Pub.CONTEXTS_RESULT_TBL_TYPE;
2281:
2282: l_sourcing_start_time NUMBER;
2283: l_sourcing_end_time NUMBER;
2284: l_time_difference NUMBER;

Line 2314: Qp_Attr_Mapping_Pub.G_REQ_TYPE_CODE := p_request_type_code; --bug3848849

2310: END IF;
2311: --setting time
2312: l_sourcing_start_time := dbms_utility.get_time;
2313:
2314: Qp_Attr_Mapping_Pub.G_REQ_TYPE_CODE := p_request_type_code; --bug3848849
2315:
2316: Qp_Build_Sourcing_Pvt.Get_Attribute_Values(p_req_type_code => p_request_type_code,
2317: p_pricing_type_code => p_pricing_type,
2318: x_qual_ctxts_result_tbl => x_qual_contexts_result_tbl,

Line 2617: Qp_Attr_Mapping_Pub.G_REQ_TYPE_CODE := p_request_type_code; --bug3848849

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
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----------');

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 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 3890: Oe_Debug_Pub.ADD('Error in QP_ATTR_MAPPING_PUB.Check_line_group_items '||SQLERRM);

3886: END IF;
3887: EXCEPTION
3888: WHEN OTHERS THEN
3889: IF l_debug = Fnd_Api.G_TRUE THEN
3890: Oe_Debug_Pub.ADD('Error in QP_ATTR_MAPPING_PUB.Check_line_group_items '||SQLERRM);
3891: END IF;
3892: G_PASS_THIS_LINE := 'Y';
3893: END Check_line_group_items;
3894:

Line 3917: Qp_Attr_Mapping_Pub.G_REQ_TYPE_CODE := p_request_type_code; --bug3848849

3913: Oe_Debug_Pub.ADD('p_check_line_flag '||p_check_line_flag);
3914: Oe_Debug_Pub.ADD('p_pricing_event '||p_pricing_event);
3915: Oe_Debug_Pub.ADD('p_pricing_type_code '||p_pricing_type);
3916: END IF;
3917: Qp_Attr_Mapping_Pub.G_REQ_TYPE_CODE := p_request_type_code; --bug3848849
3918: Build_Contexts
3919: ( p_request_type_code => p_request_type_code
3920: , p_pricing_type => p_pricing_type
3921: --added for MOAC

Line 3946: Oe_Debug_Pub.ADD('Exception in QP_ATTR_MAPPING_PUB.Build_context'||SQLERRM);

3942: END IF;
3943: EXCEPTION
3944: WHEN OTHERS THEN
3945: IF l_debug = Fnd_Api.G_TRUE THEN
3946: Oe_Debug_Pub.ADD('Exception in QP_ATTR_MAPPING_PUB.Build_context'||SQLERRM);
3947: END IF;
3948: END Build_Contexts;
3949:
3950: /*Fix for bug 2491269

Line 3974: Qp_Attr_Mapping_Pub.G_REQ_TYPE_CODE := p_request_type_code; --bug3848849

3970: Oe_Debug_Pub.ADD('p_pricing_event '||p_pricing_event);
3971: Oe_Debug_Pub.ADD('p_pricing_type_code '||p_pricing_type_code);
3972:
3973: END IF;
3974: Qp_Attr_Mapping_Pub.G_REQ_TYPE_CODE := p_request_type_code; --bug3848849
3975: Build_Contexts
3976: ( p_request_type_code => p_request_type_code,
3977: p_line_index => p_line_index,
3978: p_pricing_type_code => p_pricing_type_code,

Line 3992: Oe_Debug_Pub.ADD('Exception in QP_ATTR_MAPPING_PUB.Build_context'||SQLERRM);

3988: END IF;
3989: EXCEPTION
3990: WHEN OTHERS THEN
3991: IF l_debug = Fnd_Api.G_TRUE THEN
3992: Oe_Debug_Pub.ADD('Exception in QP_ATTR_MAPPING_PUB.Build_context'||SQLERRM);
3993: END IF;
3994: END Build_Contexts;
3995:
3996:

Line 4010: l_sql_stmt := 'BEGIN QP_Attr_Mapping_PUB.G_Temp_Value := ' || p_src_api_call || ';' || ' END;';

4006: BEGIN
4007: p_successful := TRUE;
4008: --dbms_output.put_line('*****Going Dynamic for******: ' || p_src_api_call);
4009:
4010: l_sql_stmt := 'BEGIN QP_Attr_Mapping_PUB.G_Temp_Value := ' || p_src_api_call || ';' || ' END;';
4011:
4012: --dbms_output.put_line(l_sql_stmt);
4013: EXECUTE IMMEDIATE l_sql_stmt ;
4014:

Line 4015: x_return := Qp_Attr_Mapping_Pub.G_Temp_Value;

4011:
4012: --dbms_output.put_line(l_sql_stmt);
4013: EXECUTE IMMEDIATE l_sql_stmt ;
4014:
4015: x_return := Qp_Attr_Mapping_Pub.G_Temp_Value;
4016:
4017: --dbms_output.put_line('Return Value:' || x_return);
4018:
4019: IF x_return = Fnd_Api.G_MISS_NUM THEN

Line 4046: ) RETURN Qp_Attr_Mapping_Pub.t_MultiRecord

4042:
4043: FUNCTION Get_API_MultiValue
4044: ( p_src_mult_api_call IN VARCHAR2
4045: , p_successful IN OUT NOCOPY BOOLEAN
4046: ) RETURN Qp_Attr_Mapping_Pub.t_MultiRecord
4047: IS
4048:
4049: l_sql_stmt VARCHAR2(2060);
4050: x_return Qp_Attr_Mapping_Pub.t_MultiRecord;

Line 4050: x_return Qp_Attr_Mapping_Pub.t_MultiRecord;

4046: ) RETURN Qp_Attr_Mapping_Pub.t_MultiRecord
4047: IS
4048:
4049: l_sql_stmt VARCHAR2(2060);
4050: x_return Qp_Attr_Mapping_Pub.t_MultiRecord;
4051:
4052: BEGIN
4053: p_successful := TRUE;
4054:

Line 4057: l_sql_stmt := 'BEGIN QP_Attr_Mapping_PUB.G_Temp_MultiValue := '|| p_src_mult_api_call ||'; END;';

4053: p_successful := TRUE;
4054:
4055: --dbms_output.put_line('Going Dynamic for: ' || p_src_mult_api_call);
4056:
4057: l_sql_stmt := 'BEGIN QP_Attr_Mapping_PUB.G_Temp_MultiValue := '|| p_src_mult_api_call ||'; END;';
4058: --dbms_output.put_line(l_sql_stmt);
4059:
4060: EXECUTE IMMEDIATE l_sql_stmt;
4061: --dbms_output.put_line('Count for Multirec: ' || QP_Attr_Mapping_PUB.G_Temp_MultiValue.count);

Line 4061: --dbms_output.put_line('Count for Multirec: ' || QP_Attr_Mapping_PUB.G_Temp_MultiValue.count);

4057: l_sql_stmt := 'BEGIN QP_Attr_Mapping_PUB.G_Temp_MultiValue := '|| p_src_mult_api_call ||'; END;';
4058: --dbms_output.put_line(l_sql_stmt);
4059:
4060: EXECUTE IMMEDIATE l_sql_stmt;
4061: --dbms_output.put_line('Count for Multirec: ' || QP_Attr_Mapping_PUB.G_Temp_MultiValue.count);
4062:
4063: x_return := Qp_Attr_Mapping_Pub.G_Temp_MultiValue;
4064:
4065: RETURN x_return;

Line 4063: x_return := Qp_Attr_Mapping_Pub.G_Temp_MultiValue;

4059:
4060: EXECUTE IMMEDIATE l_sql_stmt;
4061: --dbms_output.put_line('Count for Multirec: ' || QP_Attr_Mapping_PUB.G_Temp_MultiValue.count);
4062:
4063: x_return := Qp_Attr_Mapping_Pub.G_Temp_MultiValue;
4064:
4065: RETURN x_return;
4066: EXCEPTION
4067: WHEN NO_DATA_FOUND THEN

Line 4165: l_attribute_mvalue Qp_Attr_Mapping_Pub.t_MultiRecord;

4161: IS
4162:
4163: l_pricing_type VARCHAR2(30);
4164: l_attribute_value VARCHAR2(240);
4165: l_attribute_mvalue Qp_Attr_Mapping_Pub.t_MultiRecord;
4166: l_context_name qp_prc_contexts_b.prc_context_code%TYPE;
4167: l_context_type qp_prc_contexts_b.prc_context_type%TYPE;
4168: l_attribute_name qp_segments_b.segment_mapping_column%TYPE;
4169: l_src_type qp_attribute_sourcing.user_sourcing_type%TYPE;

Line 4413: l_attribute_mvalue Qp_Attr_Mapping_Pub.t_MultiRecord;

4409:
4410: TYPE l_cursor_type IS REF CURSOR;
4411:
4412: l_attribute_value VARCHAR2(240);
4413: l_attribute_mvalue Qp_Attr_Mapping_Pub.t_MultiRecord;
4414: l_context_name qp_prc_contexts_b.prc_context_code%TYPE;
4415: l_attribute_name qp_segments_b.segment_code%TYPE;
4416: l_attribute_map qp_segments_b.segment_mapping_column%TYPE;
4417: l_src_type qp_attribute_sourcing.user_sourcing_type%TYPE;

Line 4582: END Qp_Attr_Mapping_Pub;

4578:
4579: END Check_All_Mapping;
4580:
4581:
4582: END Qp_Attr_Mapping_Pub;