DBA Data[Home] [Help]

APPS.QP_VALIDATE_PLL_PRICING_ATTR dependencies on QP_GLOBALS

Line 75: IF p_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_UPDATE

71: END IF;
72:
73: --5286339
74:
75: IF p_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_UPDATE
76: THEN
77:
78: IF nvl(p_old_PRICING_ATTR_rec.PRODUCT_ATTRIBUTE_CONTEXT,'X') <>
79: nvl(p_PRICING_ATTR_rec.PRODUCT_ATTRIBUTE_CONTEXT,'X')

Line 659: oe_debug_pub.add('G_CHECK_DUP_PRICELIST_LINES is '|| QP_GLOBALS.G_CHECK_DUP_PRICELIST_LINES); -- 5018856, 5024919

655:
656:
657: end if;
658: */
659: oe_debug_pub.add('G_CHECK_DUP_PRICELIST_LINES is '|| QP_GLOBALS.G_CHECK_DUP_PRICELIST_LINES); -- 5018856, 5024919
660: IF (QP_GLOBALS.G_CHECK_DUP_PRICELIST_LINES <> 'N' or QP_GLOBALS.G_CHECK_DUP_PRICELIST_LINES IS NULL)
661: THEN --5018856 , 5024919 only log request if not N or null
662: oe_debug_pub.add('about to log a request to check duplicate list lines ');
663:

Line 660: IF (QP_GLOBALS.G_CHECK_DUP_PRICELIST_LINES <> 'N' or QP_GLOBALS.G_CHECK_DUP_PRICELIST_LINES IS NULL)

656:
657: end if;
658: */
659: oe_debug_pub.add('G_CHECK_DUP_PRICELIST_LINES is '|| QP_GLOBALS.G_CHECK_DUP_PRICELIST_LINES); -- 5018856, 5024919
660: IF (QP_GLOBALS.G_CHECK_DUP_PRICELIST_LINES <> 'N' or QP_GLOBALS.G_CHECK_DUP_PRICELIST_LINES IS NULL)
661: THEN --5018856 , 5024919 only log request if not N or null
662: oe_debug_pub.add('about to log a request to check duplicate list lines ');
663:
664: QP_DELAYED_REQUESTS_PVT.Log_Request

Line 665: ( p_entity_code => QP_GLOBALS.G_ENTITY_ALL

661: THEN --5018856 , 5024919 only log request if not N or null
662: oe_debug_pub.add('about to log a request to check duplicate list lines ');
663:
664: QP_DELAYED_REQUESTS_PVT.Log_Request
665: ( p_entity_code => QP_GLOBALS.G_ENTITY_ALL
666: , p_entity_id => p_PRICING_ATTR_rec.list_line_id
667: , p_requesting_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR
668: , p_requesting_entity_id => p_PRICING_ATTR_rec.pricing_attribute_id
669: , p_request_type => QP_GLOBALS.G_DUPLICATE_LIST_LINES

Line 667: , p_requesting_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR

663:
664: QP_DELAYED_REQUESTS_PVT.Log_Request
665: ( p_entity_code => QP_GLOBALS.G_ENTITY_ALL
666: , p_entity_id => p_PRICING_ATTR_rec.list_line_id
667: , p_requesting_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR
668: , p_requesting_entity_id => p_PRICING_ATTR_rec.pricing_attribute_id
669: , p_request_type => QP_GLOBALS.G_DUPLICATE_LIST_LINES
670: , p_param1 => l_list_header_id
671: , p_param2 => fnd_date.date_to_canonical(l_start_date_active) --2739511

Line 669: , p_request_type => QP_GLOBALS.G_DUPLICATE_LIST_LINES

665: ( p_entity_code => QP_GLOBALS.G_ENTITY_ALL
666: , p_entity_id => p_PRICING_ATTR_rec.list_line_id
667: , p_requesting_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR
668: , p_requesting_entity_id => p_PRICING_ATTR_rec.pricing_attribute_id
669: , p_request_type => QP_GLOBALS.G_DUPLICATE_LIST_LINES
670: , p_param1 => l_list_header_id
671: , p_param2 => fnd_date.date_to_canonical(l_start_date_active) --2739511
672: , p_param3 => fnd_date.date_to_canonical(l_end_date_active) --2739511
673: , p_param4 => l_revision

Line 686: END IF;-- end IF QP_GLOBALS.G_CHECK_DUP_PRICELIST_LINES <> 'N' or null-- 5108856

682:
683: END IF;
684:
685: oe_debug_pub.add('after logging delayed request ');
686: END IF;-- end IF QP_GLOBALS.G_CHECK_DUP_PRICELIST_LINES <> 'N' or null-- 5108856
687:
688: IF (p_Pricing_Attr_rec.pricing_attribute_context IS NOT NULL
689: OR p_Pricing_Attr_rec.pricing_attribute IS NOT NULL
690: OR p_Pricing_Attr_rec.pricing_attr_value_from IS NOT NULL

Line 1202: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1198: l_from_rltd_modifier_id IS NOT NULL
1199: THEN
1200: OE_Debug_Pub.add ( 'Logging delayed request for Price Break Child Line ');
1201: QP_DELAYED_REQUESTS_PVT.Log_Request
1202: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1203: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
1204: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR,
1205: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,
1206: p_request_type => QP_GLOBALS.G_MULTIPLE_PRICE_BREAK_ATTRS,

Line 1204: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR,

1200: OE_Debug_Pub.add ( 'Logging delayed request for Price Break Child Line ');
1201: QP_DELAYED_REQUESTS_PVT.Log_Request
1202: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1203: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
1204: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR,
1205: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,
1206: p_request_type => QP_GLOBALS.G_MULTIPLE_PRICE_BREAK_ATTRS,
1207: p_param1 => l_from_rltd_modifier_id,
1208: x_return_status => l_return_status

Line 1206: p_request_type => QP_GLOBALS.G_MULTIPLE_PRICE_BREAK_ATTRS,

1202: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1203: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
1204: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR,
1205: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,
1206: p_request_type => QP_GLOBALS.G_MULTIPLE_PRICE_BREAK_ATTRS,
1207: p_param1 => l_from_rltd_modifier_id,
1208: x_return_status => l_return_status
1209: );
1210:

Line 1212: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1208: x_return_status => l_return_status
1209: );
1210:
1211: QP_DELAYED_REQUESTS_PVT.Log_Request
1212: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1213: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
1214: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR,
1215: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,
1216: p_request_type => QP_GLOBALS.G_OVERLAPPING_PRICE_BREAKS,

Line 1214: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR,

1210:
1211: QP_DELAYED_REQUESTS_PVT.Log_Request
1212: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1213: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
1214: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR,
1215: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,
1216: p_request_type => QP_GLOBALS.G_OVERLAPPING_PRICE_BREAKS,
1217: p_param1 => l_from_rltd_modifier_id,
1218: p_param2 => l_continuous_price_break_flag,

Line 1216: p_request_type => QP_GLOBALS.G_OVERLAPPING_PRICE_BREAKS,

1212: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1213: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
1214: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR,
1215: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,
1216: p_request_type => QP_GLOBALS.G_OVERLAPPING_PRICE_BREAKS,
1217: p_param1 => l_from_rltd_modifier_id,
1218: p_param2 => l_continuous_price_break_flag,
1219: --Added the param to call the validation
1220: --function depending upon the break type