APPS.JG_ZZ_VAT_REGISTERS_PKG dependencies on JG_ZZ_VAT_REGISTERS_TL

Line 59: insert into jg_zz_vat_registers_tl

55: , x_record.last_update_date
56: , x_record.last_update_login
57: ) returning rowid into x_row_id;
58:
59: insert into jg_zz_vat_registers_tl
60: ( vat_register_id
61: , register_name
62: , language
63: , source_lang

Line 84: from jg_zz_vat_registers_tl jzvrgtl

80: , x_record.last_update_login
81: from fnd_languages fndlang
82: where fndlang.installed_flag in ('I','B')
83: and not exists (select 1
84: from jg_zz_vat_registers_tl jzvrgtl
85: where jzvrgtl.vat_register_id = x_vat_register_id
86: and jzvrgtl.language = fndlang.language_code
87: )
88: );

Line 102: lr_locked_tl_row jg_zz_vat_registers_tl%rowtype;

98: procedure lock_row ( x_record jg_zz_vat_registers_vl%rowtype )
99: is
100:
101: lr_locked_b_row jg_zz_vat_registers_b%rowtype;
102: lr_locked_tl_row jg_zz_vat_registers_tl%rowtype;
103: lv_usr_env_lang fnd_languages.language_code%type;
104:
105: cursor c_locked_b_row
106: is

Line 115: from jg_zz_vat_registers_tl

111:
112: cursor c_locked_tl_row
113: is
114: select *
115: from jg_zz_vat_registers_tl
116: where vat_register_id = x_record.vat_register_id
117: and ( language = lv_usr_env_lang
118: or source_lang = lv_usr_env_lang
119: )

Line 185: update jg_zz_vat_registers_tl

181: , last_update_date = x_record.last_update_date
182: , last_update_login = x_record.last_update_login
183: where vat_register_id = x_record.vat_register_id;
184:
185: update jg_zz_vat_registers_tl
186: set register_name = x_record.register_name
187: , source_lang = lv_usr_env_lang
188: , last_updated_by = x_record.last_updated_by
189: , last_update_date = x_record.last_update_date

Line 206: delete from jg_zz_vat_registers_tl

202: begin
203: delete from jg_zz_vat_registers_b
204: where vat_register_id = x_vat_register_id;
205:
206: delete from jg_zz_vat_registers_tl
207: where vat_register_id = x_vat_register_id;
208:
209: end delete_row;
210:

Line 218: delete from jg_zz_vat_registers_tl T

214: procedure add_language is
215:
216: begin
217:
218: delete from jg_zz_vat_registers_tl T
219: where not exists (
220: select NULL
221: from jg_zz_vat_registers_b B
222: where B.VAT_REGISTER_ID = T.VAT_REGISTER_ID

Line 225: update jg_zz_vat_registers_tl T

221: from jg_zz_vat_registers_b B
222: where B.VAT_REGISTER_ID = T.VAT_REGISTER_ID
223: );
224:
225: update jg_zz_vat_registers_tl T
226: set REGISTER_NAME = (select
227: B.REGISTER_NAME
228: from jg_zz_vat_registers_tl B
229: where B.vAT_REGISTER_ID = T.VAT_REGISTER_ID

Line 228: from jg_zz_vat_registers_tl B

224:
225: update jg_zz_vat_registers_tl T
226: set REGISTER_NAME = (select
227: B.REGISTER_NAME
228: from jg_zz_vat_registers_tl B
229: where B.vAT_REGISTER_ID = T.VAT_REGISTER_ID
230: and B.LANGUAGE = T.SOURCE_LANG)
231: where (T.VAT_REGISTER_ID, T.LANGUAGE ) in
232: (select subt.vat_register_id, subt.language

Line 233: from jg_zz_vat_registers_tl SUBB, jg_zz_vat_registers_tl SUBT

229: where B.vAT_REGISTER_ID = T.VAT_REGISTER_ID
230: and B.LANGUAGE = T.SOURCE_LANG)
231: where (T.VAT_REGISTER_ID, T.LANGUAGE ) in
232: (select subt.vat_register_id, subt.language
233: from jg_zz_vat_registers_tl SUBB, jg_zz_vat_registers_tl SUBT
234: where SUBB.VAT_REGISTER_ID = SUBT.VAT_REGISTER_ID
235: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
236: and (SUBB.REGISTER_NAME <> SUBT.REGISTER_NAME
237: or (SUBB.REGISTER_NAME is null and SUBT.REGISTER_NAME is not null)

Line 242: insert into jg_zz_vat_registers_tl (

238: or (SUBB.REGISTER_NAME is not null and SUBT.REGISTER_NAME is null)
239: )
240: );
241:
242: insert into jg_zz_vat_registers_tl (
243: VAT_REGISTER_ID,
244: REGISTER_NAME,
245: LAST_UPDATE_DATE,
246: LAST_UPDATED_BY,

Line 262: from jg_zz_vat_registers_tl b, fnd_languages l

258: B.CREATED_BY,
259: B.LAST_UPDATE_LOGIN,
260: L.LANGUAGE_CODE,
261: B.SOURCE_LANG
262: from jg_zz_vat_registers_tl b, fnd_languages l
263: where L.INSTALLED_FLAG in ('I', 'B')
264: and B.LANGUAGE = userenv('LANG')
265: and not exists
266: (select NULL

Line 267: from jg_zz_vat_registers_tl T

263: where L.INSTALLED_FLAG in ('I', 'B')
264: and B.LANGUAGE = userenv('LANG')
265: and not exists
266: (select NULL
267: from jg_zz_vat_registers_tl T
268: where T.VAT_REGISTER_ID = B.VAT_REGISTER_ID
269: and T.LANGUAGE = L.LANGUAGE_CODE);
270:
271: end add_language;

Line 329: update jg_zz_vat_registers_tl set

325: X_REGISTER_NAME in VARCHAR2,
326: X_OWNER in VARCHAR2
327: ) is
328: begin
329: update jg_zz_vat_registers_tl set
330: REGISTER_NAME = X_REGISTER_NAME,
331: LAST_UPDATE_DATE = sysdate,
332: LAST_UPDATED_BY = decode(X_OWNER, 'SEED', 1, 0),
333: LAST_UPDATE_LOGIN = 0,