eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ECX_TRANSACTIONS_PKG dependencies on ECX_TRANSACTIONS

Line 1: package body ECX_TRANSACTIONS_PKG as

1: package body ECX_TRANSACTIONS_PKG as
2: /* $Header: ECXTXNB.pls 120.2.12000000.3 2007/07/20 07:41:17 susaha ship $ */
3:
4: procedure TRANSLATE_ROW(
5: X_TRANSACTION_TYPE IN VARCHAR2,

Line 31: from ecx_transactions

27:
28: begin
29: select transaction_id
30: into l_transaction_id
31: from ecx_transactions
32: where transaction_type = X_TRANSACTION_TYPE
33: and transaction_subtype = X_TRANSACTION_SUBTYPE
34: and party_type = X_PARTY_TYPE;
35:

Line 38: from ecx_transactions_tl

34: and party_type = X_PARTY_TYPE;
35:
36: select last_updated_by, last_update_date
37: into l_db_luby, l_db_ludate
38: from ecx_transactions_tl
39: where transaction_id = l_transaction_id
40: and LANGUAGE = userenv('LANG');
41:
42: -- Update record, honoring customization mode.

Line 51: update ECX_TRANSACTIONS_TL set

47: if ((x_custom_mode = 'FORCE') or
48: ((l_luby = 0) and (l_db_luby = 1)) or
49: ((l_luby = l_db_luby) and (l_ludate > l_db_ludate)))
50: then
51: update ECX_TRANSACTIONS_TL set
52: TRANSACTION_DESCRIPTION = nvl(X_TRANSACTION_DESCRIPTION, TRANSACTION_DESCRIPTION),
53: SOURCE_LANG = userenv('LANG'),
54: LAST_UPDATE_DATE = l_ludate,
55: LAST_UPDATED_BY = l_luby,

Line 102: from ECX_TRANSACTIONS_B

98: LAST_UPDATE_DATE
99: into l_transaction_id,
100: l_db_luby,
101: l_db_ludate
102: from ECX_TRANSACTIONS_B
103: where TRANSACTION_TYPE = X_TRANSACTION_TYPE
104: and TRANSACTION_SUBTYPE = X_TRANSACTION_SUBTYPE
105: and PARTY_TYPE = X_PARTY_TYPE;
106:

Line 116: ecx_transactions_api.update_transaction (

112: if ((x_custom_mode = 'FORCE') or
113: ((l_luby = 0) and (l_db_luby = 1)) or
114: ((l_luby = l_db_luby) and (l_ludate > l_db_ludate)))
115: then
116: ecx_transactions_api.update_transaction (
117: X_RETURN_STATUS => l_ret_code,
118: X_MSG => l_errmsg,
119: P_TRANSACTION_ID => l_transaction_id,
120: P_TRANSACTION_TYPE => X_TRANSACTION_TYPE,

Line 132: ecx_transactions_api.create_transaction (

128: end if;
129: end if;
130: exception
131: when no_data_found then
132: ecx_transactions_api.create_transaction (
133: x_return_status => l_ret_code,
134: x_msg => l_errmsg,
135: x_transaction_id => l_transaction_id,
136: p_transaction_type => X_TRANSACTION_TYPE,

Line 164: cursor C is select ROWID from ECX_TRANSACTIONS_B

160: X_LAST_UPDATE_DATE in DATE,
161: X_LAST_UPDATED_BY in NUMBER,
162: X_LAST_UPDATE_LOGIN in NUMBER
163: ) is
164: cursor C is select ROWID from ECX_TRANSACTIONS_B
165: where TRANSACTION_ID = X_TRANSACTION_ID
166: ;
167: begin
168: insert into ECX_TRANSACTIONS_B (

Line 168: insert into ECX_TRANSACTIONS_B (

164: cursor C is select ROWID from ECX_TRANSACTIONS_B
165: where TRANSACTION_ID = X_TRANSACTION_ID
166: ;
167: begin
168: insert into ECX_TRANSACTIONS_B (
169: TRANSACTION_ID,
170: TRANSACTION_TYPE,
171: TRANSACTION_SUBTYPE,
172: PARTY_TYPE,

Line 192: insert into ECX_TRANSACTIONS_TL (

188: X_LAST_UPDATED_BY,
189: X_LAST_UPDATE_LOGIN
190: );
191:
192: insert into ECX_TRANSACTIONS_TL (
193: TRANSACTION_ID,
194: TRANSACTION_DESCRIPTION,
195: CREATED_BY,
196: CREATION_DATE,

Line 216: from ECX_TRANSACTIONS_TL T

212: from WF_LANGUAGES L
213: where L.INSTALLED_FLAG ='Y'
214: and not exists
215: (select NULL
216: from ECX_TRANSACTIONS_TL T
217: where T.TRANSACTION_ID = X_TRANSACTION_ID
218: and T.LANGUAGE = L.CODE);
219:
220: open c;

Line 241: from ECX_TRANSACTIONS_B

237: cursor c is select
238: TRANSACTION_TYPE,
239: TRANSACTION_SUBTYPE,
240: PARTY_TYPE
241: from ECX_TRANSACTIONS_B
242: where TRANSACTION_ID = X_TRANSACTION_ID
243: for update of TRANSACTION_ID nowait;
244: recinfo c%rowtype;
245:

Line 249: from ECX_TRANSACTIONS_TL

245:
246: cursor c1 is select
247: TRANSACTION_DESCRIPTION,
248: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
249: from ECX_TRANSACTIONS_TL
250: where TRANSACTION_ID = X_TRANSACTION_ID
251: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
252: for update of TRANSACTION_ID nowait;
253: begin

Line 299: update ECX_TRANSACTIONS_B set

295: X_LAST_UPDATED_BY in NUMBER,
296: X_LAST_UPDATE_LOGIN in NUMBER
297: ) is
298: begin
299: update ECX_TRANSACTIONS_B set
300: TRANSACTION_TYPE = X_TRANSACTION_TYPE,
301: TRANSACTION_SUBTYPE = X_TRANSACTION_SUBTYPE,
302: PARTY_TYPE = X_PARTY_TYPE,
303: ADMIN_USER = X_ADMIN_USER,

Line 313: update ECX_TRANSACTIONS_TL set

309: if (sql%notfound) then
310: raise no_data_found;
311: end if;
312:
313: update ECX_TRANSACTIONS_TL set
314: TRANSACTION_DESCRIPTION = X_TRANSACTION_DESCRIPTION,
315: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
316: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
317: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 331: delete from ECX_TRANSACTIONS_TL

327: procedure DELETE_ROW (
328: X_TRANSACTION_ID in NUMBER
329: ) is
330: begin
331: delete from ECX_TRANSACTIONS_TL
332: where TRANSACTION_ID = X_TRANSACTION_ID;
333:
334: if (sql%notfound) then
335: raise no_data_found;

Line 338: delete from ECX_TRANSACTIONS_B

334: if (sql%notfound) then
335: raise no_data_found;
336: end if;
337:
338: delete from ECX_TRANSACTIONS_B
339: where TRANSACTION_ID = X_TRANSACTION_ID;
340:
341: if (sql%notfound) then
342: raise no_data_found;

Line 349: delete from ECX_TRANSACTIONS_TL T

345:
346: procedure ADD_LANGUAGE
347: is
348: begin
349: delete from ECX_TRANSACTIONS_TL T
350: where not exists
351: (select NULL
352: from ECX_TRANSACTIONS_B B
353: where B.TRANSACTION_ID = T.TRANSACTION_ID

Line 352: from ECX_TRANSACTIONS_B B

348: begin
349: delete from ECX_TRANSACTIONS_TL T
350: where not exists
351: (select NULL
352: from ECX_TRANSACTIONS_B B
353: where B.TRANSACTION_ID = T.TRANSACTION_ID
354: );
355:
356: update ECX_TRANSACTIONS_TL T set (

Line 356: update ECX_TRANSACTIONS_TL T set (

352: from ECX_TRANSACTIONS_B B
353: where B.TRANSACTION_ID = T.TRANSACTION_ID
354: );
355:
356: update ECX_TRANSACTIONS_TL T set (
357: TRANSACTION_DESCRIPTION
358: ) = (select
359: B.TRANSACTION_DESCRIPTION
360: from ECX_TRANSACTIONS_TL B

Line 360: from ECX_TRANSACTIONS_TL B

356: update ECX_TRANSACTIONS_TL T set (
357: TRANSACTION_DESCRIPTION
358: ) = (select
359: B.TRANSACTION_DESCRIPTION
360: from ECX_TRANSACTIONS_TL B
361: where B.TRANSACTION_ID = T.TRANSACTION_ID
362: and B.LANGUAGE = T.SOURCE_LANG)
363: where (
364: T.TRANSACTION_ID,

Line 369: from ECX_TRANSACTIONS_TL SUBB, ECX_TRANSACTIONS_TL SUBT

365: T.LANGUAGE
366: ) in (select
367: SUBT.TRANSACTION_ID,
368: SUBT.LANGUAGE
369: from ECX_TRANSACTIONS_TL SUBB, ECX_TRANSACTIONS_TL SUBT
370: where SUBB.TRANSACTION_ID = SUBT.TRANSACTION_ID
371: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
372: and (SUBB.TRANSACTION_DESCRIPTION <> SUBT.TRANSACTION_DESCRIPTION
373: or (SUBB.TRANSACTION_DESCRIPTION is null and SUBT.TRANSACTION_DESCRIPTION is not null)

Line 376: insert into ECX_TRANSACTIONS_TL (

372: and (SUBB.TRANSACTION_DESCRIPTION <> SUBT.TRANSACTION_DESCRIPTION
373: or (SUBB.TRANSACTION_DESCRIPTION is null and SUBT.TRANSACTION_DESCRIPTION is not null)
374: or (SUBB.TRANSACTION_DESCRIPTION is not null and SUBT.TRANSACTION_DESCRIPTION is null)));
375:
376: insert into ECX_TRANSACTIONS_TL (
377: TRANSACTION_ID,
378: TRANSACTION_DESCRIPTION,
379: CREATED_BY,
380: CREATION_DATE,

Line 396: from ECX_TRANSACTIONS_TL B, WF_LANGUAGES L

392: B.LAST_UPDATE_DATE,
393: B.LAST_UPDATE_LOGIN,
394: L.CODE,
395: B.SOURCE_LANG
396: from ECX_TRANSACTIONS_TL B, WF_LANGUAGES L
397: where L.INSTALLED_FLAG = 'Y'
398: and B.LANGUAGE = userenv('LANG')
399: and not exists
400: (select NULL

Line 401: from ECX_TRANSACTIONS_TL T

397: where L.INSTALLED_FLAG = 'Y'
398: and B.LANGUAGE = userenv('LANG')
399: and not exists
400: (select NULL
401: from ECX_TRANSACTIONS_TL T
402: where T.TRANSACTION_ID = B.TRANSACTION_ID
403: and T.LANGUAGE = L.CODE);
404: end ADD_LANGUAGE;
405:

Line 406: end ECX_TRANSACTIONS_PKG;

402: where T.TRANSACTION_ID = B.TRANSACTION_ID
403: and T.LANGUAGE = L.CODE);
404: end ADD_LANGUAGE;
405:
406: end ECX_TRANSACTIONS_PKG;