APPS.AR_CASH_RULE_SETS_PKG dependencies on AR_CASH_AUTO_RULE_SETS

Line 19: cursor C is select ROWID from AR_CASH_AUTO_RULE_SETS

15: X_LAST_UPDATE_DATE in DATE,
16: X_LAST_UPDATED_BY in NUMBER,
17: X_LAST_UPDATE_LOGIN in NUMBER
18: ) is
19: cursor C is select ROWID from AR_CASH_AUTO_RULE_SETS
20: where AUTOMATCH_SET_ID = X_AUTOMATCH_SET_ID
21: ;
22: begin
23: insert into AR_CASH_AUTO_RULE_SETS (

Line 23: insert into AR_CASH_AUTO_RULE_SETS (

19: cursor C is select ROWID from AR_CASH_AUTO_RULE_SETS
20: where AUTOMATCH_SET_ID = X_AUTOMATCH_SET_ID
21: ;
22: begin
23: insert into AR_CASH_AUTO_RULE_SETS (
24: AUTOMATCH_SET_ID,
25: START_DATE,
26: END_DATE ,
27: ACTIVE_FLAG,

Line 47: insert into AR_CASH_AUTO_RULE_SETS_TL (

43: X_LAST_UPDATE_DATE ,
44: X_LAST_UPDATE_LOGIN
45: );
46:
47: insert into AR_CASH_AUTO_RULE_SETS_TL (
48: AUTOMATCH_SET_ID ,
49: AUTOMATCH_SET_NAME,
50: DESCRIPTION,
51: CREATED_BY,

Line 73: from AR_CASH_AUTO_RULE_SETS_TL T

69: from FND_LANGUAGES L
70: where L.INSTALLED_FLAG in ('I', 'B')
71: and not exists
72: (select NULL
73: from AR_CASH_AUTO_RULE_SETS_TL T
74: where T.AUTOMATCH_SET_ID = X_AUTOMATCH_SET_ID
75: and T.LANGUAGE = L.LANGUAGE_CODE);
76:
77: open c;

Line 101: from AR_CASH_AUTO_RULE_SETS

97: START_DATE,
98: END_DATE,
99: ACTIVE_FLAG,
100: EXCEPTION_REASON
101: from AR_CASH_AUTO_RULE_SETS
102: where AUTOMATCH_SET_ID = X_AUTOMATCH_SET_ID
103: for update of AUTOMATCH_SET_ID nowait;
104: recinfo c%rowtype;
105:

Line 110: from AR_CASH_AUTO_RULE_SETS_TL

106: cursor c1 is select
107: AUTOMATCH_SET_NAME,
108: DESCRIPTION,
109: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
110: from AR_CASH_AUTO_RULE_SETS_TL
111: where AUTOMATCH_SET_ID = X_AUTOMATCH_SET_ID
112: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
113: for update of AUTOMATCH_SET_ID nowait;
114: begin

Line 165: update AR_CASH_AUTO_RULE_SETS set

161: X_LAST_UPDATED_BY in NUMBER,
162: X_LAST_UPDATE_LOGIN in NUMBER
163: ) is
164: begin
165: update AR_CASH_AUTO_RULE_SETS set
166: START_DATE = X_START_DATE,
167: END_DATE = X_END_DATE,
168: ACTIVE_FLAG = X_ACTIVE_FLAG,
169: EXCEPTION_REASON = X_EXCEPTION_REASON,

Line 179: update AR_CASH_AUTO_RULE_SETS_TL set

175: if (sql%notfound) then
176: raise no_data_found;
177: end if;
178:
179: update AR_CASH_AUTO_RULE_SETS_TL set
180: AUTOMATCH_SET_NAME = X_AUTOMATCH_SET_NAME,
181: DESCRIPTION = X_DESCRIPTION,
182: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
183: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 198: delete from AR_CASH_AUTO_RULE_SETS_TL

194: procedure DELETE_ROW (
195: X_AUTOMATCH_SET_ID in NUMBER
196: ) is
197: begin
198: delete from AR_CASH_AUTO_RULE_SETS_TL
199: where AUTOMATCH_SET_ID = X_AUTOMATCH_SET_ID;
200:
201: if (sql%notfound) then
202: raise no_data_found;

Line 205: delete from AR_CASH_AUTO_RULE_SETS

201: if (sql%notfound) then
202: raise no_data_found;
203: end if;
204:
205: delete from AR_CASH_AUTO_RULE_SETS
206: where AUTOMATCH_SET_ID = X_AUTOMATCH_SET_ID;
207:
208: if (sql%notfound) then
209: raise no_data_found;

Line 216: delete from AR_CASH_AUTO_RULE_SETS_TL T

212:
213: procedure ADD_LANGUAGE
214: is
215: begin
216: delete from AR_CASH_AUTO_RULE_SETS_TL T
217: where not exists
218: (select NULL
219: from AR_CASH_AUTO_RULE_SETS B
220: where B.AUTOMATCH_SET_ID = T.AUTOMATCH_SET_ID

Line 219: from AR_CASH_AUTO_RULE_SETS B

215: begin
216: delete from AR_CASH_AUTO_RULE_SETS_TL T
217: where not exists
218: (select NULL
219: from AR_CASH_AUTO_RULE_SETS B
220: where B.AUTOMATCH_SET_ID = T.AUTOMATCH_SET_ID
221: );
222:
223: update AR_CASH_AUTO_RULE_SETS_TL T set (

Line 223: update AR_CASH_AUTO_RULE_SETS_TL T set (

219: from AR_CASH_AUTO_RULE_SETS B
220: where B.AUTOMATCH_SET_ID = T.AUTOMATCH_SET_ID
221: );
222:
223: update AR_CASH_AUTO_RULE_SETS_TL T set (
224: AUTOMATCH_SET_NAME,
225: DESCRIPTION
226: ) = (select
227: B.AUTOMATCH_SET_NAME,

Line 229: from AR_CASH_AUTO_RULE_SETS_TL B

225: DESCRIPTION
226: ) = (select
227: B.AUTOMATCH_SET_NAME,
228: B.DESCRIPTION
229: from AR_CASH_AUTO_RULE_SETS_TL B
230: where B.AUTOMATCH_SET_ID = T.AUTOMATCH_SET_ID
231: and B.LANGUAGE = T.SOURCE_LANG)
232: where (
233: T.AUTOMATCH_SET_ID,

Line 238: from AR_CASH_AUTO_RULE_SETS_TL SUBB, AR_CASH_AUTO_RULE_SETS_TL SUBT

234: T.LANGUAGE
235: ) in (select
236: SUBT.AUTOMATCH_SET_ID,
237: SUBT.LANGUAGE
238: from AR_CASH_AUTO_RULE_SETS_TL SUBB, AR_CASH_AUTO_RULE_SETS_TL SUBT
239: where SUBB.AUTOMATCH_SET_ID = SUBT.AUTOMATCH_SET_ID
240: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
241: and (SUBB.AUTOMATCH_SET_NAME <> SUBT.AUTOMATCH_SET_NAME
242: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 247: insert into AR_CASH_AUTO_RULE_SETS_TL (

243: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
244: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
245: ));
246:
247: insert into AR_CASH_AUTO_RULE_SETS_TL (
248: AUTOMATCH_SET_ID,
249: AUTOMATCH_SET_NAME,
250: DESCRIPTION,
251: CREATED_BY,

Line 269: from AR_CASH_AUTO_RULE_SETS_TL B, FND_LANGUAGES L

265: B.LAST_UPDATE_DATE,
266: B.LAST_UPDATE_LOGIN,
267: L.LANGUAGE_CODE,
268: B.SOURCE_LANG
269: from AR_CASH_AUTO_RULE_SETS_TL B, FND_LANGUAGES L
270: where L.INSTALLED_FLAG in ('I', 'B')
271: and B.LANGUAGE = userenv('LANG')
272: and not exists
273: (select NULL

Line 274: from AR_CASH_AUTO_RULE_SETS_TL T

270: where L.INSTALLED_FLAG in ('I', 'B')
271: and B.LANGUAGE = userenv('LANG')
272: and not exists
273: (select NULL
274: from AR_CASH_AUTO_RULE_SETS_TL T
275: where T.AUTOMATCH_SET_ID = B.AUTOMATCH_SET_ID
276: and T.LANGUAGE = L.LANGUAGE_CODE);
277: end ADD_LANGUAGE;
278:

Line 286: update AR_CASH_AUTO_RULE_SETS_TL

282: X_DESCRIPTION in VARCHAR2,
283: X_OWNER in VARCHAR2) IS
284: begin
285:
286: update AR_CASH_AUTO_RULE_SETS_TL
287: set AUTOMATCH_SET_NAME = X_AUTOMATCH_SET_NAME,
288: DESCRIPTION = X_DESCRIPTION,
289: source_lang = userenv('LANG'),
290: last_update_date = sysdate,