APPS.OE_BLANKET_PRICING_UTIL dependencies on OE_BLANKET_LINES_EXT

Line 395: update oe_blanket_lines_ext

391: ,last_updated_by = FND_GLOBAL.USER_ID
392: ,last_update_date = sysdate
393: where line_id = l_line_id_tbl(I);
394:
395: update oe_blanket_lines_ext
396: set modifier_list_line_id = l_x_modifiers_tbl(I).list_line_id
397: where line_id = l_line_id_tbl(I);
398:
399: oe_delayed_requests_pvt.g_delayed_requests.delete

Line 635: FROM OE_BLANKET_LINES_EXT

631: IF p_blanket_line_id IS NOT NULL THEN
632:
633: SELECT qp_list_line_id, modifier_list_line_id
634: INTO l_qp_list_line_id, l_mod_list_line_id
635: FROM OE_BLANKET_LINES_EXT
636: WHERE line_id = p_blanket_line_id;
637: -- Check if the QP line exist in the QP tables.
638: -- For the bug #3985489
639: begin

Line 793: from oe_blanket_lines_ext

789: AND p_blanket_line_number IS NOT NULL
790: THEN
791: select line_id
792: into l_blanket_line_id
793: from oe_blanket_lines_ext
794: where order_number = p_blanket_number
795: and line_number = p_blanket_line_number;
796: END IF;
797:

Line 845: from oe_blanket_lines_ext

841: AND p_blanket_line_number IS NOT NULL
842: THEN
843: select qp_list_line_id
844: into l_list_line_id
845: from oe_blanket_lines_ext
846: where order_number = p_blanket_number
847: and line_number = p_blanket_line_number;
848: END IF;
849:

Line 997: from oe_blanket_lines_ext

993: ,line_id
994: into l_released_amount
995: ,l_returned_amount
996: ,l_blanket_line_id
997: from oe_blanket_lines_ext
998: where order_number = p_blanket_number
999: and line_number = p_blanket_line_number;
1000: oe_debug_pub.add('current blkt rel amt :'||l_released_amount);
1001: oe_debug_pub.add('current blkt ret amt :'||l_returned_amount);

Line 1077: from oe_blanket_lines_ext

1073: ,line_id
1074: into l_released_quantity
1075: ,l_returned_quantity
1076: ,l_blanket_line_id
1077: from oe_blanket_lines_ext
1078: where order_number = p_blanket_number
1079: and line_number = p_blanket_line_number;
1080: oe_debug_pub.add('current blkt rel qty :'||l_released_quantity);
1081: oe_debug_pub.add('current blkt ret qty :'||l_returned_quantity);