DBA Data[Home] [Help]

APPS.QP_VALIDATE_PLL_PRICING_ATTR dependencies on QP_GLOBALS

Line 81: IF p_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_UPDATE

77: END IF;
78:
79: --5286339
80:
81: IF p_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_UPDATE
82: THEN
83:
84: IF nvl(p_old_PRICING_ATTR_rec.PRODUCT_ATTRIBUTE_CONTEXT,'X') <>
85: nvl(p_PRICING_ATTR_rec.PRODUCT_ATTRIBUTE_CONTEXT,'X')

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

712:
713:
714: end if;
715: */
716: oe_debug_pub.add('G_CHECK_DUP_PRICELIST_LINES is '|| QP_GLOBALS.G_CHECK_DUP_PRICELIST_LINES); -- 5018856, 5024919
717: IF (QP_GLOBALS.G_CHECK_DUP_PRICELIST_LINES <> 'N' or QP_GLOBALS.G_CHECK_DUP_PRICELIST_LINES IS NULL)
718: THEN --5018856 , 5024919 only log request if not N or null
719: oe_debug_pub.add('about to log a request to check duplicate list lines ');
720:

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

713:
714: end if;
715: */
716: oe_debug_pub.add('G_CHECK_DUP_PRICELIST_LINES is '|| QP_GLOBALS.G_CHECK_DUP_PRICELIST_LINES); -- 5018856, 5024919
717: IF (QP_GLOBALS.G_CHECK_DUP_PRICELIST_LINES <> 'N' or QP_GLOBALS.G_CHECK_DUP_PRICELIST_LINES IS NULL)
718: THEN --5018856 , 5024919 only log request if not N or null
719: oe_debug_pub.add('about to log a request to check duplicate list lines ');
720:
721: QP_DELAYED_REQUESTS_PVT.Log_Request

Line 722: ( p_entity_code => QP_GLOBALS.G_ENTITY_ALL

718: THEN --5018856 , 5024919 only log request if not N or null
719: oe_debug_pub.add('about to log a request to check duplicate list lines ');
720:
721: QP_DELAYED_REQUESTS_PVT.Log_Request
722: ( p_entity_code => QP_GLOBALS.G_ENTITY_ALL
723: , p_entity_id => p_PRICING_ATTR_rec.list_line_id
724: , p_requesting_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR
725: , p_requesting_entity_id => p_PRICING_ATTR_rec.pricing_attribute_id
726: , p_request_type => QP_GLOBALS.G_DUPLICATE_LIST_LINES

Line 724: , p_requesting_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR

720:
721: QP_DELAYED_REQUESTS_PVT.Log_Request
722: ( p_entity_code => QP_GLOBALS.G_ENTITY_ALL
723: , p_entity_id => p_PRICING_ATTR_rec.list_line_id
724: , p_requesting_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR
725: , p_requesting_entity_id => p_PRICING_ATTR_rec.pricing_attribute_id
726: , p_request_type => QP_GLOBALS.G_DUPLICATE_LIST_LINES
727: , p_param1 => l_list_header_id
728: , p_param2 => fnd_date.date_to_canonical(l_start_date_active) --2739511

Line 726: , p_request_type => QP_GLOBALS.G_DUPLICATE_LIST_LINES

722: ( p_entity_code => QP_GLOBALS.G_ENTITY_ALL
723: , p_entity_id => p_PRICING_ATTR_rec.list_line_id
724: , p_requesting_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR
725: , p_requesting_entity_id => p_PRICING_ATTR_rec.pricing_attribute_id
726: , p_request_type => QP_GLOBALS.G_DUPLICATE_LIST_LINES
727: , p_param1 => l_list_header_id
728: , p_param2 => fnd_date.date_to_canonical(l_start_date_active) --2739511
729: , p_param3 => fnd_date.date_to_canonical(l_end_date_active) --2739511
730: , p_param4 => l_revision

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

739:
740: END IF;
741:
742: oe_debug_pub.add('after logging delayed request ');
743: END IF;-- end IF QP_GLOBALS.G_CHECK_DUP_PRICELIST_LINES <> 'N' or null-- 5108856
744:
745: IF (p_Pricing_Attr_rec.pricing_attribute_context IS NOT NULL
746: OR p_Pricing_Attr_rec.pricing_attribute IS NOT NULL
747: OR p_Pricing_Attr_rec.pricing_attr_value_from IS NOT NULL

Line 1259: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1255: l_from_rltd_modifier_id IS NOT NULL
1256: THEN
1257: OE_Debug_Pub.add ( 'Logging delayed request for Price Break Child Line ');
1258: QP_DELAYED_REQUESTS_PVT.Log_Request
1259: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1260: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
1261: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR,
1262: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,
1263: p_request_type => QP_GLOBALS.G_MULTIPLE_PRICE_BREAK_ATTRS,

Line 1261: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR,

1257: OE_Debug_Pub.add ( 'Logging delayed request for Price Break Child Line ');
1258: QP_DELAYED_REQUESTS_PVT.Log_Request
1259: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1260: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
1261: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR,
1262: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,
1263: p_request_type => QP_GLOBALS.G_MULTIPLE_PRICE_BREAK_ATTRS,
1264: p_param1 => l_from_rltd_modifier_id,
1265: x_return_status => l_return_status

Line 1263: p_request_type => QP_GLOBALS.G_MULTIPLE_PRICE_BREAK_ATTRS,

1259: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1260: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
1261: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR,
1262: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,
1263: p_request_type => QP_GLOBALS.G_MULTIPLE_PRICE_BREAK_ATTRS,
1264: p_param1 => l_from_rltd_modifier_id,
1265: x_return_status => l_return_status
1266: );
1267:

Line 1269: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1265: x_return_status => l_return_status
1266: );
1267:
1268: QP_DELAYED_REQUESTS_PVT.Log_Request
1269: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1270: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
1271: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR,
1272: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,
1273: p_request_type => QP_GLOBALS.G_OVERLAPPING_PRICE_BREAKS,

Line 1271: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR,

1267:
1268: QP_DELAYED_REQUESTS_PVT.Log_Request
1269: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1270: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
1271: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR,
1272: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,
1273: p_request_type => QP_GLOBALS.G_OVERLAPPING_PRICE_BREAKS,
1274: p_param1 => l_from_rltd_modifier_id,
1275: p_param2 => l_continuous_price_break_flag,

Line 1273: p_request_type => QP_GLOBALS.G_OVERLAPPING_PRICE_BREAKS,

1269: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1270: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
1271: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR,
1272: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,
1273: p_request_type => QP_GLOBALS.G_OVERLAPPING_PRICE_BREAKS,
1274: p_param1 => l_from_rltd_modifier_id,
1275: p_param2 => l_continuous_price_break_flag,
1276: --Added the param to call the validation
1277: --function depending upon the break type