DBA Data[Home] [Help]

APPS.IBC_ASSOCIATIONS_GRP dependencies on JTF_VARCHAR2_TABLE_100

Line 503: p_assoc_type_codes IN JTF_VARCHAR2_TABLE_100,

499: p_init_msg_list IN VARCHAR2,
500: p_commit IN VARCHAR2,
501: p_old_content_item_ids IN JTF_NUMBER_TABLE,
502: p_new_content_item_ids IN JTF_NUMBER_TABLE,
503: p_assoc_type_codes IN JTF_VARCHAR2_TABLE_100,
504: p_assoc_objects1 IN JTF_VARCHAR2_TABLE_300,
505: p_assoc_objects2 IN JTF_VARCHAR2_TABLE_300,
506: p_assoc_objects3 IN JTF_VARCHAR2_TABLE_300,
507: p_assoc_objects4 IN JTF_VARCHAR2_TABLE_300,

Line 545: p_assoc_type_codes IN JTF_VARCHAR2_TABLE_100,

541: p_old_content_item_ids IN JTF_NUMBER_TABLE,
542: p_new_content_item_ids IN JTF_NUMBER_TABLE,
543: p_old_citem_version_ids IN JTF_NUMBER_TABLE,
544: p_new_citem_version_ids IN JTF_NUMBER_TABLE,
545: p_assoc_type_codes IN JTF_VARCHAR2_TABLE_100,
546: p_assoc_objects1 IN JTF_VARCHAR2_TABLE_300,
547: p_assoc_objects2 IN JTF_VARCHAR2_TABLE_300,
548: p_assoc_objects3 IN JTF_VARCHAR2_TABLE_300,
549: p_assoc_objects4 IN JTF_VARCHAR2_TABLE_300,

Line 604: FROM TABLE(CAST(p_assoc_type_codes AS JTF_VARCHAR2_TABLE_100)) A

600:
601:
602: CURSOR cur_assoc IS
603: SELECT A.COLUMN_VALUE association_type_code
604: FROM TABLE(CAST(p_assoc_type_codes AS JTF_VARCHAR2_TABLE_100)) A
605: MINUS
606: SELECT association_type_code FROM IBC_ASSOCIATION_TYPES_B C;
607:
608: BEGIN

Line 901: p_assoc_type_codes IN JTF_VARCHAR2_TABLE_100,

897: p_api_version IN NUMBER,
898: p_init_msg_list IN VARCHAR2,
899: p_commit IN VARCHAR2,
900: p_content_item_ids IN JTF_NUMBER_TABLE,
901: p_assoc_type_codes IN JTF_VARCHAR2_TABLE_100,
902: p_assoc_objects1 IN JTF_VARCHAR2_TABLE_300,
903: p_assoc_objects2 IN JTF_VARCHAR2_TABLE_300,
904: p_assoc_objects3 IN JTF_VARCHAR2_TABLE_300,
905: p_assoc_objects4 IN JTF_VARCHAR2_TABLE_300,

Line 939: p_assoc_type_codes IN JTF_VARCHAR2_TABLE_100,

935: p_init_msg_list IN VARCHAR2,
936: p_commit IN VARCHAR2,
937: p_content_item_ids IN JTF_NUMBER_TABLE,
938: p_citem_version_ids IN JTF_NUMBER_TABLE,
939: p_assoc_type_codes IN JTF_VARCHAR2_TABLE_100,
940: p_assoc_objects1 IN JTF_VARCHAR2_TABLE_300,
941: p_assoc_objects2 IN JTF_VARCHAR2_TABLE_300,
942: p_assoc_objects3 IN JTF_VARCHAR2_TABLE_300,
943: p_assoc_objects4 IN JTF_VARCHAR2_TABLE_300,

Line 1165: p_assoc_type_codes IN JTF_VARCHAR2_TABLE_100,

1161: p_api_version IN NUMBER,
1162: p_init_msg_list IN VARCHAR2,
1163: p_commit IN VARCHAR2,
1164: p_content_item_ids IN JTF_NUMBER_TABLE,
1165: p_assoc_type_codes IN JTF_VARCHAR2_TABLE_100,
1166: p_assoc_objects1 IN JTF_VARCHAR2_TABLE_300,
1167: p_assoc_objects2 IN JTF_VARCHAR2_TABLE_300,
1168: p_assoc_objects3 IN JTF_VARCHAR2_TABLE_300,
1169: p_assoc_objects4 IN JTF_VARCHAR2_TABLE_300,

Line 1205: p_assoc_type_codes IN JTF_VARCHAR2_TABLE_100,

1201: p_init_msg_list IN VARCHAR2,
1202: p_commit IN VARCHAR2,
1203: p_content_item_ids IN JTF_NUMBER_TABLE,
1204: p_citem_version_ids IN JTF_NUMBER_TABLE,
1205: p_assoc_type_codes IN JTF_VARCHAR2_TABLE_100,
1206: p_assoc_objects1 IN JTF_VARCHAR2_TABLE_300,
1207: p_assoc_objects2 IN JTF_VARCHAR2_TABLE_300,
1208: p_assoc_objects3 IN JTF_VARCHAR2_TABLE_300,
1209: p_assoc_objects4 IN JTF_VARCHAR2_TABLE_300,

Line 1376: p_assoc_type_codes IN JTF_VARCHAR2_TABLE_100,

