[Home] [Help]
PACKAGE: APPS.HZ_INDUSTRIAL_CLASS_APP_PKG
Source
1 PACKAGE HZ_INDUSTRIAL_CLASS_APP_PKG AUTHID CURRENT_USER as
2 /* $Header: ARHOCATS.pls 115.3 2002/11/21 19:01:49 sponnamb ship $ */
3
4
5 PROCEDURE Insert_Row(
6 x_Rowid IN OUT NOCOPY VARCHAR2,
7 x_CODE_APPLIED_ID NUMBER,
8 x_BEGIN_DATE DATE,
9 x_PARTY_ID NUMBER,
10 x_END_DATE DATE,
11 x_INDUSTRIAL_CLASS_ID NUMBER,
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 x_CONTENT_SOURCE_TYPE VARCHAR2,
23 x_IMPORTANCE_RANKING VARCHAR2);
24
25
26
27 PROCEDURE Lock_Row(
28 x_Rowid VARCHAR2,
29 x_CODE_APPLIED_ID NUMBER,
30 x_BEGIN_DATE DATE,
31 x_PARTY_ID NUMBER,
32 x_END_DATE DATE,
33 x_INDUSTRIAL_CLASS_ID NUMBER,
34 x_CREATED_BY NUMBER,
35 x_CREATION_DATE DATE,
36 x_LAST_UPDATE_LOGIN NUMBER,
37 x_LAST_UPDATE_DATE DATE,
38 x_LAST_UPDATED_BY NUMBER,
39 x_REQUEST_ID NUMBER,
40 x_PROGRAM_APPLICATION_ID NUMBER,
41 x_PROGRAM_ID NUMBER,
42 x_PROGRAM_UPDATE_DATE DATE,
43 x_WH_UPDATE_DATE DATE,
44 x_CONTENT_SOURCE_TYPE VARCHAR2,
45 x_IMPORTANCE_RANKING VARCHAR2);
46
47
48
49 PROCEDURE Update_Row(
50 x_Rowid IN OUT NOCOPY VARCHAR2,
51 x_CODE_APPLIED_ID NUMBER,
52 x_BEGIN_DATE DATE,
53 x_PARTY_ID NUMBER,
54 x_END_DATE DATE,
55 x_INDUSTRIAL_CLASS_ID NUMBER,
56 x_CREATED_BY NUMBER,
57 x_CREATION_DATE DATE,
58 x_LAST_UPDATE_LOGIN NUMBER,
59 x_LAST_UPDATE_DATE DATE,
60 x_LAST_UPDATED_BY NUMBER,
61 x_REQUEST_ID NUMBER,
62 x_PROGRAM_APPLICATION_ID NUMBER,
63 x_PROGRAM_ID NUMBER,
64 x_PROGRAM_UPDATE_DATE DATE,
65 x_WH_UPDATE_DATE DATE,
66 x_CONTENT_SOURCE_TYPE VARCHAR2,
67 x_IMPORTANCE_RANKING VARCHAR2);
68
69
70
71 PROCEDURE Delete_Row( x_CODE_APPLIED_ID NUMBER);
72
73 END HZ_INDUSTRIAL_CLASS_APP_PKG;