1: package jg_zz_vat_doc_sequences_pkg AUTHID CURRENT_USER as
2: /* $Header: jgzzvdss.pls 120.1 2006/06/23 12:24:18 brathod ship $*/
3: /* CHANGE HISTORY ------------------------------------------------------------------------------------------
4: DATE AUTHOR VERSION BUG NO. DESCRIPTION
5: (DD/MM/YYYY) (UID)
9: parameter in the call. Refer bug# 5166688 for details
10: -----------------------------------------------------------------------------------------------------------*/
11:
12: procedure insert_row
13: ( x_record jg_zz_vat_doc_sequences%rowtype
14: , x_vat_doc_sequence_id out nocopy jg_zz_vat_doc_sequences.vat_doc_sequence_id%type
15: , x_row_id out nocopy rowid
16: );
17: procedure lock_row
10: -----------------------------------------------------------------------------------------------------------*/
11:
12: procedure insert_row
13: ( x_record jg_zz_vat_doc_sequences%rowtype
14: , x_vat_doc_sequence_id out nocopy jg_zz_vat_doc_sequences.vat_doc_sequence_id%type
15: , x_row_id out nocopy rowid
16: );
17: procedure lock_row
18: ( x_row_id rowid
15: , x_row_id out nocopy rowid
16: );
17: procedure lock_row
18: ( x_row_id rowid
19: , x_record jg_zz_vat_doc_sequences%rowtype
20: );
21: procedure update_row
22: ( x_record jg_zz_vat_doc_sequences%rowtype
23: ) ;
18: ( x_row_id rowid
19: , x_record jg_zz_vat_doc_sequences%rowtype
20: );
21: procedure update_row
22: ( x_record jg_zz_vat_doc_sequences%rowtype
23: ) ;
24: procedure delete_row
25: (x_vat_doc_sequence_id jg_zz_vat_doc_sequences.vat_doc_sequence_id%type
26: );
21: procedure update_row
22: ( x_record jg_zz_vat_doc_sequences%rowtype
23: ) ;
24: procedure delete_row
25: (x_vat_doc_sequence_id jg_zz_vat_doc_sequences.vat_doc_sequence_id%type
26: );
27: end jg_zz_vat_doc_sequences_pkg;
23: ) ;
24: procedure delete_row
25: (x_vat_doc_sequence_id jg_zz_vat_doc_sequences.vat_doc_sequence_id%type
26: );
27: end jg_zz_vat_doc_sequences_pkg;