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,
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
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
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 ,
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 ,
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
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 ,
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
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,