APPS.PO_DOC_NUMBERING_PKG dependencies on PO_DRAFTS

Line 5148: UPDATE po_drafts

5144: WHERE po_header_id = p_po_header_id
5145: AND draft_id = p_po_draft_id
5146: AND attr_group_id = l_attr_group_id;
5147:
5148: UPDATE po_drafts
5149: SET modification_number = l_doc_number
5150: WHERE draft_id = p_po_draft_id;
5151:
5152: --UCA Changes CLMR 4 changes Begin.

Line 5413: FROM po_drafts

5409: l_mod_sequence_number NUMBER;
5410: BEGIN
5411: SELECT MODIFICATION_NUMBER
5412: INTO l_latest_mod_number
5413: FROM po_drafts
5414: WHERE DRAFT_ID = (SELECT Max(DRAFT_ID)
5415: FROM po_drafts
5416: WHERE DOCUMENT_ID = p_document_id);
5417:

Line 5415: FROM po_drafts

5411: SELECT MODIFICATION_NUMBER
5412: INTO l_latest_mod_number
5413: FROM po_drafts
5414: WHERE DRAFT_ID = (SELECT Max(DRAFT_ID)
5415: FROM po_drafts
5416: WHERE DOCUMENT_ID = p_document_id);
5417:
5418: --If a Modification already exists for the document
5419: l_seperator_position := instr(l_latest_mod_number, '-');