APPS.OE_BLANKET_FORM_CONTROL dependencies on OE_BLANKET_LINES

Line 1961: select line_id into dummy_id from oe_blanket_Lines

1957: IS
1958: dummy_id number;
1959: BEGIN
1960:
1961: select line_id into dummy_id from oe_blanket_Lines
1962: where rowid = p_row_id for update;
1963:
1964: END Lock_Line_Row;
1965:

Line 1976: from oe_blanket_lines

1972: l_blanket_line_number number;
1973: BEGIN
1974:
1975: select max(line_number) into l_blanket_line_number
1976: from oe_blanket_lines
1977: where header_id = l_x_header_id;
1978:
1979: g_blanket_line_number :=
1980: greatest(nvl(g_blanket_line_number,0),nvl(l_blanket_line_number,0));

Line 2227: FROM OE_BLANKET_LINES_V bl

2223: , p_x_old_line_rec.LOCK_CONTROL
2224: , p_x_old_line_rec.fulfilled_amount
2225: , p_x_old_line_rec.transaction_phase_code -- hashraf pack J
2226: , p_x_old_line_rec.source_document_version_number
2227: FROM OE_BLANKET_LINES_V bl
2228: WHERE line_id = p_x_line_rec.line_id;
2229:
2230: Exception
2231:

Line 2260: from oe_blanket_lines

2256: else
2257:
2258: begin
2259: select max(line_number) into l_line_number
2260: from oe_blanket_lines
2261: where header_id = p_header_id;
2262: exception
2263: when no_data_found then
2264: l_line_number :=0;