eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PV_RULE_EVALUATION_PUB dependencies on JTF_NUMBER_TABLE

Line 37: p_rule_id_tbl IN JTF_NUMBER_TABLE,

33: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
34: p_commit IN VARCHAR2 := FND_API.g_false,
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,

Line 38: x_attr_id_tbl OUT NOCOPY JTF_NUMBER_TABLE,

34: p_commit IN VARCHAR2 := FND_API.g_false,
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,

Line 53: l_rule_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

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

Line 58: l_criterion_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:
62:

Line 139: -- FROM (SELECT column_value FROM TABLE (CAST(p_rule_id_tbl AS JTF_NUMBER_TABLE))) ) x

135:
136: -- "SELECT a.process_rule_id, b.attribute_id, x.rank, x.process_rule_id rule_id
137: -- FROM pv_process_rules_vl a, pv_enty_select_criteria b,
138: -- (SELECT rownum rank, column_value process_rule_id
139: -- FROM (SELECT column_value FROM TABLE (CAST(p_rule_id_tbl AS JTF_NUMBER_TABLE))) ) x
140: -- WHERE a.process_rule_id = x.process_rule_id
141: -- AND a.process_rule_id = b.process_rule_id "
142:
143: -- " SELECT column_value FROM TABLE (CAST(p_rule_id_tbl AS JTF_NUMBER_TABLE "

Line 143: -- " SELECT column_value FROM TABLE (CAST(p_rule_id_tbl AS JTF_NUMBER_TABLE "

139: -- FROM (SELECT column_value FROM TABLE (CAST(p_rule_id_tbl AS JTF_NUMBER_TABLE))) ) x
140: -- WHERE a.process_rule_id = x.process_rule_id
141: -- AND a.process_rule_id = b.process_rule_id "
142:
143: -- " SELECT column_value FROM TABLE (CAST(p_rule_id_tbl AS JTF_NUMBER_TABLE "
144: -- In the above select statement CAST ensures the order of Rule ID set from the query
145: -- remains the same as that of INPUT RULE ID TABLE.
146:
147: --

Line 200: FROM TABLE (CAST(p_rule_id_tbl AS JTF_NUMBER_TABLE))) ) x

196: FROM pv_process_rules_vl a,
197: pv_enty_select_criteria b,
198: (SELECT rownum rank, column_value process_rule_id
199: FROM (SELECT column_value
200: FROM TABLE (CAST(p_rule_id_tbl AS JTF_NUMBER_TABLE))) ) x
201: WHERE a.process_rule_id = x.process_rule_id
202: AND a.process_rule_id = b.process_rule_id ) z
203: group by z.attribute_id
204: )) xy

Line 257: x_attr_id_tbl := JTF_NUMBER_TABLE();

253:
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:

Line 843: p_rule_id_tbl IN JTF_NUMBER_TABLE,

839: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
840: p_commit IN VARCHAR2 := FND_API.g_false,
841: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
842: p_partner_id IN NUMBER,
843: p_rule_id_tbl IN JTF_NUMBER_TABLE,
844: x_rule_pass_flag OUT NOCOPY VARCHAR2,
845: x_return_status OUT NOCOPY VARCHAR2,
846: x_msg_count OUT NOCOPY NUMBER,
847: x_msg_data OUT NOCOPY VARCHAR2

Line 851: x_attr_id_tbl JTF_NUMBER_TABLE;

847: x_msg_data OUT NOCOPY VARCHAR2
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);

Line 859: l_rule_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

855: x_delimiter VARCHAR2(10);
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();

Line 864: l_criterion_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:
868:

Line 945: -- FROM (SELECT column_value FROM TABLE (CAST(p_rule_id_tbl AS JTF_NUMBER_TABLE))) ) x

941:
942: -- "SELECT a.process_rule_id, b.attribute_id, x.rank, x.process_rule_id rule_id
943: -- FROM pv_process_rules_vl a, pv_enty_select_criteria b,
944: -- (SELECT rownum rank, column_value process_rule_id
945: -- FROM (SELECT column_value FROM TABLE (CAST(p_rule_id_tbl AS JTF_NUMBER_TABLE))) ) x
946: -- WHERE a.process_rule_id = x.process_rule_id
947: -- AND a.process_rule_id = b.process_rule_id "
948:
949: -- " SELECT column_value FROM TABLE (CAST(p_rule_id_tbl AS JTF_NUMBER_TABLE "

Line 949: -- " SELECT column_value FROM TABLE (CAST(p_rule_id_tbl AS JTF_NUMBER_TABLE "

945: -- FROM (SELECT column_value FROM TABLE (CAST(p_rule_id_tbl AS JTF_NUMBER_TABLE))) ) x
946: -- WHERE a.process_rule_id = x.process_rule_id
947: -- AND a.process_rule_id = b.process_rule_id "
948:
949: -- " SELECT column_value FROM TABLE (CAST(p_rule_id_tbl AS JTF_NUMBER_TABLE "
950: -- In the above select statement CAST ensures the order of Rule ID set from the query
951: -- remains the same as that of INPUT RULE ID TABLE.
952:
953: --

Line 1006: FROM TABLE (CAST(p_rule_id_tbl AS JTF_NUMBER_TABLE))) ) x

1002: FROM pv_process_rules_vl a,
1003: pv_enty_select_criteria b,
1004: (SELECT rownum rank, column_value process_rule_id
1005: FROM (SELECT column_value
1006: FROM TABLE (CAST(p_rule_id_tbl AS JTF_NUMBER_TABLE))) ) x
1007: WHERE a.process_rule_id = x.process_rule_id
1008: AND a.process_rule_id = b.process_rule_id ) z
1009: group by z.attribute_id
1010: )) xy

Line 1073: x_attr_id_tbl := JTF_NUMBER_TABLE();

1069:
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: