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.CS_KNOWLEDGE_AUDIT_PVT dependencies on JTF_NUMBER_TABLE

Line 75: t_ele_type_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

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;

Line 921: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,

917: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
918: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
919: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
920: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
921: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
922: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
923: x_set_number OUT NOCOPY VARCHAR2) RETURN NUMBER IS
924:
925: BEGIN

Line 922: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,

918: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
919: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
920: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
921: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
922: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
923: x_set_number OUT NOCOPY VARCHAR2) RETURN NUMBER IS
924:
925: BEGIN
926:

Line 987: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,

983: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
984: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
985: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
986: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
987: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
988: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
989: x_set_number OUT NOCOPY VARCHAR2,
990: p_delim IN VARCHAR2
991: ) RETURN NUMBER IS

Line 988: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,

984: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
985: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
986: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
987: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
988: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
989: x_set_number OUT NOCOPY VARCHAR2,
990: p_delim IN VARCHAR2
991: ) RETURN NUMBER IS
992: l_set_product_segments JTF_VARCHAR2_TABLE_2000;

Line 1077: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,

1073: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1074: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1075: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1076: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
1077: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
1078: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
1079: x_set_id OUT NOCOPY number) RETURN NUMBER IS
1080:
1081: BEGIN

Line 1078: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,

1074: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1075: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1076: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
1077: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
1078: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
1079: x_set_id OUT NOCOPY number) RETURN NUMBER IS
1080:
1081: BEGIN
1082: RETURN Update_Set_With_Validation_2(

Line 1143: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,

1139: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1140: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1141: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1142: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
1143: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
1144: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
1145: x_set_id OUT NOCOPY number,
1146: p_delim IN VARCHAR2
1147: ) RETURN NUMBER IS

Line 1144: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,

1140: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1141: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1142: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
1143: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
1144: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
1145: x_set_id OUT NOCOPY number,
1146: p_delim IN VARCHAR2
1147: ) RETURN NUMBER IS
1148: l_set_product_segments JTF_VARCHAR2_TABLE_2000;

Line 1222: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,

1218: p_element_type_names IN JTF_VARCHAR2_TABLE_2000,
1219: p_ele_content_types IN JTF_VARCHAR2_TABLE_2000,
1220: p_ele_dist_names IN JTF_VARCHAR2_TABLE_2000,
1221: x_visibility_id OUT NOCOPY NUMBER,
1222: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1223: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1224: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1225: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
1226: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,

Line 1223: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,

1219: p_ele_content_types IN JTF_VARCHAR2_TABLE_2000,
1220: p_ele_dist_names IN JTF_VARCHAR2_TABLE_2000,
1221: x_visibility_id OUT NOCOPY NUMBER,
1222: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1223: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1224: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1225: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
1226: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
1227: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,

Line 1224: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,

1220: p_ele_dist_names IN JTF_VARCHAR2_TABLE_2000,
1221: x_visibility_id OUT NOCOPY NUMBER,
1222: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1223: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1224: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1225: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
1226: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
1227: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
1228: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,

Line 1225: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,

1221: x_visibility_id OUT NOCOPY NUMBER,
1222: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1223: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1224: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1225: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
1226: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
1227: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
1228: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1229: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,

Line 1226: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,

1222: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1223: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1224: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1225: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
1226: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
1227: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
1228: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1229: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1230: x_ele_upd_type_ids OUT NOCOPY JTF_NUMBER_TABLE,

Line 1227: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,

1223: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1224: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1225: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
1226: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
1227: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
1228: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1229: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1230: x_ele_upd_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
1231: x_ele_upd_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,

Line 1230: x_ele_upd_type_ids OUT NOCOPY JTF_NUMBER_TABLE,

1226: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
1227: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
1228: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1229: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1230: x_ele_upd_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
1231: x_ele_upd_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1232: x_ele_upd_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1233: x_return_status OUT NOCOPY varchar2,
1234: x_msg_count OUT NOCOPY number,

Line 1289: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,

1285: p_element_type_names IN JTF_VARCHAR2_TABLE_2000,
1286: p_ele_content_types IN JTF_VARCHAR2_TABLE_2000,
1287: p_ele_dist_names IN JTF_VARCHAR2_TABLE_2000,
1288: x_visibility_id OUT NOCOPY NUMBER,
1289: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1290: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1291: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1292: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
1293: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,

Line 1290: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,

1286: p_ele_content_types IN JTF_VARCHAR2_TABLE_2000,
1287: p_ele_dist_names IN JTF_VARCHAR2_TABLE_2000,
1288: x_visibility_id OUT NOCOPY NUMBER,
1289: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1290: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1291: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1292: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
1293: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
1294: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,

Line 1291: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,

1287: p_ele_dist_names IN JTF_VARCHAR2_TABLE_2000,
1288: x_visibility_id OUT NOCOPY NUMBER,
1289: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1290: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1291: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1292: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
1293: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
1294: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
1295: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,

Line 1292: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,

1288: x_visibility_id OUT NOCOPY NUMBER,
1289: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1290: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1291: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1292: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
1293: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
1294: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
1295: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1296: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,

Line 1293: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,

1289: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1290: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1291: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1292: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
1293: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
1294: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
1295: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1296: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1297: x_ele_upd_type_ids OUT NOCOPY JTF_NUMBER_TABLE,

Line 1294: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,

1290: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1291: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
1292: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
1293: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
1294: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
1295: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1296: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1297: x_ele_upd_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
1298: x_ele_upd_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,

Line 1297: x_ele_upd_type_ids OUT NOCOPY JTF_NUMBER_TABLE,

1293: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
1294: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
1295: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1296: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1297: x_ele_upd_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
1298: x_ele_upd_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1299: x_ele_upd_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
1300: x_return_status OUT NOCOPY varchar2,
1301: x_msg_count OUT NOCOPY number,

Line 1377: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,

1373: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1374: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1375: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1376: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
1377: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
1378: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
1379: x_set_number OUT NOCOPY VARCHAR2,
1380: p_delim IN VARCHAR2
1381: ) RETURN NUMBER IS

Line 1378: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,

1374: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1375: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1376: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
1377: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
1378: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
1379: x_set_number OUT NOCOPY VARCHAR2,
1380: p_delim IN VARCHAR2
1381: ) RETURN NUMBER IS
1382:

Line 1387: l_element_ids JTF_NUMBER_TABLE;

1383: l_set_id number;
1384: l_set_type_id NUMBER;
1385: l_set_access_level VARCHAR2(2000);
1386: l_set_visibility_id NUMBER;
1387: l_element_ids JTF_NUMBER_TABLE;
1388: l_element_type_ids JTF_NUMBER_TABLE;
1389: l_element_dist_ids JTF_VARCHAR2_TABLE_2000;
1390: l_element_content_type_codes JTF_VARCHAR2_TABLE_2000;
1391: l_ele_type_id_upd_tbl JTF_NUMBER_TABLE;

Line 1388: l_element_type_ids JTF_NUMBER_TABLE;

