APPS.OE_BLANKET_FORM_CONTROL dependencies on OE_BLANKET_LINES

Line 1950: select line_id into dummy_id from oe_blanket_Lines

1946: IS
1947: dummy_id number;
1948: BEGIN
1949:
1950: select line_id into dummy_id from oe_blanket_Lines
1951: where rowid = p_row_id for update;
1952:
1953: END Lock_Line_Row;
1954:

Line 1965: from oe_blanket_lines

1961: l_blanket_line_number number;
1962: BEGIN
1963:
1964: select max(line_number) into l_blanket_line_number
1965: from oe_blanket_lines
1966: where header_id = l_x_header_id;
1967:
1968: g_blanket_line_number :=
1969: greatest(nvl(g_blanket_line_number,0),nvl(l_blanket_line_number,0));

Line 2216: FROM OE_BLANKET_LINES_V bl

2212: , p_x_old_line_rec.LOCK_CONTROL
2213: , p_x_old_line_rec.fulfilled_amount
2214: , p_x_old_line_rec.transaction_phase_code -- hashraf pack J
2215: , p_x_old_line_rec.source_document_version_number
2216: FROM OE_BLANKET_LINES_V bl
2217: WHERE line_id = p_x_line_rec.line_id;
2218:
2219: Exception
2220:

Line 2249: from oe_blanket_lines

2245: else
2246:
2247: begin
2248: select max(line_number) into l_line_number
2249: from oe_blanket_lines
2250: where header_id = p_header_id;
2251: exception
2252: when no_data_found then
2253: l_line_number :=0;