1 PACKAGE JTF_TERR_RSC_PKG AS
2 /* $Header: jtfvtrcs.pls 120.2 2006/05/24 18:45:25 mhtran ship $ */
3 -- 02/22/00 JDOCHERT Passing in ORG_ID to Insert/Update/Lock
4 -- 03/16/00 VNEDUNGA Adding Full access flag
5 -- 06/08/00 VNEDUNGA Adding group_id column
6 -- 06/26/02 ARPATEL Adding person_id column
7 -- 01/09/03 JDOCHERT BUG#2739970
8
9 PROCEDURE Insert_Row(
10 x_Rowid IN OUT NOCOPY VARCHAR2,
11 x_TERR_RSC_ID IN OUT NOCOPY NUMBER,
12 x_LAST_UPDATE_DATE IN DATE,
13 x_LAST_UPDATED_BY IN NUMBER,
14 x_CREATION_DATE IN DATE,
15 x_CREATED_BY IN NUMBER,
16 x_LAST_UPDATE_LOGIN IN NUMBER,
17 x_TERR_ID IN NUMBER,
18 x_RESOURCE_ID IN NUMBER,
19 x_GROUP_ID IN NUMBER,
20 x_RESOURCE_TYPE IN VARCHAR2,
21 x_ROLE IN VARCHAR2,
22 x_PRIMARY_CONTACT_FLAG IN VARCHAR2,
23 x_START_DATE_ACTIVE IN DATE,
24 x_END_DATE_ACTIVE IN DATE,
25 x_FULL_ACCESS_FLAG IN VARCHAR2,
26 x_ORG_ID IN NUMBER
27 );
28
29
30 PROCEDURE Insert_Row(
31 x_Rowid IN OUT NOCOPY VARCHAR2,
32 x_TERR_RSC_ID IN OUT NOCOPY NUMBER,
33 x_LAST_UPDATE_DATE IN DATE,
34 x_LAST_UPDATED_BY IN NUMBER,
35 x_CREATION_DATE IN DATE,
36 x_CREATED_BY IN NUMBER,
37 x_LAST_UPDATE_LOGIN IN NUMBER,
38 x_TERR_ID IN NUMBER,
39 x_RESOURCE_ID IN NUMBER,
40 x_GROUP_ID IN NUMBER,
41 x_RESOURCE_TYPE IN VARCHAR2,
42 x_ROLE IN VARCHAR2,
43 x_PRIMARY_CONTACT_FLAG IN VARCHAR2,
44 x_START_DATE_ACTIVE IN DATE,
45 x_END_DATE_ACTIVE IN DATE,
46 x_FULL_ACCESS_FLAG IN VARCHAR2,
47 x_ORG_ID IN NUMBER,
48 x_ATTRIBUTE_CATEGORY IN VARCHAR2,
49 x_ATTRIBUTE1 IN VARCHAR2,
50 x_ATTRIBUTE2 IN VARCHAR2,
51 x_ATTRIBUTE3 IN VARCHAR2,
52 x_ATTRIBUTE4 IN VARCHAR2,
53 x_ATTRIBUTE5 IN VARCHAR2,
54 x_ATTRIBUTE6 IN VARCHAR2,
55 x_ATTRIBUTE7 IN VARCHAR2,
56 x_ATTRIBUTE8 IN VARCHAR2,
57 x_ATTRIBUTE9 IN VARCHAR2,
58 x_ATTRIBUTE10 IN VARCHAR2,
59 x_ATTRIBUTE11 IN VARCHAR2,
60 x_ATTRIBUTE12 IN VARCHAR2,
61 x_ATTRIBUTE13 IN VARCHAR2,
62 x_ATTRIBUTE14 IN VARCHAR2,
63 x_ATTRIBUTE15 IN VARCHAR2
64 );
65
66
67 PROCEDURE Lock_Row(
68 x_Rowid IN VARCHAR2,
69 x_TERR_RSC_ID IN NUMBER,
70 x_LAST_UPDATE_DATE IN DATE,
71 x_LAST_UPDATED_BY IN NUMBER,
72 x_CREATION_DATE IN DATE,
73 x_CREATED_BY IN NUMBER,
74 x_LAST_UPDATE_LOGIN IN NUMBER,
75 x_TERR_ID IN NUMBER,
76 x_RESOURCE_ID IN NUMBER,
77 x_GROUP_ID IN NUMBER,
78 x_RESOURCE_TYPE IN VARCHAR2,
79 x_ROLE IN VARCHAR2,
80 x_PRIMARY_CONTACT_FLAG IN VARCHAR2,
81 x_START_DATE_ACTIVE IN DATE,
82 x_END_DATE_ACTIVE IN DATE,
83 x_FULL_ACCESS_FLAG IN VARCHAR2,
84 x_ORG_ID IN NUMBER
85 );
86
87
88
89 PROCEDURE Update_Row(
90 x_Rowid IN VARCHAR2,
91 x_TERR_RSC_ID IN NUMBER,
92 x_LAST_UPDATE_DATE IN DATE,
93 x_LAST_UPDATED_BY IN NUMBER,
94 x_CREATION_DATE IN DATE,
95 x_CREATED_BY IN NUMBER,
96 x_LAST_UPDATE_LOGIN IN NUMBER,
97 x_TERR_ID IN NUMBER,
98 x_RESOURCE_ID IN NUMBER,
99 x_GROUP_ID IN NUMBER,
100 x_RESOURCE_TYPE IN VARCHAR2,
101 x_ROLE IN VARCHAR2,
102 x_PRIMARY_CONTACT_FLAG IN VARCHAR2,
103 x_START_DATE_ACTIVE IN DATE,
104 x_END_DATE_ACTIVE IN DATE,
105 x_FULL_ACCESS_FLAG IN VARCHAR2,
106 x_ORG_ID IN NUMBER
107 );
108
109
110
111 PROCEDURE Delete_Row( x_TERR_RSC_ID IN NUMBER);
112
113 END JTF_TERR_RSC_PKG;