182:
183: FOR i IN 1 .. l_draft_id_tbl.COUNT LOOP
184:
185: SELECT poha.po_header_id ,
186: PO_DRAFTS_PVT.G_LOCK_HEADER_ENTITY ,
187: null,
188: null,
189: null
190: BULK COLLECT
197: WHERE poha.draft_id = l_draft_id_tbl(i);
198:
199:
200: SELECT pola.po_line_id,
201: PO_DRAFTS_PVT.G_LOCK_LINE_ENTITY ,
202: null,
203: null,
204: null
205: BULK COLLECT
223: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:Update Lines END');
224: --end
225:
226: SELECT polla.line_location_id ,
227: PO_DRAFTS_PVT.G_LOCK_SHIPMENT_ENTITY ,
228: null,
229: null,
230: null
231: BULK COLLECT
249: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:Update SHIPMENT End');
250: --end
251:
252: SELECT pod.po_distribution_id,
253: PO_DRAFTS_PVT.G_LOCK_DIST_ENTITY ,
254: null,
255: null,
256: null
257: BULK COLLECT
275: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:Update DISTRIBUTION End');
276: --end
277:
278: SELECT phbd.po_header_id ,
279: PO_DRAFTS_PVT.G_LOCK_ADDRESS_ENTITY ,
280: phbd.c_ext_attr39,
281: null,
282: null
283: BULK COLLECT
312: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:l_entity_pk3_tbl('||i||')'||l_entity_pk3_tbl(i));
313: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:l_entity_pk4_tbl('||i||')'||l_entity_pk4_tbl(i));
314: END LOOP;
315:
316: --calling PO_DRAFTS_PVT.lock_entities
317: PO_DRAFTS_PVT.lock_entities(
318: p_entity_name_tbl => l_entity_name_tbl,
319: p_draft_id => l_draft_id_tbl(i) ,
320: p_pk1_tbl => l_entity_pk1_tbl ,
313: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:l_entity_pk4_tbl('||i||')'||l_entity_pk4_tbl(i));
314: END LOOP;
315:
316: --calling PO_DRAFTS_PVT.lock_entities
317: PO_DRAFTS_PVT.lock_entities(
318: p_entity_name_tbl => l_entity_name_tbl,
319: p_draft_id => l_draft_id_tbl(i) ,
320: p_pk1_tbl => l_entity_pk1_tbl ,
321: p_pk2_tbl => l_entity_pk2_tbl ,
461: created_by
462: )
463: VALUES(
464: po_entity_locks_s.NEXTVAL,
465: PO_DRAFTS_PVT.G_LOCK_HEADER_ATTACH_ENTITY,
466: p_pk1_tbl(itr),
467: l_rec.attached_document_id,
468: p_draft_id,
469: l_attachment_lock_type,
492: created_by
493: )
494: VALUES(
495: po_entity_locks_s.NEXTVAL,
496: PO_DRAFTS_PVT.G_LOCK_LINE_ATTACH_ENTITY,
497: p_pk1_tbl(itr),
498: l_rec.attached_document_id,
499: p_draft_id,
500: l_attachment_lock_type,
525: created_by
526: )
527: VALUES(
528: po_entity_locks_s.NEXTVAL,
529: PO_DRAFTS_PVT.G_LOCK_SHIPMENT_ATTACH_ENTITY,
530: p_pk1_tbl(itr),
531: l_rec.attached_document_id,
532: p_draft_id,
533: l_attachment_lock_type,