APPS.JG_ZZ_VAT_DOC_SEQUENCES_PKG dependencies on JG_ZZ_VAT_DOC_SEQUENCES

Line 1: package body jg_zz_vat_doc_sequences_pkg as

1: package body jg_zz_vat_doc_sequences_pkg as
2: /* $Header: jgzzvdsb.pls 120.1 2006/06/23 12:25:40 brathod ship $*/
3: /* CHANGE HISTORY ------------------------------------------------------------------------------------------
4: DATE AUTHOR VERSION BUG NO. DESCRIPTION
5: (DD/MM/YYYY) (UID)

Line 12: ( x_record jg_zz_vat_doc_sequences%rowtype

8: to return rowid to caller of API by adding out
9: parameter in the call. Refer bug# 5166688 for details
10: -----------------------------------------------------------------------------------------------------------*/
11: procedure insert_row
12: ( x_record jg_zz_vat_doc_sequences%rowtype
13: , x_vat_doc_sequence_id out nocopy jg_zz_vat_doc_sequences.vat_doc_sequence_id%type
14: , x_row_id out nocopy rowid
15: )
16: is

Line 13: , x_vat_doc_sequence_id out nocopy jg_zz_vat_doc_sequences.vat_doc_sequence_id%type

9: parameter in the call. Refer bug# 5166688 for details
10: -----------------------------------------------------------------------------------------------------------*/
11: procedure insert_row
12: ( x_record jg_zz_vat_doc_sequences%rowtype
13: , x_vat_doc_sequence_id out nocopy jg_zz_vat_doc_sequences.vat_doc_sequence_id%type
14: , x_row_id out nocopy rowid
15: )
16: is
17: le_doc_sequence_exists exception;

Line 21: select jg_zz_vat_doc_sequences_s.nextval

17: le_doc_sequence_exists exception;
18:
19: cursor c_gen_vat_doc_seq_id
20: is
21: select jg_zz_vat_doc_sequences_s.nextval
22: from dual;
23:
24: begin
25:

Line 34: insert into jg_zz_vat_doc_sequences

30: else
31: x_vat_doc_sequence_id := x_record.vat_doc_sequence_id;
32: end if;
33:
34: insert into jg_zz_vat_doc_sequences
35: ( vat_doc_sequence_id
36: , vat_register_id
37: , doc_sequence_id
38: , created_by

Line 63: , x_record jg_zz_vat_doc_sequences%rowtype

59:
60: /*------------------------------------------------------------------------------------------------------------*/
61:
62: procedure lock_row( x_row_id rowid
63: , x_record jg_zz_vat_doc_sequences%rowtype
64: )
65: is
66: cursor c_locked_row
67: is

Line 69: from jg_zz_vat_doc_sequences

65: is
66: cursor c_locked_row
67: is
68: select *
69: from jg_zz_vat_doc_sequences
70: where rowid = x_row_id
71: for update nowait;
72:
73: lr_locked_row jg_zz_vat_doc_sequences%rowtype;

Line 73: lr_locked_row jg_zz_vat_doc_sequences%rowtype;

69: from jg_zz_vat_doc_sequences
70: where rowid = x_row_id
71: for update nowait;
72:
73: lr_locked_row jg_zz_vat_doc_sequences%rowtype;
74:
75: begin
76:
77: open c_locked_row;

Line 102: procedure update_row( x_record jg_zz_vat_doc_sequences%rowtype

98: end lock_row;
99:
100: /*------------------------------------------------------------------------------------------------------------*/
101:
102: procedure update_row( x_record jg_zz_vat_doc_sequences%rowtype
103: )
104: is
105:
106: le_no_rows_updated exception;

Line 109: update jg_zz_vat_doc_sequences

105:
106: le_no_rows_updated exception;
107:
108: begin
109: update jg_zz_vat_doc_sequences
110: set vat_register_id = x_record.vat_register_id
111: , doc_sequence_id = x_record.doc_sequence_id
112: , last_updated_by = x_record.last_updated_by
113: , last_update_date = x_record.last_update_date

Line 121: procedure delete_row(x_vat_doc_sequence_id jg_zz_vat_doc_sequences.vat_doc_sequence_id%type)

117: end update_row;
118:
119: /*------------------------------------------------------------------------------------------------------------*/
120:
121: procedure delete_row(x_vat_doc_sequence_id jg_zz_vat_doc_sequences.vat_doc_sequence_id%type)
122: is
123:
124: le_no_rows_deleted exception;
125:

Line 128: delete from jg_zz_vat_doc_sequences

124: le_no_rows_deleted exception;
125:
126: begin
127:
128: delete from jg_zz_vat_doc_sequences
129: where vat_doc_sequence_id = x_vat_doc_sequence_id;
130:
131: end delete_row;
132:

Line 133: end jg_zz_vat_doc_sequences_pkg;

129: where vat_doc_sequence_id = x_vat_doc_sequence_id;
130:
131: end delete_row;
132:
133: end jg_zz_vat_doc_sequences_pkg;