PACKAGE: APPS.CAC_SYNC_COMMON

Source

1 PACKAGE cac_sync_common AUTHID CURRENT_USER AS
2 /* $Header: cacstcos.pls 120.4 2005/09/27 09:24:14 rhshriva noship $ */
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-2004  Sanjeev K. Choudhary  Created                            |
19  +======================================================================*/
20    invalid_num_of_records EXCEPTION;
21    sync_success CONSTANT VARCHAR2(7) := 'Success';
22    sync_failure CONSTANT VARCHAR2(7) := 'Failure';
23 
24    FUNCTION get_seqid
25       RETURN NUMBER;
26 
27    FUNCTION is_success (
28       p_return_status IN VARCHAR2
29       )
30       RETURN BOOLEAN;
31 
32   PROCEDURE put_messages_to_result (
33       p_task_rec     IN OUT NOCOPY cac_sync_task.task_rec,
34       p_status       IN     NUMBER,
35       p_user_message IN     VARCHAR2,
36       p_token_name   IN     VARCHAR2  default null,
37       p_token_value  IN     VARCHAR2  default null
38    );
39 
40   /* PROCEDURE put_messages_to_result (
41       p_contact_rec  IN OUT NOCOPY cac_sync_contact.contact_rec,
42       p_status       IN     NUMBER
43    );  */
44 
45    PROCEDURE apps_login (
46       p_user_id IN NUMBER
47    );
48 
49    PROCEDURE get_userid (p_user_name  IN VARCHAR2
50                         ,x_user_id   OUT NOCOPY NUMBER);
51 
52    PROCEDURE get_resourceid (p_user_id      IN NUMBER
53                             ,x_resource_id OUT NOCOPY NUMBER);
54 
55    PROCEDURE get_timezoneid (p_timezone_name  IN VARCHAR2
56                             ,x_timezone_id   OUT NOCOPY NUMBER);
57    FUNCTION get_messages
58    RETURN VARCHAR2;
59 
60    --------------------------------------------------------------------------
61    --  API name    : get_territory_code
62    --  Type        : Private
63    --  Function    : Tries to convert a country into a CRM territory_code
64    --  Notes:
65    --------------------------------------------------------------------------
66    FUNCTION get_territory_code
67    ( p_country IN     VARCHAR2
68    ) RETURN VARCHAR2;
69 
70 
71 
72 
73      PROCEDURE put_message_to_excl_record (
74       p_exclusion_rec     IN OUT NOCOPY  cac_sync_task.exclusion_rec,
75       p_status       IN     NUMBER,
76       p_user_message IN     VARCHAR2,
77       p_token_name   IN     VARCHAR2 default null,
78       p_token_value  IN     VARCHAR2 default null
79    );
80 
81 
82 END;
83 
84 
85