eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_VP_AGRMNT_APPROVAL_PVT dependencies on OKC_K_HEADERS_B

Line 16: ,p_chr_id IN okc_k_headers_b.id%TYPE

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

Line 17: ,x_status_code OUT NOCOPY okc_k_headers_b.scs_code%TYPE

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

Line 19: CURSOR c_get_oa_sts_csr(cp_chr_id okc_k_headers_b.id%TYPE)IS

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;

Line 22: FROM okc_k_headers_b

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);

Line 24: lv_oa_sts_code okc_k_headers_b.sts_code%TYPE;

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';

Line 25: lv_agreement_number okc_k_headers_b.contract_number%TYPE;

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';

Line 176: ,p_chr_id IN okc_k_headers_b.id%TYPE

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

Line 177: ,x_status_code OUT NOCOPY okc_k_headers_b.scs_code%TYPE

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

Line 179: CURSOR c_get_pa_sts_csr(cp_chr_id okc_k_headers_b.id%TYPE)IS

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;

Line 182: FROM okc_k_headers_b

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;

Line 184: lv_pa_sts_code okc_k_headers_b.sts_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';

Line 185: lv_agreement_number okc_k_headers_b.contract_number%TYPE;

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';