1384: l_set_type_id NUMBER;
1385: l_set_access_level VARCHAR2(2000);
1386: l_set_visibility_id NUMBER;
1387: l_element_ids JTF_NUMBER_TABLE;
1388: l_element_type_ids JTF_NUMBER_TABLE;
1389: l_element_dist_ids JTF_VARCHAR2_TABLE_2000;
1390: l_element_content_type_codes JTF_VARCHAR2_TABLE_2000;
1391: l_ele_type_id_upd_tbl JTF_NUMBER_TABLE;
1392: l_ele_dist_id_upd_tbl JTF_VARCHAR2_TABLE_2000;

Line 1391: l_ele_type_id_upd_tbl JTF_NUMBER_TABLE;

1387: l_element_ids JTF_NUMBER_TABLE;
1388: l_element_type_ids JTF_NUMBER_TABLE;
1389: l_element_dist_ids JTF_VARCHAR2_TABLE_2000;
1390: l_element_content_type_codes JTF_VARCHAR2_TABLE_2000;
1391: l_ele_type_id_upd_tbl JTF_NUMBER_TABLE;
1392: l_ele_dist_id_upd_tbl JTF_VARCHAR2_TABLE_2000;
1393: l_ele_conttype_codes_upd_tbl JTF_VARCHAR2_TABLE_2000;
1394: l_set_product_ids JTF_NUMBER_TABLE;
1395: l_set_platform_ids JTF_NUMBER_TABLE;

Line 1394: l_set_product_ids JTF_NUMBER_TABLE;

1390: l_element_content_type_codes JTF_VARCHAR2_TABLE_2000;
1391: l_ele_type_id_upd_tbl JTF_NUMBER_TABLE;
1392: l_ele_dist_id_upd_tbl JTF_VARCHAR2_TABLE_2000;
1393: l_ele_conttype_codes_upd_tbl JTF_VARCHAR2_TABLE_2000;
1394: l_set_product_ids JTF_NUMBER_TABLE;
1395: l_set_platform_ids JTF_NUMBER_TABLE;
1396: l_set_category_ids JTF_NUMBER_TABLE;
1397: l_set_product_org_ids JTF_NUMBER_TABLE;
1398: l_set_platform_org_ids JTF_NUMBER_TABLE;

Line 1395: l_set_platform_ids JTF_NUMBER_TABLE;

1391: l_ele_type_id_upd_tbl JTF_NUMBER_TABLE;
1392: l_ele_dist_id_upd_tbl JTF_VARCHAR2_TABLE_2000;
1393: l_ele_conttype_codes_upd_tbl JTF_VARCHAR2_TABLE_2000;
1394: l_set_product_ids JTF_NUMBER_TABLE;
1395: l_set_platform_ids JTF_NUMBER_TABLE;
1396: l_set_category_ids JTF_NUMBER_TABLE;
1397: l_set_product_org_ids JTF_NUMBER_TABLE;
1398: l_set_platform_org_ids JTF_NUMBER_TABLE;
1399: l_temp_clob CLOB;

Line 1396: l_set_category_ids JTF_NUMBER_TABLE;

1392: l_ele_dist_id_upd_tbl JTF_VARCHAR2_TABLE_2000;
1393: l_ele_conttype_codes_upd_tbl JTF_VARCHAR2_TABLE_2000;
1394: l_set_product_ids JTF_NUMBER_TABLE;
1395: l_set_platform_ids JTF_NUMBER_TABLE;
1396: l_set_category_ids JTF_NUMBER_TABLE;
1397: l_set_product_org_ids JTF_NUMBER_TABLE;
1398: l_set_platform_org_ids JTF_NUMBER_TABLE;
1399: l_temp_clob CLOB;
1400: l_flow_details_id number := null;

Line 1397: l_set_product_org_ids JTF_NUMBER_TABLE;

1393: l_ele_conttype_codes_upd_tbl JTF_VARCHAR2_TABLE_2000;
1394: l_set_product_ids JTF_NUMBER_TABLE;
1395: l_set_platform_ids JTF_NUMBER_TABLE;
1396: l_set_category_ids JTF_NUMBER_TABLE;
1397: l_set_product_org_ids JTF_NUMBER_TABLE;
1398: l_set_platform_org_ids JTF_NUMBER_TABLE;
1399: l_temp_clob CLOB;
1400: l_flow_details_id number := null;
1401: l_validate_buf VARCHAR2(1000);

Line 1398: l_set_platform_org_ids JTF_NUMBER_TABLE;

1394: l_set_product_ids JTF_NUMBER_TABLE;
1395: l_set_platform_ids JTF_NUMBER_TABLE;
1396: l_set_category_ids JTF_NUMBER_TABLE;
1397: l_set_product_org_ids JTF_NUMBER_TABLE;
1398: l_set_platform_org_ids JTF_NUMBER_TABLE;
1399: l_temp_clob CLOB;
1400: l_flow_details_id number := null;
1401: l_validate_buf VARCHAR2(1000);
1402: l_return_val NUMBER;

Line 1411: x_created_ele_ids_tbl := JTF_NUMBER_TABLE();

1407: BEGIN
1408:
1409: SAVEPOINT Create_Set;
1410:
1411: x_created_ele_ids_tbl := JTF_NUMBER_TABLE();
1412: x_ele_ids_upd_tbl := JTF_NUMBER_TABLE();
1413: l_element_ids := JTF_NUMBER_TABLE();
1414: l_element_type_ids := JTF_NUMBER_TABLE();
1415: l_element_dist_ids := JTF_VARCHAR2_TABLE_2000();

Line 1412: x_ele_ids_upd_tbl := JTF_NUMBER_TABLE();

1408:
1409: SAVEPOINT Create_Set;
1410:
1411: x_created_ele_ids_tbl := JTF_NUMBER_TABLE();
1412: x_ele_ids_upd_tbl := JTF_NUMBER_TABLE();
1413: l_element_ids := JTF_NUMBER_TABLE();
1414: l_element_type_ids := JTF_NUMBER_TABLE();
1415: l_element_dist_ids := JTF_VARCHAR2_TABLE_2000();
1416: l_element_content_type_codes := JTF_VARCHAR2_TABLE_2000();

Line 1413: l_element_ids := JTF_NUMBER_TABLE();

1409: SAVEPOINT Create_Set;
1410:
1411: x_created_ele_ids_tbl := JTF_NUMBER_TABLE();
1412: x_ele_ids_upd_tbl := JTF_NUMBER_TABLE();
1413: l_element_ids := JTF_NUMBER_TABLE();
1414: l_element_type_ids := JTF_NUMBER_TABLE();
1415: l_element_dist_ids := JTF_VARCHAR2_TABLE_2000();
1416: l_element_content_type_codes := JTF_VARCHAR2_TABLE_2000();
1417: l_ele_type_id_upd_tbl := JTF_NUMBER_TABLE();

Line 1414: l_element_type_ids := JTF_NUMBER_TABLE();

