[Home] [Help]
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
7886: INTO l_abstract_id
7887: FROM PON_FORMS_SECTIONS PFS
7888: WHERE PFS.FORM_CODE='ABSTRACT';
7883: BEGIN
7884: -- Get the id of the abstract from pon_forms_sections
7885: SELECT PFS.FORM_ID
7886: INTO l_abstract_id
7887: FROM PON_FORMS_SECTIONS PFS
7888: WHERE PFS.FORM_CODE='ABSTRACT';
7889:
7890: EXCEPTION WHEN OTHERS THEN
7891: l_abstract_id := -1;
7920: SYSDATE,
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
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
7972: AND FS.STATUS = 'ACTIVE'
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
7987: AND FS.STATUS = 'INACTIVE'
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
8038: AND FS.STATUS = 'ACTIVE'