DBA Data[Home] [Help]

APPS.PV_RULE_EVALUATION_PUB dependencies on JTF_VARCHAR2_TABLE_4000

Line 40: x_partner_attr_value_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_4000,

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,
44: x_return_status OUT NOCOPY VARCHAR2,

Line 41: x_evaluation_criteria_tbl OUT NOCOPY JTF_VARCHAR2_TABLE_4000,

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,
44: x_return_status OUT NOCOPY VARCHAR2,
45: x_msg_count OUT NOCOPY NUMBER,

Line 54: l_attr_val_tbl JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000();

50:
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();

Line 60: l_attribute_value_tbl JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000();

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;
64: l_entity_attr_value pv_check_match_pub.t_entity_attr_value;

Line 259: x_partner_attr_value_tbl := JTF_VARCHAR2_TABLE_4000();

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:
263: open lc_get_rule_details;

Line 260: x_evaluation_criteria_tbl := JTF_VARCHAR2_TABLE_4000();

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:
263: open lc_get_rule_details;
264: loop

Line 853: x_partner_attr_value_tbl JTF_VARCHAR2_TABLE_4000;

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:
857: TYPE c_attr_mean IS REF CURSOR;

Line 854: x_evaluation_criteria_tbl JTF_VARCHAR2_TABLE_4000;

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:
857: TYPE c_attr_mean IS REF CURSOR;
858:

Line 866: l_attribute_value_tbl JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000();

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;
870: l_entity_attr_value pv_check_match_pub.t_entity_attr_value;

Line 1075: x_partner_attr_value_tbl := JTF_VARCHAR2_TABLE_4000();

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;
1079: loop

Line 1076: x_evaluation_criteria_tbl := JTF_VARCHAR2_TABLE_4000();

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;
1079: loop
1080: