DBA Data[Home] [Help]

PACKAGE: APPS.IGI_CIS_CERT_NI_NUMBERS_PKG

Source


1 PACKAGE IGI_CIS_CERT_NI_NUMBERS_PKG AUTHID CURRENT_USER AS
2 /* $Header: igicisbs.pls 115.8 2003/07/22 13:11:49 sdixit ship $ */
3 
4     PROCEDURE Lock_Row(p_row_id            VARCHAR2
5                       ,p_tax_rate_id       NUMBER
6                       ,p_ni_number         VARCHAR2
7                       );
8 
9     PROCEDURE Insert_Row(p_row_id            IN OUT NOCOPY VARCHAR2
10                         ,p_org_id            NUMBER
11                         ,p_tax_rate_id       NUMBER
12                         ,p_ni_number         VARCHAR2
13                         ,p_creation_date     DATE
14                         ,p_created_by        NUMBER
15                         ,p_last_update_date  DATE
16                         ,p_last_updated_by   NUMBER
17                         ,p_last_update_login NUMBER
18                         ,p_calling_sequence  IN OUT NOCOPY VARCHAR2
19                         );
20 
21     PROCEDURE Update_Row(p_row_id            VARCHAR2
22                         ,p_ni_number         VARCHAR2
23                         ,p_last_update_date  DATE
24                         ,p_last_updated_by   NUMBER
25                         ,p_last_update_login NUMBER
26                         );
27 
28 END IGI_CIS_CERT_NI_NUMBERS_PKG;