[Home] [Help]
PACKAGE BODY: APPS.OKS_ORDER_DETAILS_PVT
Source
1 PACKAGE BODY OKS_ORDER_DETAILS_PVT AS
2 /* $Header: OKSCCODB.pls 120.0 2005/05/25 18:32:29 appldev noship $ */
3
4 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
5 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_ORDER_DETAILS_PVT';
6 G_CHILD_RECORD_FOUND CONSTANT varchar2(200) := 'OKC_CHILD_RECORD_FOUND';
7 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
8 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
9
10
11 -- Start of comments
12 --
13 -- Procedure Name : create_Order_Detail
14 -- Description :
15 -- Business Rules :
16 -- Parameters :
17 -- Version : 1.0
18 -- End of comments
19 procedure create_Order_Detail(p_api_version IN NUMBER,
20 p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
21 x_return_status OUT NOCOPY VARCHAR2,
22 x_msg_count OUT NOCOPY NUMBER,
23 x_msg_data OUT NOCOPY VARCHAR2,
24 p_codv_rec IN codv_rec_type,
25 x_codv_rec OUT NOCOPY codv_rec_type) is
26 begin
27 oks_cod_pvt.insert_row(p_api_version => p_api_version,
28 p_init_msg_list => p_init_msg_list,
29 x_msg_count => x_msg_count,
30 x_msg_data => x_msg_data,
31 x_return_status => x_return_status,
32 p_codv_rec => p_codv_rec,
33 x_codv_rec => x_codv_rec);
34 --V
35 if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
36 return;
37 end if;
38 end create_Order_Detail;
39
40 -- Start of comments
41 --
42 -- Procedure Name : update_Order_Detail
43 -- Description :
44 -- Business Rules :
45 -- Parameters :
46 -- Version : 1.0
47 -- End of comments
48 procedure update_Order_Detail(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_codv_rec IN codv_rec_type,
54 x_codv_rec OUT NOCOPY codv_rec_type) is
55 begin
56 oks_cod_pvt.update_row(p_api_version => p_api_version,
57 p_init_msg_list => p_init_msg_list,
58 x_msg_count => x_msg_count,
59 x_msg_data => x_msg_data,
60 x_return_status => x_return_status,
61 p_codv_rec => p_codv_rec,
62 x_codv_rec => x_codv_rec);
63 if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
64 return;
65 end if;
66 end update_Order_Detail;
67
68 -- Start of comments
69 --
70 -- Procedure Name : delete_Order_Detail
71 -- Description :
72 -- Business Rules :
73 -- Parameters :
74 -- Version : 1.0
75 -- End of comments
76 procedure delete_Order_Detail(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_codv_rec IN codv_rec_type) is
82 BEGIN
83 oks_cod_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_codv_rec => p_codv_rec);
89
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_Detail;
97
98 -- Start of comments
99 --
100 -- Procedure Name : lock_Order_Detail
101 -- Description :
102 -- Business Rules :
103 -- Parameters :
104 -- Version : 1.0
105 -- End of comments
106 procedure lock_Order_Detail(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_codv_rec IN codv_rec_type) is
112 begin
113 oks_cod_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_codv_rec => p_codv_rec);
119 end lock_Order_Detail;
120
121 -- Start of comments
122 --
123 -- Procedure Name : validate_Order_Detail
124 -- Description :
125 -- Business Rules :
126 -- Parameters :
127 -- Version : 1.0
128 -- End of comments
129 procedure validate_Order_Detail(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_codv_rec IN codv_rec_type) is
135 begin
136 oks_cod_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_codv_rec => p_codv_rec);
142 end validate_Order_Detail;
143
144 end OKS_Order_Details_PVT;