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.24.12020000.2 2012/07/04 12:10:09 smbalara ship $ */
3:
4: g_schema VARCHAR2(30);
5: g_conc_mode VARCHAR2(1);

Line 632: v_attribute_mvalue Qp_Attr_Mapping_Pub.t_MultiRecord;

628: l_context_name VARCHAR2(240); --4932085, 4960278
629: v_attribute_name VARCHAR2(240);
630: l_attribute_name VARCHAR2(240);
631: v_attribute_value VARCHAR2(240);
632: v_attribute_mvalue Qp_Attr_Mapping_Pub.t_MultiRecord;
633: v_attr_src_string VARCHAR2(2000);
634: v_src_type VARCHAR2(30);
635: l_src_type VARCHAR2(30);
636: v_src_api_pkg VARCHAR2(1000);

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

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

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

1741: THEN
1742: Text('IF l_debug = FND_API.G_TRUE THEN',2);
1743: text('oe_debug_pub.add(''In check to call line_group'');',3);
1744: Text('END IF;',2);
1745: Text('IF QP_ATTR_MAPPING_PUB.G_CHECK_LINE_FLAG = ''Y'' THEN',2);
1746: Text('BEGIN',3);
1747: Text('IF l_debug = FND_API.G_TRUE THEN',3);
1748: text('oe_debug_pub.add(''Before call line_group'');',4);
1749: Text('END IF;',3);

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

1746: Text('BEGIN',3);
1747: Text('IF l_debug = FND_API.G_TRUE THEN',3);
1748: text('oe_debug_pub.add(''Before call line_group'');',4);
1749: Text('END IF;',3);
1750: Text('QP_ATTR_MAPPING_PUB.Check_line_group_items(p_pricing_type_code);',3);
1751: Text('IF l_debug = FND_API.G_TRUE THEN',3);
1752: text('oe_debug_pub.add(''After call line_group'');',4);
1753: Text('END IF;',3);
1754: Text('EXCEPTION',3);

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

1756: Text('IF l_debug = FND_API.G_TRUE THEN',4);
1757: Text('oe_debug_pub.add(''Error in Check_line_group_items'');',5);
1758: Text('END IF;',4);
1759: Text('END;',3);
1760: Text('ELSE--QP_ATTR_MAPPING_PUB.G_CHECK_LINE_FLAG',2);
1761: Text('QP_ATTR_MAPPING_PUB.G_PASS_THIS_LINE := ''Y'';',3);
1762: Text('END IF;--QP_ATTR_MAPPING_PUB.G_CHECK_LINE_FLAG',2);
1763: Text('IF QP_ATTR_MAPPING_PUB.G_PASS_THIS_LINE = '||'''N''',2);
1764: Text(' OR QP_ATTR_MAPPING_PUB.G_IGNORE_PRICE = '||'''Y'''||' THEN',2); --8589909

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

1757: Text('oe_debug_pub.add(''Error in Check_line_group_items'');',5);
1758: Text('END IF;',4);
1759: Text('END;',3);
1760: Text('ELSE--QP_ATTR_MAPPING_PUB.G_CHECK_LINE_FLAG',2);
1761: Text('QP_ATTR_MAPPING_PUB.G_PASS_THIS_LINE := ''Y'';',3);
1762: Text('END IF;--QP_ATTR_MAPPING_PUB.G_CHECK_LINE_FLAG',2);
1763: Text('IF QP_ATTR_MAPPING_PUB.G_PASS_THIS_LINE = '||'''N''',2);
1764: Text(' OR QP_ATTR_MAPPING_PUB.G_IGNORE_PRICE = '||'''Y'''||' THEN',2); --8589909
1765: Text('IF l_debug = FND_API.G_TRUE THEN',3);

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

