71: )
72: RETURN VARCHAR2 IS
73:
74: -- Create the table variables to hold returnable info.
75: t_ele_type_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
76: t_ele_type_name JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
77:
78: -- count of matching element type
79: l_count NUMBER;
908: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
909: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
910: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
911: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
912: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
913: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
914: x_set_number OUT NOCOPY VARCHAR2) RETURN NUMBER IS
915:
916: BEGIN
909: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
910: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
911: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
912: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
913: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
914: x_set_number OUT NOCOPY VARCHAR2) RETURN NUMBER IS
915:
916: BEGIN
917:
974: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
975: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
976: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
977: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
978: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
979: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
980: x_set_number OUT NOCOPY VARCHAR2,
981: p_delim IN VARCHAR2
982: ) RETURN NUMBER IS
975: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
976: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
977: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
978: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
979: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
980: x_set_number OUT NOCOPY VARCHAR2,
981: p_delim IN VARCHAR2
982: ) RETURN NUMBER IS
983: l_set_product_segments JTF_VARCHAR2_TABLE_2000;
1064: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1065: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1066: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1067: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
1068: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
1069: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
1070: x_set_id OUT NOCOPY number) RETURN NUMBER IS
1071:
1072: BEGIN
1065: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1066: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1067: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
1068: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
1069: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
1070: x_set_id OUT NOCOPY number) RETURN NUMBER IS
1071:
1072: BEGIN
1073: RETURN Update_Set_With_Validation_2(
1130: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1131: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1132: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1133: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
1134: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
1135: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
1136: x_set_id OUT NOCOPY number,
1137: p_delim IN VARCHAR2
1138: ) RETURN NUMBER IS
1131: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1132: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1133: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
1134: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
1135: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
1136: x_set_id OUT NOCOPY number,
1137: p_delim IN VARCHAR2
1138: ) RETURN NUMBER IS
1139: l_set_product_segments JTF_VARCHAR2_TABLE_2000;
1209: p_element_type_names IN JTF_VARCHAR2_TABLE_2000,
1210: p_ele_content_types IN JTF_VARCHAR2_TABLE_2000,
1211: p_ele_dist_names IN JTF_VARCHAR2_TABLE_2000,
1212: x_visibility_id OUT NOCOPY NUMBER,
1213: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1214: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1215: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1216: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
1217: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
1210: p_ele_content_types IN JTF_VARCHAR2_TABLE_2000,
1211: p_ele_dist_names IN JTF_VARCHAR2_TABLE_2000,
1212: x_visibility_id OUT NOCOPY NUMBER,
1213: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1214: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1215: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1216: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
1217: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
1218: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
1211: p_ele_dist_names IN JTF_VARCHAR2_TABLE_2000,
1212: x_visibility_id OUT NOCOPY NUMBER,
1213: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1214: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1215: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1216: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
1217: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
1218: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
1219: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1212: x_visibility_id OUT NOCOPY NUMBER,
1213: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1214: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1215: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1216: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
1217: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
1218: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
1219: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1220: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1213: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1214: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1215: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1216: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
1217: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
1218: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
1219: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1220: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1221: x_ele_upd_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
1214: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1215: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1216: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
1217: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
1218: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
1219: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1220: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1221: x_ele_upd_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
1222: x_ele_upd_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1217: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
1218: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
1219: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1220: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1221: x_ele_upd_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
1222: x_ele_upd_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1223: x_ele_upd_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1224: x_return_status OUT NOCOPY varchar2,
1225: x_msg_count OUT NOCOPY number,
1276: p_element_type_names IN JTF_VARCHAR2_TABLE_2000,
1277: p_ele_content_types IN JTF_VARCHAR2_TABLE_2000,
1278: p_ele_dist_names IN JTF_VARCHAR2_TABLE_2000,
1279: x_visibility_id OUT NOCOPY NUMBER,
1280: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1281: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1282: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1283: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
1284: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
1277: p_ele_content_types IN JTF_VARCHAR2_TABLE_2000,
1278: p_ele_dist_names IN JTF_VARCHAR2_TABLE_2000,
1279: x_visibility_id OUT NOCOPY NUMBER,
1280: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1281: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1282: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1283: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
1284: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
1285: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
1278: p_ele_dist_names IN JTF_VARCHAR2_TABLE_2000,
1279: x_visibility_id OUT NOCOPY NUMBER,
1280: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1281: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1282: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1283: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
1284: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
1285: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
1286: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1279: x_visibility_id OUT NOCOPY NUMBER,
1280: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1281: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1282: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1283: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
1284: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
1285: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
1286: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1287: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1280: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1281: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1282: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1283: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
1284: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
1285: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
1286: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1287: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1288: x_ele_upd_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
1281: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1282: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1283: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
1284: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
1285: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
1286: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1287: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1288: x_ele_upd_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
1289: x_ele_upd_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1284: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
1285: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
1286: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1287: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1288: x_ele_upd_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
1289: x_ele_upd_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1290: x_ele_upd_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1291: x_return_status OUT NOCOPY varchar2,
1292: x_msg_count OUT NOCOPY number,
1364: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1365: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1366: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1367: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
1368: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
1369: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
1370: x_set_number OUT NOCOPY VARCHAR2,
1371: p_delim IN VARCHAR2
1372: ) RETURN NUMBER IS
1365: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1366: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1367: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
1368: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
1369: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
1370: x_set_number OUT NOCOPY VARCHAR2,
1371: p_delim IN VARCHAR2
1372: ) RETURN NUMBER IS
1373:
1374: l_set_id number;
1375: l_set_type_id NUMBER;
1376: l_set_access_level VARCHAR2(2000);
1377: l_set_visibility_id NUMBER;
1378: l_element_ids JTF_NUMBER_TABLE;
1379: l_element_type_ids JTF_NUMBER_TABLE;
1380: l_element_dist_ids JTF_VARCHAR2_TABLE_2000;
1381: l_element_content_type_codes JTF_VARCHAR2_TABLE_2000;
1382: l_ele_type_id_upd_tbl JTF_NUMBER_TABLE;
1375: l_set_type_id NUMBER;
1376: l_set_access_level VARCHAR2(2000);
1377: l_set_visibility_id NUMBER;
1378: l_element_ids JTF_NUMBER_TABLE;
1379: l_element_type_ids JTF_NUMBER_TABLE;
1380: l_element_dist_ids JTF_VARCHAR2_TABLE_2000;
1381: l_element_content_type_codes JTF_VARCHAR2_TABLE_2000;
1382: l_ele_type_id_upd_tbl JTF_NUMBER_TABLE;
1383: l_ele_dist_id_upd_tbl JTF_VARCHAR2_TABLE_2000;
1378: l_element_ids JTF_NUMBER_TABLE;
1379: l_element_type_ids JTF_NUMBER_TABLE;
1380: l_element_dist_ids JTF_VARCHAR2_TABLE_2000;
1381: l_element_content_type_codes JTF_VARCHAR2_TABLE_2000;
1382: l_ele_type_id_upd_tbl JTF_NUMBER_TABLE;
1383: l_ele_dist_id_upd_tbl JTF_VARCHAR2_TABLE_2000;
1384: l_ele_conttype_codes_upd_tbl JTF_VARCHAR2_TABLE_2000;
1385: l_set_product_ids JTF_NUMBER_TABLE;
1386: l_set_platform_ids JTF_NUMBER_TABLE;
1381: l_element_content_type_codes JTF_VARCHAR2_TABLE_2000;
1382: l_ele_type_id_upd_tbl JTF_NUMBER_TABLE;
1383: l_ele_dist_id_upd_tbl JTF_VARCHAR2_TABLE_2000;
1384: l_ele_conttype_codes_upd_tbl JTF_VARCHAR2_TABLE_2000;
1385: l_set_product_ids JTF_NUMBER_TABLE;
1386: l_set_platform_ids JTF_NUMBER_TABLE;
1387: l_set_category_ids JTF_NUMBER_TABLE;
1388: l_set_product_org_ids JTF_NUMBER_TABLE;
1389: l_set_platform_org_ids JTF_NUMBER_TABLE;
1382: l_ele_type_id_upd_tbl JTF_NUMBER_TABLE;
1383: l_ele_dist_id_upd_tbl JTF_VARCHAR2_TABLE_2000;
1384: l_ele_conttype_codes_upd_tbl JTF_VARCHAR2_TABLE_2000;
1385: l_set_product_ids JTF_NUMBER_TABLE;
1386: l_set_platform_ids JTF_NUMBER_TABLE;
1387: l_set_category_ids JTF_NUMBER_TABLE;
1388: l_set_product_org_ids JTF_NUMBER_TABLE;
1389: l_set_platform_org_ids JTF_NUMBER_TABLE;
1390: l_temp_clob CLOB;
1383: l_ele_dist_id_upd_tbl JTF_VARCHAR2_TABLE_2000;
1384: l_ele_conttype_codes_upd_tbl JTF_VARCHAR2_TABLE_2000;
1385: l_set_product_ids JTF_NUMBER_TABLE;
1386: l_set_platform_ids JTF_NUMBER_TABLE;
1387: l_set_category_ids JTF_NUMBER_TABLE;
1388: l_set_product_org_ids JTF_NUMBER_TABLE;
1389: l_set_platform_org_ids JTF_NUMBER_TABLE;
1390: l_temp_clob CLOB;
1391: l_flow_details_id number := null;
1384: l_ele_conttype_codes_upd_tbl JTF_VARCHAR2_TABLE_2000;
1385: l_set_product_ids JTF_NUMBER_TABLE;
1386: l_set_platform_ids JTF_NUMBER_TABLE;
1387: l_set_category_ids JTF_NUMBER_TABLE;
1388: l_set_product_org_ids JTF_NUMBER_TABLE;
1389: l_set_platform_org_ids JTF_NUMBER_TABLE;
1390: l_temp_clob CLOB;
1391: l_flow_details_id number := null;
1392: l_validate_buf VARCHAR2(1000);
1385: l_set_product_ids JTF_NUMBER_TABLE;
1386: l_set_platform_ids JTF_NUMBER_TABLE;
1387: l_set_category_ids JTF_NUMBER_TABLE;
1388: l_set_product_org_ids JTF_NUMBER_TABLE;
1389: l_set_platform_org_ids JTF_NUMBER_TABLE;
1390: l_temp_clob CLOB;
1391: l_flow_details_id number := null;
1392: l_validate_buf VARCHAR2(1000);
1393: l_return_val NUMBER;
1398: BEGIN
1399:
1400: SAVEPOINT Create_Set;
1401:
1402: x_created_ele_ids_tbl := JTF_NUMBER_TABLE();
1403: x_ele_ids_upd_tbl := JTF_NUMBER_TABLE();
1404: l_element_ids := JTF_NUMBER_TABLE();
1405: l_element_type_ids := JTF_NUMBER_TABLE();
1406: l_element_dist_ids := JTF_VARCHAR2_TABLE_2000();
1399:
1400: SAVEPOINT Create_Set;
1401:
1402: x_created_ele_ids_tbl := JTF_NUMBER_TABLE();
1403: x_ele_ids_upd_tbl := JTF_NUMBER_TABLE();
1404: l_element_ids := JTF_NUMBER_TABLE();
1405: l_element_type_ids := JTF_NUMBER_TABLE();
1406: l_element_dist_ids := JTF_VARCHAR2_TABLE_2000();
1407: l_element_content_type_codes := JTF_VARCHAR2_TABLE_2000();
1400: SAVEPOINT Create_Set;
1401:
1402: x_created_ele_ids_tbl := JTF_NUMBER_TABLE();
1403: x_ele_ids_upd_tbl := JTF_NUMBER_TABLE();
1404: l_element_ids := JTF_NUMBER_TABLE();
1405: l_element_type_ids := JTF_NUMBER_TABLE();
1406: l_element_dist_ids := JTF_VARCHAR2_TABLE_2000();
1407: l_element_content_type_codes := JTF_VARCHAR2_TABLE_2000();
1408: l_ele_type_id_upd_tbl := JTF_NUMBER_TABLE();
1401:
1402: x_created_ele_ids_tbl := JTF_NUMBER_TABLE();
1403: x_ele_ids_upd_tbl := JTF_NUMBER_TABLE();
1404: l_element_ids := JTF_NUMBER_TABLE();
1405: l_element_type_ids := JTF_NUMBER_TABLE();
1406: l_element_dist_ids := JTF_VARCHAR2_TABLE_2000();
1407: l_element_content_type_codes := JTF_VARCHAR2_TABLE_2000();
1408: l_ele_type_id_upd_tbl := JTF_NUMBER_TABLE();
1409: l_ele_dist_id_upd_tbl := JTF_VARCHAR2_TABLE_2000();
1404: l_element_ids := JTF_NUMBER_TABLE();
1405: l_element_type_ids := JTF_NUMBER_TABLE();
1406: l_element_dist_ids := JTF_VARCHAR2_TABLE_2000();
1407: l_element_content_type_codes := JTF_VARCHAR2_TABLE_2000();
1408: l_ele_type_id_upd_tbl := JTF_NUMBER_TABLE();
1409: l_ele_dist_id_upd_tbl := JTF_VARCHAR2_TABLE_2000();
1410: l_ele_conttype_codes_upd_tbl := JTF_VARCHAR2_TABLE_2000();
1411: l_set_product_ids := JTF_NUMBER_TABLE();
1412: l_set_platform_ids := JTF_NUMBER_TABLE();
1407: l_element_content_type_codes := JTF_VARCHAR2_TABLE_2000();
1408: l_ele_type_id_upd_tbl := JTF_NUMBER_TABLE();
1409: l_ele_dist_id_upd_tbl := JTF_VARCHAR2_TABLE_2000();
1410: l_ele_conttype_codes_upd_tbl := JTF_VARCHAR2_TABLE_2000();
1411: l_set_product_ids := JTF_NUMBER_TABLE();
1412: l_set_platform_ids := JTF_NUMBER_TABLE();
1413: l_set_category_ids := JTF_NUMBER_TABLE();
1414: l_set_product_org_ids := JTF_NUMBER_TABLE();
1415: l_set_platform_org_ids := JTF_NUMBER_TABLE();
1408: l_ele_type_id_upd_tbl := JTF_NUMBER_TABLE();
1409: l_ele_dist_id_upd_tbl := JTF_VARCHAR2_TABLE_2000();
1410: l_ele_conttype_codes_upd_tbl := JTF_VARCHAR2_TABLE_2000();
1411: l_set_product_ids := JTF_NUMBER_TABLE();
1412: l_set_platform_ids := JTF_NUMBER_TABLE();
1413: l_set_category_ids := JTF_NUMBER_TABLE();
1414: l_set_product_org_ids := JTF_NUMBER_TABLE();
1415: l_set_platform_org_ids := JTF_NUMBER_TABLE();
1416:
1409: l_ele_dist_id_upd_tbl := JTF_VARCHAR2_TABLE_2000();
1410: l_ele_conttype_codes_upd_tbl := JTF_VARCHAR2_TABLE_2000();
1411: l_set_product_ids := JTF_NUMBER_TABLE();
1412: l_set_platform_ids := JTF_NUMBER_TABLE();
1413: l_set_category_ids := JTF_NUMBER_TABLE();
1414: l_set_product_org_ids := JTF_NUMBER_TABLE();
1415: l_set_platform_org_ids := JTF_NUMBER_TABLE();
1416:
1417: x_return_status := FND_API.G_RET_STS_SUCCESS;
1410: l_ele_conttype_codes_upd_tbl := JTF_VARCHAR2_TABLE_2000();
1411: l_set_product_ids := JTF_NUMBER_TABLE();
1412: l_set_platform_ids := JTF_NUMBER_TABLE();
1413: l_set_category_ids := JTF_NUMBER_TABLE();
1414: l_set_product_org_ids := JTF_NUMBER_TABLE();
1415: l_set_platform_org_ids := JTF_NUMBER_TABLE();
1416:
1417: x_return_status := FND_API.G_RET_STS_SUCCESS;
1418:
1411: l_set_product_ids := JTF_NUMBER_TABLE();
1412: l_set_platform_ids := JTF_NUMBER_TABLE();
1413: l_set_category_ids := JTF_NUMBER_TABLE();
1414: l_set_product_org_ids := JTF_NUMBER_TABLE();
1415: l_set_platform_org_ids := JTF_NUMBER_TABLE();
1416:
1417: x_return_status := FND_API.G_RET_STS_SUCCESS;
1418:
1419: -- Validate Set Type Name, get Set Type ID
1640: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1641: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1642: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1643: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
1644: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
1645: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
1646: x_set_id OUT NOCOPY number,
1647: p_delim IN VARCHAR2
1648: ) RETURN NUMBER IS
1641: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1642: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1643: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
1644: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
1645: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
1646: x_set_id OUT NOCOPY number,
1647: p_delim IN VARCHAR2
1648: ) RETURN NUMBER IS
1649:
1649:
1650: l_set_type_id NUMBER;
1651: l_set_access_level VARCHAR2(2000);
1652: l_set_visibility_id NUMBER;
1653: l_element_ids JTF_NUMBER_TABLE;
1654: l_element_type_ids JTF_NUMBER_TABLE;
1655: l_element_dist_ids JTF_VARCHAR2_TABLE_2000;
1656: l_element_content_type_codes JTF_VARCHAR2_TABLE_2000;
1657: l_ele_type_id_upd_tbl JTF_NUMBER_TABLE;
1650: l_set_type_id NUMBER;
1651: l_set_access_level VARCHAR2(2000);
1652: l_set_visibility_id NUMBER;
1653: l_element_ids JTF_NUMBER_TABLE;
1654: l_element_type_ids JTF_NUMBER_TABLE;
1655: l_element_dist_ids JTF_VARCHAR2_TABLE_2000;
1656: l_element_content_type_codes JTF_VARCHAR2_TABLE_2000;
1657: l_ele_type_id_upd_tbl JTF_NUMBER_TABLE;
1658: l_ele_dist_id_upd_tbl JTF_VARCHAR2_TABLE_2000;
1653: l_element_ids JTF_NUMBER_TABLE;
1654: l_element_type_ids JTF_NUMBER_TABLE;
1655: l_element_dist_ids JTF_VARCHAR2_TABLE_2000;
1656: l_element_content_type_codes JTF_VARCHAR2_TABLE_2000;
1657: l_ele_type_id_upd_tbl JTF_NUMBER_TABLE;
1658: l_ele_dist_id_upd_tbl JTF_VARCHAR2_TABLE_2000;
1659: l_ele_conttype_codes_upd_tbl JTF_VARCHAR2_TABLE_2000;
1660: l_set_product_ids JTF_NUMBER_TABLE;
1661: l_set_platform_ids JTF_NUMBER_TABLE;
1656: l_element_content_type_codes JTF_VARCHAR2_TABLE_2000;
1657: l_ele_type_id_upd_tbl JTF_NUMBER_TABLE;
1658: l_ele_dist_id_upd_tbl JTF_VARCHAR2_TABLE_2000;
1659: l_ele_conttype_codes_upd_tbl JTF_VARCHAR2_TABLE_2000;
1660: l_set_product_ids JTF_NUMBER_TABLE;
1661: l_set_platform_ids JTF_NUMBER_TABLE;
1662: l_set_category_ids JTF_NUMBER_TABLE;
1663: l_set_product_org_ids JTF_NUMBER_TABLE;
1664: l_set_platform_org_ids JTF_NUMBER_TABLE;
1657: l_ele_type_id_upd_tbl JTF_NUMBER_TABLE;
1658: l_ele_dist_id_upd_tbl JTF_VARCHAR2_TABLE_2000;
1659: l_ele_conttype_codes_upd_tbl JTF_VARCHAR2_TABLE_2000;
1660: l_set_product_ids JTF_NUMBER_TABLE;
1661: l_set_platform_ids JTF_NUMBER_TABLE;
1662: l_set_category_ids JTF_NUMBER_TABLE;
1663: l_set_product_org_ids JTF_NUMBER_TABLE;
1664: l_set_platform_org_ids JTF_NUMBER_TABLE;
1665: l_temp_clob CLOB;
1658: l_ele_dist_id_upd_tbl JTF_VARCHAR2_TABLE_2000;
1659: l_ele_conttype_codes_upd_tbl JTF_VARCHAR2_TABLE_2000;
1660: l_set_product_ids JTF_NUMBER_TABLE;
1661: l_set_platform_ids JTF_NUMBER_TABLE;
1662: l_set_category_ids JTF_NUMBER_TABLE;
1663: l_set_product_org_ids JTF_NUMBER_TABLE;
1664: l_set_platform_org_ids JTF_NUMBER_TABLE;
1665: l_temp_clob CLOB;
1666: l_validate_buf VARCHAR2(1000);
1659: l_ele_conttype_codes_upd_tbl JTF_VARCHAR2_TABLE_2000;
1660: l_set_product_ids JTF_NUMBER_TABLE;
1661: l_set_platform_ids JTF_NUMBER_TABLE;
1662: l_set_category_ids JTF_NUMBER_TABLE;
1663: l_set_product_org_ids JTF_NUMBER_TABLE;
1664: l_set_platform_org_ids JTF_NUMBER_TABLE;
1665: l_temp_clob CLOB;
1666: l_validate_buf VARCHAR2(1000);
1667: l_return_val NUMBER;
1660: l_set_product_ids JTF_NUMBER_TABLE;
1661: l_set_platform_ids JTF_NUMBER_TABLE;
1662: l_set_category_ids JTF_NUMBER_TABLE;
1663: l_set_product_org_ids JTF_NUMBER_TABLE;
1664: l_set_platform_org_ids JTF_NUMBER_TABLE;
1665: l_temp_clob CLOB;
1666: l_validate_buf VARCHAR2(1000);
1667: l_return_val NUMBER;
1668: l_return_status VARCHAR2(1);
1669: l_msg_data VARCHAR2(2000);
1670: l_msg_count NUMBER;
1671:
1672: -- old IDs to delete
1673: l_old_set_product_ids JTF_NUMBER_TABLE;
1674: l_old_set_platform_ids JTF_NUMBER_TABLE;
1675: l_old_set_product_org_ids JTF_NUMBER_TABLE;
1676: l_old_set_platform_org_ids JTF_NUMBER_TABLE;
1677: counter number := 1;
1670: l_msg_count NUMBER;
1671:
1672: -- old IDs to delete
1673: l_old_set_product_ids JTF_NUMBER_TABLE;
1674: l_old_set_platform_ids JTF_NUMBER_TABLE;
1675: l_old_set_product_org_ids JTF_NUMBER_TABLE;
1676: l_old_set_platform_org_ids JTF_NUMBER_TABLE;
1677: counter number := 1;
1678:
1671:
1672: -- old IDs to delete
1673: l_old_set_product_ids JTF_NUMBER_TABLE;
1674: l_old_set_platform_ids JTF_NUMBER_TABLE;
1675: l_old_set_product_org_ids JTF_NUMBER_TABLE;
1676: l_old_set_platform_org_ids JTF_NUMBER_TABLE;
1677: counter number := 1;
1678:
1679: cursor element_ids_cur (p_set_id IN NUMBER) IS
1672: -- old IDs to delete
1673: l_old_set_product_ids JTF_NUMBER_TABLE;
1674: l_old_set_platform_ids JTF_NUMBER_TABLE;
1675: l_old_set_product_org_ids JTF_NUMBER_TABLE;
1676: l_old_set_platform_org_ids JTF_NUMBER_TABLE;
1677: counter number := 1;
1678:
1679: cursor element_ids_cur (p_set_id IN NUMBER) IS
1680: select element_id
1700: BEGIN
1701: -- dbms_output.put_line('Update Set with Validation - BEGIN');
1702: SAVEPOINT Update_Set;
1703:
1704: x_created_ele_ids_tbl := JTF_NUMBER_TABLE();
1705: l_element_ids := JTF_NUMBER_TABLE();
1706: l_element_type_ids := JTF_NUMBER_TABLE();
1707: l_element_dist_ids := JTF_VARCHAR2_TABLE_2000();
1708: l_element_content_type_codes := JTF_VARCHAR2_TABLE_2000();
1701: -- dbms_output.put_line('Update Set with Validation - BEGIN');
1702: SAVEPOINT Update_Set;
1703:
1704: x_created_ele_ids_tbl := JTF_NUMBER_TABLE();
1705: l_element_ids := JTF_NUMBER_TABLE();
1706: l_element_type_ids := JTF_NUMBER_TABLE();
1707: l_element_dist_ids := JTF_VARCHAR2_TABLE_2000();
1708: l_element_content_type_codes := JTF_VARCHAR2_TABLE_2000();
1709: l_ele_type_id_upd_tbl := JTF_NUMBER_TABLE();
1702: SAVEPOINT Update_Set;
1703:
1704: x_created_ele_ids_tbl := JTF_NUMBER_TABLE();
1705: l_element_ids := JTF_NUMBER_TABLE();
1706: l_element_type_ids := JTF_NUMBER_TABLE();
1707: l_element_dist_ids := JTF_VARCHAR2_TABLE_2000();
1708: l_element_content_type_codes := JTF_VARCHAR2_TABLE_2000();
1709: l_ele_type_id_upd_tbl := JTF_NUMBER_TABLE();
1710: l_ele_dist_id_upd_tbl := JTF_VARCHAR2_TABLE_2000();
1705: l_element_ids := JTF_NUMBER_TABLE();
1706: l_element_type_ids := JTF_NUMBER_TABLE();
1707: l_element_dist_ids := JTF_VARCHAR2_TABLE_2000();
1708: l_element_content_type_codes := JTF_VARCHAR2_TABLE_2000();
1709: l_ele_type_id_upd_tbl := JTF_NUMBER_TABLE();
1710: l_ele_dist_id_upd_tbl := JTF_VARCHAR2_TABLE_2000();
1711: x_ele_ids_upd_tbl := JTF_NUMBER_TABLE();
1712: l_ele_conttype_codes_upd_tbl := JTF_VARCHAR2_TABLE_2000();
1713: l_set_product_ids := JTF_NUMBER_TABLE();
1707: l_element_dist_ids := JTF_VARCHAR2_TABLE_2000();
1708: l_element_content_type_codes := JTF_VARCHAR2_TABLE_2000();
1709: l_ele_type_id_upd_tbl := JTF_NUMBER_TABLE();
1710: l_ele_dist_id_upd_tbl := JTF_VARCHAR2_TABLE_2000();
1711: x_ele_ids_upd_tbl := JTF_NUMBER_TABLE();
1712: l_ele_conttype_codes_upd_tbl := JTF_VARCHAR2_TABLE_2000();
1713: l_set_product_ids := JTF_NUMBER_TABLE();
1714: l_set_platform_ids := JTF_NUMBER_TABLE();
1715: l_set_category_ids := JTF_NUMBER_TABLE();
1709: l_ele_type_id_upd_tbl := JTF_NUMBER_TABLE();
1710: l_ele_dist_id_upd_tbl := JTF_VARCHAR2_TABLE_2000();
1711: x_ele_ids_upd_tbl := JTF_NUMBER_TABLE();
1712: l_ele_conttype_codes_upd_tbl := JTF_VARCHAR2_TABLE_2000();
1713: l_set_product_ids := JTF_NUMBER_TABLE();
1714: l_set_platform_ids := JTF_NUMBER_TABLE();
1715: l_set_category_ids := JTF_NUMBER_TABLE();
1716: l_set_product_org_ids := JTF_NUMBER_TABLE();
1717: l_set_platform_org_ids := JTF_NUMBER_TABLE();
1710: l_ele_dist_id_upd_tbl := JTF_VARCHAR2_TABLE_2000();
1711: x_ele_ids_upd_tbl := JTF_NUMBER_TABLE();
1712: l_ele_conttype_codes_upd_tbl := JTF_VARCHAR2_TABLE_2000();
1713: l_set_product_ids := JTF_NUMBER_TABLE();
1714: l_set_platform_ids := JTF_NUMBER_TABLE();
1715: l_set_category_ids := JTF_NUMBER_TABLE();
1716: l_set_product_org_ids := JTF_NUMBER_TABLE();
1717: l_set_platform_org_ids := JTF_NUMBER_TABLE();
1718:
1711: x_ele_ids_upd_tbl := JTF_NUMBER_TABLE();
1712: l_ele_conttype_codes_upd_tbl := JTF_VARCHAR2_TABLE_2000();
1713: l_set_product_ids := JTF_NUMBER_TABLE();
1714: l_set_platform_ids := JTF_NUMBER_TABLE();
1715: l_set_category_ids := JTF_NUMBER_TABLE();
1716: l_set_product_org_ids := JTF_NUMBER_TABLE();
1717: l_set_platform_org_ids := JTF_NUMBER_TABLE();
1718:
1719: l_old_set_product_ids := JTF_NUMBER_TABLE();
1712: l_ele_conttype_codes_upd_tbl := JTF_VARCHAR2_TABLE_2000();
1713: l_set_product_ids := JTF_NUMBER_TABLE();
1714: l_set_platform_ids := JTF_NUMBER_TABLE();
1715: l_set_category_ids := JTF_NUMBER_TABLE();
1716: l_set_product_org_ids := JTF_NUMBER_TABLE();
1717: l_set_platform_org_ids := JTF_NUMBER_TABLE();
1718:
1719: l_old_set_product_ids := JTF_NUMBER_TABLE();
1720: l_old_set_platform_ids := JTF_NUMBER_TABLE();
1713: l_set_product_ids := JTF_NUMBER_TABLE();
1714: l_set_platform_ids := JTF_NUMBER_TABLE();
1715: l_set_category_ids := JTF_NUMBER_TABLE();
1716: l_set_product_org_ids := JTF_NUMBER_TABLE();
1717: l_set_platform_org_ids := JTF_NUMBER_TABLE();
1718:
1719: l_old_set_product_ids := JTF_NUMBER_TABLE();
1720: l_old_set_platform_ids := JTF_NUMBER_TABLE();
1721: l_old_set_product_org_ids := JTF_NUMBER_TABLE();
1715: l_set_category_ids := JTF_NUMBER_TABLE();
1716: l_set_product_org_ids := JTF_NUMBER_TABLE();
1717: l_set_platform_org_ids := JTF_NUMBER_TABLE();
1718:
1719: l_old_set_product_ids := JTF_NUMBER_TABLE();
1720: l_old_set_platform_ids := JTF_NUMBER_TABLE();
1721: l_old_set_product_org_ids := JTF_NUMBER_TABLE();
1722: l_old_set_platform_org_ids := JTF_NUMBER_TABLE();
1723:
1716: l_set_product_org_ids := JTF_NUMBER_TABLE();
1717: l_set_platform_org_ids := JTF_NUMBER_TABLE();
1718:
1719: l_old_set_product_ids := JTF_NUMBER_TABLE();
1720: l_old_set_platform_ids := JTF_NUMBER_TABLE();
1721: l_old_set_product_org_ids := JTF_NUMBER_TABLE();
1722: l_old_set_platform_org_ids := JTF_NUMBER_TABLE();
1723:
1724: x_return_status := FND_API.G_RET_STS_SUCCESS;
1717: l_set_platform_org_ids := JTF_NUMBER_TABLE();
1718:
1719: l_old_set_product_ids := JTF_NUMBER_TABLE();
1720: l_old_set_platform_ids := JTF_NUMBER_TABLE();
1721: l_old_set_product_org_ids := JTF_NUMBER_TABLE();
1722: l_old_set_platform_org_ids := JTF_NUMBER_TABLE();
1723:
1724: x_return_status := FND_API.G_RET_STS_SUCCESS;
1725:
1718:
1719: l_old_set_product_ids := JTF_NUMBER_TABLE();
1720: l_old_set_platform_ids := JTF_NUMBER_TABLE();
1721: l_old_set_product_org_ids := JTF_NUMBER_TABLE();
1722: l_old_set_platform_org_ids := JTF_NUMBER_TABLE();
1723:
1724: x_return_status := FND_API.G_RET_STS_SUCCESS;
1725:
1726: -- dbms_output.put_line('Validate Set number');
2017: p_element_type_names IN JTF_VARCHAR2_TABLE_2000,
2018: p_ele_content_types IN JTF_VARCHAR2_TABLE_2000,
2019: p_ele_dist_names IN JTF_VARCHAR2_TABLE_2000,
2020: x_visibility_id OUT NOCOPY NUMBER,
2021: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
2022: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
2023: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
2024: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
2025: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
2018: p_ele_content_types IN JTF_VARCHAR2_TABLE_2000,
2019: p_ele_dist_names IN JTF_VARCHAR2_TABLE_2000,
2020: x_visibility_id OUT NOCOPY NUMBER,
2021: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
2022: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
2023: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
2024: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
2025: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
2026: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
2019: p_ele_dist_names IN JTF_VARCHAR2_TABLE_2000,
2020: x_visibility_id OUT NOCOPY NUMBER,
2021: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
2022: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
2023: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
2024: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
2025: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
2026: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
2027: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
2020: x_visibility_id OUT NOCOPY NUMBER,
2021: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
2022: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
2023: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
2024: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
2025: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
2026: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
2027: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
2028: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
2021: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
2022: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
2023: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
2024: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
2025: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
2026: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
2027: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
2028: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
2029: x_ele_upd_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
2022: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
2023: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
2024: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
2025: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
2026: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
2027: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
2028: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
2029: x_ele_upd_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
2030: x_ele_upd_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
2025: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
2026: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
2027: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
2028: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
2029: x_ele_upd_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
2030: x_ele_upd_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
2031: x_ele_upd_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
2032: x_return_status OUT NOCOPY varchar2,
2033: x_msg_count OUT NOCOPY number,
2038: l_validate_buf VARCHAR2(1000);
2039: l_return_val NUMBER;
2040: l_return_status VARCHAR2(1);
2041: l_dup_found VARCHAR2(1);
2042: l_product_numbers JTF_NUMBER_TABLE;
2043: l_platform_numbers JTF_NUMBER_TABLE;
2044: BEGIN
2045:
2046: x_element_type_ids := JTF_NUMBER_TABLE();
2039: l_return_val NUMBER;
2040: l_return_status VARCHAR2(1);
2041: l_dup_found VARCHAR2(1);
2042: l_product_numbers JTF_NUMBER_TABLE;
2043: l_platform_numbers JTF_NUMBER_TABLE;
2044: BEGIN
2045:
2046: x_element_type_ids := JTF_NUMBER_TABLE();
2047: x_product_numbers := JTF_NUMBER_TABLE();
2042: l_product_numbers JTF_NUMBER_TABLE;
2043: l_platform_numbers JTF_NUMBER_TABLE;
2044: BEGIN
2045:
2046: x_element_type_ids := JTF_NUMBER_TABLE();
2047: x_product_numbers := JTF_NUMBER_TABLE();
2048: l_product_numbers := JTF_NUMBER_TABLE();
2049: x_platform_numbers := JTF_NUMBER_TABLE();
2050: l_platform_numbers := JTF_NUMBER_TABLE();
2043: l_platform_numbers JTF_NUMBER_TABLE;
2044: BEGIN
2045:
2046: x_element_type_ids := JTF_NUMBER_TABLE();
2047: x_product_numbers := JTF_NUMBER_TABLE();
2048: l_product_numbers := JTF_NUMBER_TABLE();
2049: x_platform_numbers := JTF_NUMBER_TABLE();
2050: l_platform_numbers := JTF_NUMBER_TABLE();
2051: x_category_numbers := JTF_NUMBER_TABLE();
2044: BEGIN
2045:
2046: x_element_type_ids := JTF_NUMBER_TABLE();
2047: x_product_numbers := JTF_NUMBER_TABLE();
2048: l_product_numbers := JTF_NUMBER_TABLE();
2049: x_platform_numbers := JTF_NUMBER_TABLE();
2050: l_platform_numbers := JTF_NUMBER_TABLE();
2051: x_category_numbers := JTF_NUMBER_TABLE();
2052: x_ele_ids := JTF_NUMBER_TABLE();
2045:
2046: x_element_type_ids := JTF_NUMBER_TABLE();
2047: x_product_numbers := JTF_NUMBER_TABLE();
2048: l_product_numbers := JTF_NUMBER_TABLE();
2049: x_platform_numbers := JTF_NUMBER_TABLE();
2050: l_platform_numbers := JTF_NUMBER_TABLE();
2051: x_category_numbers := JTF_NUMBER_TABLE();
2052: x_ele_ids := JTF_NUMBER_TABLE();
2053: x_ele_upd_ids := JTF_NUMBER_TABLE();
2046: x_element_type_ids := JTF_NUMBER_TABLE();
2047: x_product_numbers := JTF_NUMBER_TABLE();
2048: l_product_numbers := JTF_NUMBER_TABLE();
2049: x_platform_numbers := JTF_NUMBER_TABLE();
2050: l_platform_numbers := JTF_NUMBER_TABLE();
2051: x_category_numbers := JTF_NUMBER_TABLE();
2052: x_ele_ids := JTF_NUMBER_TABLE();
2053: x_ele_upd_ids := JTF_NUMBER_TABLE();
2054: x_element_type_ids := JTF_NUMBER_TABLE();
2047: x_product_numbers := JTF_NUMBER_TABLE();
2048: l_product_numbers := JTF_NUMBER_TABLE();
2049: x_platform_numbers := JTF_NUMBER_TABLE();
2050: l_platform_numbers := JTF_NUMBER_TABLE();
2051: x_category_numbers := JTF_NUMBER_TABLE();
2052: x_ele_ids := JTF_NUMBER_TABLE();
2053: x_ele_upd_ids := JTF_NUMBER_TABLE();
2054: x_element_type_ids := JTF_NUMBER_TABLE();
2055: x_ele_dist_ids := JTF_VARCHAR2_TABLE_2000();
2048: l_product_numbers := JTF_NUMBER_TABLE();
2049: x_platform_numbers := JTF_NUMBER_TABLE();
2050: l_platform_numbers := JTF_NUMBER_TABLE();
2051: x_category_numbers := JTF_NUMBER_TABLE();
2052: x_ele_ids := JTF_NUMBER_TABLE();
2053: x_ele_upd_ids := JTF_NUMBER_TABLE();
2054: x_element_type_ids := JTF_NUMBER_TABLE();
2055: x_ele_dist_ids := JTF_VARCHAR2_TABLE_2000();
2056: x_ele_content_type_codes := JTF_VARCHAR2_TABLE_2000();
2049: x_platform_numbers := JTF_NUMBER_TABLE();
2050: l_platform_numbers := JTF_NUMBER_TABLE();
2051: x_category_numbers := JTF_NUMBER_TABLE();
2052: x_ele_ids := JTF_NUMBER_TABLE();
2053: x_ele_upd_ids := JTF_NUMBER_TABLE();
2054: x_element_type_ids := JTF_NUMBER_TABLE();
2055: x_ele_dist_ids := JTF_VARCHAR2_TABLE_2000();
2056: x_ele_content_type_codes := JTF_VARCHAR2_TABLE_2000();
2057: x_ele_upd_type_ids := JTF_NUMBER_TABLE();
2050: l_platform_numbers := JTF_NUMBER_TABLE();
2051: x_category_numbers := JTF_NUMBER_TABLE();
2052: x_ele_ids := JTF_NUMBER_TABLE();
2053: x_ele_upd_ids := JTF_NUMBER_TABLE();
2054: x_element_type_ids := JTF_NUMBER_TABLE();
2055: x_ele_dist_ids := JTF_VARCHAR2_TABLE_2000();
2056: x_ele_content_type_codes := JTF_VARCHAR2_TABLE_2000();
2057: x_ele_upd_type_ids := JTF_NUMBER_TABLE();
2058: x_ele_upd_dist_ids := JTF_VARCHAR2_TABLE_2000();
2053: x_ele_upd_ids := JTF_NUMBER_TABLE();
2054: x_element_type_ids := JTF_NUMBER_TABLE();
2055: x_ele_dist_ids := JTF_VARCHAR2_TABLE_2000();
2056: x_ele_content_type_codes := JTF_VARCHAR2_TABLE_2000();
2057: x_ele_upd_type_ids := JTF_NUMBER_TABLE();
2058: x_ele_upd_dist_ids := JTF_VARCHAR2_TABLE_2000();
2059: x_ele_upd_content_type_codes := JTF_VARCHAR2_TABLE_2000();
2060:
2061: -- Validate Solution Visibility Level Name, get ID
2370: FUNCTION Link_Soln_Attributes
2371: (
2372: p_validate_type IN VARCHAR2,
2373: p_set_id IN NUMBER,
2374: p_given_element_ids IN JTF_NUMBER_TABLE,
2375: p_given_ele_nums in JTF_VARCHAR2_TABLE_2000,
2376: p_given_ele_type_ids in JTF_NUMBER_TABLE,
2377: p_given_ele_dist_ids in JTF_VARCHAR2_TABLE_2000,
2378: p_given_ele_content_types in JTF_VARCHAR2_TABLE_2000,
2372: p_validate_type IN VARCHAR2,
2373: p_set_id IN NUMBER,
2374: p_given_element_ids IN JTF_NUMBER_TABLE,
2375: p_given_ele_nums in JTF_VARCHAR2_TABLE_2000,
2376: p_given_ele_type_ids in JTF_NUMBER_TABLE,
2377: p_given_ele_dist_ids in JTF_VARCHAR2_TABLE_2000,
2378: p_given_ele_content_types in JTF_VARCHAR2_TABLE_2000,
2379: p_given_ele_summaryies in JTF_VARCHAR2_TABLE_2000,
2380: p_element_ids IN JTF_NUMBER_TABLE,
2376: p_given_ele_type_ids in JTF_NUMBER_TABLE,
2377: p_given_ele_dist_ids in JTF_VARCHAR2_TABLE_2000,
2378: p_given_ele_content_types in JTF_VARCHAR2_TABLE_2000,
2379: p_given_ele_summaryies in JTF_VARCHAR2_TABLE_2000,
2380: p_element_ids IN JTF_NUMBER_TABLE,
2381: p_element_type_ids IN JTF_NUMBER_TABLE,
2382: p_element_dist_ids IN JTF_VARCHAR2_TABLE_2000,
2383: p_element_content_types IN JTF_VARCHAR2_TABLE_2000,
2384: p_element_summaries IN JTF_VARCHAR2_TABLE_2000,
2377: p_given_ele_dist_ids in JTF_VARCHAR2_TABLE_2000,
2378: p_given_ele_content_types in JTF_VARCHAR2_TABLE_2000,
2379: p_given_ele_summaryies in JTF_VARCHAR2_TABLE_2000,
2380: p_element_ids IN JTF_NUMBER_TABLE,
2381: p_element_type_ids IN JTF_NUMBER_TABLE,
2382: p_element_dist_ids IN JTF_VARCHAR2_TABLE_2000,
2383: p_element_content_types IN JTF_VARCHAR2_TABLE_2000,
2384: p_element_summaries IN JTF_VARCHAR2_TABLE_2000,
2385: p_element_dummy_detail IN CLOB,
2382: p_element_dist_ids IN JTF_VARCHAR2_TABLE_2000,
2383: p_element_content_types IN JTF_VARCHAR2_TABLE_2000,
2384: p_element_summaries IN JTF_VARCHAR2_TABLE_2000,
2385: p_element_dummy_detail IN CLOB,
2386: p_set_product_ids IN JTF_NUMBER_TABLE,
2387: p_set_platform_ids IN JTF_NUMBER_TABLE,
2388: p_set_category_ids IN JTF_NUMBER_TABLE,
2389: x_created_element_ids OUT NOCOPY JTF_NUMBER_TABLE,
2390: x_return_status OUT NOCOPY varchar2,
2383: p_element_content_types IN JTF_VARCHAR2_TABLE_2000,
2384: p_element_summaries IN JTF_VARCHAR2_TABLE_2000,
2385: p_element_dummy_detail IN CLOB,
2386: p_set_product_ids IN JTF_NUMBER_TABLE,
2387: p_set_platform_ids IN JTF_NUMBER_TABLE,
2388: p_set_category_ids IN JTF_NUMBER_TABLE,
2389: x_created_element_ids OUT NOCOPY JTF_NUMBER_TABLE,
2390: x_return_status OUT NOCOPY varchar2,
2391: x_msg_count OUT NOCOPY number,
2384: p_element_summaries IN JTF_VARCHAR2_TABLE_2000,
2385: p_element_dummy_detail IN CLOB,
2386: p_set_product_ids IN JTF_NUMBER_TABLE,
2387: p_set_platform_ids IN JTF_NUMBER_TABLE,
2388: p_set_category_ids IN JTF_NUMBER_TABLE,
2389: x_created_element_ids OUT NOCOPY JTF_NUMBER_TABLE,
2390: x_return_status OUT NOCOPY varchar2,
2391: x_msg_count OUT NOCOPY number,
2392: x_msg_data OUT NOCOPY varchar2
2385: p_element_dummy_detail IN CLOB,
2386: p_set_product_ids IN JTF_NUMBER_TABLE,
2387: p_set_platform_ids IN JTF_NUMBER_TABLE,
2388: p_set_category_ids IN JTF_NUMBER_TABLE,
2389: x_created_element_ids OUT NOCOPY JTF_NUMBER_TABLE,
2390: x_return_status OUT NOCOPY varchar2,
2391: x_msg_count OUT NOCOPY number,
2392: x_msg_data OUT NOCOPY varchar2
2393: ) RETURN NUMBER IS
2391: x_msg_count OUT NOCOPY number,
2392: x_msg_data OUT NOCOPY varchar2
2393: ) RETURN NUMBER IS
2394: l_temp_element_no VARCHAR2(30);
2395: l_set_product_org_ids JTF_NUMBER_TABLE;
2396: l_set_platform_org_ids JTF_NUMBER_TABLE;
2397: l_temp_category_link_id number;
2398: l_temp_update_return number;
2399: l_elmt_status VARCHAR2(30);
2392: x_msg_data OUT NOCOPY varchar2
2393: ) RETURN NUMBER IS
2394: l_temp_element_no VARCHAR2(30);
2395: l_set_product_org_ids JTF_NUMBER_TABLE;
2396: l_set_platform_org_ids JTF_NUMBER_TABLE;
2397: l_temp_category_link_id number;
2398: l_temp_update_return number;
2399: l_elmt_status VARCHAR2(30);
2400:
2401: l_validate_buf VARCHAR2(1000);
2402: l_return_val NUMBER;
2403: BEGIN
2404:
2405: l_set_product_org_ids := JTF_NUMBER_TABLE();
2406: l_set_platform_org_ids := JTF_NUMBER_TABLE();
2407:
2408: IF (p_validate_type = 'UPDATE') THEN
2409: l_elmt_status := 'PUBLISHED';
2402: l_return_val NUMBER;
2403: BEGIN
2404:
2405: l_set_product_org_ids := JTF_NUMBER_TABLE();
2406: l_set_platform_org_ids := JTF_NUMBER_TABLE();
2407:
2408: IF (p_validate_type = 'UPDATE') THEN
2409: l_elmt_status := 'PUBLISHED';
2410: ELSE
2412: END IF;
2413:
2414:
2415: -- Creating new elements
2416: x_created_element_ids := JTF_NUMBER_TABLE();
2417: x_created_element_ids.extend(p_element_type_ids.count);
2418: for i in 1..p_element_type_ids.count loop
2419: x_created_element_ids(i) := CS_KB_ELEMENTS_AUDIT_PKG.Create_Element_CLOB(
2420: p_element_type_id => p_element_type_ids(i),
2784:
2785: FUNCTION Validate_Set_Element_Type_Ids
2786: (
2787: p_set_type_id IN NUMBER,
2788: p_element_type_ids IN JTF_NUMBER_TABLE
2789:
2790: ) RETURN NUMBER IS
2791:
2792: Type element_type_id_tab_type is