eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_COMMUNICATION_PVT dependencies on PO_SYSTEM_PARAMETERS

Line 1345: l_max_attachment_size po_system_parameters_all.max_attachment_size%type;

1341: l_duplicate_filenames varchar2(1); -- holds 'Y' if there are any supplier
1342: -- file attachments with same filename
1343: l_error_flag number; -- determines if the error condition (same file name
1344: -- but different file lengths has been met or not)
1345: l_max_attachment_size po_system_parameters_all.max_attachment_size%type;
1346: l_filename fnd_lobs.file_name%type;
1347: l_filename_new fnd_lobs.file_name%type;
1348: l_length number;
1349: l_length_new number;

Line 3192: l_format po_system_parameters_all.po_output_format%type;

3188:
3189:
3190: function po_communication_profile RETURN VARCHAR2 IS
3191: l_communication varchar2(1);
3192: l_format po_system_parameters_all.po_output_format%type;
3193: BEGIN
3194:
3195: select po_output_format into l_format from po_system_parameters;
3196:

Line 3195: select po_output_format into l_format from po_system_parameters;

3191: l_communication varchar2(1);
3192: l_format po_system_parameters_all.po_output_format%type;
3193: BEGIN
3194:
3195: select po_output_format into l_format from po_system_parameters;
3196:
3197: IF (l_format = 'PDF' ) THEN
3198: RETURN FND_API.G_TRUE;
3199: ELSE

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

4431: -------------------------------------------------------------------------------
4432: --Start of Comments
4433: --Name: get_max_zip_size
4434: --Pre-reqs:
4435: -- Column max_attachment_size should exist in table po_system_parameters_all
4436: -- Org context should be set correctly to enable querying from org striped
4437: -- view po_system_parameters
4438: --Modifies:
4439: -- None.

Line 4437: -- view po_system_parameters

4433: --Name: get_max_zip_size
4434: --Pre-reqs:
4435: -- Column max_attachment_size should exist in table po_system_parameters_all
4436: -- Org context should be set correctly to enable querying from org striped
4437: -- view po_system_parameters
4438: --Modifies:
4439: -- None.
4440: --Locks:
4441: -- None.

Line 4462: l_max_attachment_size po_system_parameters_all.max_attachment_size%type;

4458: --End of Comments
4459: -------------------------------------------------------------------------------
4460: FUNCTION get_max_zip_size (p_itemtype IN VARCHAR2,
4461: p_itemkey IN VARCHAR2) RETURN NUMBER IS
4462: l_max_attachment_size po_system_parameters_all.max_attachment_size%type;
4463: l_progress varchar2(200);
4464: BEGIN
4465: l_progress := 'PO_COMMUNICATION_PVT.get_max_zip_size : Querying max_attachment_size';
4466: IF (g_po_wf_debug = 'Y') THEN

Line 4471: from po_system_parameters psp;

4467: PO_WF_DEBUG_PKG.insert_debug(p_itemtype, p_itemkey, l_progress);
4468: END IF;
4469: select nvl(psp.max_attachment_size, 0)
4470: into l_max_attachment_size
4471: from po_system_parameters psp;
4472: l_progress := 'PO_COMMUNICATION_PVT.get_max_zip_size : maximum attachment size = '|| l_max_attachment_size;
4473: IF (g_po_wf_debug = 'Y') THEN
4474: PO_WF_DEBUG_PKG.insert_debug(p_itemtype, p_itemkey, l_progress);
4475: END IF;

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

7755: -------------------------------------------------------------------------------
7756: --Start of Comments
7757: --Name: getZipFileName
7758: --Pre-reqs:
7759: -- Column EMAIL_ATTACHMENT_FILENAME should exist in table po_system_parameters_all
7760: --Modifies:
7761: -- None.
7762: --Locks:
7763: -- None.

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

7778: -- The function used to construct the zip file name using
7779: -- document type, orgid, document id and revision num as
7780: -- p_document_type||'_'||p_orgid||'_'||l_document_number||'_'||p_revision_num||'.zip';
7781: -- This was changed as per ECO Bug #43877577 to return static string 'Attachments.zip'
7782: -- This was then made a parameter in po_system_parameters_all as per ECO Bug #5069318
7783: --End of Comments
7784: -------------------------------------------------------------------------------
7785: FUNCTION getZIPFileName(p_org_id in number) RETURN VARCHAR2 IS
7786: l_email_attachment_filename po_system_parameters_all.email_attachment_filename%type;

Line 7786: l_email_attachment_filename po_system_parameters_all.email_attachment_filename%type;

7782: -- This was then made a parameter in po_system_parameters_all as per ECO Bug #5069318
7783: --End of Comments
7784: -------------------------------------------------------------------------------
7785: FUNCTION getZIPFileName(p_org_id in number) RETURN VARCHAR2 IS
7786: l_email_attachment_filename po_system_parameters_all.email_attachment_filename%type;
7787: l_progress varchar2(200);
7788: d_progress NUMBER;
7789: d_module VARCHAR2(70) := 'PO_COMMUNICATION_PVT.getZIPFileName';
7790: BEGIN

Line 7798: from po_system_parameters_all psp

7794: END IF;
7795:
7796: select nvl(psp.email_attachment_filename, 'Attachments.zip')
7797: into l_email_attachment_filename
7798: from po_system_parameters_all psp
7799: where org_id = p_org_id;
7800:
7801: d_progress := 10;
7802: IF (PO_LOG.d_proc) THEN