APPS.OKI_LOAD_OKV_PVT dependencies on FND_LOOKUPS

Line 50: -- Cursor to get the FND_LOOKUPS code based on the lookup_type and code

46:
47:
48: -- Global cursor declaration
49:
50: -- Cursor to get the FND_LOOKUPS code based on the lookup_type and code
51: -- Retrieves the code representing the column label, e.g, if the days renewal
52: -- outstanding is being retrieved for insertion into a table, then retrieve
53: -- the corresponding code (DRO IN this example).
54: -- Note: The fnd_lookups.lookup_code is hard coded in this program.

Line 54: -- Note: The fnd_lookups.lookup_code is hard coded in this program.

50: -- Cursor to get the FND_LOOKUPS code based on the lookup_type and code
51: -- Retrieves the code representing the column label, e.g, if the days renewal
52: -- outstanding is being retrieved for insertion into a table, then retrieve
53: -- the corresponding code (DRO IN this example).
54: -- Note: The fnd_lookups.lookup_code is hard coded in this program.
55: -- We use this cursor to verify the hard coded values before we use the
56: -- actual value itself.
57:
58: CURSOR g_lkup_csr

Line 63: FROM fnd_lookups lkup

59: ( p_lookup_type IN VARCHAR2
60: ,p_lookup_code IN VARCHAR2
61: ) IS
62: SELECT lkup.lookup_code
63: FROM fnd_lookups lkup
64: WHERE lkup.lookup_type = p_lookup_type
65: AND lkup.lookup_code = p_lookup_code
66: ;
67: rec_g_lkup_csr g_lkup_csr%ROWTYPE ;

Line 278: -- Codes for the performance measures in fnd_lookups

274:
275:
276: -- Constant declaration
277:
278: -- Codes for the performance measures in fnd_lookups
279: l_hardcoded_dro_code CONSTANT VARCHAR2(30) := 'DRO' ;
280: l_hardcoded_fcacp_code CONSTANT VARCHAR2(30) := 'FCACP' ;
281: l_hardcoded_cncs_code CONSTANT VARCHAR2(30) := 'CNCS' ;
282: l_lkup_type CONSTANT VARCHAR2(30) := 'OKI_PERF_MEASURE_TYPES' ;

Line 302: -- Holds the code from the fnd_lookups table for the

298: l_base_achv_contract_amount NUMBER := 0 ;
299: l_base_consolidated_amount NUMBER := 0 ;
300: l_achv_pct NUMBER := 0 ;
301:
302: -- Holds the code from the fnd_lookups table for the
303: -- OKI_PERF_MEASURE_TYPES type
304: l_dro_code VARCHAR2(30) := NULL ;
305: l_fcacp_code VARCHAR2(30) := NULL ;
306: l_cncs_code VARCHAR2(30) := NULL ;

Line 724: -- Codes for the performance measures in fnd_lookups

720:
721:
722: -- Constant declaration
723:
724: -- Codes for the performance measures in fnd_lookups
725: l_hardcoded_dro_code CONSTANT VARCHAR2(30) := 'DRO' ;
726: l_hardcoded_fcacp_code CONSTANT VARCHAR2(30) := 'FCACP' ;
727: l_hardcoded_cncs_code CONSTANT VARCHAR2(30) := 'CNCS' ;
728: l_lkup_type CONSTANT VARCHAR2(30) := 'OKI_PERF_MEASURE_TYPES' ;

Line 748: -- Holds the code from the fnd_lookups table for the

744: l_base_achv_contract_amount NUMBER := 0 ;
745: l_base_consolidated_amount NUMBER := 0 ;
746: l_achv_pct NUMBER := 0 ;
747:
748: -- Holds the code from the fnd_lookups table for the
749: -- OKI_PERF_MEASURE_TYPES type
750: l_dro_code VARCHAR2(30) := NULL ;
751: l_fcacp_code VARCHAR2(30) := NULL ;
752: l_cncs_code VARCHAR2(30) := NULL ;

Line 1155: -- Codes for the performance measures in fnd_lookups

1151:
1152:
1153: -- Constant declaration
1154:
1155: -- Codes for the performance measures in fnd_lookups
1156: l_hardcoded_dro_code CONSTANT VARCHAR2(30) := 'DRO' ;
1157: l_hardcoded_fcacp_code CONSTANT VARCHAR2(30) := 'FCACP' ;
1158: l_hardcoded_cncs_code CONSTANT VARCHAR2(30) := 'CNCS' ;
1159: l_lkup_type CONSTANT VARCHAR2(30) := 'OKI_PERF_MEASURE_TYPES' ;

Line 1180: -- Holds the code from the fnd_lookups table for the

1176: l_base_consolidated_amount NUMBER := 0 ;
1177:
1178: l_achv_pct NUMBER := 0 ;
1179:
1180: -- Holds the code from the fnd_lookups table for the
1181: -- OKI_PERF_MEASURE_TYPES type
1182: l_dro_code VARCHAR2(30) := NULL ;
1183: l_fcacp_code VARCHAR2(30) := NULL ;
1184: l_cncs_code VARCHAR2(30) := NULL ;