APPS.PO_AUTOCREATE_PVT dependencies on PO_LINES_DRAFT_ALL

Line 1177: UPDATE po_lines_draft_all

1173: po_log.stmt (d_module, 10, 'p_par_line_tbl '|| p_par_line_tbl(i) );
1174: END IF;
1175:
1176: IF p_par_line_tbl(i) IS NOT NULL THEN
1177: UPDATE po_lines_draft_all
1178: SET DRAFT_LINE_STATUS = 'MOD_CREATED',
1179: mod_draft_id = p_mod_draft_id
1180: WHERE draft_id = p_par_draft_id_tbl(i)
1181: AND po_line_id = p_par_line_tbl(i);

Line 1190: FROM po_lines_draft_all par, po_requisition_lines_all req

1186:
1187: --Update po_line_id in po_requisition_lines_all after mod creation
1188: UPDATE po_requisition_lines_all
1189: SET po_line_id = ( SELECT mod_line_id
1190: FROM po_lines_draft_all par, po_requisition_lines_all req
1191: WHERE req.par_line_id = p_par_line_tbl(i)
1192: AND req.par_line_id = par.po_line_id
1193: AND par.draft_id = p_par_draft_id_tbl(i)
1194: AND par.draft_id = req.par_draft_id

Line 1291: FROM po_lines_draft_all par, po_lines_draft_all mod

1287: WHERE lock_by_draft_id = P_MOD_DRAFT_ID
1288: AND entity_pk1 = P_PO_LINE_ID
1289: AND entity_name = 'PO_LINE')
1290: AND EXISTS (SELECT 'the structure is not same in MOD and PAR'
1291: FROM po_lines_draft_all par, po_lines_draft_all mod
1292: WHERE par.po_line_id = P_PO_LINE_ID
1293: AND par.draft_id = P_PAR_DRAFT_ID
1294: AND mod.po_line_id = par.po_line_id
1295: AND mod.draft_id = P_MOD_DRAFT_ID

Line 1346: UPDATE po_lines_draft_all

1342: PO_LOG.proc_begin(d_module, 'p_par_line_id', p_par_line_id);
1343: PO_LOG.proc_begin(d_module, 'p_mod_line_id', p_mod_line_id);
1344: END IF;
1345:
1346: UPDATE po_lines_draft_all
1347: SET mod_line_id = p_mod_line_id
1348: WHERE po_line_id = p_par_line_id
1349: AND draft_id = p_par_draft_id;
1350:

Line 1474: FROM po_lines_draft_all

1470: IF l_attach_count <> 0
1471: THEN
1472: SELECT mod_line_id
1473: INTO l_mod_line_id
1474: FROM po_lines_draft_all
1475: WHERE draft_id =p_par_draft_id_tbl(i)
1476: AND po_line_id = p_par_line_id_tbl(i);
1477:
1478: IF (po_log.d_stmt) THEN

Line 1588: FROM po_lines_draft_all

1584: INTO l_mod_line_location_id
1585: FROM po_line_locations_draft_all
1586: WHERE draft_id = p_mod_draft_id
1587: AND po_line_id =Nvl((SELECT mod_line_id
1588: FROM po_lines_draft_all
1589: WHERE po_line_id = p_par_line_id_tbl(i)
1590: AND draft_id =p_par_draft_id_tbl(i)), p_par_line_id_tbl(i) )
1591: AND shipment_num = (SELECT shipment_num
1592: FROM po_line_locations_draft_all