APPS.FND_SIF_WSDLS_PKG dependencies on FND_SIF_WSDLS

Line 1: package body FND_SIF_WSDLS_PKG as

1: package body FND_SIF_WSDLS_PKG as
2: /* $Header: FNDSFWDB.pls 120.0.12020000.2 2013/04/09 18:16:50 alsosa noship $ */
3:
4: procedure INSERT_ROW (
5: X_TNS in VARCHAR2,

Line 13: cursor C is select ROWID from FND_SIF_WSDLS

9: ) is
10: l_ROWID VARCHAR2(100);
11: l_luby number := FND_LOAD_UTIL.OWNER_ID(X_OWNER);
12: l_ludate date := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
13: cursor C is select ROWID from FND_SIF_WSDLS
14: where TNS = X_TNS;
15: begin
16: insert into FND_SIF_WSDLS (
17: TNS,

Line 16: insert into FND_SIF_WSDLS (

12: l_ludate date := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
13: cursor C is select ROWID from FND_SIF_WSDLS
14: where TNS = X_TNS;
15: begin
16: insert into FND_SIF_WSDLS (
17: TNS,
18: WSDL_URL,
19: CREATION_DATE,
20: CREATED_BY,

Line 39: raise_application_error (-20000, 'FND_SIF_WSDLS_PKG.INSERT_ROW: unable to create target name space '||X_TNS);

35: open c;
36: fetch c into l_ROWID;
37: if (c%notfound) then
38: close c;
39: raise_application_error (-20000, 'FND_SIF_WSDLS_PKG.INSERT_ROW: unable to create target name space '||X_TNS);
40: end if;
41: close c;
42:
43: end INSERT_ROW;

Line 54: update FND_SIF_WSDLS set

50: ) is
51: l_luby number := FND_LOAD_UTIL.OWNER_ID(X_OWNER);
52: l_ludate date := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
53: begin
54: update FND_SIF_WSDLS set
55: WSDL_URL = X_WSDL_URL,
56: TNS = X_TNS,
57: LAST_UPDATE_DATE = l_ludate,
58: LAST_UPDATED_BY = l_luby

Line 68: end FND_SIF_WSDLS_PKG;

64: X_LAST_UPDATE_DATE => UPDATE_ROW.X_LAST_UPDATE_DATE,
65: X_OWNER => UPDATE_ROW.X_OWNER);
66: end if;
67: end UPDATE_ROW;
68: end FND_SIF_WSDLS_PKG;