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_CR_WF dependencies on FND_LOOKUPS

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

45: G_WF_USER_ORIG_SYSTEM_HR CONSTANT VARCHAR2(5) := 'PER';
46:
47: G_AMP_SIGN CONSTANT VARCHAR2(1) := '&';
48:
49: G_PENDING_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'PENDING_APPROVAL';
50: G_ACTIVE_STS_CODE CONSTANT okc_statuses_b.code%TYPE DEFAULT 'ACTIVE';
51: G_COMPLETED_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'COMPLETED';
52: G_REJECTED_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'REJECTED';
53: G_INCOMPLETE_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'INCOMPLETE';

Line 51: G_COMPLETED_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'COMPLETED';

47: G_AMP_SIGN CONSTANT VARCHAR2(1) := '&';
48:
49: G_PENDING_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'PENDING_APPROVAL';
50: G_ACTIVE_STS_CODE CONSTANT okc_statuses_b.code%TYPE DEFAULT 'ACTIVE';
51: G_COMPLETED_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'COMPLETED';
52: G_REJECTED_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'REJECTED';
53: G_INCOMPLETE_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'INCOMPLETE';
54: G_AGR_APP_REJECTED_STS_CODE fnd_lookups.lookup_code%TYPE DEFAULT 'APPROVAL_REJECTED';
55: G_APPROVED_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'APPROVED';

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

48:
49: G_PENDING_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'PENDING_APPROVAL';
50: G_ACTIVE_STS_CODE CONSTANT okc_statuses_b.code%TYPE DEFAULT 'ACTIVE';
51: G_COMPLETED_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'COMPLETED';
52: G_REJECTED_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'REJECTED';
53: G_INCOMPLETE_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'INCOMPLETE';
54: G_AGR_APP_REJECTED_STS_CODE fnd_lookups.lookup_code%TYPE DEFAULT 'APPROVAL_REJECTED';
55: G_APPROVED_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'APPROVED';
56: G_ARGREEMENT_TYPE_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'AGREEMENT';

Line 53: G_INCOMPLETE_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'INCOMPLETE';

49: G_PENDING_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'PENDING_APPROVAL';
50: G_ACTIVE_STS_CODE CONSTANT okc_statuses_b.code%TYPE DEFAULT 'ACTIVE';
51: G_COMPLETED_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'COMPLETED';
52: G_REJECTED_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'REJECTED';
53: G_INCOMPLETE_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'INCOMPLETE';
54: G_AGR_APP_REJECTED_STS_CODE fnd_lookups.lookup_code%TYPE DEFAULT 'APPROVAL_REJECTED';
55: G_APPROVED_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'APPROVED';
56: G_ARGREEMENT_TYPE_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'AGREEMENT';
57:

Line 54: G_AGR_APP_REJECTED_STS_CODE fnd_lookups.lookup_code%TYPE DEFAULT 'APPROVAL_REJECTED';

50: G_ACTIVE_STS_CODE CONSTANT okc_statuses_b.code%TYPE DEFAULT 'ACTIVE';
51: G_COMPLETED_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'COMPLETED';
52: G_REJECTED_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'REJECTED';
53: G_INCOMPLETE_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'INCOMPLETE';
54: G_AGR_APP_REJECTED_STS_CODE fnd_lookups.lookup_code%TYPE DEFAULT 'APPROVAL_REJECTED';
55: G_APPROVED_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'APPROVED';
56: G_ARGREEMENT_TYPE_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'AGREEMENT';
57:
58: -- local procedure. START

Line 55: G_APPROVED_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'APPROVED';

51: G_COMPLETED_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'COMPLETED';
52: G_REJECTED_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'REJECTED';
53: G_INCOMPLETE_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'INCOMPLETE';
54: G_AGR_APP_REJECTED_STS_CODE fnd_lookups.lookup_code%TYPE DEFAULT 'APPROVAL_REJECTED';
55: G_APPROVED_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'APPROVED';
56: G_ARGREEMENT_TYPE_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'AGREEMENT';
57:
58: -- local procedure. START
59: PROCEDURE l_get_agent(p_user_id IN NUMBER,

Line 56: G_ARGREEMENT_TYPE_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'AGREEMENT';

52: G_REJECTED_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'REJECTED';
53: G_INCOMPLETE_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'INCOMPLETE';
54: G_AGR_APP_REJECTED_STS_CODE fnd_lookups.lookup_code%TYPE DEFAULT 'APPROVAL_REJECTED';
55: G_APPROVED_STS_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'APPROVED';
56: G_ARGREEMENT_TYPE_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'AGREEMENT';
57:
58: -- local procedure. START
59: PROCEDURE l_get_agent(p_user_id IN NUMBER,
60: x_return_status OUT NOCOPY VARCHAR2,

Line 147: ,fnd_lookups lookups

143: ,okc_subclasses_v subclass
144: ,po_vendors vendors
145: ,okc_k_party_roles_b party_roles
146: ,okl_vp_change_requests change
147: ,fnd_lookups lookups
148: ,okl_k_headers khr
149: WHERE agreement.scs_code = subclass.code
150: AND party_roles.dnz_chr_id (+) = agreement.id
151: AND party_roles.rle_code (+) = 'OKL_VENDOR'

Line 174: ,fnd_lookups lookups

170: ,okc_subclasses_v subclass
171: ,po_vendors vendors
172: ,okc_k_party_roles_b party_roles
173: ,okl_vp_change_requests change
174: ,fnd_lookups lookups
175: WHERE agreement.scs_code = subclass.code
176: AND party_roles.dnz_chr_id (+) = agreement.id
177: AND party_roles.rle_code (+) = 'OKL_VENDOR'
178: AND party_roles.object1_id1 = vendors.vendor_id(+)

Line 305: l_approval_process fnd_lookups.lookup_code%TYPE;

301: l_trans_appl_id ame_calling_apps.application_id%TYPE;
302: l_trans_type_id ame_calling_apps.transaction_type_id%TYPE;
303:
304: l_api_version CONSTANT NUMBER DEFAULT 1.0;
305: l_approval_process fnd_lookups.lookup_code%TYPE;
306: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'SUBMIT_pa_FOR_APPROVAL';
307: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_CR_WF.RAISE_CR_EVENT_APPROVAL';
308: l_debug_enabled VARCHAR2(10);
309: