7788: d_progress NUMBER;
7789: d_module VARCHAR2(70) := 'PO_COMMUNICATION_PVT.getZIPFileName';
7790: BEGIN
7791: d_progress := 0;
7792: IF (PO_LOG.d_proc) THEN
7793: PO_LOG.proc_begin(d_module);
7794: END IF;
7795:
7796: select nvl(psp.email_attachment_filename, 'Attachments.zip')
7789: d_module VARCHAR2(70) := 'PO_COMMUNICATION_PVT.getZIPFileName';
7790: BEGIN
7791: d_progress := 0;
7792: IF (PO_LOG.d_proc) THEN
7793: PO_LOG.proc_begin(d_module);
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
7803: PO_LOG.proc_begin(d_module, 'Email Attachment Filename', l_email_attachment_filename);
7804: PO_LOG.proc_end(d_module);
7805: END IF;
7806: return l_email_attachment_filename;
7799: where org_id = p_org_id;
7800:
7801: d_progress := 10;
7802: IF (PO_LOG.d_proc) THEN
7803: PO_LOG.proc_begin(d_module, 'Email Attachment Filename', l_email_attachment_filename);
7804: PO_LOG.proc_end(d_module);
7805: END IF;
7806: return l_email_attachment_filename;
7807: Exception
7800:
7801: d_progress := 10;
7802: IF (PO_LOG.d_proc) THEN
7803: PO_LOG.proc_begin(d_module, 'Email Attachment Filename', l_email_attachment_filename);
7804: PO_LOG.proc_end(d_module);
7805: END IF;
7806: return l_email_attachment_filename;
7807: Exception
7808: when others then
7805: END IF;
7806: return l_email_attachment_filename;
7807: Exception
7808: when others then
7809: IF (PO_LOG.d_exc) THEN
7810: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
7811: END IF;
7812: END getZIPFileName;
7813:
7806: return l_email_attachment_filename;
7807: Exception
7808: when others then
7809: IF (PO_LOG.d_exc) THEN
7810: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
7811: END IF;
7812: END getZIPFileName;
7813:
7814: --bug:346361
8164: BEGIN
8165:
8166: d_progress := 0;
8167:
8168: IF (PO_LOG.d_proc) THEN
8169: PO_LOG.proc_begin(d_module);
8170: PO_LOG.proc_begin(d_module, 'p_document_id', p_document_id);
8171: PO_LOG.proc_begin(d_module, 'p_revision_num', p_revision_num);
8172: PO_LOG.proc_begin(d_module, 'p_which_tables', p_which_tables);
8165:
8166: d_progress := 0;
8167:
8168: IF (PO_LOG.d_proc) THEN
8169: PO_LOG.proc_begin(d_module);
8170: PO_LOG.proc_begin(d_module, 'p_document_id', p_document_id);
8171: PO_LOG.proc_begin(d_module, 'p_revision_num', p_revision_num);
8172: PO_LOG.proc_begin(d_module, 'p_which_tables', p_which_tables);
8173: END IF;
8166: d_progress := 0;
8167:
8168: IF (PO_LOG.d_proc) THEN
8169: PO_LOG.proc_begin(d_module);
8170: PO_LOG.proc_begin(d_module, 'p_document_id', p_document_id);
8171: PO_LOG.proc_begin(d_module, 'p_revision_num', p_revision_num);
8172: PO_LOG.proc_begin(d_module, 'p_which_tables', p_which_tables);
8173: END IF;
8174:
8167:
8168: IF (PO_LOG.d_proc) THEN
8169: PO_LOG.proc_begin(d_module);
8170: PO_LOG.proc_begin(d_module, 'p_document_id', p_document_id);
8171: PO_LOG.proc_begin(d_module, 'p_revision_num', p_revision_num);
8172: PO_LOG.proc_begin(d_module, 'p_which_tables', p_which_tables);
8173: END IF;
8174:
8175:
8168: IF (PO_LOG.d_proc) THEN
8169: PO_LOG.proc_begin(d_module);
8170: PO_LOG.proc_begin(d_module, 'p_document_id', p_document_id);
8171: PO_LOG.proc_begin(d_module, 'p_revision_num', p_revision_num);
8172: PO_LOG.proc_begin(d_module, 'p_which_tables', p_which_tables);
8173: END IF;
8174:
8175:
8176: IF (p_which_tables = 'MAIN') THEN
8202: d_progress := 30;
8203:
8204: END IF;
8205:
8206: IF (PO_LOG.d_stmt) THEN
8207: PO_LOG.stmt(d_module, d_progress, 'l_is_complex', l_is_complex);
8208: END IF;
8209:
8210: IF (l_is_complex) THEN
8203:
8204: END IF;
8205:
8206: IF (PO_LOG.d_stmt) THEN
8207: PO_LOG.stmt(d_module, d_progress, 'l_is_complex', l_is_complex);
8208: END IF;
8209:
8210: IF (l_is_complex) THEN
8211: g_is_complex_work_po := 'Y';
8214: END IF;
8215:
8216: d_progress := 50;
8217:
8218: IF (PO_LOG.d_proc) THEN
8219: PO_LOG.stmt(d_module, d_progress, 'g_is_complex_work_po', g_is_complex_work_po);
8220: PO_LOG.proc_end(d_module);
8221: END IF;
8222:
8215:
8216: d_progress := 50;
8217:
8218: IF (PO_LOG.d_proc) THEN
8219: PO_LOG.stmt(d_module, d_progress, 'g_is_complex_work_po', g_is_complex_work_po);
8220: PO_LOG.proc_end(d_module);
8221: END IF;
8222:
8223: EXCEPTION
8216: d_progress := 50;
8217:
8218: IF (PO_LOG.d_proc) THEN
8219: PO_LOG.stmt(d_module, d_progress, 'g_is_complex_work_po', g_is_complex_work_po);
8220: PO_LOG.proc_end(d_module);
8221: END IF;
8222:
8223: EXCEPTION
8224: WHEN OTHERS THEN
8221: END IF;
8222:
8223: EXCEPTION
8224: WHEN OTHERS THEN
8225: IF (PO_LOG.d_exc) THEN
8226: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
8227: END IF;
8228: g_is_complex_work_po := 'N';
8229: END setIsComplexWorkPO;
8222:
8223: EXCEPTION
8224: WHEN OTHERS THEN
8225: IF (PO_LOG.d_exc) THEN
8226: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
8227: END IF;
8228: g_is_complex_work_po := 'N';
8229: END setIsComplexWorkPO;
8230:
8252: INTO l_inventory_org_id
8253: FROM FINANCIALS_SYSTEM_PARAMETERS;
8254: EXCEPTION
8255: WHEN OTHERS THEN
8256: IF (PO_LOG.d_exc) THEN
8257: PO_LOG.exc('PO_COMMUNICATION_PVT.getInventoryOrgId', 0, SQLCODE || SQLERRM);
8258: END IF;
8259: l_inventory_org_id := null;
8260: END;
8253: FROM FINANCIALS_SYSTEM_PARAMETERS;
8254: EXCEPTION
8255: WHEN OTHERS THEN
8256: IF (PO_LOG.d_exc) THEN
8257: PO_LOG.exc('PO_COMMUNICATION_PVT.getInventoryOrgId', 0, SQLCODE || SQLERRM);
8258: END IF;
8259: l_inventory_org_id := null;
8260: END;
8261: return l_inventory_org_id;