DBA Data[Home] [Help]

PACKAGE: APPS.JG_ZZ_ENTITY_ASSOC_PKG

Source


1 PACKAGE JG_ZZ_ENTITY_ASSOC_PKG AUTHID CURRENT_USER AS
2 /* $Header: jgzzieas.pls 115.3 2002/11/21 17:57:36 thwon ship $  */
3 
4 PROCEDURE insert_row( x_rowid IN OUT NOCOPY VARCHAR2,
5                       x_entity_association_id NUMBER,
6                       x_primary_id_number VARCHAR2,
7                       x_associated_entity_id NUMBER,
8                       x_id_type VARCHAR2,
9                       x_id_number VARCHAR2,
10                       x_description VARCHAR2,
11                       x_effective_date DATE,
12                       x_ineffective_date DATE,
13                       x_attribute_category VARCHAR2,
14                       x_attribute1 VARCHAR2,
15                       x_attribute2 VARCHAR2,
16                       x_attribute3 VARCHAR2,
17                       x_attribute4 VARCHAR2,
18                       x_attribute5 VARCHAR2,
19                       x_attribute6 VARCHAR2,
20                       x_attribute7 VARCHAR2,
21                       x_attribute8 VARCHAR2,
22                       x_attribute9 VARCHAR2,
23                       x_attribute10 VARCHAR2,
24                       x_attribute11 VARCHAR2,
25                       x_attribute12 VARCHAR2,
26                       x_attribute13 VARCHAR2,
27                       x_attribute14 VARCHAR2,
28                       x_attribute15 VARCHAR2,
29                       x_attribute16 VARCHAR2,
30                       x_attribute17 VARCHAR2,
31                       x_attribute18 VARCHAR2,
32                       x_attribute19 VARCHAR2,
33                       x_attribute20 VARCHAR2,
34                       x_created_by NUMBER,
35                       x_creation_date DATE,
36                       x_last_updated_by NUMBER,
37                       x_last_update_date DATE,
38                       x_last_update_login NUMBER );
39 
40 PROCEDURE lock_row( x_rowid VARCHAR2,
41                     x_entity_association_id NUMBER,
42                     x_primary_id_number VARCHAR2,
43                     x_associated_entity_id NUMBER,
44                     x_id_type VARCHAR2,
45                     x_id_number VARCHAR2,
46                     x_description VARCHAR2,
47                     x_effective_date DATE,
48                     x_ineffective_date DATE,
49                     x_attribute_category VARCHAR2,
50                     x_attribute1 VARCHAR2,
51                     x_attribute2 VARCHAR2,
52                     x_attribute3 VARCHAR2,
53                     x_attribute4 VARCHAR2,
54                     x_attribute5 VARCHAR2,
55                     x_attribute6 VARCHAR2,
56                     x_attribute7 VARCHAR2,
57                     x_attribute8 VARCHAR2,
58                     x_attribute9 VARCHAR2,
59                     x_attribute10 VARCHAR2,
60                     x_attribute11 VARCHAR2,
61                     x_attribute12 VARCHAR2,
62                     x_attribute13 VARCHAR2,
63                     x_attribute14 VARCHAR2,
64                     x_attribute15 VARCHAR2,
65                     x_attribute16 VARCHAR2,
66                     x_attribute17 VARCHAR2,
67                     x_attribute18 VARCHAR2,
68                     x_attribute19 VARCHAR2,
69                     x_attribute20 VARCHAR2,
70                     x_created_by NUMBER,
71                     x_creation_date DATE,
72                     x_last_updated_by NUMBER,
73                     x_last_update_date DATE,
74                     x_last_update_login NUMBER );
75 
76 PROCEDURE update_row( x_rowid VARCHAR2,
77                       x_entity_association_id NUMBER,
78                       x_primary_id_number VARCHAR2,
79                       x_associated_entity_id NUMBER,
80                       x_id_type VARCHAR2,
81                       x_id_number VARCHAR2,
82                       x_description VARCHAR2,
83                       x_effective_date DATE,
84                       x_ineffective_date DATE,
85                       x_attribute_category VARCHAR2,
86                       x_attribute1 VARCHAR2,
87                       x_attribute2 VARCHAR2,
88                       x_attribute3 VARCHAR2,
89                       x_attribute4 VARCHAR2,
90                       x_attribute5 VARCHAR2,
91                       x_attribute6 VARCHAR2,
92                       x_attribute7 VARCHAR2,
93                       x_attribute8 VARCHAR2,
94                       x_attribute9 VARCHAR2,
95                       x_attribute10 VARCHAR2,
96                       x_attribute11 VARCHAR2,
97                       x_attribute12 VARCHAR2,
98                       x_attribute13 VARCHAR2,
99                       x_attribute14 VARCHAR2,
100                       x_attribute15 VARCHAR2,
101                       x_attribute16 VARCHAR2,
102                       x_attribute17 VARCHAR2,
103                       x_attribute18 VARCHAR2,
104                       x_attribute19 VARCHAR2,
105                       x_attribute20 VARCHAR2,
106                       x_created_by NUMBER,
107                       x_creation_date DATE,
108                       x_last_updated_by NUMBER,
109                       x_last_update_date DATE,
110                       x_last_update_login NUMBER );
111 
112 
113 END JG_ZZ_ENTITY_ASSOC_PKG;