APPS.WF_WL_VIEWS_PKG dependencies on WF_WL_VIEW_PARAMS

Line 573: select ROWID from WF_WL_VIEW_PARAMS

569: X_LAST_UPDATE_DATE in VARCHAR2) is
570: l_view_id number := FIND_VIEW_ID(X_VIEW_KEY);
571: l_row_id varchar2(50);
572: cursor c_newrow is
573: select ROWID from WF_WL_VIEW_PARAMS
574: where VIEW_ID = l_view_id and
575: PARAMETER_NAME = X_PARAMETER_NAME;
576: l_luby number;
577: l_ludate date;

Line 584: insert into WF_WL_VIEW_PARAMS (VIEW_ID ,

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 ,
585: PARAMETER_NAME,
586: PARAMETER_SEQ ,
587: PARAMETER_TYPE,
588: PARAMETER_VALUE,

Line 632: update WF_WL_VIEW_PARAMS B

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
633: set B.PARAMETER_SEQ = X_PARAMETER_SEQ ,
634: B.PARAMETER_TYPE = X_PARAMETER_TYPE ,
635: B.PARAMETER_VALUE = X_PARAMETER_VALUE,
636: B.LAST_UPDATE_DATE = l_ludate,