DBA Data[Home] [Help]

APPS.QP_ATTR_MAPPING_PUB dependencies on QP_ATTRIBUTE_SOURCING

Line 638: qp_attribute_sourcing qpsour,

634: qpcon.prc_context_type context_type,
635: '2' is_product
636: FROM
637: qp_segments_b qpseg,
638: qp_attribute_sourcing qpsour,
639: qp_prc_contexts_b qpcon,
640: qp_pte_request_types_b qpreq,
641: qp_pte_segments qppseg
642: WHERE

Line 664: qp_attribute_sourcing qpsour,

660: qpcon.prc_context_type context_type,
661: '1' is_product
662: FROM
663: qp_segments_b qpseg,
664: qp_attribute_sourcing qpsour,
665: qp_prc_contexts_b qpcon,
666: qp_pte_request_types_b qpreq,
667: qp_pte_segments qppseg
668: WHERE

Line 2229: Fnd_Message.SET_NAME('QP','QP_ATTRIBUTE_SOURCING_SUCCESS');

2225: Pkg_End('QP_BUILD_SOURCING_PVT_TMP', 'BODY');
2226:
2227: --dbms_output.put_line('............5............');
2228: retcode := 0;
2229: Fnd_Message.SET_NAME('QP','QP_ATTRIBUTE_SOURCING_SUCCESS');
2230: err_buff := Fnd_Message.GET;
2231:
2232: IF l_debug = Fnd_Api.G_TRUE THEN
2233: Oe_Debug_Pub.ADD('##### End Build Sourcing #####');

Line 2239: Fnd_Message.SET_NAME('QP','QP_ATTRIBUTE_SOURCING_ERROR');

2235: END IF;
2236: EXCEPTION
2237:
2238: WHEN Fnd_Api.G_EXC_ERROR THEN
2239: Fnd_Message.SET_NAME('QP','QP_ATTRIBUTE_SOURCING_ERROR');
2240: Fnd_Message.SET_TOKEN('PACKAGE_TYPE','BODY');
2241: Fnd_Message.SET_TOKEN('PACKAGE_NAME','QP_BUILD_SOURCING_PVT');
2242: Fnd_Message.SET_TOKEN('ERRMSG',SUBSTR(SQLERRM,1,150));
2243: err_buff := Fnd_Message.GET;

Line 2249: Fnd_Message.SET_NAME('QP','QP_ATTRIBUTE_SOURCING_ERROR');

2245:
2246: -- err_buff := 'Please check the log file for error messages';
2247:
2248: WHEN OTHERS THEN
2249: Fnd_Message.SET_NAME('QP','QP_ATTRIBUTE_SOURCING_ERROR');
2250: Fnd_Message.SET_TOKEN('PACKAGE_TYPE','BODY');
2251: Fnd_Message.SET_TOKEN('PACKAGE_NAME','QP_BUILD_SOURCING_PVT');
2252: Fnd_Message.SET_TOKEN('ERRMSG',SUBSTR(SQLERRM,1,150));
2253: err_buff := Fnd_Message.GET;

Line 4169: l_src_type qp_attribute_sourcing.user_sourcing_type%TYPE;

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;
4170: l_value_string qp_attribute_sourcing.user_value_string%TYPE;
4171: l_qual_count BINARY_INTEGER := 0;
4172: l_price_count BINARY_INTEGER := 0;
4173: l_count BINARY_INTEGER := 0;

Line 4170: l_value_string qp_attribute_sourcing.user_value_string%TYPE;

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;
4170: l_value_string qp_attribute_sourcing.user_value_string%TYPE;
4171: l_qual_count BINARY_INTEGER := 0;
4172: l_price_count BINARY_INTEGER := 0;
4173: l_count BINARY_INTEGER := 0;
4174: l_index BINARY_INTEGER := 0;

Line 4185: qp_attribute_sourcing qpsour,

4181: qpcon.prc_context_code context_code,
4182: qpcon.prc_context_type context_type
4183: FROM
4184: qp_segments_b qpseg,
4185: qp_attribute_sourcing qpsour,
4186: qp_prc_contexts_b qpcon,
4187: qp_pte_request_types_b qpreq,
4188: qp_pte_segments qppseg
4189: WHERE

Line 4417: l_src_type qp_attribute_sourcing.user_sourcing_type%TYPE;

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;
4418: l_pricing_type qp_attribute_sourcing.attribute_sourcing_level%TYPE;
4419: l_value_string qp_attribute_sourcing.user_value_string%TYPE;
4420: l_request_type qp_attribute_sourcing.request_type_code%TYPE;
4421: l_pte_name qp_pte_request_types_b.pte_code%TYPE;

Line 4418: l_pricing_type qp_attribute_sourcing.attribute_sourcing_level%TYPE;

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;
4418: l_pricing_type qp_attribute_sourcing.attribute_sourcing_level%TYPE;
4419: l_value_string qp_attribute_sourcing.user_value_string%TYPE;
4420: l_request_type qp_attribute_sourcing.request_type_code%TYPE;
4421: l_pte_name qp_pte_request_types_b.pte_code%TYPE;
4422: l_context_type qp_prc_contexts_b.prc_context_type%TYPE;

Line 4419: l_value_string qp_attribute_sourcing.user_value_string%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;
4418: l_pricing_type qp_attribute_sourcing.attribute_sourcing_level%TYPE;
4419: l_value_string qp_attribute_sourcing.user_value_string%TYPE;
4420: l_request_type qp_attribute_sourcing.request_type_code%TYPE;
4421: l_pte_name qp_pte_request_types_b.pte_code%TYPE;
4422: l_context_type qp_prc_contexts_b.prc_context_type%TYPE;
4423: l_successful BOOLEAN := TRUE;

Line 4420: l_request_type qp_attribute_sourcing.request_type_code%TYPE;

4416: l_attribute_map qp_segments_b.segment_mapping_column%TYPE;
4417: l_src_type qp_attribute_sourcing.user_sourcing_type%TYPE;
4418: l_pricing_type qp_attribute_sourcing.attribute_sourcing_level%TYPE;
4419: l_value_string qp_attribute_sourcing.user_value_string%TYPE;
4420: l_request_type qp_attribute_sourcing.request_type_code%TYPE;
4421: l_pte_name qp_pte_request_types_b.pte_code%TYPE;
4422: l_context_type qp_prc_contexts_b.prc_context_type%TYPE;
4423: l_successful BOOLEAN := TRUE;
4424: l_err_count BINARY_INTEGER := 0;

Line 4445: qp_attribute_sourcing qpsour,

4441: qpcon.prc_context_type,
4442: qpseg.segment_code
4443: FROM
4444: qp_segments_b qpseg,
4445: qp_attribute_sourcing qpsour,
4446: qp_prc_contexts_b qpcon,
4447: qp_pte_request_types_b qpreq,
4448: qp_pte_segments qppseg
4449: WHERE

Line 4473: qp_attribute_sourcing qpsour,

4469: qpseg.segment_code
4470:
4471: FROM
4472: qp_segments_b qpseg,
4473: qp_attribute_sourcing qpsour,
4474: qp_prc_contexts_b qpcon,
4475: qp_pte_request_types_b qpreq,
4476: qp_pte_segments qppseg
4477: WHERE