[Home] [Help]
PACKAGE: APPS.TAPI_DEV_KIT
Source
1 PACKAGE TAPI_DEV_KIT AUTHID CURRENT_USER AS
2 /* $Header: cscttdks.pls 115.3 99/07/16 08:55:04 porting ship $ */
3 ------------------------------------------------------------------------------
4 -- GLOBAL STRUCTURES
5 ------------------------------------------------------------------------------
6 ------------------------------------------------------------------------------
7 -- GLOBAL CONSTANTS
8 ------------------------------------------------------------------------------
9 G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
10 G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
11 G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
12 G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
13 G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
14 --------------------------------------------------------------------------------
15 -- GLOBAL MESSAGE CONSTANTS
16 --------------------------------------------------------------------------------
17 G_FND_APP CONSTANT VARCHAR2(200) := 'FND';
18 G_APP_NAME CONSTANT VARCHAR2(200) := 'CS';
19 ---G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := 'FORM_UNABLE_TO_RESERVE_RECORD';
20 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := 'FORM_COULD_NOT_RESERVE_RECORD';
21 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := 'FORM_RECORD_DELETED';
22 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := 'FORM_RECORD_CHANGED';
23 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_RECORD_LDELETED';
24 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_REQUIRED_VALUE';
25 G_INVALID_VALUE CONSTANT VARCHAR2(200) := 'CS_CONTRACTS_INVALID_VALUE';
26 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := 'COL_NAME';
27 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := 'PARENT_TABLE';
28 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := 'CHILD_TABLE';
29 --------------------------------------------------------------------------------
30 -- ERRORS AND EXCEPTIONS
31 --------------------------------------------------------------------------------
32 G_RET_STS_WARNING CONSTANT VARCHAR2(1) := 'W';
33 G_EXC_WARNING EXCEPTION;
34 G_RET_STS_DUP_VAL_ON_INDEX CONSTANT VARCHAR2(200) := 'DUPLICATE_VALUE_ON_INDEX';
35 G_EXC_DUP_VAL_ON_INDEX EXCEPTION;
36 PRAGMA EXCEPTION_INIT(G_EXC_DUP_VAL_ON_INDEX, -1);
37 ------------------------------------------------------------------------------
38 -- GLOBAL VARIABLES
39 ------------------------------------------------------------------------------
40 ------------------------------------------------------------------------------
41 -- Functions and Procedures
42 ------------------------------------------------------------------------------
43 FUNCTION start_activity(
44 p_api_name IN VARCHAR2,
45 p_pkg_name IN VARCHAR2,
46 p_current_version_number IN NUMBER,
47 p_caller_version_number IN NUMBER,
48 p_init_msg_list IN VARCHAR2,
49 p_api_type IN VARCHAR2,
50 x_return_status OUT VARCHAR2
51 ) RETURN VARCHAR2;
52 FUNCTION handle_exceptions (
53 p_api_name IN VARCHAR2,
54 p_pkg_name IN VARCHAR2,
55 p_exc_name IN VARCHAR2,
56 x_msg_count OUT NUMBER,
57 x_msg_data OUT VARCHAR2,
58 p_api_type IN VARCHAR2,
59 p_others_err_msg IN VARCHAR2
60 ) RETURN VARCHAR2;
61 FUNCTION handle_exceptions
62 (
63 p_api_name IN VARCHAR2,
64 p_pkg_name IN VARCHAR2,
65 p_exc_name IN VARCHAR2,
66 x_msg_count OUT NUMBER,
67 x_msg_data OUT VARCHAR2,
68 p_api_type IN VARCHAR2
69 ) RETURN VARCHAR2;
70 PROCEDURE end_activity
71 (
72 p_commit IN VARCHAR2,
73 x_msg_count IN OUT NUMBER,
74 x_msg_data IN OUT VARCHAR2
75 );
76 PROCEDURE get_who_info
77 (
78 x_creation_date IN OUT DATE,
79 x_created_by IN OUT NUMBER,
80 x_last_update_date IN OUT DATE,
81 x_last_updated_by IN OUT NUMBER,
82 x_last_update_login IN OUT NUMBER
83 );
84
85 PROCEDURE get_who_info
86 (
87 x_last_update_date IN OUT DATE,
88 x_last_updated_by IN OUT NUMBER,
89 x_last_update_login IN OUT NUMBER
90 );
91 PROCEDURE get_who_info (
92 x_creation_date IN OUT DATE,
93 x_created_by IN OUT NUMBER
94 );
95
96 PROCEDURE set_message
97 (
98 p_app_name IN VARCHAR2,
99 p_msg_name IN VARCHAR2,
100 p_msg_token IN VARCHAR2,
101 p_msg_value IN VARCHAR2
102 );
103 PROCEDURE set_message
104 (
105 p_app_name IN VARCHAR2,
106 p_msg_name IN VARCHAR2
107 );
108 FUNCTION get_primary_key
109 (
110 p_seq_name IN VARCHAR2
111 ) RETURN NUMBER;
112 FUNCTION g_miss_num_f RETURN NUMBER;
113 FUNCTION g_miss_date_f RETURN DATE;
114 FUNCTION g_miss_char_f RETURN VARCHAR2;
115 END TAPI_DEV_KIT;