2: /* $Header: OKEVCCCS.pls 120.1 2005/10/03 12:46:29 ausmani noship $ */
3:
4: subtype chr_rec_type is oke_chr_pvt.chr_rec_type;
5: subtype chr_tbl_type is oke_chr_pvt.chr_tbl_type;
6: subtype cle_rec_type is oke_cle_pvt.cle_rec_type;
7: subtype cle_tbl_type is oke_cle_pvt.cle_tbl_type;
8:
9:
10:
3:
4: subtype chr_rec_type is oke_chr_pvt.chr_rec_type;
5: subtype chr_tbl_type is oke_chr_pvt.chr_tbl_type;
6: subtype cle_rec_type is oke_cle_pvt.cle_rec_type;
7: subtype cle_tbl_type is oke_cle_pvt.cle_tbl_type;
8:
9:
10:
11: -- GLOBAL VARIABLES
89: p_init_msg_list IN VARCHAR2 DEFAULT OKE_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_cle_rec IN OKE_CLE_PVT.cle_rec_type,
94: x_cle_rec OUT NOCOPY OKE_CLE_PVT.cle_rec_type);
95:
96:
97: PROCEDURE create_contract_line(
90: x_return_status OUT NOCOPY VARCHAR2,
91: x_msg_count OUT NOCOPY NUMBER,
92: x_msg_data OUT NOCOPY VARCHAR2,
93: p_cle_rec IN OKE_CLE_PVT.cle_rec_type,
94: x_cle_rec OUT NOCOPY OKE_CLE_PVT.cle_rec_type);
95:
96:
97: PROCEDURE create_contract_line(
98: p_api_version IN NUMBER,
99: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
100: x_return_status OUT NOCOPY VARCHAR2,
101: x_msg_count OUT NOCOPY NUMBER,
102: x_msg_data OUT NOCOPY VARCHAR2,
103: p_cle_tbl IN OKE_CLE_PVT.cle_tbl_type,
104: x_cle_tbl OUT NOCOPY OKE_CLE_PVT.cle_tbl_type);
105:
106: PROCEDURE update_contract_line(
107: p_api_version IN NUMBER,
100: x_return_status OUT NOCOPY VARCHAR2,
101: x_msg_count OUT NOCOPY NUMBER,
102: x_msg_data OUT NOCOPY VARCHAR2,
103: p_cle_tbl IN OKE_CLE_PVT.cle_tbl_type,
104: x_cle_tbl OUT NOCOPY OKE_CLE_PVT.cle_tbl_type);
105:
106: PROCEDURE update_contract_line(
107: p_api_version IN NUMBER,
108: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
108: p_init_msg_list IN VARCHAR2 DEFAULT OKE_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_cle_rec IN OKE_CLE_PVT.cle_rec_type,
113: x_cle_rec OUT NOCOPY OKE_CLE_PVT.cle_rec_type);
114:
115: PROCEDURE update_contract_line(
116: p_api_version IN NUMBER,
109: x_return_status OUT NOCOPY VARCHAR2,
110: x_msg_count OUT NOCOPY NUMBER,
111: x_msg_data OUT NOCOPY VARCHAR2,
112: p_cle_rec IN OKE_CLE_PVT.cle_rec_type,
113: x_cle_rec OUT NOCOPY OKE_CLE_PVT.cle_rec_type);
114:
115: PROCEDURE update_contract_line(
116: p_api_version IN NUMBER,
117: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
117: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
118: x_return_status OUT NOCOPY VARCHAR2,
119: x_msg_count OUT NOCOPY NUMBER,
120: x_msg_data OUT NOCOPY VARCHAR2,
121: p_cle_tbl IN OKE_CLE_PVT.cle_tbl_type,
122: x_cle_tbl OUT NOCOPY OKE_CLE_PVT.cle_tbl_type);
123:
124: PROCEDURE delete_contract_line(
125: p_api_version IN NUMBER,
118: x_return_status OUT NOCOPY VARCHAR2,
119: x_msg_count OUT NOCOPY NUMBER,
120: x_msg_data OUT NOCOPY VARCHAR2,
121: p_cle_tbl IN OKE_CLE_PVT.cle_tbl_type,
122: x_cle_tbl OUT NOCOPY OKE_CLE_PVT.cle_tbl_type);
123:
124: PROCEDURE delete_contract_line(
125: p_api_version IN NUMBER,
126: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
126: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
127: x_return_status OUT NOCOPY VARCHAR2,
128: x_msg_count OUT NOCOPY NUMBER,
129: x_msg_data OUT NOCOPY VARCHAR2,
130: p_cle_tbl IN OKE_CLE_PVT.cle_tbl_type);
131:
132: PROCEDURE delete_contract_line(
133: p_api_version IN NUMBER,
134: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
134: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
135: x_return_status OUT NOCOPY VARCHAR2,
136: x_msg_count OUT NOCOPY NUMBER,
137: x_msg_data OUT NOCOPY VARCHAR2,
138: p_cle_rec IN OKE_CLE_PVT.cle_rec_type);
139:
140:
141: PROCEDURE delete_contract_line(
142: p_api_version IN NUMBER,
152: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
153: x_return_status OUT NOCOPY VARCHAR2,
154: x_msg_count OUT NOCOPY NUMBER,
155: x_msg_data OUT NOCOPY VARCHAR2,
156: p_cle_rec IN OKE_CLE_PVT.cle_rec_type);
157:
158: PROCEDURE validate_contract_line(
159: p_api_version IN NUMBER,
160: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
160: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
161: x_return_status OUT NOCOPY VARCHAR2,
162: x_msg_count OUT NOCOPY NUMBER,
163: x_msg_data OUT NOCOPY VARCHAR2,
164: p_cle_tbl IN OKE_CLE_PVT.cle_tbl_type);
165:
166: PROCEDURE create_deliverable(
167: p_api_version IN NUMBER,
168: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,