[Home] [Help]
PACKAGE: APPS.CS_SYSTEMS_COMMON_PUB
Source
1 package CS_SYSTEMS_COMMON_PUB AUTHID CURRENT_USER as
2 /* $Header: cscommns.pls 115.4 2001/03/13 17:09:35 pkm ship $ */
3 TYPE Sys_Info_Cursor IS REF CURSOR;
4
5 function get_party_id (p_user_id IN NUMBER) return NUMBER;
6 function get_system_id (p_system_name IN VARCHAR2) return NUMBER;
7
8 procedure is_system_enabled(
9 p_api_version_number IN NUMBER,
10 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
11 p_commit IN VARCHAR := FND_API.G_FALSE,
12 x_return_status OUT VARCHAR2,
13 x_msg_count OUT NUMBER,
14 x_msg_data OUT VARCHAR2
15 );
16
17 procedure is_system_valid(
18 p_api_version_number IN NUMBER,
19 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
20 p_system_id IN NUMBER,
21 p_system_name IN VARCHAR2,
22 p_commit IN VARCHAR := FND_API.G_FALSE,
23 x_return_status OUT VARCHAR2,
24 x_msg_count OUT NUMBER,
25 x_msg_data OUT VARCHAR2
26 );
27
28 procedure get_current_system (
29 p_api_version_number IN NUMBER,
30 p_init_msg_list IN VARCHAR2,
31 p_user_id IN NUMBER,
32 p_commit IN VARCHAR,
33 x_system_id OUT NUMBER,
34 x_system_name OUT VARCHAR2,
35 x_return_status OUT VARCHAR2,
36 x_msg_count OUT NUMBER,
37 x_msg_data OUT VARCHAR2
38 );
39
40 procedure get_all_systems_for_user(
41 p_api_version_number IN NUMBER,
42 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
43 p_user_id IN NUMBER,
44 p_commit IN VARCHAR := FND_API.G_FALSE,
45 x_system_data OUT Sys_Info_Cursor,
46 x_return_status OUT VARCHAR2,
47 x_msg_count OUT NUMBER,
48 x_msg_data OUT VARCHAR2
49 );
50
51 procedure get_all_child_systems(
52 p_api_version_number IN NUMBER,
53 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
54 p_system_id IN NUMBER,
55 p_system_name IN VARCHAR2,
56 p_commit IN VARCHAR := FND_API.G_FALSE,
57 x_system_data OUT Sys_Info_Cursor,
58 x_return_status OUT VARCHAR2,
59 x_msg_count OUT NUMBER,
60 x_msg_data OUT VARCHAR2
61 );
62
63 procedure is_user_associated_to_system(
64 p_api_version_number IN NUMBER,
65 p_init_msg_list IN VARCHAR2,
66 p_user_id IN NUMBER,
67 p_system_id IN NUMBER,
68 p_system_name IN VARCHAR2,
69 p_commit IN VARCHAR,
70 x_return_status OUT VARCHAR2,
71 x_msg_count OUT NUMBER,
72 x_msg_data OUT VARCHAR2
73 );
74
75 procedure association_exists(
76 p_api_version_number IN NUMBER,
77 p_init_msg_list IN VARCHAR2,
78 p_system_id IN NUMBER,
79 p_system_name IN VARCHAR2,
80 p_commit IN VARCHAR,
81 x_return_status OUT VARCHAR2,
82 x_msg_count OUT NUMBER,
83 x_msg_data OUT VARCHAR2
84 );
85
86 procedure user_exists(
87 p_api_version_number IN NUMBER,
88 p_init_msg_list IN VARCHAR2,
89 p_system_id IN NUMBER,
90 p_system_name IN VARCHAR2,
91 p_commit IN VARCHAR,
92 x_return_status OUT VARCHAR2,
93 x_msg_count OUT NUMBER,
94 x_msg_data OUT VARCHAR2
95 );
96
97
98 end CS_SYSTEMS_COMMON_PUB;