1410:
1411: x_created_ele_ids_tbl := JTF_NUMBER_TABLE();
1412: x_ele_ids_upd_tbl := JTF_NUMBER_TABLE();
1413: l_element_ids := JTF_NUMBER_TABLE();
1414: l_element_type_ids := JTF_NUMBER_TABLE();
1415: l_element_dist_ids := JTF_VARCHAR2_TABLE_2000();
1416: l_element_content_type_codes := JTF_VARCHAR2_TABLE_2000();
1417: l_ele_type_id_upd_tbl := JTF_NUMBER_TABLE();
1418: l_ele_dist_id_upd_tbl := JTF_VARCHAR2_TABLE_2000();

Line 1417: l_ele_type_id_upd_tbl := JTF_NUMBER_TABLE();

1413: l_element_ids := JTF_NUMBER_TABLE();
1414: l_element_type_ids := JTF_NUMBER_TABLE();
1415: l_element_dist_ids := JTF_VARCHAR2_TABLE_2000();
1416: l_element_content_type_codes := JTF_VARCHAR2_TABLE_2000();
1417: l_ele_type_id_upd_tbl := JTF_NUMBER_TABLE();
1418: l_ele_dist_id_upd_tbl := JTF_VARCHAR2_TABLE_2000();
1419: l_ele_conttype_codes_upd_tbl := JTF_VARCHAR2_TABLE_2000();
1420: l_set_product_ids := JTF_NUMBER_TABLE();
1421: l_set_platform_ids := JTF_NUMBER_TABLE();

Line 1420: l_set_product_ids := JTF_NUMBER_TABLE();

1416: l_element_content_type_codes := JTF_VARCHAR2_TABLE_2000();
1417: l_ele_type_id_upd_tbl := JTF_NUMBER_TABLE();
1418: l_ele_dist_id_upd_tbl := JTF_VARCHAR2_TABLE_2000();
1419: l_ele_conttype_codes_upd_tbl := JTF_VARCHAR2_TABLE_2000();
1420: l_set_product_ids := JTF_NUMBER_TABLE();
1421: l_set_platform_ids := JTF_NUMBER_TABLE();
1422: l_set_category_ids := JTF_NUMBER_TABLE();
1423: l_set_product_org_ids := JTF_NUMBER_TABLE();
1424: l_set_platform_org_ids := JTF_NUMBER_TABLE();

Line 1421: l_set_platform_ids := JTF_NUMBER_TABLE();

1417: l_ele_type_id_upd_tbl := JTF_NUMBER_TABLE();
1418: l_ele_dist_id_upd_tbl := JTF_VARCHAR2_TABLE_2000();
1419: l_ele_conttype_codes_upd_tbl := JTF_VARCHAR2_TABLE_2000();
1420: l_set_product_ids := JTF_NUMBER_TABLE();
1421: l_set_platform_ids := JTF_NUMBER_TABLE();
1422: l_set_category_ids := JTF_NUMBER_TABLE();
1423: l_set_product_org_ids := JTF_NUMBER_TABLE();
1424: l_set_platform_org_ids := JTF_NUMBER_TABLE();
1425:

Line 1422: l_set_category_ids := JTF_NUMBER_TABLE();

1418: l_ele_dist_id_upd_tbl := JTF_VARCHAR2_TABLE_2000();
1419: l_ele_conttype_codes_upd_tbl := JTF_VARCHAR2_TABLE_2000();
1420: l_set_product_ids := JTF_NUMBER_TABLE();
1421: l_set_platform_ids := JTF_NUMBER_TABLE();
1422: l_set_category_ids := JTF_NUMBER_TABLE();
1423: l_set_product_org_ids := JTF_NUMBER_TABLE();
1424: l_set_platform_org_ids := JTF_NUMBER_TABLE();
1425:
1426: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1423: l_set_product_org_ids := JTF_NUMBER_TABLE();

1419: l_ele_conttype_codes_upd_tbl := JTF_VARCHAR2_TABLE_2000();
1420: l_set_product_ids := JTF_NUMBER_TABLE();
1421: l_set_platform_ids := JTF_NUMBER_TABLE();
1422: l_set_category_ids := JTF_NUMBER_TABLE();
1423: l_set_product_org_ids := JTF_NUMBER_TABLE();
1424: l_set_platform_org_ids := JTF_NUMBER_TABLE();
1425:
1426: x_return_status := FND_API.G_RET_STS_SUCCESS;
1427:

Line 1424: l_set_platform_org_ids := JTF_NUMBER_TABLE();

1420: l_set_product_ids := JTF_NUMBER_TABLE();
1421: l_set_platform_ids := JTF_NUMBER_TABLE();
1422: l_set_category_ids := JTF_NUMBER_TABLE();
1423: l_set_product_org_ids := JTF_NUMBER_TABLE();
1424: l_set_platform_org_ids := JTF_NUMBER_TABLE();
1425:
1426: x_return_status := FND_API.G_RET_STS_SUCCESS;
1427:
1428: -- Validate Set Type Name, get Set Type ID

Line 1653: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,

1649: p_ele_dist_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1650: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1651: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1652: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
1653: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
1654: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
1655: x_set_id OUT NOCOPY number,
1656: p_delim IN VARCHAR2
1657: ) RETURN NUMBER IS

Line 1654: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,

1650: p_ele_content_type_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1651: p_ele_summary_upd_tbl in JTF_VARCHAR2_TABLE_2000,
1652: p_set_category_last_names in JTF_VARCHAR2_TABLE_2000,
1653: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,
1654: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,
1655: x_set_id OUT NOCOPY number,
1656: p_delim IN VARCHAR2
1657: ) RETURN NUMBER IS
1658:

Line 1662: l_element_ids JTF_NUMBER_TABLE;

1658:
1659: l_set_type_id NUMBER;
1660: l_set_access_level VARCHAR2(2000);
1661: l_set_visibility_id NUMBER;
1662: l_element_ids JTF_NUMBER_TABLE;
1663: l_element_type_ids JTF_NUMBER_TABLE;
1664: l_element_dist_ids JTF_VARCHAR2_TABLE_2000;
1665: l_element_content_type_codes JTF_VARCHAR2_TABLE_2000;
1666: l_ele_type_id_upd_tbl JTF_NUMBER_TABLE;

Line 1663: l_element_type_ids JTF_NUMBER_TABLE;

1659: l_set_type_id NUMBER;
1660: l_set_access_level VARCHAR2(2000);
1661: l_set_visibility_id NUMBER;
1662: l_element_ids JTF_NUMBER_TABLE;
1663: l_element_type_ids JTF_NUMBER_TABLE;
1664: l_element_dist_ids JTF_VARCHAR2_TABLE_2000;
1665: l_element_content_type_codes JTF_VARCHAR2_TABLE_2000;
1666: l_ele_type_id_upd_tbl JTF_NUMBER_TABLE;
1667: l_ele_dist_id_upd_tbl JTF_VARCHAR2_TABLE_2000;

Line 1666: l_ele_type_id_upd_tbl JTF_NUMBER_TABLE;

1662: l_element_ids JTF_NUMBER_TABLE;
1663: l_element_type_ids JTF_NUMBER_TABLE;
1664: l_element_dist_ids JTF_VARCHAR2_TABLE_2000;
1665: l_element_content_type_codes JTF_VARCHAR2_TABLE_2000;
1666: l_ele_type_id_upd_tbl JTF_NUMBER_TABLE;
1667: l_ele_dist_id_upd_tbl JTF_VARCHAR2_TABLE_2000;
1668: l_ele_conttype_codes_upd_tbl JTF_VARCHAR2_TABLE_2000;
1669: l_set_product_ids JTF_NUMBER_TABLE;
1670: l_set_platform_ids JTF_NUMBER_TABLE;

Line 1669: l_set_product_ids JTF_NUMBER_TABLE;

1665: l_element_content_type_codes JTF_VARCHAR2_TABLE_2000;
1666: l_ele_type_id_upd_tbl JTF_NUMBER_TABLE;
1667: l_ele_dist_id_upd_tbl JTF_VARCHAR2_TABLE_2000;
1668: l_ele_conttype_codes_upd_tbl JTF_VARCHAR2_TABLE_2000;
1669: l_set_product_ids JTF_NUMBER_TABLE;
1670: l_set_platform_ids JTF_NUMBER_TABLE;
1671: l_set_category_ids JTF_NUMBER_TABLE;
1672: l_set_product_org_ids JTF_NUMBER_TABLE;
1673: l_set_platform_org_ids JTF_NUMBER_TABLE;

Line 1670: l_set_platform_ids JTF_NUMBER_TABLE;

1666: l_ele_type_id_upd_tbl JTF_NUMBER_TABLE;
1667: l_ele_dist_id_upd_tbl JTF_VARCHAR2_TABLE_2000;
1668: l_ele_conttype_codes_upd_tbl JTF_VARCHAR2_TABLE_2000;
1669: l_set_product_ids JTF_NUMBER_TABLE;
1670: l_set_platform_ids JTF_NUMBER_TABLE;
1671: l_set_category_ids JTF_NUMBER_TABLE;
1672: l_set_product_org_ids JTF_NUMBER_TABLE;
1673: l_set_platform_org_ids JTF_NUMBER_TABLE;
1674: l_temp_clob CLOB;

Line 1671: l_set_category_ids JTF_NUMBER_TABLE;

1667: l_ele_dist_id_upd_tbl JTF_VARCHAR2_TABLE_2000;
1668: l_ele_conttype_codes_upd_tbl JTF_VARCHAR2_TABLE_2000;
1669: l_set_product_ids JTF_NUMBER_TABLE;
1670: l_set_platform_ids JTF_NUMBER_TABLE;
1671: l_set_category_ids JTF_NUMBER_TABLE;
1672: l_set_product_org_ids JTF_NUMBER_TABLE;
1673: l_set_platform_org_ids JTF_NUMBER_TABLE;
1674: l_temp_clob CLOB;
1675: l_validate_buf VARCHAR2(1000);

Line 1672: l_set_product_org_ids JTF_NUMBER_TABLE;

1668: l_ele_conttype_codes_upd_tbl JTF_VARCHAR2_TABLE_2000;
1669: l_set_product_ids JTF_NUMBER_TABLE;
1670: l_set_platform_ids JTF_NUMBER_TABLE;
1671: l_set_category_ids JTF_NUMBER_TABLE;
1672: l_set_product_org_ids JTF_NUMBER_TABLE;
1673: l_set_platform_org_ids JTF_NUMBER_TABLE;
1674: l_temp_clob CLOB;
1675: l_validate_buf VARCHAR2(1000);
1676: l_return_val NUMBER;

Line 1673: l_set_platform_org_ids JTF_NUMBER_TABLE;

1669: l_set_product_ids JTF_NUMBER_TABLE;
1670: l_set_platform_ids JTF_NUMBER_TABLE;
1671: l_set_category_ids JTF_NUMBER_TABLE;
1672: l_set_product_org_ids JTF_NUMBER_TABLE;
1673: l_set_platform_org_ids JTF_NUMBER_TABLE;
1674: l_temp_clob CLOB;
1675: l_validate_buf VARCHAR2(1000);
1676: l_return_val NUMBER;
1677: l_return_status VARCHAR2(1);

Line 1682: l_old_set_product_ids JTF_NUMBER_TABLE;

1678: l_msg_data VARCHAR2(2000);
1679: l_msg_count NUMBER;
1680:
1681: -- old IDs to delete
1682: l_old_set_product_ids JTF_NUMBER_TABLE;
1683: l_old_set_platform_ids JTF_NUMBER_TABLE;
1684: l_old_set_product_org_ids JTF_NUMBER_TABLE;
1685: l_old_set_platform_org_ids JTF_NUMBER_TABLE;
1686: counter number := 1;

Line 1683: l_old_set_platform_ids JTF_NUMBER_TABLE;

1679: l_msg_count NUMBER;
1680:
1681: -- old IDs to delete
1682: l_old_set_product_ids JTF_NUMBER_TABLE;
1683: l_old_set_platform_ids JTF_NUMBER_TABLE;
1684: l_old_set_product_org_ids JTF_NUMBER_TABLE;
1685: l_old_set_platform_org_ids JTF_NUMBER_TABLE;
1686: counter number := 1;
1687:

Line 1684: l_old_set_product_org_ids JTF_NUMBER_TABLE;

1680:
1681: -- old IDs to delete
1682: l_old_set_product_ids JTF_NUMBER_TABLE;
1683: l_old_set_platform_ids JTF_NUMBER_TABLE;
1684: l_old_set_product_org_ids JTF_NUMBER_TABLE;
1685: l_old_set_platform_org_ids JTF_NUMBER_TABLE;
1686: counter number := 1;
1687:
1688: cursor element_ids_cur (p_set_id IN NUMBER) IS

Line 1685: l_old_set_platform_org_ids JTF_NUMBER_TABLE;

1681: -- old IDs to delete
1682: l_old_set_product_ids JTF_NUMBER_TABLE;
1683: l_old_set_platform_ids JTF_NUMBER_TABLE;
1684: l_old_set_product_org_ids JTF_NUMBER_TABLE;
1685: l_old_set_platform_org_ids JTF_NUMBER_TABLE;
1686: counter number := 1;
1687:
1688: cursor element_ids_cur (p_set_id IN NUMBER) IS
1689: select element_id

Line 1713: x_created_ele_ids_tbl := JTF_NUMBER_TABLE();

1709: BEGIN
1710: -- dbms_output.put_line('Update Set with Validation - BEGIN');
1711: SAVEPOINT Update_Set;
1712:
1713: x_created_ele_ids_tbl := JTF_NUMBER_TABLE();
1714: l_element_ids := JTF_NUMBER_TABLE();
1715: l_element_type_ids := JTF_NUMBER_TABLE();
1716: l_element_dist_ids := JTF_VARCHAR2_TABLE_2000();
1717: l_element_content_type_codes := JTF_VARCHAR2_TABLE_2000();

Line 1714: l_element_ids := JTF_NUMBER_TABLE();

1710: -- dbms_output.put_line('Update Set with Validation - BEGIN');
1711: SAVEPOINT Update_Set;
1712:
1713: x_created_ele_ids_tbl := JTF_NUMBER_TABLE();
1714: l_element_ids := JTF_NUMBER_TABLE();
1715: l_element_type_ids := JTF_NUMBER_TABLE();
1716: l_element_dist_ids := JTF_VARCHAR2_TABLE_2000();
1717: l_element_content_type_codes := JTF_VARCHAR2_TABLE_2000();
1718: l_ele_type_id_upd_tbl := JTF_NUMBER_TABLE();

Line 1715: l_element_type_ids := JTF_NUMBER_TABLE();

1711: SAVEPOINT Update_Set;
1712:
1713: x_created_ele_ids_tbl := JTF_NUMBER_TABLE();
1714: l_element_ids := JTF_NUMBER_TABLE();
1715: l_element_type_ids := JTF_NUMBER_TABLE();
1716: l_element_dist_ids := JTF_VARCHAR2_TABLE_2000();
1717: l_element_content_type_codes := JTF_VARCHAR2_TABLE_2000();
1718: l_ele_type_id_upd_tbl := JTF_NUMBER_TABLE();
1719: l_ele_dist_id_upd_tbl := JTF_VARCHAR2_TABLE_2000();

Line 1718: l_ele_type_id_upd_tbl := JTF_NUMBER_TABLE();

1714: l_element_ids := JTF_NUMBER_TABLE();
1715: l_element_type_ids := JTF_NUMBER_TABLE();
1716: l_element_dist_ids := JTF_VARCHAR2_TABLE_2000();
1717: l_element_content_type_codes := JTF_VARCHAR2_TABLE_2000();
1718: l_ele_type_id_upd_tbl := JTF_NUMBER_TABLE();
1719: l_ele_dist_id_upd_tbl := JTF_VARCHAR2_TABLE_2000();
1720: x_ele_ids_upd_tbl := JTF_NUMBER_TABLE();
1721: l_ele_conttype_codes_upd_tbl := JTF_VARCHAR2_TABLE_2000();
1722: l_set_product_ids := JTF_NUMBER_TABLE();

Line 1720: x_ele_ids_upd_tbl := JTF_NUMBER_TABLE();

1716: l_element_dist_ids := JTF_VARCHAR2_TABLE_2000();
1717: l_element_content_type_codes := JTF_VARCHAR2_TABLE_2000();
1718: l_ele_type_id_upd_tbl := JTF_NUMBER_TABLE();
1719: l_ele_dist_id_upd_tbl := JTF_VARCHAR2_TABLE_2000();
1720: x_ele_ids_upd_tbl := JTF_NUMBER_TABLE();
1721: l_ele_conttype_codes_upd_tbl := JTF_VARCHAR2_TABLE_2000();
1722: l_set_product_ids := JTF_NUMBER_TABLE();
1723: l_set_platform_ids := JTF_NUMBER_TABLE();
1724: l_set_category_ids := JTF_NUMBER_TABLE();

Line 1722: l_set_product_ids := JTF_NUMBER_TABLE();

1718: l_ele_type_id_upd_tbl := JTF_NUMBER_TABLE();
1719: l_ele_dist_id_upd_tbl := JTF_VARCHAR2_TABLE_2000();
1720: x_ele_ids_upd_tbl := JTF_NUMBER_TABLE();
1721: l_ele_conttype_codes_upd_tbl := JTF_VARCHAR2_TABLE_2000();
1722: l_set_product_ids := JTF_NUMBER_TABLE();
1723: l_set_platform_ids := JTF_NUMBER_TABLE();
1724: l_set_category_ids := JTF_NUMBER_TABLE();
1725: l_set_product_org_ids := JTF_NUMBER_TABLE();
1726: l_set_platform_org_ids := JTF_NUMBER_TABLE();

Line 1723: l_set_platform_ids := JTF_NUMBER_TABLE();

1719: l_ele_dist_id_upd_tbl := JTF_VARCHAR2_TABLE_2000();
1720: x_ele_ids_upd_tbl := JTF_NUMBER_TABLE();
1721: l_ele_conttype_codes_upd_tbl := JTF_VARCHAR2_TABLE_2000();
1722: l_set_product_ids := JTF_NUMBER_TABLE();
1723: l_set_platform_ids := JTF_NUMBER_TABLE();
1724: l_set_category_ids := JTF_NUMBER_TABLE();
1725: l_set_product_org_ids := JTF_NUMBER_TABLE();
1726: l_set_platform_org_ids := JTF_NUMBER_TABLE();
1727:

Line 1724: l_set_category_ids := JTF_NUMBER_TABLE();

1720: x_ele_ids_upd_tbl := JTF_NUMBER_TABLE();
1721: l_ele_conttype_codes_upd_tbl := JTF_VARCHAR2_TABLE_2000();
1722: l_set_product_ids := JTF_NUMBER_TABLE();
1723: l_set_platform_ids := JTF_NUMBER_TABLE();
1724: l_set_category_ids := JTF_NUMBER_TABLE();
1725: l_set_product_org_ids := JTF_NUMBER_TABLE();
1726: l_set_platform_org_ids := JTF_NUMBER_TABLE();
1727:
1728: l_old_set_product_ids := JTF_NUMBER_TABLE();

Line 1725: l_set_product_org_ids := JTF_NUMBER_TABLE();

1721: l_ele_conttype_codes_upd_tbl := JTF_VARCHAR2_TABLE_2000();
1722: l_set_product_ids := JTF_NUMBER_TABLE();
1723: l_set_platform_ids := JTF_NUMBER_TABLE();
1724: l_set_category_ids := JTF_NUMBER_TABLE();
1725: l_set_product_org_ids := JTF_NUMBER_TABLE();
1726: l_set_platform_org_ids := JTF_NUMBER_TABLE();
1727:
1728: l_old_set_product_ids := JTF_NUMBER_TABLE();
1729: l_old_set_platform_ids := JTF_NUMBER_TABLE();

Line 1726: l_set_platform_org_ids := JTF_NUMBER_TABLE();

1722: l_set_product_ids := JTF_NUMBER_TABLE();
1723: l_set_platform_ids := JTF_NUMBER_TABLE();
1724: l_set_category_ids := JTF_NUMBER_TABLE();
1725: l_set_product_org_ids := JTF_NUMBER_TABLE();
1726: l_set_platform_org_ids := JTF_NUMBER_TABLE();
1727:
1728: l_old_set_product_ids := JTF_NUMBER_TABLE();
1729: l_old_set_platform_ids := JTF_NUMBER_TABLE();
1730: l_old_set_product_org_ids := JTF_NUMBER_TABLE();

Line 1728: l_old_set_product_ids := JTF_NUMBER_TABLE();

