1 PACKAGE JTF_TERR_TYPES_PKG AUTHID CURRENT_USER AS
2 /* $Header: jtfvtrts.pls 120.0 2005/06/02 18:23:00 appldev ship $ */
3
4 -- 02/17/00 VNEDUNGA Changing Table handler to accept ORG_ID
5
6 PROCEDURE Insert_Row(
7 x_Rowid IN OUT NOCOPY VARCHAR2,
8 x_TERR_TYPE_ID IN OUT NOCOPY NUMBER,
9 x_LAST_UPDATED_BY IN NUMBER,
10 x_LAST_UPDATE_DATE IN DATE,
11 x_CREATED_BY IN NUMBER,
12 x_CREATION_DATE IN DATE,
13 x_LAST_UPDATE_LOGIN IN NUMBER,
14 x_APPLICATION_SHORT_NAME IN VARCHAR2,
15 x_NAME IN VARCHAR2,
16 x_ENABLED_FLAG IN VARCHAR2,
17 x_DESCRIPTION IN VARCHAR2,
18 x_START_DATE_ACTIVE IN DATE,
19 x_END_DATE_ACTIVE IN DATE,
20 x_ATTRIBUTE_CATEGORY IN VARCHAR2,
21 x_ATTRIBUTE1 IN VARCHAR2,
22 x_ATTRIBUTE2 IN VARCHAR2,
23 x_ATTRIBUTE3 IN VARCHAR2,
24 x_ATTRIBUTE4 IN VARCHAR2,
25 x_ATTRIBUTE5 IN VARCHAR2,
26 x_ATTRIBUTE6 IN VARCHAR2,
27 x_ATTRIBUTE7 IN VARCHAR2,
28 x_ATTRIBUTE8 IN VARCHAR2,
29 x_ATTRIBUTE9 IN VARCHAR2,
30 x_ATTRIBUTE10 IN VARCHAR2,
31 x_ATTRIBUTE11 IN VARCHAR2,
32 x_ATTRIBUTE12 IN VARCHAR2,
33 x_ATTRIBUTE13 IN VARCHAR2,
34 x_ATTRIBUTE14 IN VARCHAR2,
35 x_ATTRIBUTE15 IN VARCHAR2,
36 x_ORG_ID IN NUMBER);
37
38
39
40 PROCEDURE Lock_Row(
41 x_Rowid IN VARCHAR2,
42 x_TERR_TYPE_ID IN NUMBER,
43 x_LAST_UPDATED_BY IN NUMBER,
44 x_LAST_UPDATE_DATE IN DATE,
45 x_CREATED_BY IN NUMBER,
46 x_CREATION_DATE IN DATE,
47 x_LAST_UPDATE_LOGIN IN NUMBER,
48 x_APPLICATION_SHORT_NAME IN VARCHAR2,
49 x_NAME IN VARCHAR2,
50 x_ENABLED_FLAG IN VARCHAR2,
51 x_DESCRIPTION IN VARCHAR2,
52 x_START_DATE_ACTIVE IN DATE,
53 x_END_DATE_ACTIVE IN DATE,
54 x_ATTRIBUTE_CATEGORY IN VARCHAR2,
55 x_ATTRIBUTE1 IN VARCHAR2,
56 x_ATTRIBUTE2 IN VARCHAR2,
57 x_ATTRIBUTE3 IN VARCHAR2,
58 x_ATTRIBUTE4 IN VARCHAR2,
59 x_ATTRIBUTE5 IN VARCHAR2,
60 x_ATTRIBUTE6 IN VARCHAR2,
61 x_ATTRIBUTE7 IN VARCHAR2,
62 x_ATTRIBUTE8 IN VARCHAR2,
63 x_ATTRIBUTE9 IN VARCHAR2,
64 x_ATTRIBUTE10 IN VARCHAR2,
65 x_ATTRIBUTE11 IN VARCHAR2,
66 x_ATTRIBUTE12 IN VARCHAR2,
67 x_ATTRIBUTE13 IN VARCHAR2,
68 x_ATTRIBUTE14 IN VARCHAR2,
69 x_ATTRIBUTE15 IN VARCHAR2,
70 x_ORG_ID IN NUMBER);
71
72
73
74 PROCEDURE Update_Row(
75 x_Rowid IN VARCHAR2,
76 x_TERR_TYPE_ID IN NUMBER,
77 x_LAST_UPDATED_BY IN NUMBER,
78 x_LAST_UPDATE_DATE IN DATE,
79 x_CREATED_BY IN NUMBER,
80 x_CREATION_DATE IN DATE,
81 x_LAST_UPDATE_LOGIN IN NUMBER,
82 x_APPLICATION_SHORT_NAME IN VARCHAR2,
83 x_NAME IN VARCHAR2,
84 x_ENABLED_FLAG IN VARCHAR2,
85 x_DESCRIPTION IN VARCHAR2,
86 x_START_DATE_ACTIVE IN DATE,
87 x_END_DATE_ACTIVE IN DATE,
88 x_ATTRIBUTE_CATEGORY IN VARCHAR2,
89 x_ATTRIBUTE1 IN VARCHAR2,
90 x_ATTRIBUTE2 IN VARCHAR2,
91 x_ATTRIBUTE3 IN VARCHAR2,
92 x_ATTRIBUTE4 IN VARCHAR2,
93 x_ATTRIBUTE5 IN VARCHAR2,
94 x_ATTRIBUTE6 IN VARCHAR2,
95 x_ATTRIBUTE7 IN VARCHAR2,
96 x_ATTRIBUTE8 IN VARCHAR2,
97 x_ATTRIBUTE9 IN VARCHAR2,
98 x_ATTRIBUTE10 IN VARCHAR2,
99 x_ATTRIBUTE11 IN VARCHAR2,
100 x_ATTRIBUTE12 IN VARCHAR2,
101 x_ATTRIBUTE13 IN VARCHAR2,
102 x_ATTRIBUTE14 IN VARCHAR2,
103 x_ATTRIBUTE15 IN VARCHAR2,
104 x_ORG_ID IN NUMBER);
105
106
107
108 PROCEDURE Delete_Row( x_TERR_TYPE_ID IN NUMBER);
109
110 END JTF_TERR_TYPES_PKG;