[Home] [Help]
PACKAGE: APPS.OKC_ROLE_SOURCE_PUB
Source
1 Package OKC_ROLE_SOURCE_PUB AS
2 /* $Header: OKCPRSCS.pls 120.0 2005/05/25 18:48:59 appldev noship $ */
3
4 -- simple entity object subtype definitions
5 subtype rscv_rec_type is OKC_RSC_PVT.rscv_rec_type;
6 subtype rscv_tbl_type is OKC_RSC_PVT.rscv_tbl_type;
7 subtype csov_rec_type is OKC_CSO_PVT.csov_rec_type;
8 subtype csov_tbl_type is OKC_CSO_PVT.csov_tbl_type;
9
10 -- global variables
11 g_rscv_rec rscv_rec_type;
12 g_csov_rec csov_rec_type;
13
14 -- public procedure declarations
15 function contact_role_meaning(p_cro_code in varchar2) return varchar2;
16 function source_name(p_jtot_object_code in varchar2) return varchar2;
17 procedure one_role_source_atime(x_return_status OUT NOCOPY VARCHAR2,
18 p_rle_code in varchar2);
19 procedure one_contact_source_atime(x_return_status OUT NOCOPY VARCHAR2,
20 p_rle_code in varchar2);
21 procedure create_role_source(p_api_version IN NUMBER,
22 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
23 x_return_status OUT NOCOPY VARCHAR2,
24 x_msg_count OUT NOCOPY NUMBER,
25 x_msg_data OUT NOCOPY VARCHAR2,
26 p_rscv_rec IN rscv_rec_type,
27 x_rscv_rec OUT NOCOPY rscv_rec_type);
28 procedure update_role_source(p_api_version IN NUMBER,
29 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
30 x_return_status OUT NOCOPY VARCHAR2,
31 x_msg_count OUT NOCOPY NUMBER,
32 x_msg_data OUT NOCOPY VARCHAR2,
33 p_rscv_rec IN rscv_rec_type,
34 x_rscv_rec OUT NOCOPY rscv_rec_type);
35 procedure lock_role_source(p_api_version IN NUMBER,
36 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
37 x_return_status OUT NOCOPY VARCHAR2,
38 x_msg_count OUT NOCOPY NUMBER,
39 x_msg_data OUT NOCOPY VARCHAR2,
40 p_rscv_rec IN rscv_rec_type);
41 procedure validate_role_source(p_api_version IN NUMBER,
42 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
43 x_return_status OUT NOCOPY VARCHAR2,
44 x_msg_count OUT NOCOPY NUMBER,
45 x_msg_data OUT NOCOPY VARCHAR2,
46 p_rscv_rec IN rscv_rec_type);
47 --
48 procedure create_contact_source(p_api_version IN NUMBER,
49 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
50 x_return_status OUT NOCOPY VARCHAR2,
51 x_msg_count OUT NOCOPY NUMBER,
52 x_msg_data OUT NOCOPY VARCHAR2,
53 p_csov_rec IN csov_rec_type,
54 x_csov_rec OUT NOCOPY csov_rec_type);
55 procedure update_contact_source(p_api_version IN NUMBER,
56 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
57 x_return_status OUT NOCOPY VARCHAR2,
58 x_msg_count OUT NOCOPY NUMBER,
59 x_msg_data OUT NOCOPY VARCHAR2,
60 p_csov_rec IN csov_rec_type,
61 x_csov_rec OUT NOCOPY csov_rec_type);
62 procedure lock_contact_source(p_api_version IN NUMBER,
63 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
64 x_return_status OUT NOCOPY VARCHAR2,
65 x_msg_count OUT NOCOPY NUMBER,
66 x_msg_data OUT NOCOPY VARCHAR2,
67 p_csov_rec IN csov_rec_type);
68 procedure validate_contact_source(p_api_version IN NUMBER,
69 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
70 x_return_status OUT NOCOPY VARCHAR2,
71 x_msg_count OUT NOCOPY NUMBER,
72 x_msg_data OUT NOCOPY VARCHAR2,
73 p_csov_rec IN csov_rec_type);
74 procedure create_role_source(p_api_version IN NUMBER,
75 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
76 x_return_status OUT NOCOPY VARCHAR2,
77 x_msg_count OUT NOCOPY NUMBER,
78 x_msg_data OUT NOCOPY VARCHAR2,
79 p_rscv_tbl IN rscv_tbl_type,
80 x_rscv_tbl OUT NOCOPY rscv_tbl_type);
81 procedure update_role_source(p_api_version IN NUMBER,
82 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
83 x_return_status OUT NOCOPY VARCHAR2,
84 x_msg_count OUT NOCOPY NUMBER,
85 x_msg_data OUT NOCOPY VARCHAR2,
86 p_rscv_tbl IN rscv_tbl_type,
87 x_rscv_tbl OUT NOCOPY rscv_tbl_type);
88 procedure lock_role_source(p_api_version IN NUMBER,
89 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
90 x_return_status OUT NOCOPY VARCHAR2,
91 x_msg_count OUT NOCOPY NUMBER,
92 x_msg_data OUT NOCOPY VARCHAR2,
93 p_rscv_tbl IN rscv_tbl_type);
94 procedure validate_role_source(p_api_version IN NUMBER,
95 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
96 x_return_status OUT NOCOPY VARCHAR2,
97 x_msg_count OUT NOCOPY NUMBER,
98 x_msg_data OUT NOCOPY VARCHAR2,
99 p_rscv_tbl IN rscv_tbl_type);
100 --
101 procedure create_contact_source(p_api_version IN NUMBER,
102 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
103 x_return_status OUT NOCOPY VARCHAR2,
104 x_msg_count OUT NOCOPY NUMBER,
105 x_msg_data OUT NOCOPY VARCHAR2,
106 p_csov_tbl IN csov_tbl_type,
107 x_csov_tbl OUT NOCOPY csov_tbl_type);
108 procedure update_contact_source(p_api_version IN NUMBER,
109 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
110 x_return_status OUT NOCOPY VARCHAR2,
111 x_msg_count OUT NOCOPY NUMBER,
112 x_msg_data OUT NOCOPY VARCHAR2,
113 p_csov_tbl IN csov_tbl_type,
114 x_csov_tbl OUT NOCOPY csov_tbl_type);
115 procedure lock_contact_source(p_api_version IN NUMBER,
116 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
117 x_return_status OUT NOCOPY VARCHAR2,
118 x_msg_count OUT NOCOPY NUMBER,
119 x_msg_data OUT NOCOPY VARCHAR2,
120 p_csov_tbl IN csov_tbl_type);
121 procedure validate_contact_source(p_api_version IN NUMBER,
122 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
123 x_return_status OUT NOCOPY VARCHAR2,
124 x_msg_count OUT NOCOPY NUMBER,
125 x_msg_data OUT NOCOPY VARCHAR2,
126 p_csov_tbl IN csov_tbl_type);
127 END OKC_ROLE_SOURCE_PUB;