APPS.PO_COMMUNICATION_PVT dependencies on PO_DRAFTS

Line 7538: l_po_number po_drafts.modification_number%type;

7534: p_language_code varchar2,
7535: p_extension varchar2,
7536: p_is_conf_doc varchar2 default 'N') RETURN varchar2 IS
7537:
7538: l_po_number po_drafts.modification_number%type;
7539: l_language_code fnd_languages.language_code%type;
7540: l_api_name CONSTANT VARCHAR2(25) := 'PDFFileName';
7541: l_file_name fnd_lobs.file_name%type;
7542: l_revision_num po_drafts.revision_num%type;

Line 7542: l_revision_num po_drafts.revision_num%type;

7538: l_po_number po_drafts.modification_number%type;
7539: l_language_code fnd_languages.language_code%type;
7540: l_api_name CONSTANT VARCHAR2(25) := 'PDFFileName';
7541: l_file_name fnd_lobs.file_name%type;
7542: l_revision_num po_drafts.revision_num%type;
7543: l_progress VARCHAR2(3);
7544: /* Begin Add By Akyanama Bug # 13342437*/
7545: l_release_num po_releases_all.release_num%type;
7546: /* End Add By Akyanama Bug # 13342437*/

Line 7582: FROM po_drafts

7578: FROM po_headers_all ph
7579: WHERE po_header_id = p_document_id ;
7580: ELSE --CLM
7581: SELECT modification_number into l_po_number
7582: FROM po_drafts
7583: WHERE draft_id = p_draft_id;
7584: END IF; --CLM
7585: ELSE
7586: /* Begin Edit By Akyanama Bug # 13342437*/