APPS.PO_DOCUMENT_ACTION_UTIL dependencies on PO_DRAFTS

Line 1075: -- CLM Apprvl-- for Modification the status is recorded in the po_drafts.status column.

1071: THEN
1072:
1073: d_progress := 60;
1074:
1075: -- CLM Apprvl-- for Modification the status is recorded in the po_drafts.status column.
1076: IF p_draft_id IS NOT NULL AND p_draft_id <> -1 THEN
1077: SELECT NVL(poh.status, 'DRAFT'),
1078: poh.creation_date,
1079: poh.revision_num

Line 1924: UPDATE PO_DRAFTS

1920: DECODE(poh.acceptance_required_flag, 'S', 'Y', 'N'),
1921: poh.pending_signature_flag)
1922: WHERE poh.po_header_id = p_document_id
1923: AND poh.draft_id = p_draft_id;*/
1924: UPDATE PO_DRAFTS
1925: SET status = decode(p_new_status,'APPROVED','COMPLETED',p_new_status)
1926: WHERE draft_id = p_draft_id;
1927: ELSE
1928:

Line 2062: FROM po_drafts

2058: -1, (SELECT clm_document_number
2059: FROM po_headers_all poh
2060: WHERE poh.po_header_id = p_document_id),
2061: (SELECT modification_number
2062: FROM po_drafts
2063: WHERE document_id = p_document_id
2064: AND draft_id = p_draft_id)),
2065: last_update_date = SYSDATE,
2066: last_update_login = p_login_id,