APPS.OE_BLANKET_PRICING_UTIL dependencies on OE_BLANKET_LINES_EXT

Line 416: update oe_blanket_lines_ext

412: ,last_updated_by = FND_GLOBAL.USER_ID
413: ,last_update_date = sysdate
414: where line_id = l_line_id_tbl(I);
415:
416: update oe_blanket_lines_ext
417: set modifier_list_line_id = l_x_modifiers_tbl(I).list_line_id
418: where line_id = l_line_id_tbl(I);
419:
420: oe_delayed_requests_pvt.g_delayed_requests.delete

Line 656: FROM OE_BLANKET_LINES_EXT

652: IF p_blanket_line_id IS NOT NULL THEN
653:
654: SELECT qp_list_line_id, modifier_list_line_id
655: INTO l_qp_list_line_id, l_mod_list_line_id
656: FROM OE_BLANKET_LINES_EXT
657: WHERE line_id = p_blanket_line_id;
658: -- Check if the QP line exist in the QP tables.
659: -- For the bug #3985489
660: begin

Line 814: from oe_blanket_lines_ext

810: AND p_blanket_line_number IS NOT NULL
811: THEN
812: select line_id
813: into l_blanket_line_id
814: from oe_blanket_lines_ext
815: where order_number = p_blanket_number
816: and line_number = p_blanket_line_number;
817: END IF;
818:

Line 866: from oe_blanket_lines_ext

862: AND p_blanket_line_number IS NOT NULL
863: THEN
864: select qp_list_line_id
865: into l_list_line_id
866: from oe_blanket_lines_ext
867: where order_number = p_blanket_number
868: and line_number = p_blanket_line_number;
869: END IF;
870:

Line 1020: from oe_blanket_lines_ext

1016: ,line_id
1017: into l_released_amount
1018: ,l_returned_amount
1019: ,l_blanket_line_id
1020: from oe_blanket_lines_ext
1021: where order_number = p_blanket_number
1022: and line_number = p_blanket_line_number;
1023: oe_debug_pub.add('current blkt rel amt :'||l_released_amount);
1024: oe_debug_pub.add('current blkt ret amt :'||l_returned_amount);

Line 1102: from oe_blanket_lines_ext

1098: ,line_id
1099: into l_released_quantity
1100: ,l_returned_quantity
1101: ,l_blanket_line_id
1102: from oe_blanket_lines_ext
1103: where order_number = p_blanket_number
1104: and line_number = p_blanket_line_number;
1105: oe_debug_pub.add('current blkt rel qty :'||l_released_quantity);
1106: oe_debug_pub.add('current blkt ret qty :'||l_returned_quantity);