APPS.OKC_CREATE_PO_FROM_K_PVT dependencies on PO_LINES_ALL

Line 207: -- po_line_id - primary key in po_lines_all table

203: -- unit_price - Unit price for the line
204: -- list_price_per_unit - List price for the item on the line
205: -- need_by_date - Date the goods are needed by
206: -- interface_line_id - Interface line unique identifier
207: -- po_line_id - primary key in po_lines_all table
208: -------------------------------------------------------------------------
209:
210: TYPE po_lines_rec_type IS RECORD(
211: source_cle_id okc_k_lines_b.id%type,

Line 1457: ,p_po_header_id IN po_lines_all.po_header_id%TYPE

1453: ----------------------------------------------------------------------------
1454:
1455: PROCEDURE insert_po_lines(p_chr_id IN okc_k_headers_b.id%TYPE
1456: ,p_po_lines_tab IN po_lines_tab
1457: ,p_po_header_id IN po_lines_all.po_header_id%TYPE
1458: ,x_return_status OUT NOCOPY VARCHAR2) IS
1459:
1460:
1461: -- Declaration of individual elements to avoid ORA-3113 error because

Line 2178: FROM po_lines_all pol

2174: AND rel.rty_code = g_crj_rty_code -- for K-PO records
2175: AND rel.jtot_object1_code = g_crj_cle_jtot_object_code -- correct jtot object
2176: AND NOT EXISTS (
2177: SELECT null
2178: FROM po_lines_all pol
2179: WHERE rel.object1_id1 = pol.po_header_id
2180: AND rel.object1_id2 = pol.line_num);
2181:
2182: l_sql_rowcount := SQL%ROWCOUNT;

Line 2216: FROM po_lines_all pol

2212:
2213: UPDATE okc_k_rel_objs rel
2214: SET (rel.object1_id1, rel.object1_id2) =
2215: ( SELECT pol.po_line_id, '#'
2216: FROM po_lines_all pol
2217: WHERE pol.po_header_id = rel.object1_id1
2218: AND pol.line_num = rel.object1_id2 )
2219: WHERE chr_id = p_chr_id
2220: AND rel.rty_code = g_crj_rty_code