APPS.FND_XDFDICTIONARY_PKG dependencies on FND_VIEWS

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

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

Line 536: insert into FND_VIEWS (

532: x_last_updated_by in number,
533: x_last_update_login in number
534: ) is
535: begin
536: insert into FND_VIEWS (
537: APPLICATION_ID,
538: VIEW_ID,
539: VIEW_NAME,
540: TEXT,

Line 549: FND_VIEWS_S.NEXTVAL,

545: CREATION_DATE,
546: CREATED_BY)
547: values (
548: x_application_id,
549: FND_VIEWS_S.NEXTVAL,
550: x_view_name,
551: x_text,
552: x_description,
553: x_last_updated_by,

Line 1054: for r in (select text from fnd_views

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

Line 1076: from fnd_views

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

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

1490: end;
1491:
1492: begin
1493: select view_id into vw_id
1494: from fnd_views
1495: where application_id = appl_id
1496: and view_name = upper(x_view_name);
1497: exception
1498: when no_data_found then

Line 1500: -20001, 'Sql no data found in fnd_views for view name '

1496: and view_name = upper(x_view_name);
1497: exception
1498: when no_data_found then
1499: RAISE_APPLICATION_ERROR(
1500: -20001, 'Sql no data found in fnd_views for view name '
1501: || x_view_name , TRUE);
1502: return;
1503: end;
1504:

Line 1510: delete from fnd_views

1506: delete from fnd_view_columns
1507: where application_id = appl_id
1508: and view_id = vw_id;
1509:
1510: delete from fnd_views
1511: where application_id = appl_id
1512: and view_id = vw_id;
1513:
1514: end RemoveView;

Line 3477: from fnd_views

3473: begin
3474:
3475: select VIEW_ID
3476: into vw_id
3477: from fnd_views
3478: where application_id = appl_id
3479: and VIEW_NAME = x_view_name;
3480:
3481: select LAST_UPDATED_BY, LAST_UPDATE_DATE

Line 3483: from FND_VIEWS

3479: and VIEW_NAME = x_view_name;
3480:
3481: select LAST_UPDATED_BY, LAST_UPDATE_DATE
3482: into db_luby, db_ludate
3483: from FND_VIEWS
3484: where APPLICATION_ID = appl_id
3485: and VIEW_NAME = x_view_name;
3486:
3487: if (upload_test(f_luby, f_ludate, db_luby,

Line 3490: update FND_VIEWS set

3486:
3487: if (upload_test(f_luby, f_ludate, db_luby,
3488: db_ludate, X_CUSTOM_MODE)) then
3489:
3490: update FND_VIEWS set
3491: TEXT = x_text,
3492: DESCRIPTION = x_description,
3493: LAST_UPDATED_BY = f_luby,
3494: LAST_UPDATE_DATE = f_ludate,

Line 3529: from fnd_views

3525: else -- phase_mode = 'END'
3526:
3527: select VIEW_ID
3528: into vw_id
3529: from fnd_views
3530: where application_id = appl_id
3531: and VIEW_NAME = x_view_name;
3532:
3533: -- Bug2631776 get the latest value for the last update for the db entity

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

3669: into appl_id
3670: from FND_APPLICATION A
3671: where A.APPLICATION_SHORT_NAME = x_application_short_name;
3672:
3673: select V.VIEW_ID into vw_id from FND_VIEWS V
3674: where V.APPLICATION_ID = appl_id
3675: and V.VIEW_NAME = x_view_name;
3676:
3677: -- Translate owner to file_last_updated_by