DBA Data[Home] [Help]

APPS.WF_WL_VIEWS_PKG dependencies on FND_LOAD_UTIL

Line 97: l_luby := fnd_load_util.OWNER_ID(x_owner);

93: l_luby number;
94: l_ludate date;
95: begin
96: -- Translate owner to file_last_updated_by
97: l_luby := fnd_load_util.OWNER_ID(x_owner);
98: -- Translate char last_update_date to date
99: l_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
100:
101: insert into WF_WL_VIEWS (VIEW_ID,

Line 205: l_luby := fnd_load_util.OWNER_ID(x_owner);

201: l_luby number;
202: l_ludate date;
203: begin
204: -- Translate owner to file_last_updated_by
205: l_luby := fnd_load_util.OWNER_ID(x_owner);
206: -- Translate char last_update_date to date
207: l_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
208:
209: --Look for a parent view ID only if a parent view is given in X_PARENT_VIEW

Line 372: l_luby := fnd_load_util.OWNER_ID(x_owner);

368: l_luby number;
369: l_ludate date;
370: begin
371: -- Translate owner to file_last_updated_by
372: l_luby := fnd_load_util.OWNER_ID(x_owner);
373: -- Translate char last_update_date to date
374: l_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
375:
376: UPDATE WF_WL_VIEWS_TL TL

Line 412: l_luby := fnd_load_util.OWNER_ID(x_owner);

408: l_luby number;
409: l_ludate date;
410: begin
411: -- Translate owner to file_last_updated_by
412: l_luby := fnd_load_util.OWNER_ID(x_owner);
413: -- Translate char last_update_date to date
414: l_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
415: insert into WF_WL_VIEW_ATTRIBUTES (VIEW_ID ,
416: ATTRIBUTE_NAME ,

Line 495: l_luby := fnd_load_util.OWNER_ID(x_owner);

491: l_luby number;
492: l_ludate date;
493: begin
494: -- Translate owner to file_last_updated_by
495: l_luby := fnd_load_util.OWNER_ID(x_owner);
496: -- Translate char last_update_date to date
497: l_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
498: update WF_WL_VIEW_ATTRIBUTES B
499: set B.ATTRIBUTE_TYPE = X_ATTRIBUTE_TYPE ,

Line 543: l_luby := fnd_load_util.OWNER_ID(x_owner);

539: l_luby number;
540: l_ludate date;
541: begin
542: -- Translate owner to file_last_updated_by
543: l_luby := fnd_load_util.OWNER_ID(x_owner);
544: -- Translate char last_update_date to date
545: l_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
546:
547: UPDATE WF_WL_VIEW_ATTRIBUTES_TL TL

Line 580: l_luby := fnd_load_util.OWNER_ID(x_owner);

576: l_luby number;
577: l_ludate date;
578: begin
579: -- Translate owner to file_last_updated_by
580: l_luby := fnd_load_util.OWNER_ID(x_owner);
581: -- Translate char last_update_date to date
582: l_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
583:
584: insert into WF_WL_VIEW_PARAMS (VIEW_ID ,

Line 628: l_luby := fnd_load_util.OWNER_ID(x_owner);

624: l_luby number;
625: l_ludate date;
626: begin
627: -- Translate owner to file_last_updated_by
628: l_luby := fnd_load_util.OWNER_ID(x_owner);
629: -- Translate char last_update_date to date
630: l_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
631:
632: update WF_WL_VIEW_PARAMS B

Line 663: l_luby := fnd_load_util.OWNER_ID(x_owner);

659: l_luby number;
660: l_ludate date;
661: begin
662: -- Translate owner to file_last_updated_by
663: l_luby := fnd_load_util.OWNER_ID(x_owner);
664: -- Translate char last_update_date to date
665: l_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
666:
667: insert into WF_WL_REGION_VIEWS (REGION_ID,