DBA Data[Home] [Help]

APPS.QP_PRICING_ATTR_UTIL dependencies on QP_DELAYED_REQUESTS_PVT

Line 690: qp_delayed_requests_PVT.log_request(

686: END IF;
687:
688: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.list_line_id,p_old_PRICING_ATTR_rec.list_line_id)
689: THEN
690: qp_delayed_requests_PVT.log_request(
691: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
692: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
693: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,
694: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,

Line 707: qp_delayed_requests_PVT.log_request(

703:
704: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_context,p_old_PRICING_ATTR_rec.pricing_attribute_context)
705: THEN
706: -- mkarya for bug 1789276, log the request for a change in pricing_attribute_context
707: qp_delayed_requests_PVT.log_request(
708: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
709: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
710: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,
711: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,

Line 764: qp_delayed_requests_PVT.log_request(

760:
761: IF NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_attribute_context,p_old_PRICING_ATTR_rec.product_attribute_context)
762: THEN
763: -- mkarya for bug 1789276, log the request for a change in product_attribute_context
764: qp_delayed_requests_PVT.log_request(
765: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
766: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
767: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,
768: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,

Line 809: qp_delayed_requests_pvt.log_request(

805: -- NULL;
806: --pattern
807: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
808: IF (p_PRICING_ATTR_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
809: qp_delayed_requests_pvt.log_request(
810: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
811: p_entity_id => p_PRICING_ATTR_rec.list_header_id,
812: p_request_unique_key1 => p_PRICING_ATTR_rec.list_line_id,
813: p_request_unique_key2 => 'UD',

Line 825: qp_delayed_requests_pvt.log_request(

821: -- jagan's PL/SQL pattern
822: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
823: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'M' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'P' THEN
824: IF (p_PRICING_ATTR_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
825: qp_delayed_requests_pvt.log_request(
826: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
827: p_entity_id => p_PRICING_ATTR_rec.list_header_id,
828: p_request_unique_key1 => p_PRICING_ATTR_rec.list_line_id,
829: p_request_unique_key2 => 'UD',

Line 1579: qp_delayed_requests_PVT.log_request(

1575:
1576: --Log delayed request to maintain denormalized pricing attrs columns only
1577: --for formula factor attrs
1578: IF l_list_line_type_code = 'PMR' THEN
1579: qp_delayed_requests_PVT.log_request(
1580: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1581: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
1582: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_Modifiers,
1583: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,

Line 1827: qp_delayed_requests_PVT.log_request(

1823: AND b.prc_context_code=p_PRICING_ATTR_rec.product_attribute_context);
1824:
1825: END IF;
1826: END IF;
1827: qp_delayed_requests_PVT.log_request(
1828: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1829: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
1830: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_Modifiers,
1831: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,

Line 1850: qp_delayed_requests_PVT.log_request(

1846:
1847: --Log delayed request to maintain denormalized pricing attrs columns
1848: --only for formula factor attrs
1849: IF l_list_line_type_code = 'PMR' THEN
1850: qp_delayed_requests_PVT.log_request(
1851: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1852: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
1853: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_Modifiers,
1854: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,

Line 1894: qp_delayed_requests_PVT.log_request(

1890: WHERE PRICING_ATTRIBUTE_ID = p_pricing_attribute_id
1891: RETURNING LIST_LINE_ID INTO l_list_line_id
1892: ;
1893:
1894: qp_delayed_requests_PVT.log_request(
1895: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1896: p_entity_id => l_list_line_id,
1897: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_Modifiers,
1898: p_requesting_entity_id => l_list_line_id,

Line 2917: qp_delayed_requests_pvt.log_request(

2913: l_changed_lines := 'N';
2914: end;
2915:
2916: if l_changed_lines = 'Y' then
2917: qp_delayed_requests_pvt.log_request(
2918: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
2919: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
2920: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
2921: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,

Line 2932: qp_delayed_requests_PVT.log_request(

2928: end if;
2929: end if;
2930:
2931:
2932: qp_delayed_requests_PVT.log_request(
2933: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
2934: p_entity_id => p_PRICING_ATTR_rec.list_line_id,
2935: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,
2936: p_requesting_entity_id => p_PRICING_ATTR_rec.list_line_id,

Line 2943: qp_delayed_requests_pvt.log_request(

2939: END IF;
2940: -- pattern
2941: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
2942: IF (p_PRICING_ATTR_rec.operation = OE_GLOBALS.G_OPR_CREATE) THEN
2943: qp_delayed_requests_pvt.log_request(
2944: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
2945: p_entity_id => l_list_header_id,
2946: p_request_unique_key1 => p_PRICING_ATTR_rec.list_line_id,
2947: p_request_unique_key2 => 'I',

Line 2955: qp_delayed_requests_pvt.log_request(

2951: x_return_status => l_return_status);
2952:
2953: END IF;
2954: IF ( p_PRICING_ATTR_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
2955: qp_delayed_requests_pvt.log_request(
2956: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
2957: p_entity_id => p_PRICING_ATTR_rec.list_header_id,
2958: p_request_unique_key1 => p_PRICING_ATTR_rec.list_line_id,
2959: p_request_unique_key2 => 'U',

Line 2966: qp_delayed_requests_pvt.log_request(

2962: p_request_type => QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN,
2963: x_return_status => l_return_status);
2964: END IF;
2965: IF ( p_PRICING_ATTR_rec.operation = OE_GLOBALS.G_OPR_DELETE) THEN
2966: qp_delayed_requests_pvt.log_request(
2967: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
2968: p_entity_id => p_PRICING_ATTR_rec.list_header_id,
2969: p_request_unique_key1 => p_PRICING_ATTR_rec.list_line_id,
2970: p_request_unique_key2 => 'D',

Line 2982: qp_delayed_requests_pvt.log_request(

2978: -- jagan's PL/SQL pattern
2979: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
2980: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'M' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'P' THEN
2981: IF (p_PRICING_ATTR_rec.operation = OE_GLOBALS.G_OPR_CREATE) THEN
2982: qp_delayed_requests_pvt.log_request(
2983: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
2984: p_entity_id => l_list_header_id,
2985: p_request_unique_key1 => p_PRICING_ATTR_rec.list_line_id,
2986: p_request_unique_key2 => 'I',

Line 2994: qp_delayed_requests_pvt.log_request(

2990: x_return_status => l_return_status);
2991:
2992: END IF;
2993: IF ( p_PRICING_ATTR_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
2994: qp_delayed_requests_pvt.log_request(
2995: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
2996: p_entity_id => p_PRICING_ATTR_rec.list_header_id,
2997: p_request_unique_key1 => p_PRICING_ATTR_rec.list_line_id,
2998: p_request_unique_key2 => 'U',

Line 3005: qp_delayed_requests_pvt.log_request(

3001: p_request_type => QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN,
3002: x_return_status => l_return_status);
3003: END IF;
3004: IF ( p_PRICING_ATTR_rec.operation = OE_GLOBALS.G_OPR_DELETE) THEN
3005: qp_delayed_requests_pvt.log_request(
3006: p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
3007: p_entity_id => p_PRICING_ATTR_rec.list_header_id,
3008: p_request_unique_key1 => p_PRICING_ATTR_rec.list_line_id,
3009: p_request_unique_key2 => 'D',