DBA Data[Home] [Help]

APPS.QP_ATTR_MAPPING_PUB dependencies on QP_ATTRIBUTE_SOURCING

Line 705: qp_attribute_sourcing qpsour,

701: qpcon.prc_context_type context_type,
702: '2' is_product
703: FROM
704: qp_segments_b qpseg,
705: qp_attribute_sourcing qpsour,
706: qp_prc_contexts_b qpcon,
707: qp_pte_request_types_b qpreq,
708: qp_pte_segments qppseg
709: WHERE

Line 731: qp_attribute_sourcing qpsour,

727: qpcon.prc_context_type context_type,
728: '1' is_product
729: FROM
730: qp_segments_b qpseg,
731: qp_attribute_sourcing qpsour,
732: qp_prc_contexts_b qpcon,
733: qp_pte_request_types_b qpreq,
734: qp_pte_segments qppseg
735: WHERE

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

2296: Pkg_End('QP_BUILD_SOURCING_PVT_TMP', 'BODY');
2297:
2298: --dbms_output.put_line('............5............');
2299: retcode := 0;
2300: Fnd_Message.SET_NAME('QP','QP_ATTRIBUTE_SOURCING_SUCCESS');
2301: err_buff := Fnd_Message.GET;
2302:
2303: IF l_debug = Fnd_Api.G_TRUE THEN
2304: Oe_Debug_Pub.ADD('##### End Build Sourcing #####');

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

2306: END IF;
2307: EXCEPTION
2308:
2309: WHEN Fnd_Api.G_EXC_ERROR THEN
2310: Fnd_Message.SET_NAME('QP','QP_ATTRIBUTE_SOURCING_ERROR');
2311: Fnd_Message.SET_TOKEN('PACKAGE_TYPE','BODY');
2312: Fnd_Message.SET_TOKEN('PACKAGE_NAME','QP_BUILD_SOURCING_PVT');
2313: Fnd_Message.SET_TOKEN('ERRMSG',SUBSTR(SQLERRM,1,150));
2314: err_buff := Fnd_Message.GET;

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

2316:
2317: -- err_buff := 'Please check the log file for error messages';
2318:
2319: WHEN OTHERS THEN
2320: Fnd_Message.SET_NAME('QP','QP_ATTRIBUTE_SOURCING_ERROR');
2321: Fnd_Message.SET_TOKEN('PACKAGE_TYPE','BODY');
2322: Fnd_Message.SET_TOKEN('PACKAGE_NAME','QP_BUILD_SOURCING_PVT');
2323: Fnd_Message.SET_TOKEN('ERRMSG',SUBSTR(SQLERRM,1,150));
2324: err_buff := Fnd_Message.GET;

Line 4442: l_src_type qp_attribute_sourcing.user_sourcing_type%TYPE;

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;
4443: l_value_string qp_attribute_sourcing.user_value_string%TYPE;
4444: l_qual_count BINARY_INTEGER := 0;
4445: l_price_count BINARY_INTEGER := 0;
4446: l_count BINARY_INTEGER := 0;

Line 4443: l_value_string qp_attribute_sourcing.user_value_string%TYPE;

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;
4443: l_value_string qp_attribute_sourcing.user_value_string%TYPE;
4444: l_qual_count BINARY_INTEGER := 0;
4445: l_price_count BINARY_INTEGER := 0;
4446: l_count BINARY_INTEGER := 0;
4447: l_index BINARY_INTEGER := 0;

Line 4458: qp_attribute_sourcing qpsour,

4454: qpcon.prc_context_code context_code,
4455: qpcon.prc_context_type context_type
4456: FROM
4457: qp_segments_b qpseg,
4458: qp_attribute_sourcing qpsour,
4459: qp_prc_contexts_b qpcon,
4460: qp_pte_request_types_b qpreq,
4461: qp_pte_segments qppseg
4462: WHERE

Line 4690: l_src_type qp_attribute_sourcing.user_sourcing_type%TYPE;

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;
4691: l_pricing_type qp_attribute_sourcing.attribute_sourcing_level%TYPE;
4692: l_value_string qp_attribute_sourcing.user_value_string%TYPE;
4693: l_request_type qp_attribute_sourcing.request_type_code%TYPE;
4694: l_pte_name qp_pte_request_types_b.pte_code%TYPE;

Line 4691: l_pricing_type qp_attribute_sourcing.attribute_sourcing_level%TYPE;

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;
4691: l_pricing_type qp_attribute_sourcing.attribute_sourcing_level%TYPE;
4692: l_value_string qp_attribute_sourcing.user_value_string%TYPE;
4693: l_request_type qp_attribute_sourcing.request_type_code%TYPE;
4694: l_pte_name qp_pte_request_types_b.pte_code%TYPE;
4695: l_context_type qp_prc_contexts_b.prc_context_type%TYPE;

Line 4692: l_value_string qp_attribute_sourcing.user_value_string%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;
4691: l_pricing_type qp_attribute_sourcing.attribute_sourcing_level%TYPE;
4692: l_value_string qp_attribute_sourcing.user_value_string%TYPE;
4693: l_request_type qp_attribute_sourcing.request_type_code%TYPE;
4694: l_pte_name qp_pte_request_types_b.pte_code%TYPE;
4695: l_context_type qp_prc_contexts_b.prc_context_type%TYPE;
4696: l_successful BOOLEAN := TRUE;

Line 4693: l_request_type qp_attribute_sourcing.request_type_code%TYPE;

4689: l_attribute_map qp_segments_b.segment_mapping_column%TYPE;
4690: l_src_type qp_attribute_sourcing.user_sourcing_type%TYPE;
4691: l_pricing_type qp_attribute_sourcing.attribute_sourcing_level%TYPE;
4692: l_value_string qp_attribute_sourcing.user_value_string%TYPE;
4693: l_request_type qp_attribute_sourcing.request_type_code%TYPE;
4694: l_pte_name qp_pte_request_types_b.pte_code%TYPE;
4695: l_context_type qp_prc_contexts_b.prc_context_type%TYPE;
4696: l_successful BOOLEAN := TRUE;
4697: l_err_count BINARY_INTEGER := 0;

Line 4718: qp_attribute_sourcing qpsour,

4714: qpcon.prc_context_type,
4715: qpseg.segment_code
4716: FROM
4717: qp_segments_b qpseg,
4718: qp_attribute_sourcing qpsour,
4719: qp_prc_contexts_b qpcon,
4720: qp_pte_request_types_b qpreq,
4721: qp_pte_segments qppseg
4722: WHERE

Line 4746: qp_attribute_sourcing qpsour,

4742: qpseg.segment_code
4743:
4744: FROM
4745: qp_segments_b qpseg,
4746: qp_attribute_sourcing qpsour,
4747: qp_prc_contexts_b qpcon,
4748: qp_pte_request_types_b qpreq,
4749: qp_pte_segments qppseg
4750: WHERE