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 910: p_assoc_type_codes IN JTF_VARCHAR2_TABLE_100,

906: p_api_version IN NUMBER,
907: p_init_msg_list IN VARCHAR2,
908: p_commit IN VARCHAR2,
909: p_content_item_ids IN JTF_NUMBER_TABLE,
910: p_assoc_type_codes IN JTF_VARCHAR2_TABLE_100,
911: p_assoc_objects1 IN JTF_VARCHAR2_TABLE_300,
912: p_assoc_objects2 IN JTF_VARCHAR2_TABLE_300,
913: p_assoc_objects3 IN JTF_VARCHAR2_TABLE_300,
914: p_assoc_objects4 IN JTF_VARCHAR2_TABLE_300,

Line 948: p_assoc_type_codes IN JTF_VARCHAR2_TABLE_100,

944: p_init_msg_list IN VARCHAR2,
945: p_commit IN VARCHAR2,
946: p_content_item_ids IN JTF_NUMBER_TABLE,
947: p_citem_version_ids IN JTF_NUMBER_TABLE,
948: p_assoc_type_codes IN JTF_VARCHAR2_TABLE_100,
949: p_assoc_objects1 IN JTF_VARCHAR2_TABLE_300,
950: p_assoc_objects2 IN JTF_VARCHAR2_TABLE_300,
951: p_assoc_objects3 IN JTF_VARCHAR2_TABLE_300,
952: p_assoc_objects4 IN JTF_VARCHAR2_TABLE_300,

Line 1143: p_assoc_type_codes IN JTF_VARCHAR2_TABLE_100,

1139: p_api_version IN NUMBER,
1140: p_init_msg_list IN VARCHAR2,
1141: p_commit IN VARCHAR2,
1142: p_content_item_ids IN JTF_NUMBER_TABLE,
1143: p_assoc_type_codes IN JTF_VARCHAR2_TABLE_100,
1144: p_assoc_objects1 IN JTF_VARCHAR2_TABLE_300,
1145: p_assoc_objects2 IN JTF_VARCHAR2_TABLE_300,
1146: p_assoc_objects3 IN JTF_VARCHAR2_TABLE_300,
1147: p_assoc_objects4 IN JTF_VARCHAR2_TABLE_300,

Line 1183: p_assoc_type_codes IN JTF_VARCHAR2_TABLE_100,

1179: p_init_msg_list IN VARCHAR2,
1180: p_commit IN VARCHAR2,
1181: p_content_item_ids IN JTF_NUMBER_TABLE,
1182: p_citem_version_ids IN JTF_NUMBER_TABLE,
1183: p_assoc_type_codes IN JTF_VARCHAR2_TABLE_100,
1184: p_assoc_objects1 IN JTF_VARCHAR2_TABLE_300,
1185: p_assoc_objects2 IN JTF_VARCHAR2_TABLE_300,
1186: p_assoc_objects3 IN JTF_VARCHAR2_TABLE_300,
1187: p_assoc_objects4 IN JTF_VARCHAR2_TABLE_300,

Line 1356: p_assoc_type_codes IN JTF_VARCHAR2_TABLE_100,

1352: PROCEDURE Get_Associations (
1353: p_api_version IN NUMBER,
1354: p_init_msg_list IN VARCHAR2,
1355: p_content_item_id IN NUMBER,
1356: p_assoc_type_codes IN JTF_VARCHAR2_TABLE_100,
1357: p_assoc_objects1 IN JTF_VARCHAR2_TABLE_300,
1358: p_assoc_objects2 IN JTF_VARCHAR2_TABLE_300,
1359: p_assoc_objects3 IN JTF_VARCHAR2_TABLE_300,
1360: p_assoc_objects4 IN JTF_VARCHAR2_TABLE_300,

Line 1362: x_assoc_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100,

1358: p_assoc_objects2 IN JTF_VARCHAR2_TABLE_300,
1359: p_assoc_objects3 IN JTF_VARCHAR2_TABLE_300,
1360: p_assoc_objects4 IN JTF_VARCHAR2_TABLE_300,
1361: p_assoc_objects5 IN JTF_VARCHAR2_TABLE_300,
1362: x_assoc_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100,
1363: x_assoc_objects1 OUT NOCOPY JTF_VARCHAR2_TABLE_300,
1364: x_assoc_objects2 OUT NOCOPY JTF_VARCHAR2_TABLE_300,
1365: x_assoc_objects3 OUT NOCOPY JTF_VARCHAR2_TABLE_300,
1366: x_assoc_objects4 OUT NOCOPY JTF_VARCHAR2_TABLE_300,

Line 1369: x_assoc_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100,

1365: x_assoc_objects3 OUT NOCOPY JTF_VARCHAR2_TABLE_300,
1366: x_assoc_objects4 OUT NOCOPY JTF_VARCHAR2_TABLE_300,
1367: x_assoc_objects5 OUT NOCOPY JTF_VARCHAR2_TABLE_300,
1368: x_assoc_names OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
1369: x_assoc_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100,
1370: x_return_status OUT NOCOPY VARCHAR2,
1371: x_msg_count OUT NOCOPY NUMBER,
1372: x_msg_data OUT NOCOPY VARCHAR2
1373: ) AS

