2188: l_return_status VARCHAR2(30);
2189: l_msg_count NUMBER;
2190: l_msg_data VARCHAR2(4000);
2191: l_api_version NUMBER :=1.0 ;
2192: l_cpsv_rec Okc_Contract_Pub.cpsv_rec_type;
2193: x_cpsv_rec Okc_Contract_Pub.cpsv_rec_type;
2194: l_init_msg_list VARCHAR2(1) := Okc_Api.G_FALSE;
2195: l_process_id NUMBER;
2196: BEGIN
2189: l_msg_count NUMBER;
2190: l_msg_data VARCHAR2(4000);
2191: l_api_version NUMBER :=1.0 ;
2192: l_cpsv_rec Okc_Contract_Pub.cpsv_rec_type;
2193: x_cpsv_rec Okc_Contract_Pub.cpsv_rec_type;
2194: l_init_msg_list VARCHAR2(1) := Okc_Api.G_FALSE;
2195: l_process_id NUMBER;
2196: BEGIN
2197: mo_global.init('OKC');
2212:
2213: l_cpsv_rec.id := l_process_id;
2214: l_cpsv_rec.in_process_yn := 'E';
2215:
2216: Okc_Contract_Pub.update_contract_process(
2217: p_api_version => l_api_version,
2218: p_init_msg_list => l_init_msg_list,
2219: x_return_status => l_return_status,
2220: x_msg_count => l_msg_count,
2294: l_return_status VARCHAR2(30);
2295: l_msg_count NUMBER;
2296: l_msg_data VARCHAR2(4000);
2297: l_api_version NUMBER :=1.0 ;
2298: l_cpsv_rec Okc_Contract_Pub.cpsv_rec_type;
2299: x_cpsv_rec Okc_Contract_Pub.cpsv_rec_type;
2300: l_init_msg_list VARCHAR2(1) := Okc_Api.G_FALSE;
2301: l_process_id NUMBER;
2302: l_in_process_yn VARCHAR2(1);
2295: l_msg_count NUMBER;
2296: l_msg_data VARCHAR2(4000);
2297: l_api_version NUMBER :=1.0 ;
2298: l_cpsv_rec Okc_Contract_Pub.cpsv_rec_type;
2299: x_cpsv_rec Okc_Contract_Pub.cpsv_rec_type;
2300: l_init_msg_list VARCHAR2(1) := Okc_Api.G_FALSE;
2301: l_process_id NUMBER;
2302: l_in_process_yn VARCHAR2(1);
2303: BEGIN
2319: IF l_in_process_yn = 'E' THEN
2320: l_cpsv_rec.id := l_process_id;
2321: l_cpsv_rec.in_process_yn := NULL;
2322:
2323: Okc_Contract_Pub.update_contract_process(
2324: p_api_version => l_api_version,
2325: p_init_msg_list => l_init_msg_list,
2326: x_return_status => l_return_status,
2327: x_msg_count => l_msg_count,