APPS.PON_NEGOTIATION_COPY_GRP dependencies on PON_FORMS_SECTIONS

Line 6725: -- Get the id of the abstract from pon_forms_sections

6721: BEGIN
6722: -- { Start of COPY_FORM_DATA
6723:
6724: BEGIN
6725: -- Get the id of the abstract from pon_forms_sections
6726: SELECT PFS.FORM_ID
6727: INTO l_abstract_id
6728: FROM PON_FORMS_SECTIONS PFS
6729: WHERE PFS.FORM_CODE='ABSTRACT';

Line 6728: FROM PON_FORMS_SECTIONS PFS

6724: BEGIN
6725: -- Get the id of the abstract from pon_forms_sections
6726: SELECT PFS.FORM_ID
6727: INTO l_abstract_id
6728: FROM PON_FORMS_SECTIONS PFS
6729: WHERE PFS.FORM_CODE='ABSTRACT';
6730:
6731: EXCEPTION WHEN OTHERS THEN
6732: l_abstract_id := -1;

Line 6766: FROM PON_FORMS_SECTIONS FS,

6762: SYSDATE,
6763: p_user_id,
6764: p_user_id,
6765: XML_LAST_SENT_DATE
6766: FROM PON_FORMS_SECTIONS FS,
6767: PON_FORMS_INSTANCES FI
6768: WHERE FI.ENTITY_CODE = 'PON_AUCTION_HEADERS_ALL'
6769: AND FI.ENTITY_PK1 = TO_CHAR(p_source_auction_header_id)
6770: AND FI.FORM_ID = FS.FORM_ID

Line 6808: PON_FORMS_SECTIONS FS

6804: p_user_id,
6805: p_user_id,
6806: NULL
6807: FROM PON_FORMS_INSTANCES FI,
6808: PON_FORMS_SECTIONS FS
6809: WHERE ENTITY_CODE = 'PON_AUCTION_HEADERS_ALL'
6810: AND ENTITY_PK1 = TO_CHAR(p_source_auction_header_id)
6811: AND FI.FORM_ID = FS.FORM_ID
6812: AND FS.STATUS = 'ACTIVE');

Line 6821: PON_FORMS_SECTIONS FS

6817: COUNT(1)
6818: INTO
6819: l_inactive_sections
6820: FROM PON_FORMS_INSTANCES FI,
6821: PON_FORMS_SECTIONS FS
6822: WHERE FI.ENTITY_CODE = 'PON_AUCTION_HEADERS_ALL'
6823: AND FI.ENTITY_PK1 = TO_CHAR(p_source_auction_header_id)
6824: AND FI.FORM_ID = FS.FORM_ID
6825: AND FS.STATUS = 'INACTIVE';

Line 6868: PON_FORMS_SECTIONS FS

6864: CURSOR c_negotiation_forms IS
6865: SELECT
6866: FI.FORM_ID
6867: FROM PON_FORMS_INSTANCES FI,
6868: PON_FORMS_SECTIONS FS
6869: WHERE FI.ENTITY_CODE = 'PON_AUCTION_HEADERS_ALL'
6870: AND FI.ENTITY_PK1 = TO_CHAR(p_source_auction_header_id)
6871: AND FI.FORM_ID = FS.FORM_ID
6872: AND FS.STATUS = 'ACTIVE';