DBA Data[Home] [Help]

APPS.QP_MODIFIERS_UTIL dependencies on QP_PRICING_PHASES

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

4680:
4681: IF ( p_MODIFIERS_rec.operation IN
4682: (OE_GLOBALS.G_OPR_CREATE, OE_GLOBALS.G_OPR_UPDATE)) THEN
4683:
4684: oe_debug_pub.add('request to update QP_PRICING_PHASES '||l_parent_line_type, 1);
4685:
4686: IF p_MODIFIERS_rec.list_line_type_code IN ('RLTD','OID','CIE','TSN','IUE','PRG','FREIGHT_CHARGE')
4687: OR p_MODIFIERS_rec.modifier_level_code = 'LINEGROUP' THEN
4688:

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

4685:
4686: IF p_MODIFIERS_rec.list_line_type_code IN ('RLTD','OID','CIE','TSN','IUE','PRG','FREIGHT_CHARGE')
4687: OR p_MODIFIERS_rec.modifier_level_code = 'LINEGROUP' THEN
4688:
4689: oe_debug_pub.add('Logging a request to update QP_PRICING_PHASES ', 1);
4690: --------------------------------- fix for bug 3756625
4691: l_call_from :=1;
4692: if((p_MODIFIERS_rec.operation) IN(OE_GLOBALS.G_OPR_CREATE)) or
4693: ((p_MODIFIERS_rec.operation) IN(OE_GLOBALS.G_OPR_UPDATE) and

Line 4815: from qp_pricing_phases

4811: select active_flag into l_active_flag from qp_list_headers
4812: where list_header_id = p_MODIFIERS_rec.list_header_id;
4813: if (l_active_flag = 'Y') then
4814: select manual_modifier_flag into l_manual_modifier_flag
4815: from qp_pricing_phases
4816: where pricing_phase_id = p_MODIFIERS_rec.pricing_phase_id;
4817:
4818: if l_manual_modifier_flag is null then
4819: qp_delayed_requests_PVT.log_request(