APPS.OKL_SALES_QUOTE_QA_PVT dependencies on OKL_DATA_SRC_FNCTNS_V

Line 445: ,p_function_name IN okl_data_src_fnctns_v.name%TYPE

441: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
442: ,x_return_status OUT NOCOPY VARCHAR2
443: ,x_msg_count OUT NOCOPY NUMBER
444: ,x_msg_data OUT NOCOPY VARCHAR2
445: ,p_function_name IN okl_data_src_fnctns_v.name%TYPE
446: ,x_value OUT NOCOPY NUMBER
447: ) IS
448:
449: -- Exception declarations

Line 457: l_function_name okl_data_src_fnctns_v.name%TYPE;

453: -- Local Variable Declarations
454: l_value NUMBER;
455: l_evaluated_string okl_formulae_v.formula_string%TYPE;
456: l_no_dml_message VARCHAR2(200) := 'OKL_FORMULAE_NO_DML';
457: l_function_name okl_data_src_fnctns_v.name%TYPE;
458: l_function_source okl_data_src_fnctns_v.source%TYPE;
459:
460:
461: l_program_name CONSTANT VARCHAR2(30) := 'exc_sys_vldtion';

Line 458: l_function_source okl_data_src_fnctns_v.source%TYPE;

454: l_value NUMBER;
455: l_evaluated_string okl_formulae_v.formula_string%TYPE;
456: l_no_dml_message VARCHAR2(200) := 'OKL_FORMULAE_NO_DML';
457: l_function_name okl_data_src_fnctns_v.name%TYPE;
458: l_function_source okl_data_src_fnctns_v.source%TYPE;
459:
460:
461: l_program_name CONSTANT VARCHAR2(30) := 'exc_sys_vldtion';
462: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_program_name;

Line 465: CURSOR data_src_fnctns_csr(cp_function_name IN okl_data_src_fnctns_v.name%TYPE)

461: l_program_name CONSTANT VARCHAR2(30) := 'exc_sys_vldtion';
462: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_program_name;
463: l_flag BOOLEAN DEFAULT FALSE;
464:
465: CURSOR data_src_fnctns_csr(cp_function_name IN okl_data_src_fnctns_v.name%TYPE)
466: IS
467: SELECT source
468: FROM okl_data_src_fnctns_v
469: WHERE name = cp_function_name

Line 468: FROM okl_data_src_fnctns_v

464:
465: CURSOR data_src_fnctns_csr(cp_function_name IN okl_data_src_fnctns_v.name%TYPE)
466: IS
467: SELECT source
468: FROM okl_data_src_fnctns_v
469: WHERE name = cp_function_name
470: AND fnctn_code = 'VALIDATION';
471:
472: BEGIN

Line 577: l_function_name okl_data_src_fnctns_v.name%TYPE;

573: i INTEGER;
574: ret boolean;
575: fun_ret number;
576: call_user boolean;
577: l_function_name okl_data_src_fnctns_v.name%TYPE;
578: l_source_name okl_data_src_fnctns_v.source%TYPE;
579: l_failure_severity VARCHAR2(30);
580: l_module CONSTANT fnd_log_messages.module%TYPE := 'OKLRQQCB.pls.run_qa';
581: l_debug_enabled varchar2(10);

Line 578: l_source_name okl_data_src_fnctns_v.source%TYPE;

574: ret boolean;
575: fun_ret number;
576: call_user boolean;
577: l_function_name okl_data_src_fnctns_v.name%TYPE;
578: l_source_name okl_data_src_fnctns_v.source%TYPE;
579: l_failure_severity VARCHAR2(30);
580: l_module CONSTANT fnd_log_messages.module%TYPE := 'OKLRQQCB.pls.run_qa';
581: l_debug_enabled varchar2(10);
582: is_debug_procedure_on boolean;

Line 1262: l_function_name okl_data_src_fnctns_v.name%TYPE;

1258: i INTEGER;
1259: ret boolean;
1260: fun_ret number;
1261: call_user boolean;
1262: l_function_name okl_data_src_fnctns_v.name%TYPE;
1263: l_source_name okl_data_src_fnctns_v.source%TYPE;
1264: l_failure_severity VARCHAR2(30);
1265: l_module CONSTANT fnd_log_messages.module%TYPE := 'OKL_SALES_QUOTE_QA_PVT.validate_system_validation';
1266: l_debug_enabled varchar2(10);

Line 1263: l_source_name okl_data_src_fnctns_v.source%TYPE;

1259: ret boolean;
1260: fun_ret number;
1261: call_user boolean;
1262: l_function_name okl_data_src_fnctns_v.name%TYPE;
1263: l_source_name okl_data_src_fnctns_v.source%TYPE;
1264: l_failure_severity VARCHAR2(30);
1265: l_module CONSTANT fnd_log_messages.module%TYPE := 'OKL_SALES_QUOTE_QA_PVT.validate_system_validation';
1266: l_debug_enabled varchar2(10);
1267: is_debug_procedure_on boolean;