1758: Text('END IF;',4);
1759: Text('END;',3);
1760: Text('ELSE--QP_ATTR_MAPPING_PUB.G_CHECK_LINE_FLAG',2);
1761: Text('QP_ATTR_MAPPING_PUB.G_PASS_THIS_LINE := ''Y'';',3);
1762: Text('END IF;--QP_ATTR_MAPPING_PUB.G_CHECK_LINE_FLAG',2);
1763: Text('IF QP_ATTR_MAPPING_PUB.G_PASS_THIS_LINE = '||'''N''',2);
1764: Text(' OR QP_ATTR_MAPPING_PUB.G_IGNORE_PRICE = '||'''Y'''||' THEN',2); --8589909
1765: Text('IF l_debug = FND_API.G_TRUE THEN',3);
1766: Text('oe_debug_pub.add(''Deleting sourced prod attr'');',4);

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

1759: Text('END;',3);
1760: Text('ELSE--QP_ATTR_MAPPING_PUB.G_CHECK_LINE_FLAG',2);
1761: Text('QP_ATTR_MAPPING_PUB.G_PASS_THIS_LINE := ''Y'';',3);
1762: Text('END IF;--QP_ATTR_MAPPING_PUB.G_CHECK_LINE_FLAG',2);
1763: Text('IF QP_ATTR_MAPPING_PUB.G_PASS_THIS_LINE = '||'''N''',2);
1764: Text(' OR QP_ATTR_MAPPING_PUB.G_IGNORE_PRICE = '||'''Y'''||' THEN',2); --8589909
1765: Text('IF l_debug = FND_API.G_TRUE THEN',3);
1766: Text('oe_debug_pub.add(''Deleting sourced prod attr'');',4);
1767: Text('END IF;',3);

Line 1764: Text(' OR QP_ATTR_MAPPING_PUB.G_IGNORE_PRICE = '||'''Y'''||' THEN',2); --8589909

1760: Text('ELSE--QP_ATTR_MAPPING_PUB.G_CHECK_LINE_FLAG',2);
1761: Text('QP_ATTR_MAPPING_PUB.G_PASS_THIS_LINE := ''Y'';',3);
1762: Text('END IF;--QP_ATTR_MAPPING_PUB.G_CHECK_LINE_FLAG',2);
1763: Text('IF QP_ATTR_MAPPING_PUB.G_PASS_THIS_LINE = '||'''N''',2);
1764: Text(' OR QP_ATTR_MAPPING_PUB.G_IGNORE_PRICE = '||'''Y'''||' THEN',2); --8589909
1765: Text('IF l_debug = FND_API.G_TRUE THEN',3);
1766: Text('oe_debug_pub.add(''Deleting sourced prod attr'');',4);
1767: Text('END IF;',3);
1768: Text('x_price_ctxts_result_tbl.delete;',3);

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

1766: Text('oe_debug_pub.add(''Deleting sourced prod attr'');',4);
1767: Text('END IF;',3);
1768: Text('x_price_ctxts_result_tbl.delete;',3);
1769: Text('RETURN;',3);
1770: Text('END IF;--QP_ATTR_MAPPING_PUB.G_PASS_THIS_LINE',2);
1771: END IF;
1772: --End Fix for 2491269
1773:
1774:

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

1928: text('oe_debug_pub.add(''Gathering product details'');',5);
1929: Text('END IF;',4);
1930: l_context_type_processed := v_context_type;
1931: Text('BEGIN',4);
1932: Text('QP_ATTR_MAPPING_PUB.G_Product_attr_tbl(QP_ATTR_MAPPING_PUB.G_Product_attr_tbl.COUNT+1) := '
1933: ||'x_price_ctxts_result_tbl(p_count-1);',5);
1934: Text('Exception',4);
1935: Text('When Others Then',4);
1936: Text('IF l_debug = FND_API.G_TRUE THEN',5);

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

2046: text('oe_debug_pub.add(''Gathering product details'');',5);
2047: Text('END IF;',4);
2048: l_context_type_processed := v_context_type;
2049: Text('BEGIN',4);
2050: Text('QP_ATTR_MAPPING_PUB.G_Product_attr_tbl(QP_ATTR_MAPPING_PUB.G_Product_attr_tbl.COUNT+1) := '
2051: ||'x_price_ctxts_result_tbl(p_count-1);',5);
2052: Text('Exception',4);
2053: Text('When Others Then',4);
2054: Text('IF l_debug = FND_API.G_TRUE THEN',5);

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

