APPS.QP_MODIFIERS_UTIL dependencies on QP_LIST_LINES

Line 2245: l_MODIFIERS_rec QP_LIST_LINES%rowtype;

2241: l_status NUMBER;
2242: l_modifier_grp_type varchar2(30) := 'NOVAL';
2243: l_list_line_id NUMBER;
2244: l_list_line_type_code VARCHAR2(30);
2245: l_MODIFIERS_rec QP_LIST_LINES%rowtype;
2246:
2247: Cursor C_child_records(l_list_line_id number) IS
2248: SELECT *
2249: FROM QP_LIST_LINES qll

Line 2249: FROM QP_LIST_LINES qll

2245: l_MODIFIERS_rec QP_LIST_LINES%rowtype;
2246:
2247: Cursor C_child_records(l_list_line_id number) IS
2248: SELECT *
2249: FROM QP_LIST_LINES qll
2250: WHERE qll.list_line_id IN
2251: (select to_rltd_modifier_id from
2252: qp_rltd_modifiers qrm where
2253: from_rltd_modifier_id = l_list_line_id);

Line 2276: update qp_list_lines set

2272:
2273: oe_debug_pub.add('update child lines'||to_char(p_MODIFIERS_rec.list_line_id));
2274:
2275: --fix for bug 1407684 unique index on list_line_no
2276: update qp_list_lines set
2277: -- list_line_no = p_MODIFIERS_rec.list_line_no
2278: modifier_level_code = p_MODIFIERS_rec.modifier_level_code
2279: ,automatic_flag = p_MODIFIERS_rec.automatic_flag
2280: ,override_flag = p_MODIFIERS_rec.override_flag

Line 2319: update qp_list_lines set

2315: --get or related records
2316:
2317:
2318: --fix for bug 1407684 unique index on list_line_no
2319: update qp_list_lines set
2320: -- list_line_no = p_MODIFIERS_rec.list_line_no
2321: modifier_level_code = p_MODIFIERS_rec.modifier_level_code
2322: ,automatic_flag = p_MODIFIERS_rec.automatic_flag
2323: ,override_flag = p_MODIFIERS_rec.override_flag

Line 2427: FROM QP_LIST_HEADERS_B a,QP_LIST_LINES b

2423: /* Accumulation Start */
2424: BEGIN
2425: SELECT ACTIVE_FLAG
2426: INTO l_active_flag
2427: FROM QP_LIST_HEADERS_B a,QP_LIST_LINES b
2428: WHERE b.list_line_id=p_MODIFIERS_rec.list_line_id
2429: AND b.LIST_HEADER_ID = a.list_header_id;
2430: EXCEPTION
2431: WHEN NO_DATA_FOUND THEN

Line 2437: UPDATE QP_LIST_LINES

2433: END;
2434: /* Accumulation End */
2435:
2436:
2437: UPDATE QP_LIST_LINES
2438: SET ARITHMETIC_OPERATOR = p_MODIFIERS_rec.arithmetic_operator
2439: , ATTRIBUTE1 = p_MODIFIERS_rec.attribute1
2440: , ATTRIBUTE10 = p_MODIFIERS_rec.attribute10
2441: , ATTRIBUTE11 = p_MODIFIERS_rec.attribute11

Line 2641: INSERT INTO QP_LIST_LINES

2637: NULL;
2638: END;
2639: /* Accumulation End */
2640:
2641: INSERT INTO QP_LIST_LINES
2642: ( ARITHMETIC_OPERATOR
2643: , ATTRIBUTE1
2644: , ATTRIBUTE10
2645: , ATTRIBUTE11

Line 2924: DELETE FROM QP_LIST_LINES

2920:
2921: DELETE FROM QP_RLTD_MODIFIERS
2922: WHERE TO_RLTD_MODIFIER_ID = p_list_line_id;
2923:
2924: DELETE FROM QP_LIST_LINES
2925: WHERE LIST_LINE_ID = p_list_line_id ;
2926:
2927: oe_debug_pub.add('END Delete_Row in QPXUMLLB');
2928:

Line 3059: FROM QP_LIST_LINES

3055: , QUALIFICATION_IND
3056: , NET_AMOUNT_FLAG
3057: , ACCUM_ATTRIBUTE
3058: , CONTINUOUS_PRICE_BREAK_FLAG
3059: FROM QP_LIST_LINES
3060: WHERE ( LIST_LINE_ID = p_list_line_id)
3061: UNION -- Changed for the bug#2715150
3062: SELECT ARITHMETIC_OPERATOR
3063: , ATTRIBUTE1

Line 3147: FROM QP_LIST_LINES

3143: , QUALIFICATION_IND
3144: , NET_AMOUNT_FLAG
3145: , ACCUM_ATTRIBUTE
3146: , CONTINUOUS_PRICE_BREAK_FLAG
3147: FROM QP_LIST_LINES
3148: WHERE ( LIST_HEADER_ID = p_list_header_id );
3149:
3150:
3151: BEGIN

Line 3523: FROM QP_LIST_LINES

3519: , l_MODIFIERS_rec.proration_type_code
3520: , l_MODIFIERS_rec.include_on_returns_flag
3521: , l_MODIFIERS_rec.accum_attribute
3522: , l_MODIFIERS_rec.continuous_price_break_flag
3523: FROM QP_LIST_LINES
3524: WHERE LIST_LINE_ID = p_MODIFIERS_rec.list_line_id
3525: FOR UPDATE NOWAIT;
3526:
3527: oe_debug_pub.add('list_line_id:'||l_MODIFIERS_rec.list_line_id||':'||p_MODIFIERS_rec.list_line_id);

Line 4665: l_parent_line_type QP_LIST_LINES.LIST_LINE_TYPE_CODE%TYPE := 'NONE';

4661: , x_MODIFIERS_rec OUT NOCOPY QP_Modifiers_PUB.MODIFIERS_rec_Type
4662: ) IS
4663: l_Modifiers_rec QP_MODIFIERS_PUB.MODIFIERS_rec_Type := p_MODIFIERS_rec;
4664: l_return_status varchar2(30);
4665: l_parent_line_type QP_LIST_LINES.LIST_LINE_TYPE_CODE%TYPE := 'NONE';
4666: l_count NUMBER ;
4667: l_active_flag VARCHAR2(1) ;
4668: l_call_from NUMBER;
4669:

Line 4742: select count(*) into l_count from qp_list_lines qll

4738: select active_flag into l_active_flag from qp_list_headers_b
4739: where list_header_id =p_MODIFIERS_rec.list_header_id;
4740: if l_active_flag ='Y' then
4741: begin
4742: select count(*) into l_count from qp_list_lines qll
4743: where automatic_flag = p_old_MODIFIERS_rec.automatic_flag and
4744: pricing_phase_id = p_MODIFIERS_rec.pricing_phase_id;
4745: exception
4746: when no_data_found then