APPS.PO_COMMUNICATION_PVT dependencies on PO_SYSTEM_PARAMETERS_ALL

Line 1134: l_max_attachment_size po_system_parameters_all.max_attachment_size%type;

1130: l_duplicate_filenames varchar2(1); -- holds 'Y' if there are any supplier
1131: -- file attachments with same filename
1132: l_error_flag number; -- determines if the error condition (same file name
1133: -- but different file lengths has been met or not)
1134: l_max_attachment_size po_system_parameters_all.max_attachment_size%type;
1135: l_filename fnd_lobs.file_name%type;
1136: l_filename_new fnd_lobs.file_name%type;
1137: l_length number;
1138: l_length_new number;

Line 2801: l_format po_system_parameters_all.po_output_format%type;

2797:
2798:
2799: function po_communication_profile RETURN VARCHAR2 IS
2800: l_communication varchar2(1);
2801: l_format po_system_parameters_all.po_output_format%type;
2802: BEGIN
2803:
2804: select po_output_format into l_format from po_system_parameters;
2805:

Line 3881: -- Column max_attachment_size should exist in table po_system_parameters_all

3877: -------------------------------------------------------------------------------
3878: --Start of Comments
3879: --Name: get_max_zip_size
3880: --Pre-reqs:
3881: -- Column max_attachment_size should exist in table po_system_parameters_all
3882: -- Org context should be set correctly to enable querying from org striped
3883: -- view po_system_parameters
3884: --Modifies:
3885: -- None.

Line 3908: l_max_attachment_size po_system_parameters_all.max_attachment_size%type;

3904: --End of Comments
3905: -------------------------------------------------------------------------------
3906: FUNCTION get_max_zip_size (p_itemtype IN VARCHAR2,
3907: p_itemkey IN VARCHAR2) RETURN NUMBER IS
3908: l_max_attachment_size po_system_parameters_all.max_attachment_size%type;
3909: l_progress varchar2(200);
3910: BEGIN
3911: l_progress := 'PO_COMMUNICATION_PVT.get_max_zip_size : Querying max_attachment_size';
3912: IF (g_po_wf_debug = 'Y') THEN

Line 6567: -- Column EMAIL_ATTACHMENT_FILENAME should exist in table po_system_parameters_all

6563: -------------------------------------------------------------------------------
6564: --Start of Comments
6565: --Name: getZipFileName
6566: --Pre-reqs:
6567: -- Column EMAIL_ATTACHMENT_FILENAME should exist in table po_system_parameters_all
6568: --Modifies:
6569: -- None.
6570: --Locks:
6571: -- None.

Line 6590: -- This was then made a parameter in po_system_parameters_all as per ECO Bug #5069318

6586: -- The function used to construct the zip file name using
6587: -- document type, orgid, document id and revision num as
6588: -- p_document_type||'_'||p_orgid||'_'||l_document_number||'_'||p_revision_num||'.zip';
6589: -- This was changed as per ECO Bug #43877577 to return static string 'Attachments.zip'
6590: -- This was then made a parameter in po_system_parameters_all as per ECO Bug #5069318
6591: --End of Comments
6592: -------------------------------------------------------------------------------
6593: FUNCTION getZIPFileName(p_org_id in number) RETURN VARCHAR2 IS
6594: l_email_attachment_filename po_system_parameters_all.email_attachment_filename%type;

Line 6594: l_email_attachment_filename po_system_parameters_all.email_attachment_filename%type;

6590: -- This was then made a parameter in po_system_parameters_all as per ECO Bug #5069318
6591: --End of Comments
6592: -------------------------------------------------------------------------------
6593: FUNCTION getZIPFileName(p_org_id in number) RETURN VARCHAR2 IS
6594: l_email_attachment_filename po_system_parameters_all.email_attachment_filename%type;
6595: l_progress varchar2(200);
6596: d_progress NUMBER;
6597: d_module VARCHAR2(70) := 'PO_COMMUNICATION_PVT.getZIPFileName';
6598: BEGIN

Line 6606: from po_system_parameters_all psp

6602: END IF;
6603:
6604: select nvl(psp.email_attachment_filename,'Attachments.zip')
6605: into l_email_attachment_filename
6606: from po_system_parameters_all psp
6607: where org_id = p_org_id;
6608:
6609: d_progress := 10;
6610: IF (PO_LOG.d_proc) THEN