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 FND_LOOKUPS

Line 6: G_PENDING_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'PENDING_APPROVAL';

2: /* $Header: OKLRVAAB.pls 120.0 2005/07/28 11:44:04 sjalasut noship $ */
3:
4: G_AGR_NOT_PASSED_FOR_APPROVE CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_AGR_NOT_PASS_APPROVE';
5:
6: G_PENDING_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'PENDING_APPROVAL';
7: G_REJECTED_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'REJECTED';
8: G_PASSED_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'PASSED';
9: G_ACTIVE_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'ACTIVE';
10:

Line 7: G_REJECTED_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'REJECTED';

3:
4: G_AGR_NOT_PASSED_FOR_APPROVE CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_AGR_NOT_PASS_APPROVE';
5:
6: G_PENDING_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'PENDING_APPROVAL';
7: G_REJECTED_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'REJECTED';
8: G_PASSED_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'PASSED';
9: G_ACTIVE_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'ACTIVE';
10:
11: PROCEDURE submit_oa_for_approval(p_api_version IN NUMBER

Line 8: G_PASSED_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'PASSED';

4: G_AGR_NOT_PASSED_FOR_APPROVE CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_AGR_NOT_PASS_APPROVE';
5:
6: G_PENDING_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'PENDING_APPROVAL';
7: G_REJECTED_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'REJECTED';
8: G_PASSED_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'PASSED';
9: G_ACTIVE_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'ACTIVE';
10:
11: PROCEDURE submit_oa_for_approval(p_api_version IN NUMBER
12: ,p_init_msg_list IN VARCHAR2

Line 9: G_ACTIVE_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'ACTIVE';

5:
6: G_PENDING_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'PENDING_APPROVAL';
7: G_REJECTED_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'REJECTED';
8: G_PASSED_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'PASSED';
9: G_ACTIVE_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'ACTIVE';
10:
11: PROCEDURE submit_oa_for_approval(p_api_version IN NUMBER
12: ,p_init_msg_list IN VARCHAR2
13: ,x_return_status OUT NOCOPY VARCHAR2

Line 186: l_approval_process fnd_lookups.lookup_code%TYPE;

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';
190: l_debug_enabled VARCHAR2(10);