DBA Data[Home] [Help]

APPS.QP_MODIFIERS_UTIL dependencies on QP_PRICING_PHASES

Line 4879: oe_debug_pub.add('request to update QP_PRICING_PHASES '||l_parent_line_type, 1);

4875:
4876: IF ( p_MODIFIERS_rec.operation IN
4877: (OE_GLOBALS.G_OPR_CREATE, OE_GLOBALS.G_OPR_UPDATE)) THEN
4878:
4879: oe_debug_pub.add('request to update QP_PRICING_PHASES '||l_parent_line_type, 1);
4880:
4881: IF p_MODIFIERS_rec.list_line_type_code IN ('RLTD','OID','CIE','TSN','IUE','PRG','FREIGHT_CHARGE')
4882: OR p_MODIFIERS_rec.modifier_level_code = 'LINEGROUP' THEN
4883:

Line 4884: oe_debug_pub.add('Logging a request to update QP_PRICING_PHASES ', 1);

4880:
4881: IF p_MODIFIERS_rec.list_line_type_code IN ('RLTD','OID','CIE','TSN','IUE','PRG','FREIGHT_CHARGE')
4882: OR p_MODIFIERS_rec.modifier_level_code = 'LINEGROUP' THEN
4883:
4884: oe_debug_pub.add('Logging a request to update QP_PRICING_PHASES ', 1);
4885: --------------------------------- fix for bug 3756625
4886: l_call_from :=1;
4887: if((p_MODIFIERS_rec.operation) IN(OE_GLOBALS.G_OPR_CREATE)) or
4888: ((p_MODIFIERS_rec.operation) IN(OE_GLOBALS.G_OPR_UPDATE) and

Line 5010: from qp_pricing_phases

5006: select active_flag into l_active_flag from qp_list_headers
5007: where list_header_id = p_MODIFIERS_rec.list_header_id;
5008: if (l_active_flag = 'Y') then
5009: select manual_modifier_flag into l_manual_modifier_flag
5010: from qp_pricing_phases
5011: where pricing_phase_id = p_MODIFIERS_rec.pricing_phase_id;
5012:
5013: if l_manual_modifier_flag is null then
5014: qp_delayed_requests_PVT.log_request(