DBA Data[Home] [Help]

APPS.OKC_CLM_PKG dependencies on OKC_XPRT_XRULE_VALUES_PVT

Line 50: x_udf_var_value_tbl OUT NOCOPY okc_xprt_xrule_values_pvt.udf_var_value_tbl_type

46: p_intent IN VARCHAR2,
47: x_return_status OUT NOCOPY VARCHAR2,
48: x_msg_data OUT NOCOPY VARCHAR2,
49: x_msg_count OUT NOCOPY NUMBER,
50: x_udf_var_value_tbl OUT NOCOPY okc_xprt_xrule_values_pvt.udf_var_value_tbl_type
51: )
52: IS
53: l_api_name VARCHAR2(30) := 'get_user_defined_variables';
54: l_api_version CONSTANT NUMBER := 1.0;

Line 67: OKC_XPRT_XRULE_VALUES_PVT.get_user_defined_variables (

63: END IF;
64:
65: x_return_status := G_RET_STS_SUCCESS;
66: -- call expert API for getting udv values
67: OKC_XPRT_XRULE_VALUES_PVT.get_user_defined_variables (
68: p_api_version => l_api_version,
69: p_init_msg_list => p_init_msg_list ,
70: p_doc_type => p_doc_type,
71: p_doc_id => p_doc_id,

Line 100: x_udf_var_value_tbl OUT NOCOPY okc_xprt_xrule_values_pvt.udf_var_value_tbl_type

96: p_intent IN VARCHAR2,
97: x_return_status OUT NOCOPY VARCHAR2,
98: x_msg_data OUT NOCOPY VARCHAR2,
99: x_msg_count OUT NOCOPY NUMBER,
100: x_udf_var_value_tbl OUT NOCOPY okc_xprt_xrule_values_pvt.udf_var_value_tbl_type
101: )
102: IS
103:
104: l_api_name VARCHAR2(30) := 'get_udv_with_procedures';

Line 118: OKC_XPRT_XRULE_VALUES_PVT.get_udv_with_procedures (

114:
115: x_return_status := G_RET_STS_SUCCESS;
116:
117: --call expert API to get Procedural udv values
118: OKC_XPRT_XRULE_VALUES_PVT.get_udv_with_procedures (
119: p_api_version => l_api_version,
120: p_init_msg_list => p_init_msg_list ,
121: p_doc_type => p_doc_type,
122: p_doc_id => p_doc_id,

Line 423: x_udf_var_value_tbl OUT NOCOPY okc_xprt_xrule_values_pvt.udf_var_value_tbl_type

419: p_intent IN VARCHAR2,
420: x_return_status OUT NOCOPY VARCHAR2,
421: x_msg_data OUT NOCOPY VARCHAR2,
422: x_msg_count OUT NOCOPY NUMBER,
423: x_udf_var_value_tbl OUT NOCOPY okc_xprt_xrule_values_pvt.udf_var_value_tbl_type
424: )
425: IS
426:
427: CURSOR csr_get_clm_udv (p_doc_type VARCHAR2,p_doc_id NUMBER, p_intent VARCHAR2, p_org_id NUMBER) IS

Line 509: l_udf_var_value_tbl OKC_XPRT_XRULE_VALUES_PVT.udf_var_value_tbl_type;

505:
506: --l_sql_stmt LONG;
507: l_sequence_id NUMBER;
508: var_tbl_cnt NUMBER := 1;
509: l_udf_var_value_tbl OKC_XPRT_XRULE_VALUES_PVT.udf_var_value_tbl_type;
510: /*
511: --bug 8501694-kkolukul: Multiple values variables used in expert
512: l_udf_with_proc_mul_val_tbl OKC_XPRT_XRULE_VALUES_PVT.udf_var_value_tbl_type;
513: l_hook_used NUMBER;

Line 512: l_udf_with_proc_mul_val_tbl OKC_XPRT_XRULE_VALUES_PVT.udf_var_value_tbl_type;

508: var_tbl_cnt NUMBER := 1;
509: l_udf_var_value_tbl OKC_XPRT_XRULE_VALUES_PVT.udf_var_value_tbl_type;
510: /*
511: --bug 8501694-kkolukul: Multiple values variables used in expert
512: l_udf_with_proc_mul_val_tbl OKC_XPRT_XRULE_VALUES_PVT.udf_var_value_tbl_type;
513: l_hook_used NUMBER;
514: */
515: -- CLM Changes
516: l_clm_udf_tbl OKC_XPRT_XRULE_VALUES_PVT.udf_var_value_tbl_type;

Line 516: l_clm_udf_tbl OKC_XPRT_XRULE_VALUES_PVT.udf_var_value_tbl_type;

512: l_udf_with_proc_mul_val_tbl OKC_XPRT_XRULE_VALUES_PVT.udf_var_value_tbl_type;
513: l_hook_used NUMBER;
514: */
515: -- CLM Changes
516: l_clm_udf_tbl OKC_XPRT_XRULE_VALUES_PVT.udf_var_value_tbl_type;
517:
518: TYPE VariableCodeList IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER; -- changed for R12
519: variableCode_tbl VariableCodeList;
520:

Line 908: l_sys_var_value_tbl okc_xprt_xrule_values_pvt.var_value_tbl_type;

904: l_msg_data VARCHAR2(300) := NULL;
905: l_msg_count NUMBER := NULL;
906:
907: l_count NUMBER :=0;
908: l_sys_var_value_tbl okc_xprt_xrule_values_pvt.var_value_tbl_type;
909: l_udf_var_value_tbl okc_xprt_xrule_values_pvt.udf_var_value_tbl_type;
910:
911: BEGIN
912: -- start debug log

Line 909: l_udf_var_value_tbl okc_xprt_xrule_values_pvt.udf_var_value_tbl_type;

905: l_msg_count NUMBER := NULL;
906:
907: l_count NUMBER :=0;
908: l_sys_var_value_tbl okc_xprt_xrule_values_pvt.var_value_tbl_type;
909: l_udf_var_value_tbl okc_xprt_xrule_values_pvt.udf_var_value_tbl_type;
910:
911: BEGIN
912: -- start debug log
913: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1082: x_sys_var_value_tbl OUT NOCOPY okc_xprt_xrule_values_pvt.var_value_tbl_type

1078: x_msg_count OUT NOCOPY NUMBER,
1079: p_doc_type IN VARCHAR2,
1080: p_doc_id IN NUMBER,
1081: p_only_doc_variables IN VARCHAR2 := FND_API.G_TRUE,
1082: x_sys_var_value_tbl OUT NOCOPY okc_xprt_xrule_values_pvt.var_value_tbl_type
1083: )
1084: IS
1085: l_api_name VARCHAR2(30) := 'get_system_variables';
1086: l_api_version CONSTANT NUMBER := 1.0;

Line 1088: l_sys_var_value_tbl okc_xprt_xrule_values_pvt.var_value_tbl_type;

1084: IS
1085: l_api_name VARCHAR2(30) := 'get_system_variables';
1086: l_api_version CONSTANT NUMBER := 1.0;
1087:
1088: l_sys_var_value_tbl okc_xprt_xrule_values_pvt.var_value_tbl_type;
1089: BEGIN
1090:
1091: OKC_XPRT_XRULE_VALUES_PVT.get_system_variables(
1092: p_api_version => l_api_version,

Line 1091: OKC_XPRT_XRULE_VALUES_PVT.get_system_variables(

1087:
1088: l_sys_var_value_tbl okc_xprt_xrule_values_pvt.var_value_tbl_type;
1089: BEGIN
1090:
1091: OKC_XPRT_XRULE_VALUES_PVT.get_system_variables(
1092: p_api_version => l_api_version,
1093: p_init_msg_list => p_init_msg_list,
1094: x_return_status => x_return_status,
1095: x_msg_data => x_msg_data,