APPS.PV_ENRL_PREREQ_BINS_PUB dependencies on JTF_NUMBER_TABLE

Line 91: ,x_matched_id_tbl OUT NOCOPY JTF_NUMBER_TABLE

87: x_return_status OUT NOCOPY VARCHAR2
88: ,x_msg_count OUT NOCOPY NUMBER
89: ,x_msg_data OUT NOCOPY VARCHAR2
90: ,p_program_id IN NUMBER
91: ,x_matched_id_tbl OUT NOCOPY JTF_NUMBER_TABLE
92: )
93: IS
94: CURSOR lc_partner_selection(c_program_id NUMBER) IS
95: SELECT a.attribute_id, a.operator,

Line 141: l_attr_matched_id_tbl JTF_NUMBER_TABLE;

137: );
138:
139: i NUMBER := 1;
140: l_cnt NUMBER := 1;
141: l_attr_matched_id_tbl JTF_NUMBER_TABLE;
142: l_matched_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
143: l_attr_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
144: l_attr_opr_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
145: l_val_attr_tbl JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000();

Line 142: l_matched_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

138:
139: i NUMBER := 1;
140: l_cnt NUMBER := 1;
141: l_attr_matched_id_tbl JTF_NUMBER_TABLE;
142: l_matched_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
143: l_attr_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
144: l_attr_opr_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
145: l_val_attr_tbl JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000();
146: l_partner_details JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000();

Line 143: l_attr_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

139: i NUMBER := 1;
140: l_cnt NUMBER := 1;
141: l_attr_matched_id_tbl JTF_NUMBER_TABLE;
142: l_matched_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
143: l_attr_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
144: l_attr_opr_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
145: l_val_attr_tbl JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000();
146: l_partner_details JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000();
147: l_flagcount JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

Line 149: l_distance_tbl JTF_NUMBER_TABLE;

145: l_val_attr_tbl JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000();
146: l_partner_details JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000();
147: l_flagcount JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
148: l_attr_data_type_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
149: l_distance_tbl JTF_NUMBER_TABLE;
150: l_distance_uom varchar2(100);
151: l_message varchar2(32000);
152: l_previous_attr_id NUMBER;
153: l_previous_sc_id NUMBER;

Line 381: l_matched_id_tbl JTF_NUMBER_TABLE;

377: -- -----------------------------------------------------------------------
378: -- Local Variables
379: -- -----------------------------------------------------------------------
380: l_api_package_name VARCHAR2(30) := 'PV_ENRL_PREREQ_BINS_PUB';
381: l_matched_id_tbl JTF_NUMBER_TABLE;
382: l_mirror_table VARCHAR2(30);
383: l_cache_table VARCHAR2(30);
384: l_pv_schema_name VARCHAR2(30);
385: l_user_id NUMBER := FND_GLOBAL.USER_ID();