APPS.PO_CLM_UPG_PVT dependencies on PO_HEADERS_DRAFT_ALL

Line 196: FROM po_headers_draft_all poha

192: , l_entity_name_tbl
193: , l_entity_pk2_tbl
194: , l_entity_pk3_tbl
195: , l_entity_pk4_tbl
196: FROM po_headers_draft_all poha
197: WHERE poha.draft_id = l_draft_id_tbl(i);
198:
199:
200: SELECT pola.po_line_id,

Line 339: --update PO_HEADERS_DRAFT_ALL.OLD_AMOUNT_LIMIT

335: p_pk4_tbl => l_entity_pk3_tbl
336: );
337:
338:
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

Line 345: UPDATE PO_HEADERS_DRAFT_ALL phd

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
348: WHERE phb.po_header_id=phd.po_header_id)
349: WHERE phd.draft_id=l_draft_id_tbl(i);

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

346: SET phd.OLD_AMOUNT_LIMIT = ( SELECT phb.AMOUNT_LIMIT
347: FROM PO_HEADERS_ALL phb
348: WHERE phb.po_header_id=phd.po_header_id)
349: WHERE phd.draft_id=l_draft_id_tbl(i);
350: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:Number of Rows Updated PO_HEADERS_DRAFT_ALL'||SQL%ROWCOUNT);
351:
352: UPDATE PO_LINES_DRAFT_ALL phd
353: SET phd.OLD_AMOUNT = ( SELECT phb.AMOUNT
354: FROM PO_LINES_ALL phb