APPS.JG_ZZ_VAT_REGISTERS_PKG dependencies on JG_ZZ_VAT_REGISTERS_B

Line 14: , x_vat_register_id in out nocopy jg_zz_vat_registers_b.vat_register_id%type

10: -----------------------------------------------------------------------------------------------------------*/
11:
12: procedure insert_row
13: ( x_record jg_zz_vat_registers_vl%rowtype
14: , x_vat_register_id in out nocopy jg_zz_vat_registers_b.vat_register_id%type
15: , x_row_id out nocopy rowid
16: )
17: is
18:

Line 22: select jg_zz_vat_registers_b_s.nextval

18:
19:
20: cursor c_gen_vat_register_id
21: is
22: select jg_zz_vat_registers_b_s.nextval
23: from dual;
24:
25: begin
26:

Line 35: insert into jg_zz_vat_registers_b

31: else
32: x_vat_register_id := x_record.vat_register_id;
33: end if;
34:
35: insert into jg_zz_vat_registers_b
36: ( vat_register_id
37: , vat_reporting_entity_id
38: , register_type
39: , effective_from_date

Line 101: lr_locked_b_row jg_zz_vat_registers_b%rowtype;

97:
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

Line 108: from jg_zz_vat_registers_b

104:
105: cursor c_locked_b_row
106: is
107: select *
108: from jg_zz_vat_registers_b
109: where vat_register_id = x_record.vat_register_id
110: for update nowait;
111:
112: cursor c_locked_tl_row

Line 175: update jg_zz_vat_registers_b

171: begin
172:
173: lv_usr_env_lang := userenv('LANG');
174:
175: update jg_zz_vat_registers_b
176: set vat_reporting_entity_id= x_record.vat_reporting_entity_id
177: , register_type = x_record.register_type
178: , effective_from_date = x_record.effective_from_date
179: , effective_to_date = x_record.effective_to_date

Line 200: procedure delete_row (x_vat_register_id jg_zz_vat_registers_b.vat_register_id%type)

196: end update_row;
197:
198: /*------------------------------------------------------------------------------------------------------------*/
199:
200: procedure delete_row (x_vat_register_id jg_zz_vat_registers_b.vat_register_id%type)
201: is
202: begin
203: delete from jg_zz_vat_registers_b
204: where vat_register_id = x_vat_register_id;

Line 203: delete from jg_zz_vat_registers_b

199:
200: procedure delete_row (x_vat_register_id jg_zz_vat_registers_b.vat_register_id%type)
201: is
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;

Line 221: from jg_zz_vat_registers_b B

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
223: );
224:
225: update jg_zz_vat_registers_tl T