APPS.QP_PRICE_LIST_LINE_UTIL dependencies on QP_RLTD_MODIFIERS

Line 2088: from qp_rltd_modifiers

2084: L_LINE_TYPE_CODE VARCHAR2(30) := NULL;
2085:
2086: cursor get_rltd_mods(line_id in number) is
2087: select from_rltd_modifier_id, to_rltd_modifier_id
2088: from qp_rltd_modifiers
2089: where from_rltd_modifier_id = line_id;
2090:
2091:
2092: BEGIN

Line 2100: else delete all references of this line in qp_rltd_modifiers */

2096: FROM QP_LIST_LINES
2097: WHERE LIST_LINE_ID = p_list_line_id;
2098:
2099: /* delete all the related modifier lines if the line is a PBH,
2100: else delete all references of this line in qp_rltd_modifiers */
2101:
2102: IF L_LINE_TYPE_CODE = 'PBH' THEN
2103:
2104: for get_rltd_mods_rec in get_rltd_mods(p_list_line_id) loop

Line 2110: DELETE FROM QP_RLTD_MODIFIERS

2106: QP_PRICE_LIST_LINE_UTIL.DELETE_ROW(get_rltd_mods_rec.to_rltd_modifier_id);
2107:
2108: end loop;
2109:
2110: DELETE FROM QP_RLTD_MODIFIERS
2111: WHERE FROM_RLTD_MODIFIER_ID = p_list_line_id;
2112:
2113: ELSE
2114:

Line 2115: DELETE FROM QP_RLTD_MODIFIERS

2111: WHERE FROM_RLTD_MODIFIER_ID = p_list_line_id;
2112:
2113: ELSE
2114:
2115: DELETE FROM QP_RLTD_MODIFIERS
2116: WHERE TO_RLTD_MODIFIER_ID = p_list_line_id;
2117:
2118: END IF; /* done with related modifier lines */
2119:

Line 2444: FROM QP_RLTD_MODIFIERS

2440: , l_PRICE_LIST_LINE_rec.rltd_modifier_grp_type
2441: , l_PRICE_LIST_LINE_rec.from_rltd_modifier_id
2442: , l_PRICE_LIST_LINE_rec.to_rltd_modifier_id
2443: , l_PRICE_LIST_LINE_rec.rltd_modifier_id
2444: FROM QP_RLTD_MODIFIERS
2445: WHERE ( TO_RLTD_MODIFIER_ID = l_implicit_rec.LIST_LINE_ID );
2446:
2447: EXCEPTION
2448: WHEN NO_DATA_FOUND THEN

Line 2548: FROM QP_RLTD_MODIFIERS

2544: , l_PRICE_LIST_LINE_rec.rltd_modifier_grp_type
2545: , l_PRICE_LIST_LINE_rec.from_rltd_modifier_id
2546: , l_PRICE_LIST_LINE_rec.to_rltd_modifier_id
2547: , l_PRICE_LIST_LINE_rec.rltd_modifier_id
2548: FROM QP_RLTD_MODIFIERS
2549: WHERE ( TO_RLTD_MODIFIER_ID = l_implicit_rec.LIST_LINE_ID );
2550:
2551: EXCEPTION
2552: WHEN NO_DATA_FOUND THEN