16: X_LAST_UPDATE_DATE in VARCHAR2,
17: X_OWNER in VARCHAR2
18: ) is
19: l_ROWID VARCHAR2(100);
20: l_luby number := FND_LOAD_UTIL.OWNER_ID(X_OWNER);
21: l_ludate date := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
22: cursor C is select ROWID from FND_SIF_DEFINITIONS
23: where DEFINITION_NAME = X_DEFINITION_NAME;
24: begin
103: X_DESCRIPTION in VARCHAR2,
104: X_LAST_UPDATE_DATE in VARCHAR2,
105: X_OWNER in VARCHAR2
106: ) is
107: l_luby number := FND_LOAD_UTIL.OWNER_ID(X_OWNER);
108: l_ludate date := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
109: begin
110: update FND_SIF_DEFINITIONS_TL
111: set DISPLAY_NAME = X_DISPLAY_NAME,
135: X_DESCRIPTION in VARCHAR2,
136: X_LAST_UPDATE_DATE in VARCHAR2,
137: X_OWNER in VARCHAR2
138: ) is
139: l_luby number := FND_LOAD_UTIL.OWNER_ID(X_OWNER);
140: l_ludate date := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
141: begin
142: update FND_SIF_DEFINITIONS set
143: WSDL_TNS = X_WSDL_TNS,