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 3510: AD_ZD_SEED.PREPARE ('FND_VIEW_COLUMNS');

3506: if (P_NZDT_MODE ='Y')
3507: then
3508: begin
3509: AD_ZD_SEED.PREPARE ('FND_VIEWS');
3510: AD_ZD_SEED.PREPARE ('FND_VIEW_COLUMNS');
3511: end;
3512: end if;
3513: begin
3514: select A.APPLICATION_ID

Line 3564: update FND_VIEW_COLUMNS

3560: -- BUG2631776 rename the child record's COLUMN_SEQUENCE
3561: -- and COLUMN_NAME to in order to prevent unique
3562: -- constraints while processing the PARENT/CHILD entity.
3563:
3564: update FND_VIEW_COLUMNS
3565: set COLUMN_SEQUENCE = -1 * COLUMN_SEQUENCE,
3566: COLUMN_NAME = decode(instr(COLUMN_NAME,'_'),0,concat('#',COLUMN_NAME),
3567: replace(COLUMN_NAME, '_','#'))
3568: where APPLICATION_ID = appl_id

Line 3598: from fnd_view_columns

3594: -- and the file entity.
3595:
3596: select max(last_update_date)
3597: into child_db_ludate
3598: from fnd_view_columns
3599: where application_id = appl_id
3600: and VIEW_ID = vw_id
3601: and column_sequence < 0;
3602:

Line 3605: from fnd_view_columns

3601: and column_sequence < 0;
3602:
3603: select max(last_update_date)
3604: into child_file_ludate
3605: from fnd_view_columns
3606: where application_id = appl_id
3607: and VIEW_ID = vw_id
3608: and column_sequence > 0;
3609:

Line 3626: from fnd_view_columns

3622:
3623: -- If any non-seed owners, set owner to user
3624: select max(-1)
3625: into child_db_luby
3626: from fnd_view_columns
3627: where application_id = appl_id
3628: and VIEW_ID = vw_id
3629: and column_sequence < 0
3630: and last_updated_by not in (0,1,2);

Line 3639: from fnd_view_columns

3635:
3636: -- If any non-seed owners, set owner to user
3637: select max(-1)
3638: into child_file_luby
3639: from fnd_view_columns
3640: where application_id = appl_id
3641: and VIEW_ID = vw_id
3642: and column_sequence > 0
3643: and last_updated_by not in (0,1,2);

Line 3656: delete from fnd_view_columns

3652:
3653: -- The new child entity rows from the data file are kept so
3654: -- delete the existing db child entity rows.
3655:
3656: delete from fnd_view_columns
3657: where application_id = appl_id
3658: and VIEW_ID = vw_id
3659: and column_sequence < 0;
3660:

Line 3666: delete from fnd_view_columns

3662:
3663: -- The existing db child entity rows are kept so delete the new child
3664: -- entity rows from the data file
3665:
3666: delete from fnd_view_columns
3667: where application_id = appl_id
3668: and VIEW_ID = vw_id
3669: and column_sequence > 0;
3670:

Line 3675: update FND_VIEW_COLUMNS

3671: -- Rename the existing db entity rows back to normal since
3672: -- it was not replaced by the new child entity rows
3673: -- from the data file.
3674:
3675: update FND_VIEW_COLUMNS
3676: set COLUMN_SEQUENCE = -1 * COLUMN_SEQUENCE,
3677: COLUMN_NAME = decode(instr(COLUMN_NAME, '#'),1,ltrim(COLUMN_NAME, '#'),
3678: replace(COLUMN_NAME, '#','_'))
3679: where APPLICATION_ID = appl_id

Line 3695: update FND_VIEW_COLUMNS

3691: -- Rename the existing db entity rows back to normal since
3692: -- it was not replaced by the new child entity rows
3693: -- from the data file.
3694:
3695: update FND_VIEW_COLUMNS
3696: set COLUMN_SEQUENCE = -1 * COLUMN_SEQUENCE,
3697: COLUMN_NAME = decode(instr(COLUMN_NAME, '#'),1,ltrim(COLUMN_NAME, '#'),
3698: replace(COLUMN_NAME, '#','_'))
3699: where APPLICATION_ID = appl_id

Line 3749: insert into FND_VIEW_COLUMNS(

3745: -- view columns from the data file to determine which will be
3746: -- updated into the database based on the date and custom factirs.
3747:
3748: begin
3749: insert into FND_VIEW_COLUMNS(
3750: APPLICATION_ID,
3751: VIEW_ID,
3752: COLUMN_SEQUENCE,
3753: COLUMN_NAME,