[Home] [Help]
1702: log_message(l_module_name, 'submit request for storing pdf');
1703: savepoint genpdf;
1704: -- revision num is null for amendment record. so no values is
1705: -- selected explicitly
1706: l_pdfFileName := PON_CLM_UTIL_PKG.get_clm_pdf_name(
1707: l_doc_number,
1708: l_src_rev_num,
1709: USERENV('LANG'),
1710: 'BUYER'
2164: l_orig_document_number := l_auction_header_id_orig_round;
2165: end;
2166:
2167: /* Offer Enhancement Project Changes Start */
2168: l_is_document_federal := PON_CLM_UTIL_PKG.IS_NEG_DOCUMENT_FEDERAL(l_auction_header_id_orig_round);
2169:
2170: IF (l_is_document_federal=1) THEN
2171: l_document_number := l_orig_document_number||'('||l_auction_round_number||')';
2172: ELSE
2211: -- Set the output parameter x_document_number with the docuement number
2212: --
2213: --For federal amendment case generate the document number via this API call
2214: IF p_source_orig_amend_id IS NOT NULL THEN
2215: l_is_Federal := PON_CLM_UTIL_PKG.IS_NEG_DOCUMENT_FEDERAL(p_source_orig_amend_id);
2216: LOG_MESSAGE('copy_negotiation','1.1.2.1 is_federal_document : '||l_is_Federal);
2217:
2218: IF ( p_copy_type = g_amend_copy AND l_is_Federal = 1) THEN
2219: BEGIN
3341:
3342: /* Modified for CLM QA bug : 8831577
3343: * Set Revision to zero in case of creating new round/copying active or draft document.
3344: */
3345: IF PON_CLM_UTIL_PKG.IS_DOCUMENT_FEDERAL(p_doc_type_id => p_doctype_id) = 1 THEN
3346: IF p_copy_type = g_conformed_doc_copy THEN
3347: l_Revision_Number := GET_REVISION_NUMBER(p_auction_header_id);
3348: ELSE
3349: IF p_copy_type in (g_new_rnd_copy,g_active_neg_copy,g_draft_neg_copy) THEN
4264: amendments for federal documents
4265: 2. While conforming, attachments in the amendments
4266: should be merged with those in base documents.
4267: */
4268: l_is_federal := PON_CLM_UTIL_PKG.IS_NEG_DOCUMENT_FEDERAL(p_source_auction_header_id);
4269: IF ( p_retain_attachments = 'Y' AND
4270: (l_is_federal = 0 OR p_copy_type <> g_amend_copy)) THEN
4271: -- AND l_attachment_flag(x) = 'Y' ) THEN
4272:
4651: );
4652:
4653: --
4654: --Copy Line UDAs
4655: l_is_Federal := PON_CLM_UTIL_PKG.IS_NEG_DOCUMENT_FEDERAL(p_auction_header_id);
4656:
4657: IF ( l_is_Federal = 1 ) THEN
4658: FOR x IN 1..l_line_number.COUNT LOOP
4659: LOG_MESSAGE('COPY_LINES','Copy Line UDA for '||l_line_number(x));
5858: amendments for federal documents
5859: 2. While conforming, attachments in the amendments
5860: should be merged with those in base documents.
5861: */
5862: l_is_federal := PON_CLM_UTIL_PKG.IS_NEG_DOCUMENT_FEDERAL(p_source_auction_header_id);
5863: IF ( p_retain_attachments = 'Y') THEN
5864: FOR payment_line_rec in c_attachment_pymt_lines LOOP
5865: g_err_loc := '3. before calling copy payments attachments';
5866: LOG_MESSAGE('copy_negotiation','Before copying attachments for payments. Source id =' ||payment_line_rec.source_payment_id);
7877:
7878: BEGIN
7879: -- { Start of COPY_FORM_DATA
7880:
7881: l_is_Federal := PON_CLM_UTIL_PKG.IS_NEG_DOCUMENT_FEDERAL(p_source_auction_header_id);
7882:
7883: BEGIN
7884: -- Get the id of the abstract from pon_forms_sections
7885: SELECT PFS.FORM_ID
8035: WHERE FI.ENTITY_CODE = 'PON_AUCTION_HEADERS_ALL'
8036: AND FI.ENTITY_PK1 = TO_CHAR(p_source_auction_header_id)
8037: AND FI.FORM_ID = FS.FORM_ID
8038: AND FS.STATUS = 'ACTIVE'
8039: AND (PON_CLM_UTIL_PKG.IS_NEG_DOCUMENT_FEDERAL(p_auction_header_id) <>1 OR
8040: FS.FORM_CODE='ABSTRACT'); -- Forms won't be copied for solicitations
8041:
8042: l_has_children NUMBER;
8043: l_orig_parent_field_val_fk NUMBER;
9748: LOG_MESSAGE('copy_lines_and_children','Copy Form and section data is starting');
9749: --
9750: -- Copy the Event Abstract related data
9751: --
9752: l_is_Federal := PON_CLM_UTIL_PKG.IS_NEG_DOCUMENT_FEDERAL(p_source_auction_header_id);
9753: --IF( NOT( l_is_federal = 1 AND ( p_copy_type = g_amend_copy or p_copy_type = g_conformed_doc_copy))) THEN
9754: -- bug 9945940 - removed above IF
9755: -- do not copy abstracts/forms if federal amendment or federal conformed case
9756: COPY_FORM_DATA (
11950: bug 13504088
11951: Do not copy attachments while creating solicitation amendment
11952: While conforming take attachments from amendment + base solicitation
11953: */
11954: l_is_federal := PON_CLM_UTIL_PKG.IS_NEG_DOCUMENT_FEDERAL(p_source_auction_header_id);
11955: --
11956: -- Copy Attachments
11957: --
11958: IF (p_retain_attachments = 'Y' AND