APPS.QP_DELAYED_REQUESTS_UTIL dependencies on QP_PRICING_PHASES

Line 1918: l_Pricing_Phase_id QP_PRICING_PHASES.PRICING_PHASE_ID%TYPE

1914: ( x_return_status OUT NOCOPY Varchar2
1915: , p_List_Line_ID IN NUMBER
1916: ) IS
1917:
1918: l_Pricing_Phase_id QP_PRICING_PHASES.PRICING_PHASE_ID%TYPE
1919: := FND_API.G_MISS_NUM;
1920: l_List_Header_ID QP_LIST_HEADERS_B.LIST_HEADER_ID%TYPE
1921: := FND_API.G_MISS_NUM;
1922:

Line 2025: update qp_pricing_phases PH set

2021: END IF;
2022:
2023: -- oe_debug_pub.add('update_pricing_phase l_line '||l_line||' l_rltd '||l_rltd||' l_level '||l_level);
2024:
2025: update qp_pricing_phases PH set
2026: PH.oid_exists = decode(l_line,'N',PH.oid_exists,'Y',l_line)
2027: , PH.rltd_exists = decode(l_rltd,'N',PH.rltd_exists,'Y',l_rltd)
2028: , PH.line_group_exists =
2029: decode(l_level,'N',PH.line_group_exists,'Y',l_level)

Line 2095: from qp_pricing_phases

2091: oe_debug_pub.add('Automatic Flag : '||p_automatic_flag);
2092:
2093: l_set_manual_flag := NULL;
2094: select manual_modifier_flag into l_manual_modifier_flag
2095: from qp_pricing_phases
2096: where pricing_phase_id = p_pricing_phase_id;
2097:
2098: IF nvl(l_manual_modifier_flag, '*') = 'A' then
2099: IF p_automatic_flag = 'N' then

Line 2121: update qp_pricing_phases

2117: if l_set_manual_flag is not NULL
2118: AND ( l_manual_modifier_flag IS NULL --bug 14367359
2119: OR l_manual_modifier_flag <> l_set_manual_flag) --bug 14367359
2120: then
2121: update qp_pricing_phases
2122: set manual_modifier_flag = l_set_manual_flag
2123: where pricing_phase_id = p_pricing_phase_id;
2124: end if;
2125: