12: ,p_init_msg_list IN VARCHAR2
13: ,x_return_status OUT NOCOPY VARCHAR2
14: ,x_msg_count OUT NOCOPY NUMBER
15: ,x_msg_data OUT NOCOPY VARCHAR2
16: ,p_chr_id IN okc_k_headers_b.id%TYPE
17: ,x_status_code OUT NOCOPY okc_k_headers_b.scs_code%TYPE
18: ) IS
19: CURSOR c_get_oa_sts_csr(cp_chr_id okc_k_headers_b.id%TYPE)IS
20: SELECT sts_code
13: ,x_return_status OUT NOCOPY VARCHAR2
14: ,x_msg_count OUT NOCOPY NUMBER
15: ,x_msg_data OUT NOCOPY VARCHAR2
16: ,p_chr_id IN okc_k_headers_b.id%TYPE
17: ,x_status_code OUT NOCOPY okc_k_headers_b.scs_code%TYPE
18: ) IS
19: CURSOR c_get_oa_sts_csr(cp_chr_id okc_k_headers_b.id%TYPE)IS
20: SELECT sts_code
21: ,contract_number
15: ,x_msg_data OUT NOCOPY VARCHAR2
16: ,p_chr_id IN okc_k_headers_b.id%TYPE
17: ,x_status_code OUT NOCOPY okc_k_headers_b.scs_code%TYPE
18: ) IS
19: CURSOR c_get_oa_sts_csr(cp_chr_id okc_k_headers_b.id%TYPE)IS
20: SELECT sts_code
21: ,contract_number
22: FROM okc_k_headers_b
23: WHERE id = cp_chr_id;
18: ) IS
19: CURSOR c_get_oa_sts_csr(cp_chr_id okc_k_headers_b.id%TYPE)IS
20: SELECT sts_code
21: ,contract_number
22: FROM okc_k_headers_b
23: WHERE id = cp_chr_id;
24: lv_oa_sts_code okc_k_headers_b.sts_code%TYPE;
25: lv_agreement_number okc_k_headers_b.contract_number%TYPE;
26: l_approval_process VARCHAR2(30);
20: SELECT sts_code
21: ,contract_number
22: FROM okc_k_headers_b
23: WHERE id = cp_chr_id;
24: lv_oa_sts_code okc_k_headers_b.sts_code%TYPE;
25: lv_agreement_number okc_k_headers_b.contract_number%TYPE;
26: l_approval_process VARCHAR2(30);
27: l_api_version CONSTANT NUMBER DEFAULT 1.0;
28: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'SUBMIT_OA_FOR_APPROVAL';
21: ,contract_number
22: FROM okc_k_headers_b
23: WHERE id = cp_chr_id;
24: lv_oa_sts_code okc_k_headers_b.sts_code%TYPE;
25: lv_agreement_number okc_k_headers_b.contract_number%TYPE;
26: l_approval_process VARCHAR2(30);
27: l_api_version CONSTANT NUMBER DEFAULT 1.0;
28: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'SUBMIT_OA_FOR_APPROVAL';
29: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_AGRMNT_APPROVAL_PVT.SUBMIT_OA_FOR_APPROVAL';
172: ,p_init_msg_list IN VARCHAR2
173: ,x_return_status OUT NOCOPY VARCHAR2
174: ,x_msg_count OUT NOCOPY NUMBER
175: ,x_msg_data OUT NOCOPY VARCHAR2
176: ,p_chr_id IN okc_k_headers_b.id%TYPE
177: ,x_status_code OUT NOCOPY okc_k_headers_b.scs_code%TYPE
178: ) IS
179: CURSOR c_get_pa_sts_csr(cp_chr_id okc_k_headers_b.id%TYPE)IS
180: SELECT sts_code
173: ,x_return_status OUT NOCOPY VARCHAR2
174: ,x_msg_count OUT NOCOPY NUMBER
175: ,x_msg_data OUT NOCOPY VARCHAR2
176: ,p_chr_id IN okc_k_headers_b.id%TYPE
177: ,x_status_code OUT NOCOPY okc_k_headers_b.scs_code%TYPE
178: ) IS
179: CURSOR c_get_pa_sts_csr(cp_chr_id okc_k_headers_b.id%TYPE)IS
180: SELECT sts_code
181: ,contract_number
175: ,x_msg_data OUT NOCOPY VARCHAR2
176: ,p_chr_id IN okc_k_headers_b.id%TYPE
177: ,x_status_code OUT NOCOPY okc_k_headers_b.scs_code%TYPE
178: ) IS
179: CURSOR c_get_pa_sts_csr(cp_chr_id okc_k_headers_b.id%TYPE)IS
180: SELECT sts_code
181: ,contract_number
182: FROM okc_k_headers_b
183: WHERE id = cp_chr_id;
178: ) IS
179: CURSOR c_get_pa_sts_csr(cp_chr_id okc_k_headers_b.id%TYPE)IS
180: SELECT sts_code
181: ,contract_number
182: FROM okc_k_headers_b
183: WHERE id = cp_chr_id;
184: lv_pa_sts_code okc_k_headers_b.sts_code%TYPE;
185: lv_agreement_number okc_k_headers_b.contract_number%TYPE;
186: l_approval_process fnd_lookups.lookup_code%TYPE;
180: SELECT sts_code
181: ,contract_number
182: FROM okc_k_headers_b
183: WHERE id = cp_chr_id;
184: lv_pa_sts_code okc_k_headers_b.sts_code%TYPE;
185: lv_agreement_number okc_k_headers_b.contract_number%TYPE;
186: l_approval_process fnd_lookups.lookup_code%TYPE;
187: l_api_version CONSTANT NUMBER DEFAULT 1.0;
188: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'SUBMIT_PA_FOR_APPROVAL';
181: ,contract_number
182: FROM okc_k_headers_b
183: WHERE id = cp_chr_id;
184: lv_pa_sts_code okc_k_headers_b.sts_code%TYPE;
185: lv_agreement_number okc_k_headers_b.contract_number%TYPE;
186: l_approval_process fnd_lookups.lookup_code%TYPE;
187: l_api_version CONSTANT NUMBER DEFAULT 1.0;
188: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'SUBMIT_PA_FOR_APPROVAL';
189: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_AGRMNT_APPROVAL_PVT.SUBMIT_PA_FOR_APPROVAL';