APPS.AR_BPA_RULE_ATTRIBUTES_PKG dependencies on AR_BPA_RULE_ATTRIBUTES_TL

Line 42: insert into AR_BPA_RULE_ATTRIBUTES_TL (

38: X_LAST_UPDATED_BY,
39: X_LAST_UPDATE_LOGIN
40: );
41:
42: insert into AR_BPA_RULE_ATTRIBUTES_TL (
43: RULE_ATTRIBUTE_ID,
44: ATTRIBUTE_VALUE,
45: CREATED_BY,
46: CREATION_DATE,

Line 66: from AR_BPA_RULE_ATTRIBUTES_TL T

62: from FND_LANGUAGES L
63: where L.INSTALLED_FLAG in ('I', 'B')
64: and not exists
65: (select NULL
66: from AR_BPA_RULE_ATTRIBUTES_TL T
67: where T.RULE_ATTRIBUTE_ID = X_RULE_ATTRIBUTE_ID
68: and T.LANGUAGE = L.LANGUAGE_CODE);
69:
70: open c;

Line 99: from AR_BPA_RULE_ATTRIBUTES_TL

95:
96: cursor c1 is select
97: ATTRIBUTE_VALUE,
98: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
99: from AR_BPA_RULE_ATTRIBUTES_TL
100: where RULE_ATTRIBUTE_ID = X_RULE_ATTRIBUTE_ID
101: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
102: for update of RULE_ATTRIBUTE_ID nowait;
103: begin

Line 161: update AR_BPA_RULE_ATTRIBUTES_TL set

157: if (sql%notfound) then
158: raise no_data_found;
159: end if;
160:
161: update AR_BPA_RULE_ATTRIBUTES_TL set
162: ATTRIBUTE_VALUE = X_ATTRIBUTE_VALUE,
163: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
164: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
165: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 179: delete from AR_BPA_RULE_ATTRIBUTES_TL

175: procedure DELETE_ROW (
176: X_RULE_ATTRIBUTE_ID in NUMBER
177: ) is
178: begin
179: delete from AR_BPA_RULE_ATTRIBUTES_TL
180: where RULE_ATTRIBUTE_ID = X_RULE_ATTRIBUTE_ID;
181:
182: if (sql%notfound) then
183: raise no_data_found;

Line 197: delete from AR_BPA_RULE_ATTRIBUTES_TL T

193:
194: procedure ADD_LANGUAGE
195: is
196: begin
197: delete from AR_BPA_RULE_ATTRIBUTES_TL T
198: where not exists
199: (select NULL
200: from AR_BPA_RULE_ATTRIBUTES_B B
201: where B.RULE_ATTRIBUTE_ID = T.RULE_ATTRIBUTE_ID

Line 204: update AR_BPA_RULE_ATTRIBUTES_TL T set (

200: from AR_BPA_RULE_ATTRIBUTES_B B
201: where B.RULE_ATTRIBUTE_ID = T.RULE_ATTRIBUTE_ID
202: );
203:
204: update AR_BPA_RULE_ATTRIBUTES_TL T set (
205: ATTRIBUTE_VALUE
206: ) = (select
207: B.ATTRIBUTE_VALUE
208: from AR_BPA_RULE_ATTRIBUTES_TL B

Line 208: from AR_BPA_RULE_ATTRIBUTES_TL B

204: update AR_BPA_RULE_ATTRIBUTES_TL T set (
205: ATTRIBUTE_VALUE
206: ) = (select
207: B.ATTRIBUTE_VALUE
208: from AR_BPA_RULE_ATTRIBUTES_TL B
209: where B.RULE_ATTRIBUTE_ID = T.RULE_ATTRIBUTE_ID
210: and B.LANGUAGE = T.SOURCE_LANG)
211: where (
212: T.RULE_ATTRIBUTE_ID,

Line 217: from AR_BPA_RULE_ATTRIBUTES_TL SUBB, AR_BPA_RULE_ATTRIBUTES_TL SUBT

213: T.LANGUAGE
214: ) in (select
215: SUBT.RULE_ATTRIBUTE_ID,
216: SUBT.LANGUAGE
217: from AR_BPA_RULE_ATTRIBUTES_TL SUBB, AR_BPA_RULE_ATTRIBUTES_TL SUBT
218: where SUBB.RULE_ATTRIBUTE_ID = SUBT.RULE_ATTRIBUTE_ID
219: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
220: and (SUBB.ATTRIBUTE_VALUE <> SUBT.ATTRIBUTE_VALUE
221: ));

Line 223: insert into AR_BPA_RULE_ATTRIBUTES_TL (

219: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
220: and (SUBB.ATTRIBUTE_VALUE <> SUBT.ATTRIBUTE_VALUE
221: ));
222:
223: insert into AR_BPA_RULE_ATTRIBUTES_TL (
224: RULE_ATTRIBUTE_ID,
225: ATTRIBUTE_VALUE,
226: CREATED_BY,
227: CREATION_DATE,

Line 243: from AR_BPA_RULE_ATTRIBUTES_TL B, FND_LANGUAGES L

239: B.LAST_UPDATE_DATE,
240: B.LAST_UPDATE_LOGIN,
241: L.LANGUAGE_CODE,
242: B.SOURCE_LANG
243: from AR_BPA_RULE_ATTRIBUTES_TL B, FND_LANGUAGES L
244: where L.INSTALLED_FLAG in ('I', 'B')
245: and B.LANGUAGE = userenv('LANG')
246: and not exists
247: (select NULL

Line 248: from AR_BPA_RULE_ATTRIBUTES_TL T

244: where L.INSTALLED_FLAG in ('I', 'B')
245: and B.LANGUAGE = userenv('LANG')
246: and not exists
247: (select NULL
248: from AR_BPA_RULE_ATTRIBUTES_TL T
249: where T.RULE_ATTRIBUTE_ID = B.RULE_ATTRIBUTE_ID
250: and T.LANGUAGE = L.LANGUAGE_CODE);
251: end ADD_LANGUAGE;
252:

Line 259: update AR_BPA_RULE_ATTRIBUTES_TL

255: X_ATTRIBUTE_VALUE in VARCHAR2,
256: X_OWNER in VARCHAR2) IS
257: begin
258:
259: update AR_BPA_RULE_ATTRIBUTES_TL
260: set ATTRIBUTE_VALUE = X_ATTRIBUTE_VALUE,
261: source_lang = userenv('LANG'),
262: last_update_date = sysdate,
263: last_updated_by = decode(X_OWNER, 'SEED', 1, 0),