APPS.FND_SIF_DEFINITIONS_PKG dependencies on FND_SIF_DEFINITIONS

Line 1: package body FND_SIF_DEFINITIONS_PKG as

1: package body FND_SIF_DEFINITIONS_PKG as
2: /* $Header: FNDSFDFB.pls 120.0.12020000.3 2013/05/20 04:24:21 vshanmug noship $ */
3:
4: procedure INSERT_ROW (
5: X_DEFINITION_NAME in VARCHAR2,

Line 22: cursor C is select ROWID from FND_SIF_DEFINITIONS

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
25: insert into FND_SIF_DEFINITIONS (
26: WSDL_TNS,

Line 25: insert into FND_SIF_DEFINITIONS (

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
25: insert into FND_SIF_DEFINITIONS (
26: WSDL_TNS,
27: ATTR1,
28: DEFINITION_NAME,
29: APPLICATION_ID,

Line 59: insert into FND_SIF_DEFINITIONS_TL (

55: 0,
56: FND_GLOBAL.SECURITY_GROUP_ID
57: );
58:
59: insert into FND_SIF_DEFINITIONS_TL (
60: DEFINITION_NAME,
61: DISPLAY_NAME,
62: DESCRIPTION,
63: LANGUAGE,

Line 87: from FND_SIF_DEFINITIONS_TL T

83: from FND_LANGUAGES L
84: where L.INSTALLED_FLAG in ('I', 'B')
85: and not exists
86: (select NULL
87: from FND_SIF_DEFINITIONS_TL T
88: where T.DEFINITION_NAME = X_DEFINITION_NAME
89: and T.LANGUAGE = L.LANGUAGE_CODE);
90:
91: open c;

Line 95: raise_application_error (-20000, 'FND_SIF_DEFINITIONS_PKG.INSERT_ROW: unable to create definition '||X_DEFINITION_NAME);

91: open c;
92: fetch c into l_ROWID;
93: if (c%notfound) then
94: close c;
95: raise_application_error (-20000, 'FND_SIF_DEFINITIONS_PKG.INSERT_ROW: unable to create definition '||X_DEFINITION_NAME);
96: end if;
97: close c;
98: end INSERT_ROW;
99:

Line 110: update FND_SIF_DEFINITIONS_TL

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,
112: DESCRIPTION = X_DESCRIPTION,
113: LAST_UPDATE_DATE = l_ludate,
114: LAST_UPDATED_BY = l_luby,

Line 119: raise_application_error (-20000, 'FND_SIF_DEFINITIONS_PKG.TRANSLATE_ROW: unable to find definition '

115: SOURCE_LANG = userenv('LANG')
116: where DEFINITION_NAME = X_DEFINITION_NAME
117: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
118: IF (sql%rowcount=0) THEN
119: raise_application_error (-20000, 'FND_SIF_DEFINITIONS_PKG.TRANSLATE_ROW: unable to find definition '
120: ||X_DEFINITION_NAME||'. Ensure base language is uploaded first');
121: END IF;
122: end TRANSLATE_ROW;
123:

Line 142: update FND_SIF_DEFINITIONS set

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,
144: ATTR1 = X_WSDL_URL,
145: APPLICATION_ID = X_APPLICATION_ID,
146: STATUS = X_STATUS,

Line 180: insert into FND_SIF_DEFINITIONS_TL (

176: end UPDATE_ROW;
177:
178: procedure ADD_LANGUAGE is
179: begin
180: insert into FND_SIF_DEFINITIONS_TL (
181: DEFINITION_NAME,
182: DISPLAY_NAME,
183: DESCRIPTION,
184: LANGUAGE,

Line 203: from FND_SIF_DEFINITIONS_TL B, FND_LANGUAGES L

199: B.LAST_UPDATE_DATE,
200: B.LAST_UPDATED_BY,
201: B.LAST_UPDATE_LOGIN,
202: B.SECURITY_GROUP_ID
203: from FND_SIF_DEFINITIONS_TL B, FND_LANGUAGES L
204: where L.INSTALLED_FLAG in ('I', 'B')
205: and B.LANGUAGE=userenv('LANG')
206: and not exists
207: (select NULL

Line 208: from FND_SIF_DEFINITIONS_TL T

204: where L.INSTALLED_FLAG in ('I', 'B')
205: and B.LANGUAGE=userenv('LANG')
206: and not exists
207: (select NULL
208: from FND_SIF_DEFINITIONS_TL T
209: where T.DEFINITION_NAME = B.DEFINITION_NAME
210: and T.LANGUAGE = L.LANGUAGE_CODE);
211: end ADD_LANGUAGE;
212: end FND_SIF_DEFINITIONS_PKG;

Line 212: end FND_SIF_DEFINITIONS_PKG;

208: from FND_SIF_DEFINITIONS_TL T
209: where T.DEFINITION_NAME = B.DEFINITION_NAME
210: and T.LANGUAGE = L.LANGUAGE_CODE);
211: end ADD_LANGUAGE;
212: end FND_SIF_DEFINITIONS_PKG;