[Home] [Help]
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;