DBA Data[Home] [Help]

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 912: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,

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

Line 913: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,

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:

Line 978: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,

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

Line 979: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,

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;

Line 1068: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,

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

Line 1069: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,

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(

Line 1134: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,

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

Line 1135: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,

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;

Line 1213: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,

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,

Line 1214: x_platform_numbers 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,

Line 1215: x_category_numbers 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,

Line 1216: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,

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,

Line 1217: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,

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,

Line 1218: x_element_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,

Line 1221: x_ele_upd_type_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,
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,

Line 1280: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,

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,

Line 1281: x_platform_numbers 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,

Line 1282: x_category_numbers 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,

Line 1283: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,

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,

Line 1284: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,

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,

Line 1285: x_element_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,

Line 1288: x_ele_upd_type_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,
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,

Line 1368: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,

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

Line 1369: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,

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:

Line 1378: l_element_ids JTF_NUMBER_TABLE;

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;

Line 1379: l_element_type_ids 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;

Line 1382: l_ele_type_id_upd_tbl JTF_NUMBER_TABLE;

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;

Line 1385: l_set_product_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;

Line 1386: l_set_platform_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;

Line 1387: l_set_category_ids 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;
1391: l_flow_details_id number := null;

Line 1388: l_set_product_org_ids JTF_NUMBER_TABLE;

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);

Line 1389: l_set_platform_org_ids JTF_NUMBER_TABLE;

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;

Line 1402: x_created_ele_ids_tbl := JTF_NUMBER_TABLE();

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();

Line 1403: x_ele_ids_upd_tbl := JTF_NUMBER_TABLE();

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();

Line 1404: l_element_ids := JTF_NUMBER_TABLE();

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();

Line 1405: l_element_type_ids := 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();

Line 1408: l_ele_type_id_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();
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();

Line 1411: l_set_product_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();

Line 1412: l_set_platform_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:

Line 1413: l_set_category_ids := 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:
1417: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1414: l_set_product_org_ids := JTF_NUMBER_TABLE();

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:

Line 1415: l_set_platform_org_ids := JTF_NUMBER_TABLE();

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

Line 1644: x_created_ele_ids_tbl OUT NOCOPY JTF_NUMBER_TABLE,

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

Line 1645: x_ele_ids_upd_tbl OUT NOCOPY JTF_NUMBER_TABLE,

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:

Line 1653: l_element_ids JTF_NUMBER_TABLE;

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;

Line 1654: l_element_type_ids 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;

Line 1657: l_ele_type_id_upd_tbl JTF_NUMBER_TABLE;

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;

Line 1660: l_set_product_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;

Line 1661: l_set_platform_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;

Line 1662: l_set_category_ids 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;
1666: l_validate_buf VARCHAR2(1000);

Line 1663: l_set_product_org_ids JTF_NUMBER_TABLE;

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;

Line 1664: l_set_platform_org_ids JTF_NUMBER_TABLE;

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);

Line 1673: l_old_set_product_ids JTF_NUMBER_TABLE;

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;

Line 1674: l_old_set_platform_ids JTF_NUMBER_TABLE;

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:

Line 1675: l_old_set_product_org_ids JTF_NUMBER_TABLE;

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

Line 1676: l_old_set_platform_org_ids JTF_NUMBER_TABLE;

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

Line 1704: x_created_ele_ids_tbl := JTF_NUMBER_TABLE();

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();

Line 1705: l_element_ids := JTF_NUMBER_TABLE();

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();

Line 1706: l_element_type_ids := 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();

Line 1709: l_ele_type_id_upd_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();
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();

Line 1711: x_ele_ids_upd_tbl := 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();

Line 1713: l_set_product_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();

Line 1714: l_set_platform_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:

Line 1715: l_set_category_ids := JTF_NUMBER_TABLE();

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();

Line 1716: l_set_product_org_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();

Line 1717: l_set_platform_org_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();

Line 1719: l_old_set_product_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:

Line 1720: l_old_set_platform_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:
1724: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1721: l_old_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;
1725:

Line 1722: l_old_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:
1726: -- dbms_output.put_line('Validate Set number');

Line 2021: x_product_numbers OUT NOCOPY JTF_NUMBER_TABLE,

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,

Line 2022: x_platform_numbers 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,

Line 2023: x_category_numbers 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,

Line 2024: x_ele_ids OUT NOCOPY JTF_NUMBER_TABLE,

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,

Line 2025: x_ele_upd_ids OUT NOCOPY JTF_NUMBER_TABLE,

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,

Line 2026: x_element_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,

Line 2029: x_ele_upd_type_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,
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,

Line 2042: l_product_numbers JTF_NUMBER_TABLE;

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();

Line 2043: l_platform_numbers 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();

Line 2046: x_element_type_ids := 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();

Line 2047: x_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();
2051: x_category_numbers := JTF_NUMBER_TABLE();

Line 2048: l_product_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();

Line 2049: x_platform_numbers := 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();

Line 2050: l_platform_numbers := 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();

Line 2051: x_category_numbers := 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();

Line 2052: x_ele_ids := 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();
2056: x_ele_content_type_codes := JTF_VARCHAR2_TABLE_2000();

Line 2053: x_ele_upd_ids := 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();
2057: x_ele_upd_type_ids := JTF_NUMBER_TABLE();

Line 2054: x_element_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();

Line 2057: x_ele_upd_type_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();
2059: x_ele_upd_content_type_codes := JTF_VARCHAR2_TABLE_2000();
2060:
2061: -- Validate Solution Visibility Level Name, get ID

Line 2374: p_given_element_ids IN JTF_NUMBER_TABLE,

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,

Line 2376: p_given_ele_type_ids in JTF_NUMBER_TABLE,

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,

Line 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,

Line 2381: p_element_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,
2385: p_element_dummy_detail IN CLOB,

Line 2386: p_set_product_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,
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,

Line 2387: p_set_platform_ids IN JTF_NUMBER_TABLE,

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,

Line 2388: p_set_category_ids IN JTF_NUMBER_TABLE,

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

Line 2389: x_created_element_ids OUT NOCOPY JTF_NUMBER_TABLE,

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

Line 2395: l_set_product_org_ids JTF_NUMBER_TABLE;

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);

Line 2396: l_set_platform_org_ids JTF_NUMBER_TABLE;

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:

Line 2405: l_set_product_org_ids := JTF_NUMBER_TABLE();

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';

Line 2406: l_set_platform_org_ids := JTF_NUMBER_TABLE();

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

Line 2416: x_created_element_ids := JTF_NUMBER_TABLE();

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),

Line 2788: p_element_type_ids IN JTF_NUMBER_TABLE

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