1724: l_set_category_ids := JTF_NUMBER_TABLE();
1725: l_set_product_org_ids := JTF_NUMBER_TABLE();
1726: l_set_platform_org_ids := JTF_NUMBER_TABLE();
1727:
1728: l_old_set_product_ids := JTF_NUMBER_TABLE();
1729: l_old_set_platform_ids := JTF_NUMBER_TABLE();
1730: l_old_set_product_org_ids := JTF_NUMBER_TABLE();
1731: l_old_set_platform_org_ids := JTF_NUMBER_TABLE();
1732:

Line 1729: l_old_set_platform_ids := JTF_NUMBER_TABLE();

1725: l_set_product_org_ids := JTF_NUMBER_TABLE();
1726: l_set_platform_org_ids := JTF_NUMBER_TABLE();
1727:
1728: l_old_set_product_ids := JTF_NUMBER_TABLE();
1729: l_old_set_platform_ids := JTF_NUMBER_TABLE();
1730: l_old_set_product_org_ids := JTF_NUMBER_TABLE();
1731: l_old_set_platform_org_ids := JTF_NUMBER_TABLE();
1732:
1733: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1730: l_old_set_product_org_ids := JTF_NUMBER_TABLE();

1726: l_set_platform_org_ids := JTF_NUMBER_TABLE();
1727:
1728: l_old_set_product_ids := JTF_NUMBER_TABLE();
1729: l_old_set_platform_ids := JTF_NUMBER_TABLE();
1730: l_old_set_product_org_ids := JTF_NUMBER_TABLE();
1731: l_old_set_platform_org_ids := JTF_NUMBER_TABLE();
1732:
1733: x_return_status := FND_API.G_RET_STS_SUCCESS;
1734:

Line 1731: l_old_set_platform_org_ids := JTF_NUMBER_TABLE();

1727:
1728: l_old_set_product_ids := JTF_NUMBER_TABLE();
1729: l_old_set_platform_ids := JTF_NUMBER_TABLE();
1730: l_old_set_product_org_ids := JTF_NUMBER_TABLE();
1731: l_old_set_platform_org_ids := JTF_NUMBER_TABLE();
1732:
1733: x_return_status := FND_API.G_RET_STS_SUCCESS;
1734:
1735: -- dbms_output.put_line('Validate Set number');

Line 2031: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,

2027: p_element_type_names IN JTF_VARCHAR2_TABLE_2000,
2028: p_ele_content_types IN JTF_VARCHAR2_TABLE_2000,
2029: p_ele_dist_names IN JTF_VARCHAR2_TABLE_2000,
2030: x_visibility_id OUT NOCOPY NUMBER,
2031: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
2032: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
2033: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
2034: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
2035: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,

Line 2032: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,

2028: p_ele_content_types IN JTF_VARCHAR2_TABLE_2000,
2029: p_ele_dist_names IN JTF_VARCHAR2_TABLE_2000,
2030: x_visibility_id OUT NOCOPY NUMBER,
2031: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
2032: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
2033: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
2034: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
2035: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
2036: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,

Line 2033: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,

2029: p_ele_dist_names IN JTF_VARCHAR2_TABLE_2000,
2030: x_visibility_id OUT NOCOPY NUMBER,
2031: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
2032: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
2033: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
2034: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
2035: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
2036: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
2037: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,

Line 2034: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,

2030: x_visibility_id OUT NOCOPY NUMBER,
2031: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
2032: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
2033: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
2034: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
2035: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
2036: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
2037: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
2038: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,

Line 2035: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,

2031: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,
2032: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
2033: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
2034: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
2035: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
2036: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
2037: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
2038: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
2039: x_ele_upd_type_ids OUT NOCOPY JTF_NUMBER_TABLE,

Line 2036: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,

2032: x_platform_numbers OUT NOCOPY JTF_NUMBER_TABLE,
2033: x_category_numbers OUT NOCOPY JTF_NUMBER_TABLE,
2034: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,
2035: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
2036: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
2037: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
2038: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
2039: x_ele_upd_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
2040: x_ele_upd_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,

Line 2039: x_ele_upd_type_ids OUT NOCOPY JTF_NUMBER_TABLE,

2035: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,
2036: x_element_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
2037: x_ele_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
2038: x_ele_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
2039: x_ele_upd_type_ids OUT NOCOPY JTF_NUMBER_TABLE,
2040: x_ele_upd_dist_ids OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
2041: x_ele_upd_content_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
2042: x_return_status OUT NOCOPY varchar2,
2043: x_msg_count OUT NOCOPY number,

Line 2052: l_product_numbers JTF_NUMBER_TABLE;

2048: l_validate_buf VARCHAR2(1000);
2049: l_return_val NUMBER;
2050: l_return_status VARCHAR2(1);
2051: l_dup_found VARCHAR2(1);
2052: l_product_numbers JTF_NUMBER_TABLE;
2053: l_platform_numbers JTF_NUMBER_TABLE;
2054: BEGIN
2055:
2056: x_element_type_ids := JTF_NUMBER_TABLE();

Line 2053: l_platform_numbers JTF_NUMBER_TABLE;

2049: l_return_val NUMBER;
2050: l_return_status VARCHAR2(1);
2051: l_dup_found VARCHAR2(1);
2052: l_product_numbers JTF_NUMBER_TABLE;
2053: l_platform_numbers JTF_NUMBER_TABLE;
2054: BEGIN
2055:
2056: x_element_type_ids := JTF_NUMBER_TABLE();
2057: x_product_numbers := JTF_NUMBER_TABLE();

Line 2056: x_element_type_ids := JTF_NUMBER_TABLE();

2052: l_product_numbers JTF_NUMBER_TABLE;
2053: l_platform_numbers JTF_NUMBER_TABLE;
2054: BEGIN
2055:
2056: x_element_type_ids := JTF_NUMBER_TABLE();
2057: x_product_numbers := JTF_NUMBER_TABLE();
2058: l_product_numbers := JTF_NUMBER_TABLE();
2059: x_platform_numbers := JTF_NUMBER_TABLE();
2060: l_platform_numbers := JTF_NUMBER_TABLE();

Line 2057: x_product_numbers := JTF_NUMBER_TABLE();

2053: l_platform_numbers JTF_NUMBER_TABLE;
2054: BEGIN
2055:
2056: x_element_type_ids := JTF_NUMBER_TABLE();
2057: x_product_numbers := JTF_NUMBER_TABLE();
2058: l_product_numbers := JTF_NUMBER_TABLE();
2059: x_platform_numbers := JTF_NUMBER_TABLE();
2060: l_platform_numbers := JTF_NUMBER_TABLE();
2061: x_category_numbers := JTF_NUMBER_TABLE();

Line 2058: l_product_numbers := JTF_NUMBER_TABLE();

2054: BEGIN
2055:
2056: x_element_type_ids := JTF_NUMBER_TABLE();
2057: x_product_numbers := JTF_NUMBER_TABLE();
2058: l_product_numbers := JTF_NUMBER_TABLE();
2059: x_platform_numbers := JTF_NUMBER_TABLE();
2060: l_platform_numbers := JTF_NUMBER_TABLE();
2061: x_category_numbers := JTF_NUMBER_TABLE();
2062: x_ele_ids := JTF_NUMBER_TABLE();