2127: New_Line;
2128: Text('PROCEDURE Get_Attribute_Values',0);
2129: Text('( p_req_type_code IN VARCHAR2',0);
2130: Text(', p_pricing_type_code IN VARCHAR2',0);
2131: Text(', x_qual_ctxts_result_tbl OUT NOCOPY QP_Attr_Mapping_PUB.CONTEXTS_RESULT_TBL_TYPE',0);
2132: Text(', x_price_ctxts_result_tbl OUT NOCOPY QP_Attr_Mapping_PUB.CONTEXTS_RESULT_TBL_TYPE',0);
2133: Text(')',0);
2134: Text('IS',0);
2135: New_line;

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

2128: Text('PROCEDURE Get_Attribute_Values',0);
2129: Text('( p_req_type_code IN VARCHAR2',0);
2130: Text(', p_pricing_type_code IN VARCHAR2',0);
2131: Text(', x_qual_ctxts_result_tbl OUT NOCOPY QP_Attr_Mapping_PUB.CONTEXTS_RESULT_TBL_TYPE',0);
2132: Text(', x_price_ctxts_result_tbl OUT NOCOPY QP_Attr_Mapping_PUB.CONTEXTS_RESULT_TBL_TYPE',0);
2133: Text(')',0);
2134: Text('IS',0);
2135: New_line;
2136: Text('v_attr_value VARCHAR2(240);',0); --4932085, 4960278

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

2133: Text(')',0);
2134: Text('IS',0);
2135: New_line;
2136: Text('v_attr_value VARCHAR2(240);',0); --4932085, 4960278
2137: Text('v_attr_mvalue QP_Attr_Mapping_PUB.t_MultiRecord;',0);
2138: Text('q_count NUMBER := 1;',0);
2139: Text('p_count NUMBER := 1;',0);
2140: Text('v_index NUMBER := 1;',0);
2141: Text('v_tot_time NUMBER := 0;',0);

Line 2350: l_qual_contexts_result_tbl Qp_Attr_Mapping_Pub.CONTEXTS_RESULT_TBL_TYPE;

2346: l_custom_sourced VARCHAR2(1) := Fnd_Profile.VALUE('QP_CUSTOM_SOURCED');
2347:
2348: l_req_type_code VARCHAR2(30);
2349: l_pricing_type_code VARCHAR2(1);
2350: l_qual_contexts_result_tbl Qp_Attr_Mapping_Pub.CONTEXTS_RESULT_TBL_TYPE;
2351: l_price_contexts_result_tbl Qp_Attr_Mapping_Pub.CONTEXTS_RESULT_TBL_TYPE;
2352:
2353: l_sourcing_start_time NUMBER;
2354: l_sourcing_end_time NUMBER;

Line 2351: l_price_contexts_result_tbl Qp_Attr_Mapping_Pub.CONTEXTS_RESULT_TBL_TYPE;

2347:
2348: l_req_type_code VARCHAR2(30);
2349: l_pricing_type_code VARCHAR2(1);
2350: l_qual_contexts_result_tbl Qp_Attr_Mapping_Pub.CONTEXTS_RESULT_TBL_TYPE;
2351: l_price_contexts_result_tbl Qp_Attr_Mapping_Pub.CONTEXTS_RESULT_TBL_TYPE;
2352:
2353: l_sourcing_start_time NUMBER;
2354: l_sourcing_end_time NUMBER;
2355: l_time_difference NUMBER;

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

