APPS.PO_MOD_UTIL_PVT dependencies on PO_DRAFTS

Line 316: UPDATE PO_DRAFTS

312: l_dradt_id := p_doc_id;
313:
314: -- The following code is invoked if change description is generated
315: IF(p_changeDescGenerated = 'Y') THEN
316: UPDATE PO_DRAFTS
317: SET CHANGEDESCRIPTION_DATA = p_changedescription,
318: CD_EDITBYUSER_FLAG = p_editbyuserflag,
319: CD_GENERATED_DATE = SYSDATE,
320: CD_GENERATED_FLAG = p_changeDescGenerated,

Line 326: UPDATE PO_DRAFTS

322: WHERE DRAFT_ID=l_dradt_id;
323: END IF;
324: -- The following code is invoked if change description is saved
325: IF(p_changeDescGenerated = 'N') THEN
326: UPDATE PO_DRAFTS
327: SET CHANGEDESCRIPTION_DATA = p_changedescription,
328: CD_EDITBYUSER_FLAG = p_editbyuserflag
329: WHERE DRAFT_ID=l_dradt_id;
330: END IF;

Line 365: FROM po_drafts WHERE draft_id = l_dradt_id;

361: -- being used by the Mod Updated After Change Description generated checkbox
362:
363: SELECT MODUPDATED_AFTERCDGENERATED
364: INTO l_ismodupdated
365: FROM po_drafts WHERE draft_id = l_dradt_id;
366:
367: IF(l_ismodupdated IS NOT NULL) THEN
368: RETURN l_ismodupdated;
369: ELSE

Line 373: po_drafts

369: ELSE
370: SELECT Count(*)
371: INTO l_count
372: FROM
373: po_drafts
374: WHERE draft_id = l_dradt_id
375: AND CD_GENERATED_DATE IS NOT NULL
376: AND po_core_s.get_last_update_date_for_mod(draft_id) > CD_GENERATED_DATE;
377: