1 PACKAGE CSL_SERVICEL_WRAPPER_PKG AUTHID CURRENT_USER AS
2 /* $Header: csllwrps.pls 115.10 2003/03/12 05:15:43 vekrishn ship $ */
3
4 /***
5 This function accepts a list of publication items and a publication item
6 name and returns whether the item name was found within the item list.
7 When the item name was found, it will be removed from the list.
8 ***/
9 PROCEDURE APPLY_CLIENT_CHANGES
10 (
11 p_user_name IN VARCHAR2,
12 p_tranid IN NUMBER
13 );
14
15 /***
16 This function returns a translated error message string. If p_api_error
17 is FALSE, it gets message with MESSAGE_NAME = p_message from
18 FND_NEW_MESSAGES and replaces any tokens with the supplied token values.
19 If p_api_error is TRUE, it just returns the api error in the
20 FND_MSG_PUB message stack.
21 ***/
22
23 FUNCTION GET_ERROR_MESSAGE_TEXT
24 (
25 p_api_error IN BOOLEAN DEFAULT FALSE
26 , p_message IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE DEFAULT NULL
27 , p_token_name1 IN VARCHAR2 DEFAULT NULL
28 , p_token_value1 IN VARCHAR2 DEFAULT NULL
29 , p_token_name2 IN VARCHAR2 DEFAULT NULL
30 , p_token_value2 IN VARCHAR2 DEFAULT NULL
31 , p_token_name3 IN VARCHAR2 DEFAULT NULL
32 , p_token_value3 IN VARCHAR2 DEFAULT NULL
33 )
34 RETURN VARCHAR2;
35
36 /***
37 This procedure is called by APPLY_CLIENT_CHANGES wrapper procedure when a
38 record was successfully applied and needs to be deleted from the in-queue.
39 ***/
40 PROCEDURE DELETE_RECORD
41 (
42 p_user_name IN VARCHAR2,
43 p_tranid IN NUMBER,
44 p_seqno IN NUMBER,
45 p_pk IN VARCHAR2,
46 p_object_name IN VARCHAR2,
47 p_pub_name IN VARCHAR2,
48 p_error_msg OUT NOCOPY VARCHAR2,
49 x_return_status IN OUT NOCOPY VARCHAR2
50 );
51
52 /***
53 This procedure is called by APPLY_CLIENT_CHANGES wrapper procedure
54 when a record failed to be processed and needs to be deferred and rejected
55 from mobile.
56 ***/
57
58 PROCEDURE DEFER_RECORD
59 (
60 p_user_name IN VARCHAR2,
61 p_tranid IN NUMBER,
62 p_seqno IN NUMBER,
63 p_pk IN VARCHAR2,
64 p_object_name IN VARCHAR2,
65 p_pub_name IN VARCHAR2,
66 p_error_msg IN VARCHAR2,
67 x_return_status IN OUT NOCOPY VARCHAR2,
68 p_dml_type IN VARCHAR2 DEFAULT 'I'
69 );
70
71 /***
72 This procedure gets called when a record needs to be rejected when e.g.
73 the api provides its own pk
74 ***/
75
76 PROCEDURE REJECT_RECORD
77 (
78 p_user_name IN VARCHAR2,
79 p_tranid IN NUMBER,
80 p_seqno IN NUMBER,
81 p_pk IN VARCHAR2,
82 p_object_name IN VARCHAR2,
83 p_pub_name IN VARCHAR2,
84 p_error_msg IN VARCHAR2,
85 x_return_status IN OUT NOCOPY VARCHAR2
86 );
87
88 /***
89 This procedure gets called when a user gets created
90 ***/
91 PROCEDURE POPULATE_ACCESS_RECORDS ( P_USER_ID IN NUMBER );
92
93 /***
94 This procedure gets called when a user gets deleted
95 ***/
96 PROCEDURE DELETE_ACCESS_RECORDS ( P_USER_ID IN NUMBER );
97
98 /***
99 This function returns a boolean if the markdirty is succesfull
100 The function is autonomous and commits the markdirty.
101 ***/
102 FUNCTION AUTONOMOUS_MARK_DIRTY
103 (
104 p_pub_item IN VARCHAR2,
105 p_accessid IN NUMBER,
106 p_resourceid IN NUMBER,
107 p_dml IN CHAR,
108 p_timestamp IN DATE
109 )
110 RETURN BOOLEAN;
111
112 /***
113 Function to Enable Detection of Conflict
114 ***/
115
116 FUNCTION DETECT_CONFLICT
117 (
118 p_user_name IN VARCHAR2
119 )
120 RETURN VARCHAR2;
121
122
123 /***
124 Function Handler for Resolving Conflicts
125 ***/
126
127 FUNCTION CONFLICT_RESOLUTION_HANDLER
128 ( p_user_name IN VARCHAR2,
129 p_tran_id IN NUMBER,
130 p_sequence IN NUMBER
131 )
132 RETURN VARCHAR2;
133
134 END CSL_SERVICEL_WRAPPER_PKG;