[Home] [Help]
PACKAGE: APPS.HZ_INDUSTRIAL_REFERENCE_PKG
Source
1 PACKAGE HZ_INDUSTRIAL_REFERENCE_PKG AUTHID CURRENT_USER as
2 /* $Header: ARHORITS.pls 115.2 2002/11/21 19:21:38 sponnamb ship $ */
3
4
5 PROCEDURE Insert_Row(
6 x_Rowid IN OUT NOCOPY VARCHAR2,
7 x_INDUSTRY_REFERENCE_ID NUMBER,
8 x_INDUSTRY_REFERENCE VARCHAR2,
9 x_ISSUED_BY_AUTHORITY VARCHAR2,
10 x_NAME_OF_REFERENCE VARCHAR2,
11 x_RECOGNIZED_AS_OF_DATE DATE,
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_PARTY_ID NUMBER,
23 x_STATUS VARCHAR2);
24
25
26
27 PROCEDURE Lock_Row(
28 x_Rowid VARCHAR2,
29 x_INDUSTRY_REFERENCE_ID NUMBER,
30 x_INDUSTRY_REFERENCE VARCHAR2,
31 x_ISSUED_BY_AUTHORITY VARCHAR2,
32 x_NAME_OF_REFERENCE VARCHAR2,
33 x_RECOGNIZED_AS_OF_DATE DATE,
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_PARTY_ID NUMBER,
45 x_STATUS VARCHAR2);
46
47
48
49 PROCEDURE Update_Row(
50 x_Rowid IN OUT NOCOPY VARCHAR2,
51 x_INDUSTRY_REFERENCE_ID NUMBER,
52 x_INDUSTRY_REFERENCE VARCHAR2,
53 x_ISSUED_BY_AUTHORITY VARCHAR2,
54 x_NAME_OF_REFERENCE VARCHAR2,
55 x_RECOGNIZED_AS_OF_DATE DATE,
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_PARTY_ID NUMBER,
67 x_STATUS VARCHAR2);
68
69
70
71 PROCEDURE Delete_Row( x_INDUSTRY_REFERENCE_ID NUMBER);
72
73 END HZ_INDUSTRIAL_REFERENCE_PKG;