Line 2059: x_platform_numbers := JTF_NUMBER_TABLE();

2055:
2056: x_element_type_ids := JTF_NUMBER_TABLE();
2057: x_product_numbers := JTF_NUMBER_TABLE();
2058: l_product_numbers := JTF_NUMBER_TABLE();
2059: x_platform_numbers := JTF_NUMBER_TABLE();
2060: l_platform_numbers := JTF_NUMBER_TABLE();
2061: x_category_numbers := JTF_NUMBER_TABLE();
2062: x_ele_ids := JTF_NUMBER_TABLE();
2063: x_ele_upd_ids := JTF_NUMBER_TABLE();

Line 2060: l_platform_numbers := JTF_NUMBER_TABLE();

2056: x_element_type_ids := JTF_NUMBER_TABLE();
2057: x_product_numbers := JTF_NUMBER_TABLE();
2058: l_product_numbers := JTF_NUMBER_TABLE();
2059: x_platform_numbers := JTF_NUMBER_TABLE();
2060: l_platform_numbers := JTF_NUMBER_TABLE();
2061: x_category_numbers := JTF_NUMBER_TABLE();
2062: x_ele_ids := JTF_NUMBER_TABLE();
2063: x_ele_upd_ids := JTF_NUMBER_TABLE();
2064: x_element_type_ids := JTF_NUMBER_TABLE();

Line 2061: x_category_numbers := JTF_NUMBER_TABLE();

2057: x_product_numbers := JTF_NUMBER_TABLE();
2058: l_product_numbers := JTF_NUMBER_TABLE();
2059: x_platform_numbers := JTF_NUMBER_TABLE();
2060: l_platform_numbers := JTF_NUMBER_TABLE();
2061: x_category_numbers := JTF_NUMBER_TABLE();
2062: x_ele_ids := JTF_NUMBER_TABLE();
2063: x_ele_upd_ids := JTF_NUMBER_TABLE();
2064: x_element_type_ids := JTF_NUMBER_TABLE();
2065: x_ele_dist_ids := JTF_VARCHAR2_TABLE_2000();

Line 2062: x_ele_ids := JTF_NUMBER_TABLE();

2058: l_product_numbers := JTF_NUMBER_TABLE();
2059: x_platform_numbers := JTF_NUMBER_TABLE();
2060: l_platform_numbers := JTF_NUMBER_TABLE();
2061: x_category_numbers := JTF_NUMBER_TABLE();
2062: x_ele_ids := JTF_NUMBER_TABLE();
2063: x_ele_upd_ids := JTF_NUMBER_TABLE();
2064: x_element_type_ids := JTF_NUMBER_TABLE();
2065: x_ele_dist_ids := JTF_VARCHAR2_TABLE_2000();
2066: x_ele_content_type_codes := JTF_VARCHAR2_TABLE_2000();

Line 2063: x_ele_upd_ids := JTF_NUMBER_TABLE();

2059: x_platform_numbers := JTF_NUMBER_TABLE();
2060: l_platform_numbers := JTF_NUMBER_TABLE();
2061: x_category_numbers := JTF_NUMBER_TABLE();
2062: x_ele_ids := JTF_NUMBER_TABLE();
2063: x_ele_upd_ids := JTF_NUMBER_TABLE();
2064: x_element_type_ids := JTF_NUMBER_TABLE();
2065: x_ele_dist_ids := JTF_VARCHAR2_TABLE_2000();
2066: x_ele_content_type_codes := JTF_VARCHAR2_TABLE_2000();
2067: x_ele_upd_type_ids := JTF_NUMBER_TABLE();

Line 2064: x_element_type_ids := JTF_NUMBER_TABLE();

2060: l_platform_numbers := JTF_NUMBER_TABLE();
2061: x_category_numbers := JTF_NUMBER_TABLE();
2062: x_ele_ids := JTF_NUMBER_TABLE();
2063: x_ele_upd_ids := JTF_NUMBER_TABLE();
2064: x_element_type_ids := JTF_NUMBER_TABLE();
2065: x_ele_dist_ids := JTF_VARCHAR2_TABLE_2000();
2066: x_ele_content_type_codes := JTF_VARCHAR2_TABLE_2000();
2067: x_ele_upd_type_ids := JTF_NUMBER_TABLE();
2068: x_ele_upd_dist_ids := JTF_VARCHAR2_TABLE_2000();

Line 2067: x_ele_upd_type_ids := JTF_NUMBER_TABLE();

2063: x_ele_upd_ids := JTF_NUMBER_TABLE();
2064: x_element_type_ids := JTF_NUMBER_TABLE();
2065: x_ele_dist_ids := JTF_VARCHAR2_TABLE_2000();
2066: x_ele_content_type_codes := JTF_VARCHAR2_TABLE_2000();
2067: x_ele_upd_type_ids := JTF_NUMBER_TABLE();
2068: x_ele_upd_dist_ids := JTF_VARCHAR2_TABLE_2000();
2069: x_ele_upd_content_type_codes := JTF_VARCHAR2_TABLE_2000();
2070:
2071: -- Validate Solution Visibility Level Name, get ID

Line 2384: p_given_element_ids IN JTF_NUMBER_TABLE,

