PACKAGE: APPS.HZ_CERTIFICATIONS_PKG

Source

1 PACKAGE HZ_CERTIFICATIONS_PKG AUTHID CURRENT_USER as
2 /* $Header: ARHOCETS.pls 115.2 2002/11/21 19:16:34 sponnamb ship $ */
3 
4 
5 PROCEDURE Insert_Row(
6                   x_Rowid        IN OUT NOCOPY           VARCHAR2,
7                   x_CERTIFICATION_ID              NUMBER,
8                   x_CERTIFICATION_NAME            VARCHAR2,
9                   x_CURRENT_STATUS                VARCHAR2,
10                   x_PARTY_ID                      NUMBER,
11                   x_EXPIRES_ON_DATE               DATE,
12                   x_GRADE                         VARCHAR2,
13                   x_ISSUED_BY_AUTHORITY           VARCHAR2,
14                   x_ISSUED_ON_DATE                DATE,
15                   x_CREATED_BY                    NUMBER,
16                   x_CREATION_DATE                 DATE,
17                   x_LAST_UPDATE_LOGIN             NUMBER,
18                   x_LAST_UPDATE_DATE              DATE,
19                   x_LAST_UPDATED_BY               NUMBER,
20                   x_REQUEST_ID                    NUMBER,
21                   x_PROGRAM_APPLICATION_ID        NUMBER,
22                   x_PROGRAM_ID                    NUMBER,
23                   x_PROGRAM_UPDATE_DATE           DATE,
24                   x_WH_UPDATE_DATE                DATE,
25                   x_STATUS                        VARCHAR2);
26 
27 
28 
29 PROCEDURE Lock_Row(
30                   x_Rowid                         VARCHAR2,
31                   x_CERTIFICATION_ID              NUMBER,
32                   x_CERTIFICATION_NAME            VARCHAR2,
33                   x_CURRENT_STATUS                VARCHAR2,
34                   x_PARTY_ID                      NUMBER,
35                   x_EXPIRES_ON_DATE               DATE,
36                   x_GRADE                         VARCHAR2,
37                   x_ISSUED_BY_AUTHORITY           VARCHAR2,
38                   x_ISSUED_ON_DATE                DATE,
39                   x_CREATED_BY                    NUMBER,
40                   x_CREATION_DATE                 DATE,
41                   x_LAST_UPDATE_LOGIN             NUMBER,
42                   x_LAST_UPDATE_DATE              DATE,
43                   x_LAST_UPDATED_BY               NUMBER,
44                   x_REQUEST_ID                    NUMBER,
45                   x_PROGRAM_APPLICATION_ID        NUMBER,
46                   x_PROGRAM_ID                    NUMBER,
47                   x_PROGRAM_UPDATE_DATE           DATE,
48                   x_WH_UPDATE_DATE                DATE,
49                   x_STATUS                        VARCHAR2);
50 
51 
52 
53 PROCEDURE Update_Row(
54                   x_Rowid       IN OUT NOCOPY            VARCHAR2,
55                   x_CERTIFICATION_ID              NUMBER,
56                   x_CERTIFICATION_NAME            VARCHAR2,
57                   x_CURRENT_STATUS                VARCHAR2,
58                   x_PARTY_ID                      NUMBER,
59                   x_EXPIRES_ON_DATE               DATE,
60                   x_GRADE                         VARCHAR2,
61                   x_ISSUED_BY_AUTHORITY           VARCHAR2,
62                   x_ISSUED_ON_DATE                DATE,
63                   x_CREATED_BY                    NUMBER,
64                   x_CREATION_DATE                 DATE,
65                   x_LAST_UPDATE_LOGIN             NUMBER,
66                   x_LAST_UPDATE_DATE              DATE,
67                   x_LAST_UPDATED_BY               NUMBER,
68                   x_REQUEST_ID                    NUMBER,
69                   x_PROGRAM_APPLICATION_ID        NUMBER,
70                   x_PROGRAM_ID                    NUMBER,
71                   x_PROGRAM_UPDATE_DATE           DATE,
72                   x_WH_UPDATE_DATE                DATE,
73                   x_STATUS                        VARCHAR2);
74 
75 
76 
77 PROCEDURE Delete_Row(                  x_CERTIFICATION_ID              NUMBER);
78 
79 END HZ_CERTIFICATIONS_PKG;