1: package jg_zz_vat_alloc_rules_pkg as
2: /* $Header: jgzzvars.pls 120.1 2006/06/23 12:24:00 brathod ship $*/
3: /* CHANGE HISTORY ------------------------------------------------------------------------------------------
4: DATE AUTHOR VERSION BUG NO. DESCRIPTION
5: (DD/MM/YYYY) (UID)
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_alloc_rules%rowtype
13: , x_allocation_rule_id out nocopy jg_zz_vat_alloc_rules.allocation_rule_id%type
14: , x_row_id out nocopy rowid
15: );
16: procedure lock_row
9: parameter in the call. Refer bug# 5166688 for details
10: -----------------------------------------------------------------------------------------------------------*/
11: procedure insert_row
12: ( x_record jg_zz_vat_alloc_rules%rowtype
13: , x_allocation_rule_id out nocopy jg_zz_vat_alloc_rules.allocation_rule_id%type
14: , x_row_id out nocopy rowid
15: );
16: procedure lock_row
17: ( x_row_id rowid
14: , x_row_id out nocopy rowid
15: );
16: procedure lock_row
17: ( x_row_id rowid
18: , x_record jg_zz_vat_alloc_rules%rowtype
19: );
20: procedure update_row
21: ( x_record jg_zz_vat_alloc_rules%rowtype
22: );
17: ( x_row_id rowid
18: , x_record jg_zz_vat_alloc_rules%rowtype
19: );
20: procedure update_row
21: ( x_record jg_zz_vat_alloc_rules%rowtype
22: );
23: procedure delete_row
24: ( x_allocation_rule_id jg_zz_vat_alloc_rules.allocation_rule_id%type
25: );
20: procedure update_row
21: ( x_record jg_zz_vat_alloc_rules%rowtype
22: );
23: procedure delete_row
24: ( x_allocation_rule_id jg_zz_vat_alloc_rules.allocation_rule_id%type
25: );
26:
27: end jg_zz_vat_alloc_rules_pkg;
23: procedure delete_row
24: ( x_allocation_rule_id jg_zz_vat_alloc_rules.allocation_rule_id%type
25: );
26:
27: end jg_zz_vat_alloc_rules_pkg;