APPS.CN_LEDGER_BAL_TYPES_ALL_PKG dependencies on CN_LEDGER_BAL_TYPES_ALL_TL

Line 54: insert into CN_LEDGER_BAL_TYPES_ALL_TL (

50: X_LAST_UPDATED_BY,
51: X_LAST_UPDATE_LOGIN
52: );
53:
54: insert into CN_LEDGER_BAL_TYPES_ALL_TL (
55: BALANCE_ID,
56: BALANCE_NAME,
57: LAST_UPDATE_DATE,
58: LAST_UPDATED_BY,

Line 78: from CN_LEDGER_BAL_TYPES_ALL_TL T

74: from FND_LANGUAGES L
75: where L.INSTALLED_FLAG in ('I', 'B')
76: and not exists
77: (select NULL
78: from CN_LEDGER_BAL_TYPES_ALL_TL T
79: where T.BALANCE_ID = X_BALANCE_ID
80: and T.LANGUAGE = L.language_code AND
81: NVL(ORG_ID,NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99));
82:

Line 121: from CN_LEDGER_BAL_TYPES_ALL_TL

117:
118: cursor c1 is select
119: BALANCE_NAME,
120: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
121: from CN_LEDGER_BAL_TYPES_ALL_TL
122: where BALANCE_ID = X_BALANCE_ID
123: and userenv('LANG') in (LANGUAGE, SOURCE_LANG) AND
124: NVL(ORG_ID,NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)
125: for update of BALANCE_ID nowait;

Line 203: update CN_LEDGER_BAL_TYPES_ALL_TL set

199: if (sql%notfound) then
200: raise no_data_found;
201: end if;
202:
203: update CN_LEDGER_BAL_TYPES_ALL_TL set
204: BALANCE_NAME = X_BALANCE_NAME,
205: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
206: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
207: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 222: delete from CN_LEDGER_BAL_TYPES_ALL_TL

218: procedure DELETE_ROW (
219: X_BALANCE_ID in NUMBER
220: ) is
221: begin
222: delete from CN_LEDGER_BAL_TYPES_ALL_TL
223: where BALANCE_ID = X_BALANCE_ID AND
224: NVL(ORG_ID,NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99);
225:
226: if (sql%notfound) then

Line 242: delete from CN_LEDGER_BAL_TYPES_ALL_TL T

238:
239: procedure ADD_LANGUAGE
240: is
241: begin
242: delete from CN_LEDGER_BAL_TYPES_ALL_TL T
243: where not exists
244: (select NULL
245: from CN_LEDGER_BAL_TYPES_ALL_B B
246: where B.BALANCE_ID = T.balance_id

Line 253: update CN_LEDGER_BAL_TYPES_ALL_TL T set (

249: NVL(T.ORG_ID, NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',
250: NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99))
251: );
252:
253: update CN_LEDGER_BAL_TYPES_ALL_TL T set (
254: BALANCE_NAME
255: ) = (select
256: B.BALANCE_NAME
257: from CN_LEDGER_BAL_TYPES_ALL_TL B

Line 257: from CN_LEDGER_BAL_TYPES_ALL_TL B

253: update CN_LEDGER_BAL_TYPES_ALL_TL T set (
254: BALANCE_NAME
255: ) = (select
256: B.BALANCE_NAME
257: from CN_LEDGER_BAL_TYPES_ALL_TL B
258: where B.BALANCE_ID = T.BALANCE_ID
259: and B.LANGUAGE = T.source_lang
260: and NVL(B.ORG_ID,NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',
261: NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) =

Line 270: from CN_LEDGER_BAL_TYPES_ALL_TL SUBB, CN_LEDGER_BAL_TYPES_ALL_TL SUBT

266: T.LANGUAGE
267: ) in (select
268: SUBT.BALANCE_ID,
269: SUBT.LANGUAGE
270: from CN_LEDGER_BAL_TYPES_ALL_TL SUBB, CN_LEDGER_BAL_TYPES_ALL_TL SUBT
271: where SUBB.BALANCE_ID = SUBT.BALANCE_ID
272: and SUBB.LANGUAGE = SUBT.source_lang
273: and NVL(SUBB.ORG_ID,NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',
274: NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) =

Line 282: insert into CN_LEDGER_BAL_TYPES_ALL_TL (

278: or (SUBB.BALANCE_NAME is null and SUBT.BALANCE_NAME is not null)
279: or (SUBB.BALANCE_NAME is not null and SUBT.BALANCE_NAME is null)
280: ));
281:
282: insert into CN_LEDGER_BAL_TYPES_ALL_TL (
283: ORG_ID,
284: BALANCE_ID,
285: BALANCE_NAME,
286: LAST_UPDATE_DATE,

Line 304: from CN_LEDGER_BAL_TYPES_ALL_TL B, FND_LANGUAGES L

300: B.CREATION_DATE,
301: B.CREATED_BY,
302: L.LANGUAGE_CODE,
303: B.SOURCE_LANG
304: from CN_LEDGER_BAL_TYPES_ALL_TL B, FND_LANGUAGES L
305: where L.INSTALLED_FLAG in ('I', 'B')
306: and B.LANGUAGE = userenv('LANG')
307: and not exists
308: (select NULL

Line 309: from CN_LEDGER_BAL_TYPES_ALL_TL T

305: where L.INSTALLED_FLAG in ('I', 'B')
306: and B.LANGUAGE = userenv('LANG')
307: and not exists
308: (select NULL
309: from CN_LEDGER_BAL_TYPES_ALL_TL T
310: where T.BALANCE_ID = B.BALANCE_ID
311: and T.LANGUAGE = L.language_code
312: and NVL(T.ORG_ID,NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',
313: NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) =

Line 394: UPDATE cn_ledger_bal_types_all_tl SET

390: 0
391: );
392: END IF;
393: -- Load The record to _TL table
394: UPDATE cn_ledger_bal_types_all_tl SET
395: BALANCE_NAME = X_BALANCE_NAME,
396: LAST_UPDATE_DATE = sysdate,
397: LAST_UPDATED_BY = user_id,
398: LAST_UPDATE_LOGIN = 0,

Line 404: INSERT INTO cn_ledger_bal_types_all_tl

400: WHERE BALANCE_ID = X_BALANCE_ID
401: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);
402: IF (SQL%NOTFOUND) THEN
403: -- Insert new record to _TL table
404: INSERT INTO cn_ledger_bal_types_all_tl
405: (BALANCE_ID,
406: BALANCE_NAME,
407: LAST_UPDATE_DATE,
408: LAST_UPDATED_BY,

Line 428: FROM CN_LEDGER_BAL_TYPES_ALL_TL T

424: FROM FND_LANGUAGES L
425: WHERE L.INSTALLED_FLAG IN ('I', 'B')
426: AND NOT EXISTS
427: (SELECT NULL
428: FROM CN_LEDGER_BAL_TYPES_ALL_TL T
429: WHERE T.BALANCE_ID = X_BALANCE_ID
430: AND T.LANGUAGE = L.LANGUAGE_CODE);
431: END IF;
432: << end_load_row >>

Line 459: UPDATE cn_ledger_bal_types_all_tl SET

455: ELSE
456: user_id := 0;
457: END IF;
458: -- Update the translation
459: UPDATE cn_ledger_bal_types_all_tl SET
460: balance_name = x_balance_name,
461: last_update_date = sysdate,
462: last_updated_by = user_id,
463: last_update_login = 0,