1372: PROCEDURE Get_Associations (
1373: p_api_version IN NUMBER,
1374: p_init_msg_list IN VARCHAR2,
1375: p_content_item_id IN NUMBER,
1376: p_assoc_type_codes IN JTF_VARCHAR2_TABLE_100,
1377: p_assoc_objects1 IN JTF_VARCHAR2_TABLE_300,
1378: p_assoc_objects2 IN JTF_VARCHAR2_TABLE_300,
1379: p_assoc_objects3 IN JTF_VARCHAR2_TABLE_300,
1380: p_assoc_objects4 IN JTF_VARCHAR2_TABLE_300,

Line 1382: x_assoc_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100,

1378: p_assoc_objects2 IN JTF_VARCHAR2_TABLE_300,
1379: p_assoc_objects3 IN JTF_VARCHAR2_TABLE_300,
1380: p_assoc_objects4 IN JTF_VARCHAR2_TABLE_300,
1381: p_assoc_objects5 IN JTF_VARCHAR2_TABLE_300,
1382: x_assoc_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100,
1383: x_assoc_objects1 OUT NOCOPY JTF_VARCHAR2_TABLE_300,
1384: x_assoc_objects2 OUT NOCOPY JTF_VARCHAR2_TABLE_300,
1385: x_assoc_objects3 OUT NOCOPY JTF_VARCHAR2_TABLE_300,
1386: x_assoc_objects4 OUT NOCOPY JTF_VARCHAR2_TABLE_300,

Line 1389: x_assoc_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100,

1385: x_assoc_objects3 OUT NOCOPY JTF_VARCHAR2_TABLE_300,
1386: x_assoc_objects4 OUT NOCOPY JTF_VARCHAR2_TABLE_300,
1387: x_assoc_objects5 OUT NOCOPY JTF_VARCHAR2_TABLE_300,
1388: x_assoc_names OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
1389: x_assoc_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100,
1390: x_return_status OUT NOCOPY VARCHAR2,
1391: x_msg_count OUT NOCOPY NUMBER,
1392: x_msg_data OUT NOCOPY VARCHAR2
1393: ) AS

Line 1428: p_assoc_type_codes IN JTF_VARCHAR2_TABLE_100,

1424: p_api_version IN NUMBER,
1425: p_init_msg_list IN VARCHAR2,
1426: p_content_item_id IN NUMBER,
1427: p_citem_version_id IN NUMBER,
1428: p_assoc_type_codes IN JTF_VARCHAR2_TABLE_100,
1429: p_assoc_objects1 IN JTF_VARCHAR2_TABLE_300,
1430: p_assoc_objects2 IN JTF_VARCHAR2_TABLE_300,
1431: p_assoc_objects3 IN JTF_VARCHAR2_TABLE_300,
1432: p_assoc_objects4 IN JTF_VARCHAR2_TABLE_300,

Line 1434: x_assoc_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100,

1430: p_assoc_objects2 IN JTF_VARCHAR2_TABLE_300,
1431: p_assoc_objects3 IN JTF_VARCHAR2_TABLE_300,
1432: p_assoc_objects4 IN JTF_VARCHAR2_TABLE_300,
1433: p_assoc_objects5 IN JTF_VARCHAR2_TABLE_300,
1434: x_assoc_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100,
1435: x_assoc_objects1 OUT NOCOPY JTF_VARCHAR2_TABLE_300,
1436: x_assoc_objects2 OUT NOCOPY JTF_VARCHAR2_TABLE_300,
1437: x_assoc_objects3 OUT NOCOPY JTF_VARCHAR2_TABLE_300,
1438: x_assoc_objects4 OUT NOCOPY JTF_VARCHAR2_TABLE_300,

Line 1441: x_assoc_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100,

1437: x_assoc_objects3 OUT NOCOPY JTF_VARCHAR2_TABLE_300,
1438: x_assoc_objects4 OUT NOCOPY JTF_VARCHAR2_TABLE_300,
1439: x_assoc_objects5 OUT NOCOPY JTF_VARCHAR2_TABLE_300,
1440: x_assoc_names OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
1441: x_assoc_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100,
1442: x_return_status OUT NOCOPY VARCHAR2,
1443: x_msg_count OUT NOCOPY NUMBER,
1444: x_msg_data OUT NOCOPY VARCHAR2
1445: ) AS

Line 1521: x_assoc_type_codes := JTF_VARCHAR2_TABLE_100();

1517: END IF;
1518:
1519:
1520: -- Initialize OUT NOCOPYput parameters
1521: x_assoc_type_codes := JTF_VARCHAR2_TABLE_100();
1522: x_assoc_objects1 := JTF_VARCHAR2_TABLE_300();
1523: x_assoc_objects2 := JTF_VARCHAR2_TABLE_300();
1524: x_assoc_objects3 := JTF_VARCHAR2_TABLE_300();
1525: x_assoc_objects4 := JTF_VARCHAR2_TABLE_300();

Line 1528: x_assoc_codes := JTF_VARCHAR2_TABLE_100();

1524: x_assoc_objects3 := JTF_VARCHAR2_TABLE_300();
1525: x_assoc_objects4 := JTF_VARCHAR2_TABLE_300();
1526: x_assoc_objects5 := JTF_VARCHAR2_TABLE_300();
1527: x_assoc_names := JTF_VARCHAR2_TABLE_4000();
1528: x_assoc_codes := JTF_VARCHAR2_TABLE_100();
1529:
1530: -- Retrieive Existing Associations
1531: FOR assoc_rec IN Get_Assoc LOOP
1532: IF (assoc_rec.CALL_BACK_PKG IS NULL) THEN