eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_CLM_UPG_PVT dependencies on PO_DRAFTS

Line 170: FROM po_drafts pod,

166:
167: SELECT pod.draft_id
168: BULK COLLECT
169: INTO l_draft_id_tbl
170: FROM po_drafts pod,
171: po_headers_all poh
172: WHERE pod.document_id = poh.po_header_id
173: AND poh.style_id = p_style_id
174: AND pod.draft_type= 'MOD'

Line 186: PO_DRAFTS_PVT.G_LOCK_HEADER_ENTITY ,

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

Line 201: PO_DRAFTS_PVT.G_LOCK_LINE_ENTITY ,

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

Line 227: PO_DRAFTS_PVT.G_LOCK_SHIPMENT_ENTITY ,

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

Line 253: PO_DRAFTS_PVT.G_LOCK_DIST_ENTITY ,

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

Line 279: PO_DRAFTS_PVT.G_LOCK_ADDRESS_ENTITY ,

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

Line 316: --calling PO_DRAFTS_PVT.lock_entities

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 ,

Line 317: PO_DRAFTS_PVT.lock_entities(

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 ,

Line 343: -- PO_DRAFTS.AGENT_ID

339: --update PO_HEADERS_DRAFT_ALL.OLD_AMOUNT_LIMIT
340: -- PO_LINES_DRAFT_ALL.OLD_AMOUNT
341: -- PO_LINE_LOCATIONS_DRAFT_ALL.OLD_AMOUNT
342: -- PO_DISTRIBUTIONS_DRAFT_ALL.OLD_AMOUNT_ORDERED
343: -- PO_DRAFTS.AGENT_ID
344:
345: UPDATE PO_HEADERS_DRAFT_ALL phd
346: SET phd.OLD_AMOUNT_LIMIT = ( SELECT phb.AMOUNT_LIMIT
347: FROM PO_HEADERS_ALL phb

Line 373: UPDATE PO_DRAFTS phd

369: WHERE phb.po_distribution_id= phd.po_distribution_id)
370: WHERE phd.draft_id=l_draft_id_tbl(i);
371: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:Number of Rows Updated PO_DISTRIBUTIONS_DRAFT_ALL'||SQL%ROWCOUNT);
372:
373: UPDATE PO_DRAFTS phd
374: SET phd.AGENT_ID = ( SELECT phb.AGENT_ID
375: FROM PO_HEADERS_ALL phb
376: WHERE phb.po_header_id=phd.document_id)
377: WHERE phd.draft_id=l_draft_id_tbl(i);

Line 378: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:Number of Rows Updated PO_DRAFTS'||SQL%ROWCOUNT);

374: SET phd.AGENT_ID = ( SELECT phb.AGENT_ID
375: FROM PO_HEADERS_ALL phb
376: WHERE phb.po_header_id=phd.document_id)
377: WHERE phd.draft_id=l_draft_id_tbl(i);
378: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:Number of Rows Updated PO_DRAFTS'||SQL%ROWCOUNT);
379:
380: IF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
381: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId: FAILED for draft_id:'||l_draft_id_tbl(i)
382: ||' for style_id:'||p_style_id);

Line 465: PO_DRAFTS_PVT.G_LOCK_HEADER_ATTACH_ENTITY,

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,

Line 496: PO_DRAFTS_PVT.G_LOCK_LINE_ATTACH_ENTITY,

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,

Line 529: PO_DRAFTS_PVT.G_LOCK_SHIPMENT_ATTACH_ENTITY,

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,