2380: FUNCTION Link_Soln_Attributes
2381: (
2382: p_validate_type IN VARCHAR2,
2383: p_set_id IN NUMBER,
2384: p_given_element_ids IN JTF_NUMBER_TABLE,
2385: p_given_ele_nums in JTF_VARCHAR2_TABLE_2000,
2386: p_given_ele_type_ids in JTF_NUMBER_TABLE,
2387: p_given_ele_dist_ids in JTF_VARCHAR2_TABLE_2000,
2388: p_given_ele_content_types in JTF_VARCHAR2_TABLE_2000,

Line 2386: p_given_ele_type_ids in JTF_NUMBER_TABLE,

2382: p_validate_type IN VARCHAR2,
2383: p_set_id IN NUMBER,
2384: p_given_element_ids IN JTF_NUMBER_TABLE,
2385: p_given_ele_nums in JTF_VARCHAR2_TABLE_2000,
2386: p_given_ele_type_ids in JTF_NUMBER_TABLE,
2387: p_given_ele_dist_ids in JTF_VARCHAR2_TABLE_2000,
2388: p_given_ele_content_types in JTF_VARCHAR2_TABLE_2000,
2389: p_given_ele_summaryies in JTF_VARCHAR2_TABLE_2000,
2390: p_element_ids IN JTF_NUMBER_TABLE,

Line 2390: p_element_ids IN JTF_NUMBER_TABLE,

2386: p_given_ele_type_ids in JTF_NUMBER_TABLE,
2387: p_given_ele_dist_ids in JTF_VARCHAR2_TABLE_2000,
2388: p_given_ele_content_types in JTF_VARCHAR2_TABLE_2000,
2389: p_given_ele_summaryies in JTF_VARCHAR2_TABLE_2000,
2390: p_element_ids IN JTF_NUMBER_TABLE,
2391: p_element_type_ids IN JTF_NUMBER_TABLE,
2392: p_element_dist_ids IN JTF_VARCHAR2_TABLE_2000,
2393: p_element_content_types IN JTF_VARCHAR2_TABLE_2000,
2394: p_element_summaries IN JTF_VARCHAR2_TABLE_2000,

Line 2391: p_element_type_ids IN JTF_NUMBER_TABLE,

2387: p_given_ele_dist_ids in JTF_VARCHAR2_TABLE_2000,
2388: p_given_ele_content_types in JTF_VARCHAR2_TABLE_2000,
2389: p_given_ele_summaryies in JTF_VARCHAR2_TABLE_2000,
2390: p_element_ids IN JTF_NUMBER_TABLE,
2391: p_element_type_ids IN JTF_NUMBER_TABLE,
2392: p_element_dist_ids IN JTF_VARCHAR2_TABLE_2000,
2393: p_element_content_types IN JTF_VARCHAR2_TABLE_2000,
2394: p_element_summaries IN JTF_VARCHAR2_TABLE_2000,
2395: p_element_dummy_detail IN CLOB,

Line 2396: p_set_product_ids IN JTF_NUMBER_TABLE,

2392: p_element_dist_ids IN JTF_VARCHAR2_TABLE_2000,
2393: p_element_content_types IN JTF_VARCHAR2_TABLE_2000,
2394: p_element_summaries IN JTF_VARCHAR2_TABLE_2000,
2395: p_element_dummy_detail IN CLOB,
2396: p_set_product_ids IN JTF_NUMBER_TABLE,
2397: p_set_platform_ids IN JTF_NUMBER_TABLE,
2398: p_set_category_ids IN JTF_NUMBER_TABLE,
2399: x_created_element_ids OUT NOCOPY JTF_NUMBER_TABLE,
2400: x_return_status OUT NOCOPY varchar2,

Line 2397: p_set_platform_ids IN JTF_NUMBER_TABLE,

2393: p_element_content_types IN JTF_VARCHAR2_TABLE_2000,
2394: p_element_summaries IN JTF_VARCHAR2_TABLE_2000,
2395: p_element_dummy_detail IN CLOB,
2396: p_set_product_ids IN JTF_NUMBER_TABLE,
2397: p_set_platform_ids IN JTF_NUMBER_TABLE,
2398: p_set_category_ids IN JTF_NUMBER_TABLE,
2399: x_created_element_ids OUT NOCOPY JTF_NUMBER_TABLE,
2400: x_return_status OUT NOCOPY varchar2,
2401: x_msg_count OUT NOCOPY number,

Line 2398: p_set_category_ids IN JTF_NUMBER_TABLE,

2394: p_element_summaries IN JTF_VARCHAR2_TABLE_2000,
2395: p_element_dummy_detail IN CLOB,
2396: p_set_product_ids IN JTF_NUMBER_TABLE,
2397: p_set_platform_ids IN JTF_NUMBER_TABLE,
2398: p_set_category_ids IN JTF_NUMBER_TABLE,
2399: x_created_element_ids OUT NOCOPY JTF_NUMBER_TABLE,
2400: x_return_status OUT NOCOPY varchar2,
2401: x_msg_count OUT NOCOPY number,
2402: x_msg_data OUT NOCOPY varchar2

Line 2399: x_created_element_ids OUT NOCOPY JTF_NUMBER_TABLE,

2395: p_element_dummy_detail IN CLOB,
2396: p_set_product_ids IN JTF_NUMBER_TABLE,
2397: p_set_platform_ids IN JTF_NUMBER_TABLE,
2398: p_set_category_ids IN JTF_NUMBER_TABLE,
2399: x_created_element_ids OUT NOCOPY JTF_NUMBER_TABLE,
2400: x_return_status OUT NOCOPY varchar2,
2401: x_msg_count OUT NOCOPY number,
2402: x_msg_data OUT NOCOPY varchar2
2403: ) RETURN NUMBER IS

Line 2405: l_set_product_org_ids JTF_NUMBER_TABLE;

2401: x_msg_count OUT NOCOPY number,
2402: x_msg_data OUT NOCOPY varchar2
2403: ) RETURN NUMBER IS
2404: l_temp_element_no VARCHAR2(30);
2405: l_set_product_org_ids JTF_NUMBER_TABLE;
2406: l_set_platform_org_ids JTF_NUMBER_TABLE;
2407: l_temp_category_link_id number;
2408: l_temp_update_return number;
2409: l_elmt_status VARCHAR2(30);

Line 2406: l_set_platform_org_ids JTF_NUMBER_TABLE;

2402: x_msg_data OUT NOCOPY varchar2
2403: ) RETURN NUMBER IS
2404: l_temp_element_no VARCHAR2(30);
2405: l_set_product_org_ids JTF_NUMBER_TABLE;
2406: l_set_platform_org_ids JTF_NUMBER_TABLE;
2407: l_temp_category_link_id number;
2408: l_temp_update_return number;
2409: l_elmt_status VARCHAR2(30);
2410:

Line 2415: l_set_product_org_ids := JTF_NUMBER_TABLE();

2411: l_validate_buf VARCHAR2(1000);
2412: l_return_val NUMBER;
2413: BEGIN
2414:
2415: l_set_product_org_ids := JTF_NUMBER_TABLE();
2416: l_set_platform_org_ids := JTF_NUMBER_TABLE();
2417:
2418: IF (p_validate_type = 'UPDATE') THEN
2419: l_elmt_status := 'PUBLISHED';

Line 2416: l_set_platform_org_ids := JTF_NUMBER_TABLE();

2412: l_return_val NUMBER;
2413: BEGIN
2414:
2415: l_set_product_org_ids := JTF_NUMBER_TABLE();
2416: l_set_platform_org_ids := JTF_NUMBER_TABLE();
2417:
2418: IF (p_validate_type = 'UPDATE') THEN
2419: l_elmt_status := 'PUBLISHED';
2420: ELSE

Line 2426: x_created_element_ids := JTF_NUMBER_TABLE();

2422: END IF;
2423:
2424:
2425: -- Creating new elements
2426: x_created_element_ids := JTF_NUMBER_TABLE();
2427: x_created_element_ids.extend(p_element_type_ids.count);
2428: for i in 1..p_element_type_ids.count loop
2429: x_created_element_ids(i) := CS_KB_ELEMENTS_AUDIT_PKG.Create_Element_CLOB(
2430: p_element_type_id => p_element_type_ids(i),

Line 2798: p_element_type_ids IN JTF_NUMBER_TABLE

2794:
2795: FUNCTION Validate_Set_Element_Type_Ids
2796: (
2797: p_set_type_id IN NUMBER,
2798: p_element_type_ids IN JTF_NUMBER_TABLE
2799:
2800: ) RETURN NUMBER IS
2801:
2802: Type element_type_id_tab_type is