APPS.FND_XDFDICTIONARY_PKG dependencies on FND_FOREIGN_KEY_COLUMNS

Line 1191: from fnd_foreign_key_columns

1187:
1188: -- Check foreign key column
1189: cnt := 0;
1190: select count(*) into cnt
1191: from fnd_foreign_key_columns
1192: where application_id = appl_id
1193: and table_id = tab_id
1194: and column_id = col_id;
1195: if (cnt > 0) then

Line 1370: -- Remove foreign key from FND_FOREIGN_KEYS and FND_FOREIGN_KEY_COLUMNS table.

1366: end RemovePrimaryKey;
1367:
1368: --
1369: -- RemoveForeignKey (PUBLIC)
1370: -- Remove foreign key from FND_FOREIGN_KEYS and FND_FOREIGN_KEY_COLUMNS table.
1371: --
1372: procedure RemoveForeignKey(
1373: x_application_short_name in varchar2,
1374: x_table_name in varchar2,

Line 1423: delete from fnd_foreign_key_columns

1419: return;
1420: end;
1421:
1422: -- Nothing pointing to foreign key so is safe to delete
1423: delete from fnd_foreign_key_columns
1424: where application_id = appl_id
1425: and table_id = tab_id
1426: and foreign_key_id = fk_id;
1427:

Line 3022: delete from FND_FOREIGN_KEY_COLUMNS

3018:
3019: -- Bug3230044 Delete any child records with a negative
3020: -- value for COLUMN_ID.
3021:
3022: delete from FND_FOREIGN_KEY_COLUMNS
3023: where APPLICATION_ID = appl_id
3024: and TABLE_ID = tab_id
3025: and FOREIGN_KEY_ID = fk_id
3026: and COLUMN_ID < 0;

Line 3034: update FND_FOREIGN_KEY_COLUMNS

3030: -- and COLUMN_ID values to a negative value in order to
3031: -- prevent unique constraints while processing the
3032: -- PARENT/CHILD entity.
3033:
3034: update FND_FOREIGN_KEY_COLUMNS
3035: set FOREIGN_KEY_SEQUENCE = -1 * FOREIGN_KEY_SEQUENCE,
3036: COLUMN_ID = -1 * COLUMN_ID
3037: where APPLICATION_ID = appl_id
3038: and TABLE_ID = tab_id

Line 3043: update FND_FOREIGN_KEY_COLUMNS

3039: and FOREIGN_KEY_ID = fk_id;
3040:
3041: /*Bug3139883 - Handle special case where FOREIGN_KEY_SEQUENCE = 0 */
3042:
3043: update FND_FOREIGN_KEY_COLUMNS
3044: set FOREIGN_KEY_SEQUENCE = -1000
3045: where APPLICATION_ID = appl_id
3046: and TABLE_ID = tab_id
3047: and FOREIGN_KEY_ID = fk_id

Line 3086: from fnd_foreign_key_columns

3082: -- and the file entity.
3083:
3084: select max(last_update_date)
3085: into child_db_ludate
3086: from fnd_foreign_key_columns
3087: where application_id = appl_id
3088: and table_id = tab_id
3089: and foreign_key_id = fk_id
3090: and foreign_key_sequence < 0

Line 3097: from fnd_foreign_key_columns

3093: -- Bug3139883 changed select to also include value if foreign_key_sequence =0
3094:
3095: select max(last_update_date)
3096: into child_file_ludate
3097: from fnd_foreign_key_columns
3098: where application_id = appl_id
3099: and table_id = tab_id
3100: and foreign_key_id = fk_id
3101: and foreign_key_sequence >= 0

Line 3120: from fnd_foreign_key_columns

3116:
3117: -- If any non-seed owners, set owner to user
3118: select max(-1)
3119: into child_db_luby
3120: from fnd_foreign_key_columns
3121: where application_id = appl_id
3122: and table_id = tab_id
3123: and foreign_key_id = fk_id
3124: and foreign_key_sequence < 0

Line 3135: from fnd_foreign_key_columns

3131:
3132: -- If any non-seed owners, set owner to user
3133: select max(-1)
3134: into child_file_luby
3135: from fnd_foreign_key_columns
3136: where application_id = appl_id
3137: and table_id = tab_id
3138: and foreign_key_id = fk_id
3139: and foreign_key_sequence > 0

Line 3154: delete from fnd_foreign_key_columns

3150:
3151: -- The new child entity rows from the data file are kept so
3152: -- delete the existing db child entity rows.
3153:
3154: delete from fnd_foreign_key_columns
3155: where application_id = appl_id
3156: and table_id = tab_id
3157: and foreign_key_id = fk_id
3158: and foreign_key_sequence < 0

Line 3167: delete from fnd_foreign_key_columns

3163: -- The existing db child entity rows are kept so delete the new child
3164: -- entity rows from the data file
3165: -- Bug3139883 - Modified delete to include the value column_sequence = 0
3166:
3167: delete from fnd_foreign_key_columns
3168: where application_id = appl_id
3169: and table_id = tab_id
3170: and foreign_key_id = fk_id
3171: and foreign_key_sequence >= 0

Line 3178: update FND_FOREIGN_KEY_COLUMNS

3174: -- Rename the existing db entity rows back to normal since
3175: -- it was not replaced by the new child entity rows
3176: -- from the data file.
3177:
3178: update FND_FOREIGN_KEY_COLUMNS
3179: set FOREIGN_KEY_SEQUENCE = -1 * FOREIGN_KEY_SEQUENCE,
3180: COLUMN_ID = -1 * COLUMN_ID
3181: where APPLICATION_ID = appl_id
3182: and TABLE_ID = tab_id

Line 3187: update FND_FOREIGN_KEY_COLUMNS

3183: and FOREIGN_KEY_ID = fk_id;
3184:
3185: /*Bug3139883 - Handle special case where FOREIGN_KEY_SEQUENCE = 0 */
3186:
3187: update FND_FOREIGN_KEY_COLUMNS
3188: set FOREIGN_KEY_SEQUENCE = 0
3189: where APPLICATION_ID = appl_id
3190: and TABLE_ID = tab_id
3191: and FOREIGN_KEY_ID = fk_id

Line 3207: update FND_FOREIGN_KEY_COLUMNS

3203: -- Rename the existing db entity rows back to normal since
3204: -- it was not replaced by the new child entity rows
3205: -- from the data file.
3206:
3207: update FND_FOREIGN_KEY_COLUMNS
3208: set FOREIGN_KEY_SEQUENCE = -1 * FOREIGN_KEY_SEQUENCE,
3209: COLUMN_ID = -1 * COLUMN_ID
3210: where APPLICATION_ID = appl_id
3211: and TABLE_ID = tab_id

Line 3216: update FND_FOREIGN_KEY_COLUMNS

3212: and FOREIGN_KEY_ID = fk_id;
3213:
3214: /*Bug3139883 - Handle special case where FOREIGN_KEY_SEQUENCE = 0 */
3215:
3216: update FND_FOREIGN_KEY_COLUMNS
3217: set FOREIGN_KEY_SEQUENCE = 0
3218: where APPLICATION_ID = appl_id
3219: and TABLE_ID = tab_id
3220: and FOREIGN_KEY_ID = fk_id

Line 3295: insert into FND_FOREIGN_KEY_COLUMNS(

3291: -- updated into the database based on the date and custom factirs.
3292:
3293:
3294: begin
3295: insert into FND_FOREIGN_KEY_COLUMNS(
3296: APPLICATION_ID,
3297: TABLE_ID,
3298: FOREIGN_KEY_ID,
3299: COLUMN_ID,