APPS.FND_XDFDICTIONARY_PKG dependencies on FND_VIEW_COLUMNS

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

1467: end RemoveSequence;
1468:
1469: --
1470: -- RemoveView (PUBLIC)
1471: -- Remove view from FND_VIEWS and FND_VIEW_COLUMNS table.
1472: --
1473: procedure RemoveView(
1474: x_application_short_name in varchar2,
1475: x_view_name in varchar2) is

Line 1506: delete from fnd_view_columns

1502: return;
1503: end;
1504:
1505: -- Nothing pointing to view, so is safe to delete
1506: delete from fnd_view_columns
1507: where application_id = appl_id
1508: and view_id = vw_id;
1509:
1510: delete from fnd_views

Line 3504: update FND_VIEW_COLUMNS

3500: -- BUG2631776 rename the child record's COLUMN_SEQUENCE
3501: -- and COLUMN_NAME to in order to prevent unique
3502: -- constraints while processing the PARENT/CHILD entity.
3503:
3504: update FND_VIEW_COLUMNS
3505: set COLUMN_SEQUENCE = -1 * COLUMN_SEQUENCE,
3506: COLUMN_NAME = decode(instr(COLUMN_NAME,'_'),0,concat('#',COLUMN_NAME),
3507: replace(COLUMN_NAME, '_','#'))
3508: where APPLICATION_ID = appl_id

Line 3538: from fnd_view_columns

3534: -- and the file entity.
3535:
3536: select max(last_update_date)
3537: into child_db_ludate
3538: from fnd_view_columns
3539: where application_id = appl_id
3540: and VIEW_ID = vw_id
3541: and column_sequence < 0;
3542:

Line 3545: from fnd_view_columns

3541: and column_sequence < 0;
3542:
3543: select max(last_update_date)
3544: into child_file_ludate
3545: from fnd_view_columns
3546: where application_id = appl_id
3547: and VIEW_ID = vw_id
3548: and column_sequence > 0;
3549:

Line 3566: from fnd_view_columns

3562:
3563: -- If any non-seed owners, set owner to user
3564: select max(-1)
3565: into child_db_luby
3566: from fnd_view_columns
3567: where application_id = appl_id
3568: and VIEW_ID = vw_id
3569: and column_sequence < 0
3570: and last_updated_by not in (0,1,2);

Line 3579: from fnd_view_columns

3575:
3576: -- If any non-seed owners, set owner to user
3577: select max(-1)
3578: into child_file_luby
3579: from fnd_view_columns
3580: where application_id = appl_id
3581: and VIEW_ID = vw_id
3582: and column_sequence > 0
3583: and last_updated_by not in (0,1,2);

Line 3596: delete from fnd_view_columns

3592:
3593: -- The new child entity rows from the data file are kept so
3594: -- delete the existing db child entity rows.
3595:
3596: delete from fnd_view_columns
3597: where application_id = appl_id
3598: and VIEW_ID = vw_id
3599: and column_sequence < 0;
3600:

Line 3606: delete from fnd_view_columns

3602:
3603: -- The existing db child entity rows are kept so delete the new child
3604: -- entity rows from the data file
3605:
3606: delete from fnd_view_columns
3607: where application_id = appl_id
3608: and VIEW_ID = vw_id
3609: and column_sequence > 0;
3610:

Line 3615: update FND_VIEW_COLUMNS

3611: -- Rename the existing db entity rows back to normal since
3612: -- it was not replaced by the new child entity rows
3613: -- from the data file.
3614:
3615: update FND_VIEW_COLUMNS
3616: set COLUMN_SEQUENCE = -1 * COLUMN_SEQUENCE,
3617: COLUMN_NAME = decode(instr(COLUMN_NAME, '#'),1,ltrim(COLUMN_NAME, '#'),
3618: replace(COLUMN_NAME, '#','_'))
3619: where APPLICATION_ID = appl_id

Line 3635: update FND_VIEW_COLUMNS

3631: -- Rename the existing db entity rows back to normal since
3632: -- it was not replaced by the new child entity rows
3633: -- from the data file.
3634:
3635: update FND_VIEW_COLUMNS
3636: set COLUMN_SEQUENCE = -1 * COLUMN_SEQUENCE,
3637: COLUMN_NAME = decode(instr(COLUMN_NAME, '#'),1,ltrim(COLUMN_NAME, '#'),
3638: replace(COLUMN_NAME, '#','_'))
3639: where APPLICATION_ID = appl_id

Line 3689: insert into FND_VIEW_COLUMNS(

3685: -- view columns from the data file to determine which will be
3686: -- updated into the database based on the date and custom factirs.
3687:
3688: begin
3689: insert into FND_VIEW_COLUMNS(
3690: APPLICATION_ID,
3691: VIEW_ID,
3692: COLUMN_SEQUENCE,
3693: COLUMN_NAME,