DBA Data[Home] [Help]

APPS.QP_MODIFIERS_UTIL dependencies on QP_LIST_LINES

Line 2316: l_MODIFIERS_rec QP_LIST_LINES%rowtype;

2312: l_status NUMBER;
2313: l_modifier_grp_type varchar2(30) := 'NOVAL';
2314: l_list_line_id NUMBER;
2315: l_list_line_type_code VARCHAR2(30);
2316: l_MODIFIERS_rec QP_LIST_LINES%rowtype;
2317:
2318: Cursor C_child_records(l_list_line_id number) IS
2319: SELECT *
2320: FROM QP_LIST_LINES qll

Line 2320: FROM QP_LIST_LINES qll

2316: l_MODIFIERS_rec QP_LIST_LINES%rowtype;
2317:
2318: Cursor C_child_records(l_list_line_id number) IS
2319: SELECT *
2320: FROM QP_LIST_LINES qll
2321: WHERE qll.list_line_id IN
2322: (select to_rltd_modifier_id from
2323: qp_rltd_modifiers qrm where
2324: from_rltd_modifier_id = l_list_line_id);

Line 2347: update qp_list_lines set

2343:
2344: oe_debug_pub.add('update child lines'||to_char(p_MODIFIERS_rec.list_line_id));
2345:
2346: --fix for bug 1407684 unique index on list_line_no
2347: update qp_list_lines set
2348: -- list_line_no = p_MODIFIERS_rec.list_line_no
2349: modifier_level_code = p_MODIFIERS_rec.modifier_level_code
2350: ,automatic_flag = p_MODIFIERS_rec.automatic_flag
2351: ,override_flag = p_MODIFIERS_rec.override_flag

Line 2390: update qp_list_lines set

2386: --get or related records
2387:
2388:
2389: --fix for bug 1407684 unique index on list_line_no
2390: update qp_list_lines set
2391: -- list_line_no = p_MODIFIERS_rec.list_line_no
2392: modifier_level_code = p_MODIFIERS_rec.modifier_level_code
2393: ,automatic_flag = p_MODIFIERS_rec.automatic_flag
2394: ,override_flag = p_MODIFIERS_rec.override_flag

Line 2498: FROM QP_LIST_HEADERS_B a,QP_LIST_LINES b

2494: /* Accumulation Start */
2495: BEGIN
2496: SELECT ACTIVE_FLAG
2497: INTO l_active_flag
2498: FROM QP_LIST_HEADERS_B a,QP_LIST_LINES b
2499: WHERE b.list_line_id=p_MODIFIERS_rec.list_line_id
2500: AND b.LIST_HEADER_ID = a.list_header_id;
2501: EXCEPTION
2502: WHEN NO_DATA_FOUND THEN

Line 2508: UPDATE QP_LIST_LINES

2504: END;
2505: /* Accumulation End */
2506:
2507:
2508: UPDATE QP_LIST_LINES
2509: SET ARITHMETIC_OPERATOR = p_MODIFIERS_rec.arithmetic_operator
2510: , ATTRIBUTE1 = p_MODIFIERS_rec.attribute1
2511: , ATTRIBUTE10 = p_MODIFIERS_rec.attribute10
2512: , ATTRIBUTE11 = p_MODIFIERS_rec.attribute11

Line 2714: INSERT INTO QP_LIST_LINES

2710: NULL;
2711: END;
2712: /* Accumulation End */
2713:
2714: INSERT INTO QP_LIST_LINES
2715: ( ARITHMETIC_OPERATOR
2716: , ATTRIBUTE1
2717: , ATTRIBUTE10
2718: , ATTRIBUTE11

Line 3001: DELETE FROM QP_LIST_LINES

2997:
2998: DELETE FROM QP_RLTD_MODIFIERS
2999: WHERE TO_RLTD_MODIFIER_ID = p_list_line_id;
3000:
3001: DELETE FROM QP_LIST_LINES
3002: WHERE LIST_LINE_ID = p_list_line_id ;
3003:
3004: oe_debug_pub.add('END Delete_Row in QPXUMLLB');
3005:

Line 3138: FROM QP_LIST_LINES

3134: , ACCUM_ATTRIBUTE
3135: , CONTINUOUS_PRICE_BREAK_FLAG
3136: , SERVICE_DURATION
3137: , SERVICE_PERIOD
3138: FROM QP_LIST_LINES
3139: WHERE ( LIST_LINE_ID = p_list_line_id)
3140: UNION -- Changed for the bug#2715150
3141: SELECT ARITHMETIC_OPERATOR
3142: , ATTRIBUTE1

Line 3228: FROM QP_LIST_LINES

3224: , ACCUM_ATTRIBUTE
3225: , CONTINUOUS_PRICE_BREAK_FLAG
3226: , SERVICE_DURATION
3227: , SERVICE_PERIOD
3228: FROM QP_LIST_LINES
3229: WHERE ( LIST_HEADER_ID = p_list_header_id );
3230:
3231:
3232: BEGIN

Line 3610: FROM QP_LIST_LINES

3606: , l_MODIFIERS_rec.accum_attribute
3607: , l_MODIFIERS_rec.continuous_price_break_flag
3608: , l_MODIFIERS_rec.service_duration
3609: , l_MODIFIERS_rec.service_period
3610: FROM QP_LIST_LINES
3611: WHERE LIST_LINE_ID = p_MODIFIERS_rec.list_line_id
3612: FOR UPDATE NOWAIT;
3613:
3614: /* display debug messages only when OE_LOCK_ROW issue occurs

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

4838: , x_MODIFIERS_rec OUT NOCOPY QP_Modifiers_PUB.MODIFIERS_rec_Type
4839: ) IS
4840: l_Modifiers_rec QP_MODIFIERS_PUB.MODIFIERS_rec_Type := p_MODIFIERS_rec;
4841: l_return_status varchar2(30);
4842: l_parent_line_type QP_LIST_LINES.LIST_LINE_TYPE_CODE%TYPE := 'NONE';
4843: l_count NUMBER ;
4844: l_active_flag VARCHAR2(1) ;
4845: l_call_from NUMBER;
4846:

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

4933: select active_flag into l_active_flag from qp_list_headers_b
4934: where list_header_id =p_MODIFIERS_rec.list_header_id;
4935: if l_active_flag ='Y' then
4936: begin
4937: select count(*) into l_count from qp_list_lines qll
4938: where automatic_flag = p_old_MODIFIERS_rec.automatic_flag and
4939: pricing_phase_id = p_MODIFIERS_rec.pricing_phase_id;
4940: exception
4941: when no_data_found then