[Home] [Help]
7895: --
7896: -- STATUS will be same for amendment and multi round
7897: IF ( Nvl(l_is_Federal,0)<>1 AND (p_copy_type = g_amend_copy OR p_copy_type = g_new_rnd_copy) ) THEN
7898:
7899: INSERT INTO PON_FORMS_INSTANCES
7900: ( ENTITY_CODE,
7901: ENTITY_PK1,
7902: FORM_ID,
7903: STATUS,
7921: p_user_id,
7922: p_user_id,
7923: XML_LAST_SENT_DATE
7924: FROM PON_FORMS_SECTIONS FS,
7925: PON_FORMS_INSTANCES FI
7926: WHERE FI.ENTITY_CODE = 'PON_AUCTION_HEADERS_ALL'
7927: AND FI.ENTITY_PK1 = TO_CHAR(p_source_auction_header_id)
7928: AND FI.FORM_ID = FS.FORM_ID
7929: AND FS.STATUS = 'ACTIVE');
7938: --
7939: IF (p_copy_type = g_active_neg_copy OR p_copy_type = g_draft_neg_copy
7940: OR (Nvl(l_is_Federal,0)=1 AND (p_copy_type = g_amend_copy OR p_copy_type = g_new_rnd_copy OR p_copy_type=g_conformed_doc_copy))) THEN
7941:
7942: INSERT INTO PON_FORMS_INSTANCES
7943: ( ENTITY_CODE,
7944: ENTITY_PK1,
7945: FORM_ID,
7946: STATUS,
7963: SYSDATE,
7964: p_user_id,
7965: p_user_id,
7966: NULL
7967: FROM PON_FORMS_INSTANCES FI,
7968: PON_FORMS_SECTIONS FS
7969: WHERE ENTITY_CODE = 'PON_AUCTION_HEADERS_ALL'
7970: AND ENTITY_PK1 = TO_CHAR(p_source_auction_header_id)
7971: AND FI.FORM_ID = FS.FORM_ID
7978: SELECT
7979: COUNT(1)
7980: INTO
7981: l_inactive_sections
7982: FROM PON_FORMS_INSTANCES FI,
7983: PON_FORMS_SECTIONS FS
7984: WHERE FI.ENTITY_CODE = 'PON_AUCTION_HEADERS_ALL'
7985: AND FI.ENTITY_PK1 = TO_CHAR(p_source_auction_header_id)
7986: AND FI.FORM_ID = FS.FORM_ID
8029:
8030: CURSOR c_negotiation_forms IS
8031: SELECT
8032: FI.FORM_ID
8033: FROM PON_FORMS_INSTANCES FI,
8034: PON_FORMS_SECTIONS FS
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