[Home] [Help]
PACKAGE: APPS.OKC_CHANGE_REQUEST_PVT
Source
1 package OKC_CHANGE_REQUEST_PVT AUTHID CURRENT_USER as
2 /* $Header: OKCCCRTS.pls 120.0 2005/05/26 09:56:51 appldev noship $ */
3
4 -- simple entity object subtype definitions
5 subtype crtv_rec_type is OKC_CRT_PVT.crtv_rec_type;
6 subtype crtv_tbl_type is OKC_CRT_PVT.crtv_tbl_type;
7 subtype corv_rec_type is OKC_COR_PVT.corv_rec_type;
8 subtype corv_tbl_type is OKC_COR_PVT.corv_tbl_type;
9 subtype cprv_rec_type is OKC_CPR_PVT.cprv_rec_type;
10 subtype cprv_tbl_type is OKC_CPR_PVT.cprv_tbl_type;
11
12 -- public procedure declarations
13 -- for use by OKC_CHANGE_REQUEST_PUB public PL/SQL API
14 procedure add_language_change_request;
15 procedure add_language_change;
16 procedure create_change_request(p_api_version IN NUMBER,
17 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
18 x_return_status OUT NOCOPY VARCHAR2,
19 x_msg_count OUT NOCOPY NUMBER,
20 x_msg_data OUT NOCOPY VARCHAR2,
21 p_crtv_rec IN crtv_rec_type,
22 x_crtv_rec OUT NOCOPY crtv_rec_type);
23 procedure update_change_request(p_api_version IN NUMBER,
24 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
25 x_return_status OUT NOCOPY VARCHAR2,
26 x_msg_count OUT NOCOPY NUMBER,
27 x_msg_data OUT NOCOPY VARCHAR2,
28 p_crtv_rec IN crtv_rec_type,
29 x_crtv_rec OUT NOCOPY crtv_rec_type);
30 procedure delete_change_request(p_api_version IN NUMBER,
31 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
32 x_return_status OUT NOCOPY VARCHAR2,
33 x_msg_count OUT NOCOPY NUMBER,
34 x_msg_data OUT NOCOPY VARCHAR2,
35 p_crtv_rec IN crtv_rec_type);
36 procedure lock_change_request(p_api_version IN NUMBER,
37 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
38 x_return_status OUT NOCOPY VARCHAR2,
39 x_msg_count OUT NOCOPY NUMBER,
40 x_msg_data OUT NOCOPY VARCHAR2,
41 p_restricted IN VARCHAR2 default OKC_API.G_TRUE,
42 p_crtv_rec IN crtv_rec_type);
43 procedure validate_change_request(p_api_version IN NUMBER,
44 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
45 x_return_status OUT NOCOPY VARCHAR2,
46 x_msg_count OUT NOCOPY NUMBER,
47 x_msg_data OUT NOCOPY VARCHAR2,
48 p_crtv_rec IN crtv_rec_type);
49 procedure create_change(p_api_version IN NUMBER,
50 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
51 x_return_status OUT NOCOPY VARCHAR2,
52 x_msg_count OUT NOCOPY NUMBER,
53 x_msg_data OUT NOCOPY VARCHAR2,
54 p_corv_rec IN corv_rec_type,
55 x_corv_rec OUT NOCOPY corv_rec_type);
56 procedure update_change(p_api_version IN NUMBER,
57 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
58 x_return_status OUT NOCOPY VARCHAR2,
59 x_msg_count OUT NOCOPY NUMBER,
60 x_msg_data OUT NOCOPY VARCHAR2,
61 p_corv_rec IN corv_rec_type,
62 x_corv_rec OUT NOCOPY corv_rec_type);
63 procedure delete_change(p_api_version IN NUMBER,
64 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
65 x_return_status OUT NOCOPY VARCHAR2,
66 x_msg_count OUT NOCOPY NUMBER,
67 x_msg_data OUT NOCOPY VARCHAR2,
68 p_corv_rec IN corv_rec_type);
69 procedure lock_change(p_api_version IN NUMBER,
70 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
71 x_return_status OUT NOCOPY VARCHAR2,
72 x_msg_count OUT NOCOPY NUMBER,
73 x_msg_data OUT NOCOPY VARCHAR2,
74 p_corv_rec IN corv_rec_type);
75 procedure validate_change(p_api_version IN NUMBER,
76 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
77 x_return_status OUT NOCOPY VARCHAR2,
78 x_msg_count OUT NOCOPY NUMBER,
79 x_msg_data OUT NOCOPY VARCHAR2,
80 p_corv_rec IN corv_rec_type);
81 procedure create_change_party_role(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_cprv_rec IN cprv_rec_type,
87 x_cprv_rec OUT NOCOPY cprv_rec_type);
88 procedure update_change_party_role(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_cprv_rec IN cprv_rec_type,
94 x_cprv_rec OUT NOCOPY cprv_rec_type);
95 procedure delete_change_party_role(p_api_version IN NUMBER,
96 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
97 x_return_status OUT NOCOPY VARCHAR2,
98 x_msg_count OUT NOCOPY NUMBER,
99 x_msg_data OUT NOCOPY VARCHAR2,
100 p_cprv_rec IN cprv_rec_type);
101 procedure lock_change_party_role(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_cprv_rec IN cprv_rec_type);
107 procedure validate_change_party_role(p_api_version IN NUMBER,
108 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
109 x_return_status OUT NOCOPY VARCHAR2,
110 x_msg_count OUT NOCOPY NUMBER,
111 x_msg_data OUT NOCOPY VARCHAR2,
112 p_cprv_rec IN cprv_rec_type);
113 end OKC_CHANGE_REQUEST_PVT;