APPS.PON_NEGOTIATION_COPY_GRP dependencies on PON_FORM_FIELD_VALUES

Line 8055: FROM PON_FORM_FIELD_VALUES

8051: SELECT
8052: COUNT(1)
8053: INTO
8054: l_has_children
8055: FROM PON_FORM_FIELD_VALUES
8056: WHERE FORM_ID = form.FORM_ID
8057: AND OWNING_ENTITY_CODE = 'PON_AUCTION_HEADERS_ALL'
8058: AND ENTITY_PK1 = TO_CHAR(p_source_auction_header_id)
8059: AND PARENT_FIELD_VALUES_FK = -1;

Line 8067: FROM PON_FORM_FIELD_VALUES

8063: SELECT
8064: FORM_FIELD_VALUE_ID
8065: INTO
8066: l_orig_parent_field_val_fk
8067: FROM PON_FORM_FIELD_VALUES
8068: WHERE FORM_ID = form.FORM_ID
8069: AND OWNING_ENTITY_CODE = 'PON_AUCTION_HEADERS_ALL'
8070: AND ENTITY_PK1 = TO_CHAR(p_source_auction_header_id)
8071: AND PARENT_FIELD_VALUES_FK = -1;

Line 8464: FROM PON_FORM_FIELD_VALUES

8460: CREATED_BY ,
8461: LAST_UPDATE_DATE ,
8462: LAST_UPDATED_BY ,
8463: LAST_UPDATE_LOGIN
8464: FROM PON_FORM_FIELD_VALUES
8465: WHERE PARENT_FIELD_VALUES_FK = p_orig_parent_fld_values_fk
8466: AND FORM_ID = p_form_id
8467: AND ENTITY_PK1 = p_old_entity_pk1
8468: AND OWNING_ENTITY_CODE='PON_AUCTION_HEADERS_ALL';

Line 8478: PON_FORM_FIELD_VALUES_S.NEXTVAL

8474: FOR field_value IN c_field_values_cursor LOOP
8475: -- {
8476:
8477: SELECT
8478: PON_FORM_FIELD_VALUES_S.NEXTVAL
8479: INTO
8480: l_new_field_values_fk
8481: FROM DUAL;
8482:

Line 8484: PON_FORM_FIELD_VALUES

8480: l_new_field_values_fk
8481: FROM DUAL;
8482:
8483: INSERT INTO
8484: PON_FORM_FIELD_VALUES
8485: (
8486: FORM_FIELD_VALUE_ID,
8487: FORM_ID,
8488: OWNING_ENTITY_CODE,