APPS.FND_DICTIONARY_PKG dependencies on FND_VIEW_COLUMNS

Line 1498: -- Remove view from FND_VIEWS and FND_VIEW_COLUMNS table.

1494: end RemoveSequence;
1495:
1496: --
1497: -- RemoveView (PUBLIC)
1498: -- Remove view from FND_VIEWS and FND_VIEW_COLUMNS table.
1499: --
1500: procedure RemoveView(
1501: x_application_short_name in varchar2,
1502: x_view_name in varchar2) is

Line 1537: delete from fnd_view_columns

1533: return;
1534: end;
1535:
1536: -- Nothing pointing to view, so is safe to delete
1537: delete from fnd_view_columns
1538: where application_id = appl_id
1539: and view_id = vw_id;
1540:
1541: delete from fnd_views

Line 3434: update FND_VIEW_COLUMNS

3430: -- BUG2631776 rename the child record's COLUMN_SEQUENCE
3431: -- and COLUMN_NAME to in order to prevent unique
3432: -- constraints while processing the PARENT/CHILD entity.
3433:
3434: update FND_VIEW_COLUMNS
3435: set COLUMN_SEQUENCE = -1 * COLUMN_SEQUENCE,
3436: COLUMN_NAME = decode(instr(COLUMN_NAME,'_'),0,concat('#',COLUMN_NAME),
3437: replace(COLUMN_NAME, '_','#'))
3438: where APPLICATION_ID = appl_id

Line 3468: from fnd_view_columns

3464: -- and the file entity.
3465:
3466: select max(last_update_date)
3467: into child_db_ludate
3468: from fnd_view_columns
3469: where application_id = appl_id
3470: and VIEW_ID = vw_id
3471: and column_sequence < 0;
3472:

Line 3475: from fnd_view_columns

3471: and column_sequence < 0;
3472:
3473: select max(last_update_date)
3474: into child_file_ludate
3475: from fnd_view_columns
3476: where application_id = appl_id
3477: and VIEW_ID = vw_id
3478: and column_sequence > 0;
3479:

Line 3496: from fnd_view_columns

3492:
3493: -- If any non-seed owners, set owner to user
3494: select max(-1)
3495: into child_db_luby
3496: from fnd_view_columns
3497: where application_id = appl_id
3498: and VIEW_ID = vw_id
3499: and column_sequence < 0
3500: and last_updated_by not in (0,1,2);

Line 3509: from fnd_view_columns

3505:
3506: -- If any non-seed owners, set owner to user
3507: select max(-1)
3508: into child_file_luby
3509: from fnd_view_columns
3510: where application_id = appl_id
3511: and VIEW_ID = vw_id
3512: and column_sequence > 0
3513: and last_updated_by not in (0,1,2);

Line 3526: delete from fnd_view_columns

3522:
3523: -- The new child entity rows from the data file are kept so
3524: -- delete the existing db child entity rows.
3525:
3526: delete from fnd_view_columns
3527: where application_id = appl_id
3528: and VIEW_ID = vw_id
3529: and column_sequence < 0;
3530:

Line 3536: delete from fnd_view_columns

3532:
3533: -- The existing db child entity rows are kept so delete the new child
3534: -- entity rows from the data file
3535:
3536: delete from fnd_view_columns
3537: where application_id = appl_id
3538: and VIEW_ID = vw_id
3539: and column_sequence > 0;
3540:

Line 3545: update FND_VIEW_COLUMNS

3541: -- Rename the existing db entity rows back to normal since
3542: -- it was not replaced by the new child entity rows
3543: -- from the data file.
3544:
3545: update FND_VIEW_COLUMNS
3546: set COLUMN_SEQUENCE = -1 * COLUMN_SEQUENCE,
3547: COLUMN_NAME = decode(instr(COLUMN_NAME, '#'),1,ltrim(COLUMN_NAME, '#'),
3548: replace(COLUMN_NAME, '#','_'))
3549: where APPLICATION_ID = appl_id

Line 3565: update FND_VIEW_COLUMNS

3561: -- Rename the existing db entity rows back to normal since
3562: -- it was not replaced by the new child entity rows
3563: -- from the data file.
3564:
3565: update FND_VIEW_COLUMNS
3566: set COLUMN_SEQUENCE = -1 * COLUMN_SEQUENCE,
3567: COLUMN_NAME = decode(instr(COLUMN_NAME, '#'),1,ltrim(COLUMN_NAME, '#'),
3568: replace(COLUMN_NAME, '#','_'))
3569: where APPLICATION_ID = appl_id

Line 3619: insert into FND_VIEW_COLUMNS(

3615: -- view columns from the data file to determine which will be
3616: -- updated into the database based on the date and custom factirs.
3617:
3618: begin
3619: insert into FND_VIEW_COLUMNS(
3620: APPLICATION_ID,
3621: VIEW_ID,
3622: COLUMN_SEQUENCE,
3623: COLUMN_NAME,