DBA Data[Home] [Help]

APPS.PV_RULE_EVALUATION_PUB dependencies on JTF_VARCHAR2_TABLE_100

Line 39: x_attr_evaluation_result_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,

35: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
36: p_partner_id IN NUMBER,
37: p_rule_id_tbl IN JTF_NUMBER_TABLE,
38: x_attr_id_tbl OUT NOCOPY JTF_NUMBER_TABLE,
39: x_attr_evaluation_result_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_100,
40: x_partner_attr_value_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
41: x_evaluation_criteria_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
42: x_rule_pass_flag OUT NOCOPY VARCHAR2,
43: x_delimiter OUT NOCOPY VARCHAR2,

Line 55: l_attr_to_val JTF_VARCHAR2_TABLE_1000 := JTF_VARCHAR2_TABLE_1000();

51: TYPE c_attr_mean IS REF CURSOR;
52:
53: l_rule_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
54: l_attr_val_tbl JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000();
55: l_attr_to_val JTF_VARCHAR2_TABLE_1000 := JTF_VARCHAR2_TABLE_1000();
56: l_operator_tbl JTF_VARCHAR2_TABLE_1000 := JTF_VARCHAR2_TABLE_1000();
57: l_currency_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
58: l_criterion_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
59: l_cri_condition_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

Line 56: l_operator_tbl JTF_VARCHAR2_TABLE_1000 := JTF_VARCHAR2_TABLE_1000();

52:
53: l_rule_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
54: l_attr_val_tbl JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000();
55: l_attr_to_val JTF_VARCHAR2_TABLE_1000 := JTF_VARCHAR2_TABLE_1000();
56: l_operator_tbl JTF_VARCHAR2_TABLE_1000 := JTF_VARCHAR2_TABLE_1000();
57: l_currency_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
58: l_criterion_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
59: l_cri_condition_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
60: l_attribute_value_tbl JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000();

Line 57: l_currency_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

53: l_rule_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
54: l_attr_val_tbl JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000();
55: l_attr_to_val JTF_VARCHAR2_TABLE_1000 := JTF_VARCHAR2_TABLE_1000();
56: l_operator_tbl JTF_VARCHAR2_TABLE_1000 := JTF_VARCHAR2_TABLE_1000();
57: l_currency_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
58: l_criterion_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
59: l_cri_condition_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
60: l_attribute_value_tbl JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000();
61:

Line 59: l_cri_condition_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

55: l_attr_to_val JTF_VARCHAR2_TABLE_1000 := JTF_VARCHAR2_TABLE_1000();
56: l_operator_tbl JTF_VARCHAR2_TABLE_1000 := JTF_VARCHAR2_TABLE_1000();
57: l_currency_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
58: l_criterion_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
59: l_cri_condition_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
60: l_attribute_value_tbl JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000();
61:
62:
63: l_input_filter pv_check_match_pub.t_input_filter;

Line 258: x_attr_evaluation_result_tbl := JTF_VARCHAR2_TABLE_100();

254: RAISE FND_API.G_EXC_ERROR;
255: END IF;
256:
257: x_attr_id_tbl := JTF_NUMBER_TABLE();
258: x_attr_evaluation_result_tbl := JTF_VARCHAR2_TABLE_100();
259: x_partner_attr_value_tbl := JTF_VARCHAR2_TABLE_4000();
260: x_evaluation_criteria_tbl := JTF_VARCHAR2_TABLE_4000();
261:
262:

Line 852: x_attr_evaluation_result_tbl JTF_VARCHAR2_TABLE_100;

848: )
849:
850: IS
851: x_attr_id_tbl JTF_NUMBER_TABLE;
852: x_attr_evaluation_result_tbl JTF_VARCHAR2_TABLE_100;
853: x_partner_attr_value_tbl JTF_VARCHAR2_TABLE_4000;
854: x_evaluation_criteria_tbl JTF_VARCHAR2_TABLE_4000;
855: x_delimiter VARCHAR2(10);
856:

Line 860: l_attr_val_tbl JTF_VARCHAR2_TABLE_1000 := JTF_VARCHAR2_TABLE_1000();

856:
857: TYPE c_attr_mean IS REF CURSOR;
858:
859: l_rule_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
860: l_attr_val_tbl JTF_VARCHAR2_TABLE_1000 := JTF_VARCHAR2_TABLE_1000();
861: l_attr_to_val JTF_VARCHAR2_TABLE_1000 := JTF_VARCHAR2_TABLE_1000();
862: l_operator_tbl JTF_VARCHAR2_TABLE_1000 := JTF_VARCHAR2_TABLE_1000();
863: l_currency_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
864: l_criterion_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 861: l_attr_to_val JTF_VARCHAR2_TABLE_1000 := JTF_VARCHAR2_TABLE_1000();

857: TYPE c_attr_mean IS REF CURSOR;
858:
859: l_rule_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
860: l_attr_val_tbl JTF_VARCHAR2_TABLE_1000 := JTF_VARCHAR2_TABLE_1000();
861: l_attr_to_val JTF_VARCHAR2_TABLE_1000 := JTF_VARCHAR2_TABLE_1000();
862: l_operator_tbl JTF_VARCHAR2_TABLE_1000 := JTF_VARCHAR2_TABLE_1000();
863: l_currency_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
864: l_criterion_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
865: l_cri_condition_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

Line 862: l_operator_tbl JTF_VARCHAR2_TABLE_1000 := JTF_VARCHAR2_TABLE_1000();

858:
859: l_rule_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
860: l_attr_val_tbl JTF_VARCHAR2_TABLE_1000 := JTF_VARCHAR2_TABLE_1000();
861: l_attr_to_val JTF_VARCHAR2_TABLE_1000 := JTF_VARCHAR2_TABLE_1000();
862: l_operator_tbl JTF_VARCHAR2_TABLE_1000 := JTF_VARCHAR2_TABLE_1000();
863: l_currency_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
864: l_criterion_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
865: l_cri_condition_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
866: l_attribute_value_tbl JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000();

Line 863: l_currency_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

859: l_rule_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
860: l_attr_val_tbl JTF_VARCHAR2_TABLE_1000 := JTF_VARCHAR2_TABLE_1000();
861: l_attr_to_val JTF_VARCHAR2_TABLE_1000 := JTF_VARCHAR2_TABLE_1000();
862: l_operator_tbl JTF_VARCHAR2_TABLE_1000 := JTF_VARCHAR2_TABLE_1000();
863: l_currency_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
864: l_criterion_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
865: l_cri_condition_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
866: l_attribute_value_tbl JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000();
867:

Line 865: l_cri_condition_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

861: l_attr_to_val JTF_VARCHAR2_TABLE_1000 := JTF_VARCHAR2_TABLE_1000();
862: l_operator_tbl JTF_VARCHAR2_TABLE_1000 := JTF_VARCHAR2_TABLE_1000();
863: l_currency_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
864: l_criterion_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
865: l_cri_condition_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
866: l_attribute_value_tbl JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000();
867:
868:
869: l_input_filter pv_check_match_pub.t_input_filter;

Line 1074: x_attr_evaluation_result_tbl := JTF_VARCHAR2_TABLE_100();

1070: END IF;
1071:
1072:
1073: x_attr_id_tbl := JTF_NUMBER_TABLE();
1074: x_attr_evaluation_result_tbl := JTF_VARCHAR2_TABLE_100();
1075: x_partner_attr_value_tbl := JTF_VARCHAR2_TABLE_4000();
1076: x_evaluation_criteria_tbl := JTF_VARCHAR2_TABLE_4000();
1077:
1078: open lc_get_rule_details;