APPS.PON_NEGOTIATION_COPY_GRP dependencies on PON_FORMS_INSTANCES

Line 6741: INSERT INTO PON_FORMS_INSTANCES

6737: -- STATUS will be same for amendment and multi round
6738: --
6739: IF (p_copy_type = g_amend_copy OR p_copy_type = g_new_rnd_copy) THEN
6740:
6741: INSERT INTO PON_FORMS_INSTANCES
6742: ( ENTITY_CODE,
6743: ENTITY_PK1,
6744: FORM_ID,
6745: STATUS,

Line 6767: PON_FORMS_INSTANCES FI

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
6771: AND FS.STATUS = 'ACTIVE');

Line 6782: INSERT INTO PON_FORMS_INSTANCES

6778: -- 2. for Draff Negotiation Copy STATUS will be NOT_ENTERED
6779: --
6780: IF (p_copy_type = g_active_neg_copy OR p_copy_type = g_draft_neg_copy) THEN
6781:
6782: INSERT INTO PON_FORMS_INSTANCES
6783: ( ENTITY_CODE,
6784: ENTITY_PK1,
6785: FORM_ID,
6786: STATUS,

Line 6807: FROM PON_FORMS_INSTANCES FI,

6803: SYSDATE,
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

Line 6820: FROM PON_FORMS_INSTANCES FI,

6816: SELECT
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

Line 6867: FROM PON_FORMS_INSTANCES FI,

6863:
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