APPS.OKS_ORDER_CONTACTS_PVT dependencies on OKC_API

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

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;

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

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

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

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 :

Line 19: p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,

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,

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

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:

Line 48: p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,

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,

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

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:

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

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

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

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