DBA Data[Home] [Help]

PACKAGE: APPS.JG_ZZ_VAT_REGISTERS_PKG

Source


1 package jg_zz_vat_registers_pkg as
2 /* $Header: jgzzvrgs.pls 120.1 2006/06/23 12:24:53 brathod ship $*/
3 /* CHANGE HISTORY ------------------------------------------------------------------------------------------
4 DATE            AUTHOR       VERSION       BUG NO.         DESCRIPTION
5 (DD/MM/YYYY)    (UID)
6 ------------------------------------------------------------------------------------------------------------
7 23/6/2006       BRATHOD      120.1         5166688         Modified the signature of INSERT_ROW procedure in
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_registers_vl%rowtype
13             , x_vat_register_id in  out nocopy    jg_zz_vat_registers_b.vat_register_id%type
14             , x_row_id          out     nocopy    rowid
15             );
16 
17   procedure lock_row
18             ( x_record                            jg_zz_vat_registers_vl%rowtype
19             );
20   procedure update_row
21             ( x_record                            jg_zz_vat_registers_vl%rowtype
22             );
23   procedure delete_row
24             ( x_vat_register_id  jg_zz_vat_registers_b.vat_register_id%type
25             );
26 
27   procedure add_language;
28 
29   procedure LOAD_ROW (
30     x_VAT_REGISTER_ID              in  NUMBER,
31     x_VAT_REPORTING_ENTITY_ID      in  NUMBER,
32     x_REGISTER_TYPE                in  VARCHAR2,
33     x_REGISTER_NAME                in  VARCHAR2,
34     x_EFFECTIVE_FROM_DATE          in  DATE,
35     x_EFFECTIVE_TO_DATE            in  DATE,
36     x_OWNER                        in  VARCHAR2
37   );
38 
39   procedure TRANSLATE_ROW (
40     X_VAT_REGISTER_ID   in NUMBER,
41     X_REGISTER_NAME     in VARCHAR2,
42     X_OWNER             in VARCHAR2
43   );
44 
45 end jg_zz_vat_registers_pkg;