DBA Data[Home] [Help]

APPS.OKS_ORDER_DETAILS_PVT dependencies on OKC_API

Line 4: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;

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;

Line 7: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

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

Line 8: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

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: --

Line 20: p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,

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,

Line 35: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then

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:

Line 49: p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,

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,

Line 63: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then

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:

Line 77: p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,

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

Line 90: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then

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

Line 107: p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,

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

Line 130: p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,

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