APPS.QP_DELAYED_REQUESTS_UTIL dependencies on QP_PRICING_PHASES

Line 1910: l_Pricing_Phase_id QP_PRICING_PHASES.PRICING_PHASE_ID%TYPE

1906: ( x_return_status OUT NOCOPY Varchar2
1907: , p_List_Line_ID IN NUMBER
1908: ) IS
1909:
1910: l_Pricing_Phase_id QP_PRICING_PHASES.PRICING_PHASE_ID%TYPE
1911: := FND_API.G_MISS_NUM;
1912: l_List_Header_ID QP_LIST_HEADERS_B.LIST_HEADER_ID%TYPE
1913: := FND_API.G_MISS_NUM;
1914:

Line 2017: update qp_pricing_phases PH set

2013: END IF;
2014:
2015: -- oe_debug_pub.add('update_pricing_phase l_line '||l_line||' l_rltd '||l_rltd||' l_level '||l_level);
2016:
2017: update qp_pricing_phases PH set
2018: PH.oid_exists = decode(l_line,'N',PH.oid_exists,'Y',l_line)
2019: , PH.rltd_exists = decode(l_rltd,'N',PH.rltd_exists,'Y',l_rltd)
2020: , PH.line_group_exists =
2021: decode(l_level,'N',PH.line_group_exists,'Y',l_level)

Line 2087: from qp_pricing_phases

2083: oe_debug_pub.add('Automatic Flag : '||p_automatic_flag);
2084:
2085: l_set_manual_flag := NULL;
2086: select manual_modifier_flag into l_manual_modifier_flag
2087: from qp_pricing_phases
2088: where pricing_phase_id = p_pricing_phase_id;
2089:
2090: IF nvl(l_manual_modifier_flag, '*') = 'A' then
2091: IF p_automatic_flag = 'N' then

Line 2110: update qp_pricing_phases

2106: l_set_manual_flag := 'M';
2107: END IF;
2108: END IF;
2109: if l_set_manual_flag is not NULL then
2110: update qp_pricing_phases
2111: set manual_modifier_flag = l_set_manual_flag
2112: where pricing_phase_id = p_pricing_phase_id;
2113: end if;
2114: