[Home] [Help]
PACKAGE: APPS.HZ_INDUSTRIAL_CLASSES_PKG
Source
1 PACKAGE HZ_INDUSTRIAL_CLASSES_PKG AUTHID CURRENT_USER as
2 /* $Header: ARHOICTS.pls 115.1 2002/11/21 19:03:36 sponnamb ship $ */
3
4
5 PROCEDURE Insert_Row(
6 x_Rowid IN OUT NOCOPY VARCHAR2,
7 x_INDUSTRIAL_CLASS_ID NUMBER,
8 x_INDUSTRIAL_CODE_NAME VARCHAR2,
9 x_CODE_PRIMARY_SEGMENT VARCHAR2,
10 x_INDUSTRIAL_CLASS_SOURCE VARCHAR2,
11 x_CODE_DESCRIPTION VARCHAR2,
12 x_CREATED_BY NUMBER,
13 x_CREATION_DATE DATE,
14 x_LAST_UPDATE_LOGIN NUMBER,
15 x_LAST_UPDATE_DATE DATE,
16 x_LAST_UPDATED_BY NUMBER,
17 x_REQUEST_ID NUMBER,
18 x_PROGRAM_APPLICATION_ID NUMBER,
19 x_PROGRAM_ID NUMBER,
20 x_PROGRAM_UPDATE_DATE DATE,
21 x_WH_UPDATE_DATE DATE);
22
23
24
25 PROCEDURE Lock_Row(
26 x_Rowid VARCHAR2,
27 x_INDUSTRIAL_CLASS_ID NUMBER,
28 x_INDUSTRIAL_CODE_NAME VARCHAR2,
29 x_CODE_PRIMARY_SEGMENT VARCHAR2,
30 x_INDUSTRIAL_CLASS_SOURCE VARCHAR2,
31 x_CODE_DESCRIPTION VARCHAR2,
32 x_CREATED_BY NUMBER,
33 x_CREATION_DATE DATE,
34 x_LAST_UPDATE_LOGIN NUMBER,
35 x_LAST_UPDATE_DATE DATE,
36 x_LAST_UPDATED_BY NUMBER,
37 x_REQUEST_ID NUMBER,
38 x_PROGRAM_APPLICATION_ID NUMBER,
39 x_PROGRAM_ID NUMBER,
40 x_PROGRAM_UPDATE_DATE DATE,
41 x_WH_UPDATE_DATE DATE);
42
43
44
45 PROCEDURE Update_Row(
46 x_Rowid IN OUT NOCOPY VARCHAR2,
47 x_INDUSTRIAL_CLASS_ID NUMBER,
48 x_INDUSTRIAL_CODE_NAME VARCHAR2,
49 x_CODE_PRIMARY_SEGMENT VARCHAR2,
50 x_INDUSTRIAL_CLASS_SOURCE VARCHAR2,
51 x_CODE_DESCRIPTION VARCHAR2,
52 x_CREATED_BY NUMBER,
53 x_CREATION_DATE DATE,
54 x_LAST_UPDATE_LOGIN NUMBER,
55 x_LAST_UPDATE_DATE DATE,
56 x_LAST_UPDATED_BY NUMBER,
57 x_REQUEST_ID NUMBER,
58 x_PROGRAM_APPLICATION_ID NUMBER,
59 x_PROGRAM_ID NUMBER,
60 x_PROGRAM_UPDATE_DATE DATE,
61 x_WH_UPDATE_DATE DATE);
62
63
64
65 PROCEDURE Delete_Row( x_INDUSTRIAL_CLASS_ID NUMBER);
66
67 END HZ_INDUSTRIAL_CLASSES_PKG;