2381: END IF;
2382: --setting time
2383: l_sourcing_start_time := dbms_utility.get_time;
2384:
2385: Qp_Attr_Mapping_Pub.G_REQ_TYPE_CODE := p_request_type_code; --bug3848849
2386: -- 13638721
2387: oe_debug_pub.add('Maintain Dynamic pkgs profile is 1:'||L_MAINT_DYN_SRC_VER);
2388: IF (L_MAINT_DYN_SRC_VER='N') THEN
2389: Qp_Build_Sourcing_Pvt.Get_Attribute_Values(p_req_type_code => p_request_type_code,

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

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

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

4159: END IF; -- 10120089
4160: EXCEPTION
4161: WHEN OTHERS THEN
4162: IF l_debug = Fnd_Api.G_TRUE THEN
4163: Oe_Debug_Pub.ADD('Error in QP_ATTR_MAPPING_PUB.Check_line_group_items '||SQLERRM);
4164: END IF;
4165: G_PASS_THIS_LINE := 'Y';
4166: END Check_line_group_items;
4167:

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

4186: Oe_Debug_Pub.ADD('p_check_line_flag '||p_check_line_flag);
4187: Oe_Debug_Pub.ADD('p_pricing_event '||p_pricing_event);
4188: Oe_Debug_Pub.ADD('p_pricing_type_code '||p_pricing_type);
4189: END IF;
4190: Qp_Attr_Mapping_Pub.G_REQ_TYPE_CODE := p_request_type_code; --bug3848849
4191: Build_Contexts
4192: ( p_request_type_code => p_request_type_code
4193: , p_pricing_type => p_pricing_type
4194: --added for MOAC

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

4215: END IF;
4216: EXCEPTION
4217: WHEN OTHERS THEN
4218: IF l_debug = Fnd_Api.G_TRUE THEN
4219: Oe_Debug_Pub.ADD('Exception in QP_ATTR_MAPPING_PUB.Build_context'||SQLERRM);
4220: END IF;
4221: END Build_Contexts;
4222:
4223: /*Fix for bug 2491269

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

4243: Oe_Debug_Pub.ADD('p_pricing_event '||p_pricing_event);
4244: Oe_Debug_Pub.ADD('p_pricing_type_code '||p_pricing_type_code);
4245:
4246: END IF;
4247: Qp_Attr_Mapping_Pub.G_REQ_TYPE_CODE := p_request_type_code; --bug3848849
4248: Build_Contexts
4249: ( p_request_type_code => p_request_type_code,
4250: p_line_index => p_line_index,
4251: p_pricing_type_code => p_pricing_type_code,

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

4261: END IF;
4262: EXCEPTION
4263: WHEN OTHERS THEN
4264: IF l_debug = Fnd_Api.G_TRUE THEN
4265: Oe_Debug_Pub.ADD('Exception in QP_ATTR_MAPPING_PUB.Build_context'||SQLERRM);
4266: END IF;
4267: END Build_Contexts;
4268:
4269:

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

4279: BEGIN
4280: p_successful := TRUE;
4281: --dbms_output.put_line('*****Going Dynamic for******: ' || p_src_api_call);
4282:
4283: l_sql_stmt := 'BEGIN QP_Attr_Mapping_PUB.G_Temp_Value := ' || p_src_api_call || ';' || ' END;';
4284:
4285: --dbms_output.put_line(l_sql_stmt);
4286: EXECUTE IMMEDIATE l_sql_stmt ;
4287:

Line 4288: x_return := Qp_Attr_Mapping_Pub.G_Temp_Value;

4284:
4285: --dbms_output.put_line(l_sql_stmt);
4286: EXECUTE IMMEDIATE l_sql_stmt ;
4287:
4288: x_return := Qp_Attr_Mapping_Pub.G_Temp_Value;
4289:
4290: --dbms_output.put_line('Return Value:' || x_return);
4291:
4292: IF x_return = Fnd_Api.G_MISS_NUM THEN

Line 4319: ) RETURN Qp_Attr_Mapping_Pub.t_MultiRecord

4315:
4316: FUNCTION Get_API_MultiValue
4317: ( p_src_mult_api_call IN VARCHAR2
4318: , p_successful IN OUT NOCOPY BOOLEAN
4319: ) RETURN Qp_Attr_Mapping_Pub.t_MultiRecord
4320: IS
4321:
4322: l_sql_stmt VARCHAR2(2060);
4323: x_return Qp_Attr_Mapping_Pub.t_MultiRecord;

Line 4323: x_return Qp_Attr_Mapping_Pub.t_MultiRecord;

4319: ) RETURN Qp_Attr_Mapping_Pub.t_MultiRecord
4320: IS
4321:
4322: l_sql_stmt VARCHAR2(2060);
4323: x_return Qp_Attr_Mapping_Pub.t_MultiRecord;
4324:
4325: BEGIN
4326: p_successful := TRUE;
4327:

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

4326: p_successful := TRUE;
4327:
4328: --dbms_output.put_line('Going Dynamic for: ' || p_src_mult_api_call);
4329:
4330: l_sql_stmt := 'BEGIN QP_Attr_Mapping_PUB.G_Temp_MultiValue := '|| p_src_mult_api_call ||'; END;';
4331: --dbms_output.put_line(l_sql_stmt);
4332:
4333: EXECUTE IMMEDIATE l_sql_stmt;
4334: --dbms_output.put_line('Count for Multirec: ' || QP_Attr_Mapping_PUB.G_Temp_MultiValue.count);

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

4330: l_sql_stmt := 'BEGIN QP_Attr_Mapping_PUB.G_Temp_MultiValue := '|| p_src_mult_api_call ||'; END;';
4331: --dbms_output.put_line(l_sql_stmt);
4332:
4333: EXECUTE IMMEDIATE l_sql_stmt;
4334: --dbms_output.put_line('Count for Multirec: ' || QP_Attr_Mapping_PUB.G_Temp_MultiValue.count);
4335:
4336: x_return := Qp_Attr_Mapping_Pub.G_Temp_MultiValue;
4337:
4338: RETURN x_return;

Line 4336: x_return := Qp_Attr_Mapping_Pub.G_Temp_MultiValue;

4332:
4333: EXECUTE IMMEDIATE l_sql_stmt;
4334: --dbms_output.put_line('Count for Multirec: ' || QP_Attr_Mapping_PUB.G_Temp_MultiValue.count);
4335:
4336: x_return := Qp_Attr_Mapping_Pub.G_Temp_MultiValue;
4337:
4338: RETURN x_return;
4339: EXCEPTION
4340: WHEN NO_DATA_FOUND THEN

Line 4438: l_attribute_mvalue Qp_Attr_Mapping_Pub.t_MultiRecord;

4434: IS
4435:
4436: l_pricing_type VARCHAR2(30);
4437: l_attribute_value VARCHAR2(240);
4438: l_attribute_mvalue Qp_Attr_Mapping_Pub.t_MultiRecord;
4439: l_context_name qp_prc_contexts_b.prc_context_code%TYPE;
4440: l_context_type qp_prc_contexts_b.prc_context_type%TYPE;
4441: l_attribute_name qp_segments_b.segment_mapping_column%TYPE;
4442: l_src_type qp_attribute_sourcing.user_sourcing_type%TYPE;

Line 4686: l_attribute_mvalue Qp_Attr_Mapping_Pub.t_MultiRecord;

4682:
4683: TYPE l_cursor_type IS REF CURSOR;
4684:
4685: l_attribute_value VARCHAR2(240);
4686: l_attribute_mvalue Qp_Attr_Mapping_Pub.t_MultiRecord;
4687: l_context_name qp_prc_contexts_b.prc_context_code%TYPE;
4688: l_attribute_name qp_segments_b.segment_code%TYPE;
4689: l_attribute_map qp_segments_b.segment_mapping_column%TYPE;
4690: l_src_type qp_attribute_sourcing.user_sourcing_type%TYPE;

Line 4855: END Qp_Attr_Mapping_Pub;

4851:
4852: END Check_All_Mapping;
4853:
4854:
4855: END Qp_Attr_Mapping_Pub;