1 PACKAGE jta_sync_common AUTHID CURRENT_USER AS
2 /* $Header: jtavscs.pls 120.4 2006/04/12 03:27:18 deeprao ship $ */
3 /*=======================================================================+
4 | Copyright (c) 2002 Oracle Corporation Redwood Shores, California, USA|
5 | All rights reserved. |
6 +=======================================================================+
7 | FILENAME |
8 | jtavscs.pls |
9 | |
10 | DESCRIPTION |
11 | - This package is implemented for the commonly used procedure or |
12 | function. |
13 | |
14 | NOTES |
15 | |
16 | Date Developer Change |
17 | ------ --------------- -------------------------------------- |
18 | 01-Feb-2002 rdespoto Modified |
19 | 12-Feb-2002 cjang Added get_userid,get_resourceid, |
20 | get_timezoneid,get_messages |
21 | 27-Feb-2002 hbouten Added get_territory_code |
22 +======================================================================*/
23
24 /**
25 * This package is implemented for the commonly used procedure or function in Contact Sync.
26 * @rep:scope private
27 * @rep:product CAC
28 * @rep:lifecycle active
29 * @rep:displayname Synchronization Common
30 * @rep:compatibility N
31 * @rep:category BUSINESS_ENTITY CAC_SYNC_SERVER
32 */
33 invalid_num_of_records EXCEPTION;
34 sync_success CONSTANT VARCHAR2(7) := 'Success';
35 sync_failure CONSTANT VARCHAR2(7) := 'Failure';
36
37 /**
38 * This function will return the sequence Id
39 * @return The item type number
40 * @rep:displayname Get Sequence Id
41 * @rep:lifecycle active
42 * @rep:compatibility N
43 */
44 FUNCTION get_seqid
45 RETURN NUMBER;
46
47 /**
48 * This function will return whether operation was successful
49 * @return Is successful
50 * @param p_return_status Return status
51 * @rep:displayname Is Success
52 * @rep:lifecycle active
53 * @rep:compatibility N
54 */
55 FUNCTION is_success (
56 p_return_status IN VARCHAR2
57 )
58 RETURN BOOLEAN;
59
60
61 /**
62 * This procedure will put messages to Result
63 * @param p_task_rec Task Record
64 * @p_status Status
65 * @p_user_message User Message
66 * @rep:displayname Put messages to result
67 * @rep:lifecycle active
68 * @rep:compatibility N
69 */
70 PROCEDURE put_messages_to_result (
71 p_task_rec IN OUT NOCOPY jta_sync_task.task_rec,
72 p_status IN NUMBER,
73 p_user_message IN VARCHAR2
74 );
75
76 /**
77 * This procedure will put messages to Result
78 * @param p_contact_rec Contact Record
79 * @p_status Status
80 * @rep:displayname Put messages to result
81 * @rep:lifecycle active
82 * @rep:compatibility N
83 */
84 /* Commenting the method for bug # 5029377
85 PROCEDURE put_messages_to_result (
86 p_contact_rec IN OUT NOCOPY jta_sync_contact.contact_rec,
87 p_status IN NUMBER
88 );*/
89
90
91
92 /**
93 * This procedure is for logging to Apps
94 * @param p_user_id User Id
95 * @rep:displayname Apps Login
96 * @rep:lifecycle active
97 * @rep:compatibility N
98 */
99 PROCEDURE apps_login (
100 p_user_id IN NUMBER
101 );
102
103
104
105 /**
106 * This procedure is for getting the user Id
107 * @param p_user_name User Name
108 * @x_user_id User Id
109 * @rep:displayname Get User Id
110 * @rep:lifecycle active
111 * @rep:compatibility N
112 */
113 PROCEDURE get_userid (p_user_name IN VARCHAR2
114 ,x_user_id OUT NOCOPY NUMBER);
115
116
117
118 /**
119 * This procedure is for getting the Resource Id
120 * @param p_user_id User Id
121 * @x_resource_id Resource Id
122 * @rep:displayname Get Resource Id
123 * @rep:lifecycle active
124 * @rep:compatibility N
125 */
126 PROCEDURE get_resourceid (p_user_id IN NUMBER
127 ,x_resource_id OUT NOCOPY NUMBER);
128
129
130
131 /**
132 * This procedure is for getting the Timezone Id
133 * @param p_timezone_name User Id
134 * @x_timezone_id Timezone Id
135 * @rep:displayname Get Timezone Id
136 * @rep:lifecycle active
137 * @rep:compatibility N
138 */
139 PROCEDURE get_timezoneid (p_timezone_name IN VARCHAR2
140 ,x_timezone_id OUT NOCOPY NUMBER);
141
142 /**
143 * This function will retrieve the messages
144 * @return Messages
145 * @rep:displayname Get Messages
146 * @rep:lifecycle active
147 * @rep:compatibility N
148 */
149 FUNCTION get_messages
150 RETURN VARCHAR2;
151
152 --------------------------------------------------------------------------
153 -- API name : get_territory_code
154 -- Type : Private
155 -- Function : Tries to convert a country into a CRM territory_code
156 -- Notes:
157 --------------------------------------------------------------------------
158
159 /**
160 * This function tries to convert a country into a CRM territory_code
161 * @return Territory code
162 * @param p_country Country
163 * @rep:displayname Get Territory Code
164 * @rep:lifecycle active
165 * @rep:compatibility N
166 */
167 FUNCTION get_territory_code
168 ( p_country IN VARCHAR2
169 ) RETURN VARCHAR2;
170
171 END;