APPS.IBY_PP_MLSUTL_PVT dependencies on IBY_VALIDATION_SETS_TL

Line 49: insert into IBY_VALIDATION_SETS_TL (

45: X_LAST_UPDATED_BY,
46: X_LAST_UPDATE_LOGIN
47: );
48:
49: insert into IBY_VALIDATION_SETS_TL (
50: CREATED_BY,
51: CREATION_DATE,
52: LAST_UPDATED_BY,
53: LAST_UPDATE_DATE,

Line 75: from IBY_VALIDATION_SETS_TL T

71: from FND_LANGUAGES L
72: where L.INSTALLED_FLAG in ('I', 'B')
73: and not exists
74: (select NULL
75: from IBY_VALIDATION_SETS_TL T
76: where T.VALIDATION_SET_CODE = X_VALIDATION_SET_CODE
77: and T.LANGUAGE = L.LANGUAGE_CODE);
78:
79: open c;

Line 117: update IBY_VALIDATION_SETS_TL set

113: if (sql%notfound) then
114: raise no_data_found;
115: end if;
116:
117: update IBY_VALIDATION_SETS_TL set
118: VALIDATION_SET_DISPLAY_NAME = X_VALIDATION_SET_DISPLAY_NAME,
119: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
120: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
121: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 135: delete from IBY_VALIDATION_SETS_TL

131: procedure VAL_SET_DELETE_ROW (
132: X_VALIDATION_SET_CODE in VARCHAR2
133: ) is
134: begin
135: delete from IBY_VALIDATION_SETS_TL
136: where VALIDATION_SET_CODE = X_VALIDATION_SET_CODE;
137:
138: if (sql%notfound) then
139: raise no_data_found;

Line 153: delete from IBY_VALIDATION_SETS_TL T

149:
150: procedure VAL_SET_ADD_LANGUAGE
151: is
152: begin
153: delete from IBY_VALIDATION_SETS_TL T
154: where not exists
155: (select NULL
156: from IBY_VALIDATION_SETS_B B
157: where B.VALIDATION_SET_CODE = T.VALIDATION_SET_CODE

Line 160: update IBY_VALIDATION_SETS_TL T set (

156: from IBY_VALIDATION_SETS_B B
157: where B.VALIDATION_SET_CODE = T.VALIDATION_SET_CODE
158: );
159:
160: update IBY_VALIDATION_SETS_TL T set (
161: VALIDATION_SET_DISPLAY_NAME
162: ) = (select
163: B.VALIDATION_SET_DISPLAY_NAME
164: from IBY_VALIDATION_SETS_TL B

Line 164: from IBY_VALIDATION_SETS_TL B

160: update IBY_VALIDATION_SETS_TL T set (
161: VALIDATION_SET_DISPLAY_NAME
162: ) = (select
163: B.VALIDATION_SET_DISPLAY_NAME
164: from IBY_VALIDATION_SETS_TL B
165: where B.VALIDATION_SET_CODE = T.VALIDATION_SET_CODE
166: and B.LANGUAGE = T.SOURCE_LANG)
167: where (
168: T.VALIDATION_SET_CODE,

Line 173: from IBY_VALIDATION_SETS_TL SUBB, IBY_VALIDATION_SETS_TL SUBT

169: T.LANGUAGE
170: ) in (select
171: SUBT.VALIDATION_SET_CODE,
172: SUBT.LANGUAGE
173: from IBY_VALIDATION_SETS_TL SUBB, IBY_VALIDATION_SETS_TL SUBT
174: where SUBB.VALIDATION_SET_CODE = SUBT.VALIDATION_SET_CODE
175: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
176: and (SUBB.VALIDATION_SET_DISPLAY_NAME <> SUBT.VALIDATION_SET_DISPLAY_NAME
177: ));

Line 179: insert into IBY_VALIDATION_SETS_TL (

175: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
176: and (SUBB.VALIDATION_SET_DISPLAY_NAME <> SUBT.VALIDATION_SET_DISPLAY_NAME
177: ));
178:
179: insert into IBY_VALIDATION_SETS_TL (
180: CREATED_BY,
181: CREATION_DATE,
182: LAST_UPDATED_BY,
183: LAST_UPDATE_DATE,

Line 201: from IBY_VALIDATION_SETS_TL B, FND_LANGUAGES L

197: B.VALIDATION_SET_CODE,
198: B.VALIDATION_SET_DISPLAY_NAME,
199: L.LANGUAGE_CODE,
200: B.SOURCE_LANG
201: from IBY_VALIDATION_SETS_TL B, FND_LANGUAGES L
202: where L.INSTALLED_FLAG in ('I', 'B')
203: and B.LANGUAGE = userenv('LANG')
204: and not exists
205: (select NULL

Line 206: from IBY_VALIDATION_SETS_TL T

202: where L.INSTALLED_FLAG in ('I', 'B')
203: and B.LANGUAGE = userenv('LANG')
204: and not exists
205: (select NULL
206: from IBY_VALIDATION_SETS_TL T
207: where T.VALIDATION_SET_CODE = B.VALIDATION_SET_CODE
208: and T.LANGUAGE = L.LANGUAGE_CODE);
209: end VAL_SET_ADD_LANGUAGE;
210:

Line 261: update iby_validation_sets_tl set

257: X_LAST_UPDATE_DATE in DATE,
258: X_OWNER in VARCHAR2)
259: is
260: begin
261: update iby_validation_sets_tl set
262: VALIDATION_SET_DISPLAY_NAME = X_VALIDATION_SET_DISPLAY_NAME,
263: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
264: LAST_UPDATED_BY = fnd_load_util.owner_id(X_OWNER),
265: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,