1 PACKAGE JTF_CAL_Addr_PVT AUTHID CURRENT_USER AS
2 /* $Header: jtfvcas.pls 115.6 2002/04/09 10:56:35 pkm ship $ */
3
4 TYPE AddrRec IS RECORD
5 ( ADDRESS_ID NUMBER
6 , RESOURCE_ID NUMBER
7 , CREATED_BY NUMBER
8 , CREATION_DATE DATE
9 , LAST_UPDATED_BY NUMBER
10 , LAST_UPDATE_DATE DATE
11 , LAST_UPDATE_LOGIN NUMBER
12 , LAST_NAME VARCHAR2(2000)
13 , FIRST_NAME VARCHAR2(2000)
14 , JOB_TITLE VARCHAR2(2000)
15 , COMPANY VARCHAR2(2000)
16 , PRIMARY_CONTACT NUMBER
17 , CONTACT1_TYPE VARCHAR2(2000)
18 , CONTACT1 VARCHAR2(2000)
19 , CONTACT2_TYPE VARCHAR2(2000)
20 , CONTACT2 VARCHAR2(2000)
21 , CONTACT3_TYPE VARCHAR2(2000)
22 , CONTACT3 VARCHAR2(2000)
23 , CONTACT4_TYPE VARCHAR2(2000)
24 , CONTACT4 VARCHAR2(2000)
25 , CONTACT5_TYPE VARCHAR2(2000)
26 , CONTACT5 VARCHAR2(2000)
27 , WWW_ADDRESS VARCHAR2(2000)
28 , ASSISTANT_NAME VARCHAR2(2000)
29 , ASSISTANT_PHONE VARCHAR2(2000)
30 , CATEGORY NUMBER
31 , ADDRESS1 VARCHAR2(2000)
32 , ADDRESS2 VARCHAR2(2000)
33 , ADDRESS3 VARCHAR2(2000)
34 , ADDRESS4 VARCHAR2(2000)
35 , CITY VARCHAR2(2000)
36 , COUNTY VARCHAR2(2000)
37 , STATE VARCHAR2(2000)
38 , ZIP VARCHAR2(2000)
39 , COUNTRY VARCHAR2(2000)
40 , NOTE VARCHAR2(4000)
41 , PRIVATE_FLAG VARCHAR2(1)
42 , DELETED_AS_OF DATE
43 , APPLICATION_ID NUMBER
44 , SECURITY_GROUP_ID NUMBER
45 , OBJECT_VERSION_NUMBER NUMBER(9)
46 );
47
48 --------------------------------------------------------------------------
49 -- Start of comments
50 -- API name : Insert_Row
51 -- Type : Private
52 -- Function : Create record in JTF_CAL_ADDRESSES table.
53 -- Pre-reqs : None.
54 -- Parameters :
55 -- name direction type required?
56 -- ---- --------- ---- ---------
57 -- p_api_version IN NUMBER required
58 -- p_init_msg_list IN VARCHAR2 optional
59 -- p_commit IN VARCHAR2 optional
60 -- p_validation_level IN NUMBER optional
61 -- x_return_status OUT VARCHAR2 required
62 -- x_msg_count OUT NUMBER required
63 -- x_msg_data OUT VARCHAR2 required
64 -- p_bel_rec IN cal_address_rec_type required
65 -- x_address_id OUT NUMBER required
66 --
67 -- Version : Current version 1.0
68 -- Previous version 1.0
69 -- Initial version 1.0
70 --
71 -- Notes: The object_version_number of a new entry is always 1.
72 --
73 -- End of comments
74 --------------------------------------------------------------------------
75 PROCEDURE Insert_Row
76 ( p_api_version IN NUMBER
77 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
78 , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
79 , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
80 , x_return_status OUT VARCHAR2
81 , x_msg_count OUT NUMBER
82 , x_msg_data OUT VARCHAR2
83 , p_adr_rec IN AddrRec
84 , x_address_id OUT NUMBER
85 );
86
87 --------------------------------------------------------------------------
88 -- Start of comments
89 -- API name : Update_Row
90 -- Type : Private
91 -- Function : Update record in JTF_CAL_ADDRESSES table.
92 -- Pre-reqs : None.
93 -- Parameters :
94 -- name direction type required?
95 -- ---- --------- -------- ---------
96 -- p_api_version IN NUMBER required
97 -- p_init_msg_list IN VARCHAR2 optional
98 -- p_commit IN VARCHAR2 optional
99 -- p_validation_level IN NUMBER optional
100 -- x_return_status OUT VARCHAR2 required
101 -- x_msg_count OUT NUMBER required
102 -- x_msg_data OUT VARCHAR2 required
103 -- p_adr_rec IN cal_address_rec_type required
104 -- x_object_version_number OUT NUMBER required
105 --
106 -- Version : Current version 1.0
107 -- Previous version 1.0
108 -- Initial version 1.0
109 --
110 -- Notes: An address can only be updated if the object_version_number
111 -- is an exact match.
112 --
113 -- End of comments
114 --------------------------------------------------------------------------
115 PROCEDURE Update_Row
116 ( p_api_version IN NUMBER
117 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
118 , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
119 , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
120 , x_return_status OUT VARCHAR2
121 , x_msg_count OUT NUMBER
122 , x_msg_data OUT VARCHAR2
123 , p_adr_rec IN AddrRec
124 , x_object_version_number OUT NUMBER
125 );
126
127
128 --------------------------------------------------------------------------
129 -- Start of comments
130 -- API Name : Delete_Row
131 -- Type : Private
132 -- Description : Soft delete record in JTF_CAL_ADDRESSES table.
133 -- Pre-reqs : None
134 -- Parameters :
135 -- name direction type required?
136 -- ---- --------- ---- ---------
137 -- p_api_version IN NUMBER required
138 -- p_init_msg_list IN VARCHAR2 optional
139 -- p_commit IN VARCHAR2 optional
140 -- p_validation_level IN NUMBER optional
141 -- x_return_status OUT VARCHAR2 required
142 -- x_msg_count OUT NUMBER required
143 -- x_msg_data OUT VARCHAR2 required
144 -- p_address_id IN NUMBER required
145 -- p_object_version_number IN NUMBER required
146 --
147 -- Version : Current version 1.0
148 -- Previous version 1.0
149 -- Initial version 1.0
150 --
151 -- Notes: An address can only be deleted if the object_version_number
152 -- is an exact match.
153 --
154 -- End of comments
155 --------------------------------------------------------------------------
156 PROCEDURE Delete_Row
157 ( p_api_version IN NUMBER
158 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
159 , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
160 , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
161 , x_return_status OUT VARCHAR2
162 , x_msg_count OUT NUMBER
163 , x_msg_data OUT VARCHAR2
164 , p_address_id IN NUMBER
165 , p_object_version_number IN NUMBER
166 );
167 END JTF_CAL_Addr_PVT;