APPS.PV_BATCH_ASSIGN_PUB dependencies on JTF_NUMBER_TABLE

Line 126: l_rank_tbl JTF_NUMBER_TABLE;

122: AND fuser.user_id = extn.user_id;
123:
124: l_rank number := 0;
125: l_assignment_type VARCHAR2(30);
126: l_rank_tbl JTF_NUMBER_TABLE;
127: l_source_type_tbl JTF_VARCHAR2_TABLE_100;
128: l_size NUMBER;
129: l_resource_id NUMBER;
130: l_partner_count NUMBER;

Line 132: l_lead_id_tbl JTF_NUMBER_TABLE;

128: l_size NUMBER;
129: l_resource_id NUMBER;
130: l_partner_count NUMBER;
131: l_category VARCHAR2(30);
132: l_lead_id_tbl JTF_NUMBER_TABLE;
133: l_lead_desc_tbl JTF_VARCHAR2_TABLE_400;
134: l_partner_id_tbl JTF_NUMBER_TABLE;
135:
136: l_return_status VARCHAR2(1);

Line 134: l_partner_id_tbl JTF_NUMBER_TABLE;

130: l_partner_count NUMBER;
131: l_category VARCHAR2(30);
132: l_lead_id_tbl JTF_NUMBER_TABLE;
133: l_lead_desc_tbl JTF_VARCHAR2_TABLE_400;
134: l_partner_id_tbl JTF_NUMBER_TABLE;
135:
136: l_return_status VARCHAR2(1);
137: l_message VARCHAR2(32000);
138: l_msg_data VARCHAR2(32000);

Line 163: l_lead_id_tbl := JTF_NUMBER_TABLE();

159:
160: l_return_status := FND_API.G_RET_STS_SUCCESS ;
161:
162: l_size := 0;
163: l_lead_id_tbl := JTF_NUMBER_TABLE();
164: l_lead_desc_tbl := JTF_VARCHAR2_TABLE_400();
165:
166:
167: IF (p_country is not null) THEN