APPS.FND_DICTIONARY_PKG dependencies on FND_VIEWS

Line 525: -- Add a new view into FND_VIEWS. This is only called after checking

521: end InsertSequence;
522:
523: --
524: -- InsertView (PRIVATE))
525: -- Add a new view into FND_VIEWS. This is only called after checking
526: -- there is no such view key exists in UploadView().
527: --
528: procedure InsertView (
529: x_application_id in number,

Line 540: insert into FND_VIEWS (

536: x_last_updated_by in number,
537: x_last_update_login in number
538: ) is
539: begin
540: insert into FND_VIEWS (
541: APPLICATION_ID,
542: VIEW_ID,
543: VIEW_NAME,
544: TEXT,

Line 553: FND_VIEWS_S.NEXTVAL,

549: CREATION_DATE,
550: CREATED_BY)
551: values (
552: x_application_id,
553: FND_VIEWS_S.NEXTVAL,
554: x_view_name,
555: x_text,
556: x_description,
557: x_last_updated_by,

Line 1056: for r in (select text from fnd_views

1052: x_view_name in varchar2) return number
1053: is
1054: len number;
1055: begin
1056: for r in (select text from fnd_views
1057: where application_id = x_application_id
1058: and view_name = x_view_name) loop
1059: len := length(r.text);
1060:

Line 1078: from fnd_views

1074: begin
1075: begin
1076: select text
1077: into vtext
1078: from fnd_views
1079: where application_id = x_application_id
1080: and view_name = x_view_name;
1081: len := 200;
1082: return(len);

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 1523: from fnd_views

1519: end;
1520:
1521: begin
1522: select view_id into vw_id
1523: from fnd_views
1524: where application_id = appl_id
1525: and view_name = upper(x_view_name);
1526: exception
1527: when no_data_found then

Line 1529: fnd_message.set_token('TABLE', 'FND_VIEWS');

1525: and view_name = upper(x_view_name);
1526: exception
1527: when no_data_found then
1528: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1529: fnd_message.set_token('TABLE', 'FND_VIEWS');
1530: fnd_message.set_token('COLUMN', 'VIEW_NAME');
1531: fnd_message.set_token('VALUE', x_view_name);
1532: app_exception.raise_exception;
1533: return;

Line 1541: delete from fnd_views

1537: delete from fnd_view_columns
1538: where application_id = appl_id
1539: and view_id = vw_id;
1540:
1541: delete from fnd_views
1542: where application_id = appl_id
1543: and view_id = vw_id;
1544:
1545: end RemoveView;

Line 3407: from fnd_views

3403: begin
3404:
3405: select VIEW_ID
3406: into vw_id
3407: from fnd_views
3408: where application_id = appl_id
3409: and VIEW_NAME = x_view_name;
3410:
3411: select LAST_UPDATED_BY, LAST_UPDATE_DATE

Line 3413: from FND_VIEWS

3409: and VIEW_NAME = x_view_name;
3410:
3411: select LAST_UPDATED_BY, LAST_UPDATE_DATE
3412: into db_luby, db_ludate
3413: from FND_VIEWS
3414: where APPLICATION_ID = appl_id
3415: and VIEW_NAME = x_view_name;
3416:
3417: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 3420: update FND_VIEWS set

3416:
3417: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
3418: db_ludate, X_CUSTOM_MODE)) then
3419:
3420: update FND_VIEWS set
3421: TEXT = x_text,
3422: DESCRIPTION = x_description,
3423: LAST_UPDATED_BY = f_luby,
3424: LAST_UPDATE_DATE = f_ludate,

Line 3459: from fnd_views

3455: else -- phase_mode = 'END'
3456:
3457: select VIEW_ID
3458: into vw_id
3459: from fnd_views
3460: where application_id = appl_id
3461: and VIEW_NAME = x_view_name;
3462:
3463: -- Bug2631776 get the latest value for the last update for the db entity

Line 3603: select V.VIEW_ID into vw_id from FND_VIEWS V

3599: into appl_id
3600: from FND_APPLICATION A
3601: where A.APPLICATION_SHORT_NAME = x_application_short_name;
3602:
3603: select V.VIEW_ID into vw_id from FND_VIEWS V
3604: where V.APPLICATION_ID = appl_id
3605: and V.VIEW_NAME = x_view_name;
3606:
3607: -- Translate owner to file_last_updated_by