DBA Data[Home] [Help]

APPS.POR_UTIL_PKG dependencies on PO_REQ_LINES_EXT_B

Line 1404: delete from PO_REQ_LINES_EXT_B where requisition_line_id = p_origLineIds(idx);

1400:
1401:
1402: l_progress := '200';
1403: FOR idx IN 1..p_tempLineIds.COUNT loop
1404: delete from PO_REQ_LINES_EXT_B where requisition_line_id = p_origLineIds(idx);
1405:
1406: l_progress := '210';
1407:
1408: UPDATE PO_REQ_LINES_EXT_B

Line 1408: UPDATE PO_REQ_LINES_EXT_B

1404: delete from PO_REQ_LINES_EXT_B where requisition_line_id = p_origLineIds(idx);
1405:
1406: l_progress := '210';
1407:
1408: UPDATE PO_REQ_LINES_EXT_B
1409: SET requisition_line_id = p_origLineIds(idx)
1410: WHERE requisition_line_id = p_tempLineIds(idx);
1411: END LOOP;
1412:

Line 3805: (SELECT extension_id FROM po_req_lines_ext_b

3801: l_log_msg := 'Starting create_req_line_from_po_line';
3802:
3803: BEGIN
3804: SELECT 'Y' INTO l_are_udas_already_present FROM dual WHERE EXISTS
3805: (SELECT extension_id FROM po_req_lines_ext_b
3806: WHERE REQUISITION_LINE_ID = p_req_line_id);
3807: EXCEPTION
3808: WHEN no_data_found THEN
3809: l_are_udas_already_present := 'N';