[Home] [Help]
PACKAGE BODY: APPS.OKS_ORDER_CONTACTS_PVT
Source
1 PACKAGE BODY OKS_ORDER_CONTACTS_PVT AS
2 /* $Header: OKSCCOCB.pls 120.0 2005/05/25 18:11:51 appldev noship $ */
3
4
5 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
6 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_ORDER_CONTACTS_PVT';
7 G_CHILD_RECORD_FOUND CONSTANT varchar2(200) := 'OKC_CHILD_RECORD_FOUND';
8 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
9 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
10 -- Start of comments
11 --
12 -- Procedure Name : create_Order_Contact
13 -- Description :
14 -- Business Rules :
15 -- Parameters :
16 -- Version : 1.0
17 -- End of comments
18 procedure create_Order_Contact(p_api_version IN NUMBER,
19 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
20 x_return_status OUT NOCOPY VARCHAR2,
21 x_msg_count OUT NOCOPY NUMBER,
22 x_msg_data OUT NOCOPY VARCHAR2,
23 p_cocv_rec IN cocv_rec_type,
24 x_cocv_rec OUT NOCOPY cocv_rec_type) is
25 begin
26 oks_coc_pvt.insert_row(p_api_version => p_api_version,
27 p_init_msg_list => p_init_msg_list,
28 x_return_status => x_return_status,
29 x_msg_count => x_msg_count,
30 x_msg_data => x_msg_data,
31 p_cocv_rec => p_cocv_rec,
32 x_cocv_rec => x_cocv_rec);
33 --V
34 if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
35 return;
36 end if;
37 end create_Order_Contact;
38
39 -- Start of comments
40 --
41 -- Procedure Name : update_Order_Contact
42 -- Description :
43 -- Business Rules :
44 -- Parameters :
45 -- Version : 1.0
46 -- End of comments
47 procedure update_Order_Contact(p_api_version IN NUMBER,
48 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
49 x_return_status OUT NOCOPY VARCHAR2,
50 x_msg_count OUT NOCOPY NUMBER,
51 x_msg_data OUT NOCOPY VARCHAR2,
52 p_cocv_rec IN cocv_rec_type,
53 x_cocv_rec OUT NOCOPY cocv_rec_type) is
54 begin
55 oks_coc_pvt.update_row(p_api_version => p_api_version,
56 p_init_msg_list => p_init_msg_list,
57 x_msg_count => x_msg_count,
58 x_msg_data => x_msg_data,
59 x_return_status => x_return_status,
60 p_cocv_rec => p_cocv_rec,
61 x_cocv_rec => x_cocv_rec);
62 --V
63 if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
64 return;
65 end if;
66 end update_Order_Contact;
67
68 -- Start of comments
69 --
70 -- Procedure Name : delete_Order_Contact
71 -- Description :
72 -- Business Rules :
73 -- Parameters :
74 -- Version : 1.0
75 -- End of comments
76 procedure delete_Order_Contact(p_api_version IN NUMBER,
77 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
78 x_return_status OUT NOCOPY VARCHAR2,
79 x_msg_count OUT NOCOPY NUMBER,
80 x_msg_data OUT NOCOPY VARCHAR2,
81 p_cocv_rec IN cocv_rec_type) is
82 begin
83 oks_coc_pvt.delete_row(p_api_version => p_api_version,
84 p_init_msg_list => p_init_msg_list,
85 x_msg_count => x_msg_count,
86 x_msg_data => x_msg_data,
87 x_return_status => x_return_status,
88 p_cocv_rec => p_cocv_rec);
89 --V
90 if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
91 return;
92 end if;
93 exception
94 WHEN OTHERS THEN
95 null;
96 end delete_Order_Contact;
97
98 -- Start of comments
99 --
100 -- Procedure Name : lock_Order_Contact
101 -- Description :
102 -- Business Rules :
103 -- Parameters :
104 -- Version : 1.0
105 -- End of comments
106 procedure lock_Order_Contact(p_api_version IN NUMBER,
107 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
108 x_return_status OUT NOCOPY VARCHAR2,
109 x_msg_count OUT NOCOPY NUMBER,
110 x_msg_data OUT NOCOPY VARCHAR2,
111 p_cocv_rec IN cocv_rec_type) is
112 begin
113 oks_coc_pvt.lock_row(p_api_version => p_api_version,
114 p_init_msg_list => p_init_msg_list,
115 x_msg_count => x_msg_count,
116 x_msg_data => x_msg_data,
117 x_return_status => x_return_status,
118 p_cocv_rec => p_cocv_rec);
119 end lock_Order_Contact;
120
121 -- Start of comments
122 --
123 -- Procedure Name : validate_Order_Contact
124 -- Description :
125 -- Business Rules :
126 -- Parameters :
127 -- Version : 1.0
128 -- End of comments
129 procedure validate_Order_Contact(p_api_version IN NUMBER,
130 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
131 x_return_status OUT NOCOPY VARCHAR2,
132 x_msg_count OUT NOCOPY NUMBER,
133 x_msg_data OUT NOCOPY VARCHAR2,
134 p_cocv_rec IN cocv_rec_type) is
135 begin
136 oks_coc_pvt.validate_row(p_api_version => p_api_version,
137 p_init_msg_list => p_init_msg_list,
138 x_msg_count => x_msg_count,
139 x_msg_data => x_msg_data,
140 x_return_status => x_return_status,
141 p_cocv_rec => p_cocv_rec);
142 end validate_Order_Contact;
143
144 end OKS_Order_Contacts_PVT;