Line 1408: p_assoc_type_codes IN JTF_VARCHAR2_TABLE_100,

1404: p_api_version IN NUMBER,
1405: p_init_msg_list IN VARCHAR2,
1406: p_content_item_id IN NUMBER,
1407: p_citem_version_id IN NUMBER,
1408: p_assoc_type_codes IN JTF_VARCHAR2_TABLE_100,
1409: p_assoc_objects1 IN JTF_VARCHAR2_TABLE_300,
1410: p_assoc_objects2 IN JTF_VARCHAR2_TABLE_300,
1411: p_assoc_objects3 IN JTF_VARCHAR2_TABLE_300,
1412: p_assoc_objects4 IN JTF_VARCHAR2_TABLE_300,

Line 1414: x_assoc_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100,

1410: p_assoc_objects2 IN JTF_VARCHAR2_TABLE_300,
1411: p_assoc_objects3 IN JTF_VARCHAR2_TABLE_300,
1412: p_assoc_objects4 IN JTF_VARCHAR2_TABLE_300,
1413: p_assoc_objects5 IN JTF_VARCHAR2_TABLE_300,
1414: x_assoc_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100,
1415: x_assoc_objects1 OUT NOCOPY JTF_VARCHAR2_TABLE_300,
1416: x_assoc_objects2 OUT NOCOPY JTF_VARCHAR2_TABLE_300,
1417: x_assoc_objects3 OUT NOCOPY JTF_VARCHAR2_TABLE_300,
1418: x_assoc_objects4 OUT NOCOPY JTF_VARCHAR2_TABLE_300,

Line 1421: x_assoc_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100,

1417: x_assoc_objects3 OUT NOCOPY JTF_VARCHAR2_TABLE_300,
1418: x_assoc_objects4 OUT NOCOPY JTF_VARCHAR2_TABLE_300,
1419: x_assoc_objects5 OUT NOCOPY JTF_VARCHAR2_TABLE_300,
1420: x_assoc_names OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
1421: x_assoc_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100,
1422: x_return_status OUT NOCOPY VARCHAR2,
1423: x_msg_count OUT NOCOPY NUMBER,
1424: x_msg_data OUT NOCOPY VARCHAR2
1425: ) AS

Line 1503: x_assoc_type_codes := JTF_VARCHAR2_TABLE_100();

1499: END IF;
1500:
1501:
1502: -- Initialize OUT NOCOPYput parameters
1503: x_assoc_type_codes := JTF_VARCHAR2_TABLE_100();
1504: x_assoc_objects1 := JTF_VARCHAR2_TABLE_300();
1505: x_assoc_objects2 := JTF_VARCHAR2_TABLE_300();
1506: x_assoc_objects3 := JTF_VARCHAR2_TABLE_300();
1507: x_assoc_objects4 := JTF_VARCHAR2_TABLE_300();

Line 1510: x_assoc_codes := JTF_VARCHAR2_TABLE_100();

1506: x_assoc_objects3 := JTF_VARCHAR2_TABLE_300();
1507: x_assoc_objects4 := JTF_VARCHAR2_TABLE_300();
1508: x_assoc_objects5 := JTF_VARCHAR2_TABLE_300();
1509: x_assoc_names := JTF_VARCHAR2_TABLE_4000();
1510: x_assoc_codes := JTF_VARCHAR2_TABLE_100();
1511:
1512: -- Retrieive Existing Associations
1513: FOR assoc_rec IN Get_Assoc LOOP
1514: IF (assoc_rec.CALL_BACK_PKG IS NULL) THEN