APPS.OKL_SUBSIDY_PROCESS_PVT dependencies on FND_LOOKUPS

Line 56: G_SOURCE_BILLING_TRX_BOOK CONSTANT fnd_lookups.lookup_code%TYPE :='BOOKING';

52: --Bug# 4899328
53: G_FORMULA_CAP CONSTANT VARCHAR2(200) := 'LINE_CAP_AMNT';
54:
55: -- sjalasut, added Booking source as part of R12 Billing Enhancement. BEGIN
56: G_SOURCE_BILLING_TRX_BOOK CONSTANT fnd_lookups.lookup_code%TYPE :='BOOKING';
57: -- sjalasut, added Booking source as part of R12 Billing Enhancement. END
58:
59: -- varangan - Billing Enhancement - Bug#5874824 - New constant added -Begin
60: G_SOURCE_BILLING_TRX_RBK CONSTANT fnd_lookups.lookup_code%TYPE :='REBOOK';

Line 60: G_SOURCE_BILLING_TRX_RBK CONSTANT fnd_lookups.lookup_code%TYPE :='REBOOK';

56: G_SOURCE_BILLING_TRX_BOOK CONSTANT fnd_lookups.lookup_code%TYPE :='BOOKING';
57: -- sjalasut, added Booking source as part of R12 Billing Enhancement. END
58:
59: -- varangan - Billing Enhancement - Bug#5874824 - New constant added -Begin
60: G_SOURCE_BILLING_TRX_RBK CONSTANT fnd_lookups.lookup_code%TYPE :='REBOOK';
61: -- varangan - Billing Enhancement - Bug#5874824 - New constant added -End
62:
63: -------------------------------------------------------------------------------
64: --****Local procedures for parameter validations

Line 174: from fnd_lookups

170:
171: --cursor to find whether accounting method is valid
172: cursor l_flkup_csr (p_lookup_code in varchar2) is
173: select 'Y'
174: from fnd_lookups
175: where lookup_code = p_lookup_code
176: and lookup_type = 'OKL_SUBACCT_METHOD';
177:
178: l_valid_value varchar2(1) default 'N';

Line 2025: from fnd_lookups flkup

2021: --cursor to find out calculation basis meaning for errors
2022: cursor l_flkup_csr (p_lookup_code in varchar2,
2023: p_lookup_type in varchar2) is
2024: select flkup.meaning
2025: from fnd_lookups flkup
2026: where flkup.lookup_type = p_lookup_type
2027: and flkup.lookup_code = p_lookup_code;
2028:
2029: l_flkup_meaning fnd_lookups.meaning%TYPE;

Line 2029: l_flkup_meaning fnd_lookups.meaning%TYPE;

2025: from fnd_lookups flkup
2026: where flkup.lookup_type = p_lookup_type
2027: and flkup.lookup_code = p_lookup_code;
2028:
2029: l_flkup_meaning fnd_lookups.meaning%TYPE;
2030:
2031:
2032: begin
2033: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 4278: l_party_role FND_LOOKUPS.meaning%TYPE;

4274: l_party_name VARCHAR2(1000);
4275:
4276: l_bill_to_site_use_id OKC_K_HEADERS_B.bill_to_site_use_id%TYPE;
4277: l_cust_acct_id OKC_K_PARTY_ROLES_B.cust_acct_id%TYPE;
4278: l_party_role FND_LOOKUPS.meaning%TYPE;
4279:
4280: ----------------------------------------------------------------------------
4281: -- Get bill to site of OKL_VENDOR party on the contract
4282: ----------------------------------------------------------------------------