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.IBC_CITEM_ADMIN_GRP dependencies on JTF_VARCHAR2_TABLE_100

Line 1014: ,p_attribute_type_codes IN JTF_VARCHAR2_TABLE_100

1010: -- with that data.
1011: -- --------------------------------------------------------------
1012: PROCEDURE create_attribute_bundle(
1013: px_attribute_bundle IN OUT NOCOPY CLOB
1014: ,p_attribute_type_codes IN JTF_VARCHAR2_TABLE_100
1015: ,p_attributes IN JTF_VARCHAR2_TABLE_32767
1016: ,p_ctype_code IN VARCHAR2
1017: ,x_return_status IN OUT NOCOPY VARCHAR2
1018: )

Line 1621: ,x_attribute_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100

1617: PROCEDURE get_attribute_bundle_int(
1618: p_attrib_fid IN NUMBER
1619: ,p_ctype_code IN VARCHAR2
1620: ,p_language IN VARCHAR2 DEFAULT USERENV('LANG')
1621: ,x_attribute_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100
1622: ,x_attribute_type_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
1623: ,x_attributes OUT NOCOPY JTF_VARCHAR2_TABLE_32767
1624: ,x_return_status OUT NOCOPY VARCHAR2
1625: )

Line 1644: attribute_type_codes JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

1640: l_res_buffer VARCHAR2(32767);
1641: l_total_length NUMBER;
1642:
1643: -- table variables
1644: attribute_type_codes JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
1645: attribute_type_names JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300();
1646: attributes JTF_VARCHAR2_TABLE_32767 := JTF_VARCHAR2_TABLE_32767();
1647:
1648: -- attribute loop variables

Line 1871: ,p_assoc_type_codes IN JTF_VARCHAR2_TABLE_100

1867: -- --------------------------------------------------------------
1868: PROCEDURE insert_citem_associations_int(
1869: p_content_item_id IN NUMBER
1870: ,p_citem_version_id IN NUMBER
1871: ,p_assoc_type_codes IN JTF_VARCHAR2_TABLE_100
1872: ,p_assoc_objects1 IN JTF_VARCHAR2_TABLE_300
1873: ,p_assoc_objects2 IN JTF_VARCHAR2_TABLE_300 DEFAULT NULL
1874: ,p_assoc_objects3 IN JTF_VARCHAR2_TABLE_300 DEFAULT NULL
1875: ,p_assoc_objects4 IN JTF_VARCHAR2_TABLE_300 DEFAULT NULL

Line 2059: ,p_attribute_type_codes IN JTF_VARCHAR2_TABLE_100

2055: p_citem_ver_id IN NUMBER
2056: ,p_content_item_id IN NUMBER
2057: ,p_content_item_ids IN JTF_NUMBER_TABLE
2058: ,p_citem_ver_ids IN JTF_NUMBER_TABLE DEFAULT NULL
2059: ,p_attribute_type_codes IN JTF_VARCHAR2_TABLE_100
2060: ,p_ctype_code IN VARCHAR2
2061: ,p_sort_order IN JTF_NUMBER_TABLE DEFAULT NULL
2062: ,p_log_action IN VARCHAR2 DEFAULT FND_API.g_true
2063: ,x_return_status OUT NOCOPY VARCHAR2

Line 5809: ,x_attribute_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100

5805: PROCEDURE get_attribute_bundle(
5806: p_citem_ver_id IN NUMBER
5807: ,p_init_msg_list IN VARCHAR2
5808: ,p_api_version_number IN NUMBER
5809: ,x_attribute_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100
5810: ,x_attribute_type_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
5811: ,x_attributes OUT NOCOPY JTF_VARCHAR2_TABLE_32767
5812: ,x_object_version_number OUT NOCOPY NUMBER
5813: ,x_return_status OUT NOCOPY VARCHAR2

Line 6044: ,x_attribute_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100

6040: PROCEDURE get_attribute_bundle(
6041: p_citem_ver_id IN NUMBER
6042: ,p_init_msg_list IN VARCHAR2
6043: ,p_api_version_number IN NUMBER
6044: ,x_attribute_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100
6045: ,x_attribute_type_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
6046: ,x_attributes OUT NOCOPY JTF_VARCHAR2_TABLE_4000
6047: ,x_object_version_number OUT NOCOPY NUMBER
6048: ,x_return_status OUT NOCOPY VARCHAR2

Line 6122: ,x_rendition_mime_types OUT NOCOPY JTF_VARCHAR2_TABLE_100

6118: ,x_attach_mime_type OUT NOCOPY VARCHAR2
6119: ,x_attach_mime_name OUT NOCOPY VARCHAR2
6120: ,x_rendition_file_ids OUT NOCOPY JTF_NUMBER_TABLE
6121: ,x_rendition_file_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
6122: ,x_rendition_mime_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
6123: ,x_rendition_mime_names OUT NOCOPY JTF_VARCHAR2_TABLE_100
6124: ,x_default_rendition OUT NOCOPY NUMBER
6125: ,x_object_version_number OUT NOCOPY NUMBER
6126: ,x_created_by OUT NOCOPY NUMBER

Line 6123: ,x_rendition_mime_names OUT NOCOPY JTF_VARCHAR2_TABLE_100

6119: ,x_attach_mime_name OUT NOCOPY VARCHAR2
6120: ,x_rendition_file_ids OUT NOCOPY JTF_NUMBER_TABLE
6121: ,x_rendition_file_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
6122: ,x_rendition_mime_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
6123: ,x_rendition_mime_names OUT NOCOPY JTF_VARCHAR2_TABLE_100
6124: ,x_default_rendition OUT NOCOPY NUMBER
6125: ,x_object_version_number OUT NOCOPY NUMBER
6126: ,x_created_by OUT NOCOPY NUMBER
6127: ,x_creation_date OUT NOCOPY DATE

Line 6130: ,x_attribute_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100

6126: ,x_created_by OUT NOCOPY NUMBER
6127: ,x_creation_date OUT NOCOPY DATE
6128: ,x_last_updated_by OUT NOCOPY NUMBER
6129: ,x_last_update_date OUT NOCOPY DATE
6130: ,x_attribute_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100
6131: ,x_attribute_type_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
6132: ,x_attributes OUT NOCOPY JTF_VARCHAR2_TABLE_32767
6133: ,x_component_citems OUT NOCOPY JTF_NUMBER_TABLE
6134: ,x_component_citem_ver_ids OUT NOCOPY JTF_NUMBER_TABLE

Line 6135: ,x_component_attrib_types OUT NOCOPY JTF_VARCHAR2_TABLE_100

6131: ,x_attribute_type_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
6132: ,x_attributes OUT NOCOPY JTF_VARCHAR2_TABLE_32767
6133: ,x_component_citems OUT NOCOPY JTF_NUMBER_TABLE
6134: ,x_component_citem_ver_ids OUT NOCOPY JTF_NUMBER_TABLE
6135: ,x_component_attrib_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
6136: ,x_component_citem_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
6137: ,x_component_owner_ids OUT NOCOPY JTF_NUMBER_TABLE
6138: ,x_component_owner_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
6139: ,x_component_sort_orders OUT NOCOPY JTF_NUMBER_TABLE

Line 6138: ,x_component_owner_types OUT NOCOPY JTF_VARCHAR2_TABLE_100

6134: ,x_component_citem_ver_ids OUT NOCOPY JTF_NUMBER_TABLE
6135: ,x_component_attrib_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
6136: ,x_component_citem_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
6137: ,x_component_owner_ids OUT NOCOPY JTF_NUMBER_TABLE
6138: ,x_component_owner_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
6139: ,x_component_sort_orders OUT NOCOPY JTF_NUMBER_TABLE
6140: ,x_keywords OUT NOCOPY JTF_VARCHAR2_TABLE_100
6141: ,x_return_status OUT NOCOPY VARCHAR2
6142: ,x_msg_count OUT NOCOPY NUMBER

Line 6140: ,x_keywords OUT NOCOPY JTF_VARCHAR2_TABLE_100

6136: ,x_component_citem_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
6137: ,x_component_owner_ids OUT NOCOPY JTF_NUMBER_TABLE
6138: ,x_component_owner_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
6139: ,x_component_sort_orders OUT NOCOPY JTF_NUMBER_TABLE
6140: ,x_keywords OUT NOCOPY JTF_VARCHAR2_TABLE_100
6141: ,x_return_status OUT NOCOPY VARCHAR2
6142: ,x_msg_count OUT NOCOPY NUMBER
6143: ,x_msg_data OUT NOCOPY VARCHAR2
6144: )

Line 6418: x_rendition_mime_types := JTF_VARCHAR2_TABLE_100();

6414: -- Allocate
6415: IF l_index = 1 THEN
6416: x_rendition_file_ids := JTF_NUMBER_TABLE();
6417: x_rendition_file_names := JTF_VARCHAR2_TABLE_300();
6418: x_rendition_mime_types := JTF_VARCHAR2_TABLE_100();
6419: x_rendition_mime_names := JTF_VARCHAR2_TABLE_100();
6420: END IF;
6421:
6422: -- Extend

Line 6419: x_rendition_mime_names := JTF_VARCHAR2_TABLE_100();

6415: IF l_index = 1 THEN
6416: x_rendition_file_ids := JTF_NUMBER_TABLE();
6417: x_rendition_file_names := JTF_VARCHAR2_TABLE_300();
6418: x_rendition_mime_types := JTF_VARCHAR2_TABLE_100();
6419: x_rendition_mime_names := JTF_VARCHAR2_TABLE_100();
6420: END IF;
6421:
6422: -- Extend
6423: x_rendition_file_ids.extend;

Line 6464: x_component_attrib_types := JTF_VARCHAR2_TABLE_100();

6460: -- Allocate
6461: IF l_index = 1 THEN
6462: x_component_citems := JTF_NUMBER_TABLE();
6463: x_component_citem_ver_ids := JTF_NUMBER_TABLE();
6464: x_component_attrib_types := JTF_VARCHAR2_TABLE_100();
6465: x_component_citem_names := JTF_VARCHAR2_TABLE_300();
6466: x_component_sort_orders := JTF_NUMBER_TABLE();
6467: x_component_owner_ids := JTF_NUMBER_TABLE();
6468: x_component_owner_types := JTF_VARCHAR2_TABLE_100();

Line 6468: x_component_owner_types := JTF_VARCHAR2_TABLE_100();

6464: x_component_attrib_types := JTF_VARCHAR2_TABLE_100();
6465: x_component_citem_names := JTF_VARCHAR2_TABLE_300();
6466: x_component_sort_orders := JTF_NUMBER_TABLE();
6467: x_component_owner_ids := JTF_NUMBER_TABLE();
6468: x_component_owner_types := JTF_VARCHAR2_TABLE_100();
6469: END IF;
6470:
6471: -- Extend
6472: x_component_citems.extend;

Line 6495: x_keywords := JTF_VARCHAR2_TABLE_100();

6491: -- Keywords loading
6492: FOR r_keyword IN c_keywords(x_content_item_id) LOOP
6493: l_index := c_keywords%ROWCOUNT;
6494: IF l_index = 1 THEN
6495: x_keywords := JTF_VARCHAR2_TABLE_100();
6496: END IF;
6497: x_keywords.extend;
6498: x_keywords(l_index) := r_keyword.keyword;
6499: END LOOP;

Line 6675: ,x_rendition_mime_types OUT NOCOPY JTF_VARCHAR2_TABLE_100

6671: ,x_attach_mime_type OUT NOCOPY VARCHAR2
6672: ,x_attach_mime_name OUT NOCOPY VARCHAR2
6673: ,x_rendition_file_ids OUT NOCOPY JTF_NUMBER_TABLE
6674: ,x_rendition_file_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
6675: ,x_rendition_mime_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
6676: ,x_rendition_mime_names OUT NOCOPY JTF_VARCHAR2_TABLE_100
6677: ,x_default_rendition OUT NOCOPY NUMBER
6678: ,x_object_version_number OUT NOCOPY NUMBER
6679: ,x_created_by OUT NOCOPY NUMBER

Line 6676: ,x_rendition_mime_names OUT NOCOPY JTF_VARCHAR2_TABLE_100

6672: ,x_attach_mime_name OUT NOCOPY VARCHAR2
6673: ,x_rendition_file_ids OUT NOCOPY JTF_NUMBER_TABLE
6674: ,x_rendition_file_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
6675: ,x_rendition_mime_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
6676: ,x_rendition_mime_names OUT NOCOPY JTF_VARCHAR2_TABLE_100
6677: ,x_default_rendition OUT NOCOPY NUMBER
6678: ,x_object_version_number OUT NOCOPY NUMBER
6679: ,x_created_by OUT NOCOPY NUMBER
6680: ,x_creation_date OUT NOCOPY DATE

Line 6683: ,x_attribute_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100

6679: ,x_created_by OUT NOCOPY NUMBER
6680: ,x_creation_date OUT NOCOPY DATE
6681: ,x_last_updated_by OUT NOCOPY NUMBER
6682: ,x_last_update_date OUT NOCOPY DATE
6683: ,x_attribute_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100
6684: ,x_attribute_type_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
6685: ,x_attributes OUT NOCOPY JTF_VARCHAR2_TABLE_32767
6686: ,x_component_citems OUT NOCOPY JTF_NUMBER_TABLE
6687: ,x_component_citem_ver_ids OUT NOCOPY JTF_NUMBER_TABLE

Line 6688: ,x_component_attrib_types OUT NOCOPY JTF_VARCHAR2_TABLE_100

6684: ,x_attribute_type_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
6685: ,x_attributes OUT NOCOPY JTF_VARCHAR2_TABLE_32767
6686: ,x_component_citems OUT NOCOPY JTF_NUMBER_TABLE
6687: ,x_component_citem_ver_ids OUT NOCOPY JTF_NUMBER_TABLE
6688: ,x_component_attrib_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
6689: ,x_component_citem_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
6690: ,x_component_owner_ids OUT NOCOPY JTF_NUMBER_TABLE
6691: ,x_component_owner_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
6692: ,x_component_sort_orders OUT NOCOPY JTF_NUMBER_TABLE

Line 6691: ,x_component_owner_types OUT NOCOPY JTF_VARCHAR2_TABLE_100

6687: ,x_component_citem_ver_ids OUT NOCOPY JTF_NUMBER_TABLE
6688: ,x_component_attrib_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
6689: ,x_component_citem_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
6690: ,x_component_owner_ids OUT NOCOPY JTF_NUMBER_TABLE
6691: ,x_component_owner_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
6692: ,x_component_sort_orders OUT NOCOPY JTF_NUMBER_TABLE
6693: ,x_keywords OUT NOCOPY JTF_VARCHAR2_TABLE_100
6694: ,x_return_status OUT NOCOPY VARCHAR2
6695: ,x_msg_count OUT NOCOPY NUMBER

Line 6693: ,x_keywords OUT NOCOPY JTF_VARCHAR2_TABLE_100

6689: ,x_component_citem_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
6690: ,x_component_owner_ids OUT NOCOPY JTF_NUMBER_TABLE
6691: ,x_component_owner_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
6692: ,x_component_sort_orders OUT NOCOPY JTF_NUMBER_TABLE
6693: ,x_keywords OUT NOCOPY JTF_VARCHAR2_TABLE_100
6694: ,x_return_status OUT NOCOPY VARCHAR2
6695: ,x_msg_count OUT NOCOPY NUMBER
6696: ,x_msg_data OUT NOCOPY VARCHAR2
6697: )

Line 6794: ,x_rendition_mime_types OUT NOCOPY JTF_VARCHAR2_TABLE_100

6790: ,x_attach_mime_type OUT NOCOPY VARCHAR2
6791: ,x_attach_mime_name OUT NOCOPY VARCHAR2
6792: ,x_rendition_file_ids OUT NOCOPY JTF_NUMBER_TABLE
6793: ,x_rendition_file_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
6794: ,x_rendition_mime_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
6795: ,x_rendition_mime_names OUT NOCOPY JTF_VARCHAR2_TABLE_100
6796: ,x_default_rendition OUT NOCOPY NUMBER
6797: ,x_object_version_number OUT NOCOPY NUMBER
6798: ,x_created_by OUT NOCOPY NUMBER

Line 6795: ,x_rendition_mime_names OUT NOCOPY JTF_VARCHAR2_TABLE_100

6791: ,x_attach_mime_name OUT NOCOPY VARCHAR2
6792: ,x_rendition_file_ids OUT NOCOPY JTF_NUMBER_TABLE
6793: ,x_rendition_file_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
6794: ,x_rendition_mime_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
6795: ,x_rendition_mime_names OUT NOCOPY JTF_VARCHAR2_TABLE_100
6796: ,x_default_rendition OUT NOCOPY NUMBER
6797: ,x_object_version_number OUT NOCOPY NUMBER
6798: ,x_created_by OUT NOCOPY NUMBER
6799: ,x_creation_date OUT NOCOPY DATE

Line 6802: ,x_attribute_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100

6798: ,x_created_by OUT NOCOPY NUMBER
6799: ,x_creation_date OUT NOCOPY DATE
6800: ,x_last_updated_by OUT NOCOPY NUMBER
6801: ,x_last_update_date OUT NOCOPY DATE
6802: ,x_attribute_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100
6803: ,x_attribute_type_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
6804: ,x_attributes OUT NOCOPY JTF_VARCHAR2_TABLE_4000
6805: ,x_component_citems OUT NOCOPY JTF_NUMBER_TABLE
6806: ,x_component_citem_ver_ids OUT NOCOPY JTF_NUMBER_TABLE

Line 6807: ,x_component_attrib_types OUT NOCOPY JTF_VARCHAR2_TABLE_100

6803: ,x_attribute_type_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
6804: ,x_attributes OUT NOCOPY JTF_VARCHAR2_TABLE_4000
6805: ,x_component_citems OUT NOCOPY JTF_NUMBER_TABLE
6806: ,x_component_citem_ver_ids OUT NOCOPY JTF_NUMBER_TABLE
6807: ,x_component_attrib_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
6808: ,x_component_citem_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
6809: ,x_component_owner_ids OUT NOCOPY JTF_NUMBER_TABLE
6810: ,x_component_owner_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
6811: ,x_component_sort_orders OUT NOCOPY JTF_NUMBER_TABLE

Line 6810: ,x_component_owner_types OUT NOCOPY JTF_VARCHAR2_TABLE_100

6806: ,x_component_citem_ver_ids OUT NOCOPY JTF_NUMBER_TABLE
6807: ,x_component_attrib_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
6808: ,x_component_citem_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
6809: ,x_component_owner_ids OUT NOCOPY JTF_NUMBER_TABLE
6810: ,x_component_owner_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
6811: ,x_component_sort_orders OUT NOCOPY JTF_NUMBER_TABLE
6812: ,x_keywords OUT NOCOPY JTF_VARCHAR2_TABLE_100
6813: ,x_return_status OUT NOCOPY VARCHAR2
6814: ,x_msg_count OUT NOCOPY NUMBER

Line 6812: ,x_keywords OUT NOCOPY JTF_VARCHAR2_TABLE_100

6808: ,x_component_citem_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
6809: ,x_component_owner_ids OUT NOCOPY JTF_NUMBER_TABLE
6810: ,x_component_owner_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
6811: ,x_component_sort_orders OUT NOCOPY JTF_NUMBER_TABLE
6812: ,x_keywords OUT NOCOPY JTF_VARCHAR2_TABLE_100
6813: ,x_return_status OUT NOCOPY VARCHAR2
6814: ,x_msg_count OUT NOCOPY NUMBER
6815: ,x_msg_data OUT NOCOPY VARCHAR2
6816: )

Line 6924: ,x_attach_mime_types OUT NOCOPY JTF_VARCHAR2_TABLE_100

6920: ,x_locked_by OUT NOCOPY NUMBER
6921: ,x_wd_restricted OUT NOCOPY VARCHAR2
6922: ,x_attach_file_ids OUT NOCOPY JTF_NUMBER_TABLE
6923: ,x_attach_file_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
6924: ,x_attach_mime_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
6925: ,x_attach_mime_names OUT NOCOPY JTF_VARCHAR2_TABLE_100
6926: ,x_default_rendition OUT NOCOPY NUMBER
6927: ,x_object_version_number OUT NOCOPY NUMBER
6928: ,x_created_by OUT NOCOPY NUMBER

Line 6925: ,x_attach_mime_names OUT NOCOPY JTF_VARCHAR2_TABLE_100

6921: ,x_wd_restricted OUT NOCOPY VARCHAR2
6922: ,x_attach_file_ids OUT NOCOPY JTF_NUMBER_TABLE
6923: ,x_attach_file_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
6924: ,x_attach_mime_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
6925: ,x_attach_mime_names OUT NOCOPY JTF_VARCHAR2_TABLE_100
6926: ,x_default_rendition OUT NOCOPY NUMBER
6927: ,x_object_version_number OUT NOCOPY NUMBER
6928: ,x_created_by OUT NOCOPY NUMBER
6929: ,x_creation_date OUT NOCOPY DATE

Line 6932: ,x_attribute_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100

6928: ,x_created_by OUT NOCOPY NUMBER
6929: ,x_creation_date OUT NOCOPY DATE
6930: ,x_last_updated_by OUT NOCOPY NUMBER
6931: ,x_last_update_date OUT NOCOPY DATE
6932: ,x_attribute_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100
6933: ,x_attribute_type_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
6934: ,x_attributes OUT NOCOPY JTF_VARCHAR2_TABLE_4000
6935: ,x_component_citems OUT NOCOPY JTF_NUMBER_TABLE
6936: ,x_component_citem_ver_ids OUT NOCOPY JTF_NUMBER_TABLE

Line 6937: ,x_component_attrib_types OUT NOCOPY JTF_VARCHAR2_TABLE_100

6933: ,x_attribute_type_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
6934: ,x_attributes OUT NOCOPY JTF_VARCHAR2_TABLE_4000
6935: ,x_component_citems OUT NOCOPY JTF_NUMBER_TABLE
6936: ,x_component_citem_ver_ids OUT NOCOPY JTF_NUMBER_TABLE
6937: ,x_component_attrib_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
6938: ,x_component_citem_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
6939: ,x_component_owner_ids OUT NOCOPY JTF_NUMBER_TABLE
6940: ,x_component_owner_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
6941: ,x_component_sort_orders OUT NOCOPY JTF_NUMBER_TABLE

Line 6940: ,x_component_owner_types OUT NOCOPY JTF_VARCHAR2_TABLE_100

6936: ,x_component_citem_ver_ids OUT NOCOPY JTF_NUMBER_TABLE
6937: ,x_component_attrib_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
6938: ,x_component_citem_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
6939: ,x_component_owner_ids OUT NOCOPY JTF_NUMBER_TABLE
6940: ,x_component_owner_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
6941: ,x_component_sort_orders OUT NOCOPY JTF_NUMBER_TABLE
6942: ,x_keywords OUT NOCOPY JTF_VARCHAR2_TABLE_100
6943: ,x_return_status OUT NOCOPY VARCHAR2
6944: ,x_msg_count OUT NOCOPY NUMBER

Line 6942: ,x_keywords OUT NOCOPY JTF_VARCHAR2_TABLE_100

6938: ,x_component_citem_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
6939: ,x_component_owner_ids OUT NOCOPY JTF_NUMBER_TABLE
6940: ,x_component_owner_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
6941: ,x_component_sort_orders OUT NOCOPY JTF_NUMBER_TABLE
6942: ,x_keywords OUT NOCOPY JTF_VARCHAR2_TABLE_100
6943: ,x_return_status OUT NOCOPY VARCHAR2
6944: ,x_msg_count OUT NOCOPY NUMBER
6945: ,x_msg_data OUT NOCOPY VARCHAR2
6946: )

Line 6955: l_norend_mime_types JTF_VARCHAR2_TABLE_100;

6951: l_attach_mime_name VARCHAR2(80);
6952:
6953: l_norend_file_ids JTF_NUMBER_TABLE;
6954: l_norend_file_names JTF_VARCHAR2_TABLE_300;
6955: l_norend_mime_types JTF_VARCHAR2_TABLE_100;
6956: l_norend_mime_names JTF_VARCHAR2_TABLE_100;
6957: BEGIN
6958: get_trans_item(
6959: p_citem_ver_id => p_citem_ver_id

Line 6956: l_norend_mime_names JTF_VARCHAR2_TABLE_100;

6952:
6953: l_norend_file_ids JTF_NUMBER_TABLE;
6954: l_norend_file_names JTF_VARCHAR2_TABLE_300;
6955: l_norend_mime_types JTF_VARCHAR2_TABLE_100;
6956: l_norend_mime_names JTF_VARCHAR2_TABLE_100;
6957: BEGIN
6958: get_trans_item(
6959: p_citem_ver_id => p_citem_ver_id
6960: ,p_language => p_language

Line 7016: x_attach_mime_types := JTF_VARCHAR2_TABLE_100();

7012:
7013: IF l_attach_file_id IS NOT NULL THEN
7014: x_attach_file_ids := JTF_NUMBER_TABLE();
7015: x_attach_file_names := JTF_VARCHAR2_TABLE_300();
7016: x_attach_mime_types := JTF_VARCHAR2_TABLE_100();
7017: x_attach_mime_names := JTF_VARCHAR2_TABLE_100();
7018:
7019: x_attach_file_ids.extend();
7020: x_attach_file_names.extend();

Line 7017: x_attach_mime_names := JTF_VARCHAR2_TABLE_100();

7013: IF l_attach_file_id IS NOT NULL THEN
7014: x_attach_file_ids := JTF_NUMBER_TABLE();
7015: x_attach_file_names := JTF_VARCHAR2_TABLE_300();
7016: x_attach_mime_types := JTF_VARCHAR2_TABLE_100();
7017: x_attach_mime_names := JTF_VARCHAR2_TABLE_100();
7018:
7019: x_attach_file_ids.extend();
7020: x_attach_file_names.extend();
7021: x_attach_mime_types.extend();

Line 7063: ,x_attach_mime_types OUT NOCOPY JTF_VARCHAR2_TABLE_100

7059: ,x_locked_by OUT NOCOPY NUMBER
7060: ,x_wd_restricted OUT NOCOPY VARCHAR2
7061: ,x_attach_file_ids OUT NOCOPY JTF_NUMBER_TABLE
7062: ,x_attach_file_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
7063: ,x_attach_mime_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
7064: ,x_attach_mime_names OUT NOCOPY JTF_VARCHAR2_TABLE_100
7065: ,x_default_rendition OUT NOCOPY NUMBER
7066: ,x_object_version_number OUT NOCOPY NUMBER
7067: ,x_created_by OUT NOCOPY NUMBER

Line 7064: ,x_attach_mime_names OUT NOCOPY JTF_VARCHAR2_TABLE_100

7060: ,x_wd_restricted OUT NOCOPY VARCHAR2
7061: ,x_attach_file_ids OUT NOCOPY JTF_NUMBER_TABLE
7062: ,x_attach_file_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
7063: ,x_attach_mime_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
7064: ,x_attach_mime_names OUT NOCOPY JTF_VARCHAR2_TABLE_100
7065: ,x_default_rendition OUT NOCOPY NUMBER
7066: ,x_object_version_number OUT NOCOPY NUMBER
7067: ,x_created_by OUT NOCOPY NUMBER
7068: ,x_creation_date OUT NOCOPY DATE

Line 7071: ,x_attribute_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100

7067: ,x_created_by OUT NOCOPY NUMBER
7068: ,x_creation_date OUT NOCOPY DATE
7069: ,x_last_updated_by OUT NOCOPY NUMBER
7070: ,x_last_update_date OUT NOCOPY DATE
7071: ,x_attribute_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100
7072: ,x_attribute_type_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
7073: ,x_attributes OUT NOCOPY JTF_VARCHAR2_TABLE_4000
7074: ,x_component_citems OUT NOCOPY JTF_NUMBER_TABLE
7075: ,x_component_attrib_types OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 7075: ,x_component_attrib_types OUT NOCOPY JTF_VARCHAR2_TABLE_100

7071: ,x_attribute_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100
7072: ,x_attribute_type_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
7073: ,x_attributes OUT NOCOPY JTF_VARCHAR2_TABLE_4000
7074: ,x_component_citems OUT NOCOPY JTF_NUMBER_TABLE
7075: ,x_component_attrib_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
7076: ,x_component_citem_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
7077: ,x_component_owner_ids OUT NOCOPY JTF_NUMBER_TABLE
7078: ,x_component_owner_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
7079: ,x_component_sort_orders OUT NOCOPY JTF_NUMBER_TABLE

Line 7078: ,x_component_owner_types OUT NOCOPY JTF_VARCHAR2_TABLE_100

7074: ,x_component_citems OUT NOCOPY JTF_NUMBER_TABLE
7075: ,x_component_attrib_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
7076: ,x_component_citem_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
7077: ,x_component_owner_ids OUT NOCOPY JTF_NUMBER_TABLE
7078: ,x_component_owner_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
7079: ,x_component_sort_orders OUT NOCOPY JTF_NUMBER_TABLE
7080: ,x_return_status OUT NOCOPY VARCHAR2
7081: ,x_msg_count OUT NOCOPY NUMBER
7082: ,x_msg_data OUT NOCOPY VARCHAR2

Line 7170: ,x_attach_mime_types OUT NOCOPY JTF_VARCHAR2_TABLE_100

7166: ,x_locked_by OUT NOCOPY NUMBER
7167: ,x_wd_restricted OUT NOCOPY VARCHAR2
7168: ,x_attach_file_ids OUT NOCOPY JTF_NUMBER_TABLE
7169: ,x_attach_file_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
7170: ,x_attach_mime_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
7171: ,x_attach_mime_names OUT NOCOPY JTF_VARCHAR2_TABLE_100
7172: ,x_default_rendition OUT NOCOPY NUMBER
7173: ,x_object_version_number OUT NOCOPY NUMBER
7174: ,x_created_by OUT NOCOPY NUMBER

Line 7171: ,x_attach_mime_names OUT NOCOPY JTF_VARCHAR2_TABLE_100

7167: ,x_wd_restricted OUT NOCOPY VARCHAR2
7168: ,x_attach_file_ids OUT NOCOPY JTF_NUMBER_TABLE
7169: ,x_attach_file_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
7170: ,x_attach_mime_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
7171: ,x_attach_mime_names OUT NOCOPY JTF_VARCHAR2_TABLE_100
7172: ,x_default_rendition OUT NOCOPY NUMBER
7173: ,x_object_version_number OUT NOCOPY NUMBER
7174: ,x_created_by OUT NOCOPY NUMBER
7175: ,x_creation_date OUT NOCOPY DATE

Line 7178: ,x_attribute_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100

7174: ,x_created_by OUT NOCOPY NUMBER
7175: ,x_creation_date OUT NOCOPY DATE
7176: ,x_last_updated_by OUT NOCOPY NUMBER
7177: ,x_last_update_date OUT NOCOPY DATE
7178: ,x_attribute_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100
7179: ,x_attribute_type_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
7180: ,x_attributes OUT NOCOPY JTF_VARCHAR2_TABLE_4000
7181: ,x_component_citems OUT NOCOPY JTF_NUMBER_TABLE
7182: ,x_component_citem_ver_ids OUT NOCOPY JTF_NUMBER_TABLE

Line 7183: ,x_component_attrib_types OUT NOCOPY JTF_VARCHAR2_TABLE_100

7179: ,x_attribute_type_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
7180: ,x_attributes OUT NOCOPY JTF_VARCHAR2_TABLE_4000
7181: ,x_component_citems OUT NOCOPY JTF_NUMBER_TABLE
7182: ,x_component_citem_ver_ids OUT NOCOPY JTF_NUMBER_TABLE
7183: ,x_component_attrib_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
7184: ,x_component_citem_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
7185: ,x_component_owner_ids OUT NOCOPY JTF_NUMBER_TABLE
7186: ,x_component_owner_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
7187: ,x_component_sort_orders OUT NOCOPY JTF_NUMBER_TABLE

Line 7186: ,x_component_owner_types OUT NOCOPY JTF_VARCHAR2_TABLE_100

7182: ,x_component_citem_ver_ids OUT NOCOPY JTF_NUMBER_TABLE
7183: ,x_component_attrib_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
7184: ,x_component_citem_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
7185: ,x_component_owner_ids OUT NOCOPY JTF_NUMBER_TABLE
7186: ,x_component_owner_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
7187: ,x_component_sort_orders OUT NOCOPY JTF_NUMBER_TABLE
7188: ,x_return_status OUT NOCOPY VARCHAR2
7189: ,x_msg_count OUT NOCOPY NUMBER
7190: ,x_msg_data OUT NOCOPY VARCHAR2

Line 7193: l_keywords JTF_VARCHAR2_TABLE_100;

7189: ,x_msg_count OUT NOCOPY NUMBER
7190: ,x_msg_data OUT NOCOPY VARCHAR2
7191: )
7192: IS
7193: l_keywords JTF_VARCHAR2_TABLE_100;
7194: BEGIN
7195:
7196: get_trans_item(
7197: p_citem_ver_id => p_citem_ver_id

Line 7290: ,x_attribute_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100

7286: ,x_created_by OUT NOCOPY NUMBER
7287: ,x_creation_date OUT NOCOPY DATE
7288: ,x_last_updated_by OUT NOCOPY NUMBER
7289: ,x_last_update_date OUT NOCOPY DATE
7290: ,x_attribute_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100
7291: ,x_attribute_type_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
7292: ,x_attributes OUT NOCOPY JTF_VARCHAR2_TABLE_4000
7293: ,x_component_citems OUT NOCOPY JTF_NUMBER_TABLE
7294: ,x_component_attrib_types OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 7294: ,x_component_attrib_types OUT NOCOPY JTF_VARCHAR2_TABLE_100

7290: ,x_attribute_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100
7291: ,x_attribute_type_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
7292: ,x_attributes OUT NOCOPY JTF_VARCHAR2_TABLE_4000
7293: ,x_component_citems OUT NOCOPY JTF_NUMBER_TABLE
7294: ,x_component_attrib_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
7295: ,x_component_citem_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
7296: ,x_component_owner_ids OUT NOCOPY JTF_NUMBER_TABLE
7297: ,x_component_owner_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
7298: ,x_component_sort_orders OUT NOCOPY JTF_NUMBER_TABLE

Line 7297: ,x_component_owner_types OUT NOCOPY JTF_VARCHAR2_TABLE_100

7293: ,x_component_citems OUT NOCOPY JTF_NUMBER_TABLE
7294: ,x_component_attrib_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
7295: ,x_component_citem_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
7296: ,x_component_owner_ids OUT NOCOPY JTF_NUMBER_TABLE
7297: ,x_component_owner_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
7298: ,x_component_sort_orders OUT NOCOPY JTF_NUMBER_TABLE
7299: ,x_return_status OUT NOCOPY VARCHAR2
7300: ,x_msg_count OUT NOCOPY NUMBER
7301: ,x_msg_data OUT NOCOPY VARCHAR2

Line 7306: l_attach_mime_types JTF_VARCHAR2_TABLE_100;

7302: )
7303: IS
7304: l_attach_file_ids JTF_NUMBER_TABLE;
7305: l_attach_file_names JTF_VARCHAR2_TABLE_300;
7306: l_attach_mime_types JTF_VARCHAR2_TABLE_100;
7307: l_attach_mime_names JTF_VARCHAR2_TABLE_100;
7308: l_default_rendition NUMBER;
7309: BEGIN
7310: get_trans_item(

Line 7307: l_attach_mime_names JTF_VARCHAR2_TABLE_100;

7303: IS
7304: l_attach_file_ids JTF_NUMBER_TABLE;
7305: l_attach_file_names JTF_VARCHAR2_TABLE_300;
7306: l_attach_mime_types JTF_VARCHAR2_TABLE_100;
7307: l_attach_mime_names JTF_VARCHAR2_TABLE_100;
7308: l_default_rendition NUMBER;
7309: BEGIN
7310: get_trans_item(
7311: p_citem_ver_id => p_citem_ver_id

Line 7405: ,x_attribute_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100

7401: ,x_created_by OUT NOCOPY NUMBER
7402: ,x_creation_date OUT NOCOPY DATE
7403: ,x_last_updated_by OUT NOCOPY NUMBER
7404: ,x_last_update_date OUT NOCOPY DATE
7405: ,x_attribute_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100
7406: ,x_attribute_type_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
7407: ,x_attributes OUT NOCOPY JTF_VARCHAR2_TABLE_4000
7408: ,x_component_citems OUT NOCOPY JTF_NUMBER_TABLE
7409: ,x_component_attrib_types OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 7409: ,x_component_attrib_types OUT NOCOPY JTF_VARCHAR2_TABLE_100

7405: ,x_attribute_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100
7406: ,x_attribute_type_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
7407: ,x_attributes OUT NOCOPY JTF_VARCHAR2_TABLE_4000
7408: ,x_component_citems OUT NOCOPY JTF_NUMBER_TABLE
7409: ,x_component_attrib_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
7410: ,x_component_citem_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
7411: ,x_component_owner_ids OUT NOCOPY JTF_NUMBER_TABLE
7412: ,x_component_owner_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
7413: ,x_component_sort_orders OUT NOCOPY JTF_NUMBER_TABLE

Line 7412: ,x_component_owner_types OUT NOCOPY JTF_VARCHAR2_TABLE_100

7408: ,x_component_citems OUT NOCOPY JTF_NUMBER_TABLE
7409: ,x_component_attrib_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
7410: ,x_component_citem_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
7411: ,x_component_owner_ids OUT NOCOPY JTF_NUMBER_TABLE
7412: ,x_component_owner_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
7413: ,x_component_sort_orders OUT NOCOPY JTF_NUMBER_TABLE
7414: ,x_return_status OUT NOCOPY VARCHAR2
7415: ,x_msg_count OUT NOCOPY NUMBER
7416: ,x_msg_data OUT NOCOPY VARCHAR2

Line 7498: ,x_attach_mime_types OUT NOCOPY JTF_VARCHAR2_TABLE_100

7494: ,x_locked_by OUT NOCOPY NUMBER
7495: ,x_wd_restricted OUT NOCOPY VARCHAR2
7496: ,x_attach_file_ids OUT NOCOPY JTF_NUMBER_TABLE
7497: ,x_attach_file_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
7498: ,x_attach_mime_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
7499: ,x_attach_mime_names OUT NOCOPY JTF_VARCHAR2_TABLE_100
7500: ,x_default_rendition OUT NOCOPY NUMBER
7501: ,x_object_version_number OUT NOCOPY NUMBER
7502: ,x_created_by OUT NOCOPY NUMBER

Line 7499: ,x_attach_mime_names OUT NOCOPY JTF_VARCHAR2_TABLE_100

7495: ,x_wd_restricted OUT NOCOPY VARCHAR2
7496: ,x_attach_file_ids OUT NOCOPY JTF_NUMBER_TABLE
7497: ,x_attach_file_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
7498: ,x_attach_mime_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
7499: ,x_attach_mime_names OUT NOCOPY JTF_VARCHAR2_TABLE_100
7500: ,x_default_rendition OUT NOCOPY NUMBER
7501: ,x_object_version_number OUT NOCOPY NUMBER
7502: ,x_created_by OUT NOCOPY NUMBER
7503: ,x_creation_date OUT NOCOPY DATE

Line 7506: ,x_attribute_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100

7502: ,x_created_by OUT NOCOPY NUMBER
7503: ,x_creation_date OUT NOCOPY DATE
7504: ,x_last_updated_by OUT NOCOPY NUMBER
7505: ,x_last_update_date OUT NOCOPY DATE
7506: ,x_attribute_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100
7507: ,x_attribute_type_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
7508: ,x_attributes OUT NOCOPY JTF_VARCHAR2_TABLE_4000
7509: ,x_component_citems OUT NOCOPY JTF_NUMBER_TABLE
7510: ,x_component_attrib_types OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 7510: ,x_component_attrib_types OUT NOCOPY JTF_VARCHAR2_TABLE_100

7506: ,x_attribute_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100
7507: ,x_attribute_type_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
7508: ,x_attributes OUT NOCOPY JTF_VARCHAR2_TABLE_4000
7509: ,x_component_citems OUT NOCOPY JTF_NUMBER_TABLE
7510: ,x_component_attrib_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
7511: ,x_component_citem_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
7512: ,x_component_owner_ids OUT NOCOPY JTF_NUMBER_TABLE
7513: ,x_component_owner_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
7514: ,x_component_sort_orders OUT NOCOPY JTF_NUMBER_TABLE

Line 7513: ,x_component_owner_types OUT NOCOPY JTF_VARCHAR2_TABLE_100

7509: ,x_component_citems OUT NOCOPY JTF_NUMBER_TABLE
7510: ,x_component_attrib_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
7511: ,x_component_citem_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
7512: ,x_component_owner_ids OUT NOCOPY JTF_NUMBER_TABLE
7513: ,x_component_owner_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
7514: ,x_component_sort_orders OUT NOCOPY JTF_NUMBER_TABLE
7515: ,x_return_status OUT NOCOPY VARCHAR2
7516: ,x_msg_count OUT NOCOPY NUMBER
7517: ,x_msg_data OUT NOCOPY VARCHAR2

Line 7602: ,x_attach_mime_types OUT NOCOPY JTF_VARCHAR2_TABLE_100

7598: ,x_locked_by OUT NOCOPY NUMBER
7599: ,x_wd_restricted OUT NOCOPY VARCHAR2
7600: ,x_attach_file_ids OUT NOCOPY JTF_NUMBER_TABLE
7601: ,x_attach_file_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
7602: ,x_attach_mime_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
7603: ,x_attach_mime_names OUT NOCOPY JTF_VARCHAR2_TABLE_100
7604: ,x_default_rendition OUT NOCOPY NUMBER
7605: ,x_object_version_number OUT NOCOPY NUMBER
7606: ,x_created_by OUT NOCOPY NUMBER

Line 7603: ,x_attach_mime_names OUT NOCOPY JTF_VARCHAR2_TABLE_100

7599: ,x_wd_restricted OUT NOCOPY VARCHAR2
7600: ,x_attach_file_ids OUT NOCOPY JTF_NUMBER_TABLE
7601: ,x_attach_file_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
7602: ,x_attach_mime_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
7603: ,x_attach_mime_names OUT NOCOPY JTF_VARCHAR2_TABLE_100
7604: ,x_default_rendition OUT NOCOPY NUMBER
7605: ,x_object_version_number OUT NOCOPY NUMBER
7606: ,x_created_by OUT NOCOPY NUMBER
7607: ,x_creation_date OUT NOCOPY DATE

Line 7610: ,x_attribute_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100

7606: ,x_created_by OUT NOCOPY NUMBER
7607: ,x_creation_date OUT NOCOPY DATE
7608: ,x_last_updated_by OUT NOCOPY NUMBER
7609: ,x_last_update_date OUT NOCOPY DATE
7610: ,x_attribute_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100
7611: ,x_attribute_type_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
7612: ,x_attributes OUT NOCOPY JTF_VARCHAR2_TABLE_4000
7613: ,x_component_citems OUT NOCOPY JTF_NUMBER_TABLE
7614: ,x_component_citem_ver_ids OUT NOCOPY JTF_NUMBER_TABLE

Line 7615: ,x_component_attrib_types OUT NOCOPY JTF_VARCHAR2_TABLE_100

7611: ,x_attribute_type_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
7612: ,x_attributes OUT NOCOPY JTF_VARCHAR2_TABLE_4000
7613: ,x_component_citems OUT NOCOPY JTF_NUMBER_TABLE
7614: ,x_component_citem_ver_ids OUT NOCOPY JTF_NUMBER_TABLE
7615: ,x_component_attrib_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
7616: ,x_component_citem_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
7617: ,x_component_owner_ids OUT NOCOPY JTF_NUMBER_TABLE
7618: ,x_component_owner_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
7619: ,x_component_sort_orders OUT NOCOPY JTF_NUMBER_TABLE

Line 7618: ,x_component_owner_types OUT NOCOPY JTF_VARCHAR2_TABLE_100

7614: ,x_component_citem_ver_ids OUT NOCOPY JTF_NUMBER_TABLE
7615: ,x_component_attrib_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
7616: ,x_component_citem_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
7617: ,x_component_owner_ids OUT NOCOPY JTF_NUMBER_TABLE
7618: ,x_component_owner_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
7619: ,x_component_sort_orders OUT NOCOPY JTF_NUMBER_TABLE
7620: ,x_return_status OUT NOCOPY VARCHAR2
7621: ,x_msg_count OUT NOCOPY NUMBER
7622: ,x_msg_data OUT NOCOPY VARCHAR2

Line 7708: ,x_attach_mime_types OUT NOCOPY JTF_VARCHAR2_TABLE_100

7704: ,x_locked_by OUT NOCOPY NUMBER
7705: ,x_wd_restricted OUT NOCOPY VARCHAR2
7706: ,x_attach_file_ids OUT NOCOPY JTF_NUMBER_TABLE
7707: ,x_attach_file_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
7708: ,x_attach_mime_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
7709: ,x_attach_mime_names OUT NOCOPY JTF_VARCHAR2_TABLE_100
7710: ,x_default_rendition OUT NOCOPY NUMBER
7711: ,x_object_version_number OUT NOCOPY NUMBER
7712: ,x_created_by OUT NOCOPY NUMBER

Line 7709: ,x_attach_mime_names OUT NOCOPY JTF_VARCHAR2_TABLE_100

7705: ,x_wd_restricted OUT NOCOPY VARCHAR2
7706: ,x_attach_file_ids OUT NOCOPY JTF_NUMBER_TABLE
7707: ,x_attach_file_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
7708: ,x_attach_mime_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
7709: ,x_attach_mime_names OUT NOCOPY JTF_VARCHAR2_TABLE_100
7710: ,x_default_rendition OUT NOCOPY NUMBER
7711: ,x_object_version_number OUT NOCOPY NUMBER
7712: ,x_created_by OUT NOCOPY NUMBER
7713: ,x_creation_date OUT NOCOPY DATE

Line 7716: ,x_attribute_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100

7712: ,x_created_by OUT NOCOPY NUMBER
7713: ,x_creation_date OUT NOCOPY DATE
7714: ,x_last_updated_by OUT NOCOPY NUMBER
7715: ,x_last_update_date OUT NOCOPY DATE
7716: ,x_attribute_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100
7717: ,x_attribute_type_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
7718: ,x_attributes OUT NOCOPY JTF_VARCHAR2_TABLE_4000
7719: ,x_component_citems OUT NOCOPY JTF_NUMBER_TABLE
7720: ,x_component_citem_ver_ids OUT NOCOPY JTF_NUMBER_TABLE

Line 7721: ,x_component_attrib_types OUT NOCOPY JTF_VARCHAR2_TABLE_100

7717: ,x_attribute_type_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
7718: ,x_attributes OUT NOCOPY JTF_VARCHAR2_TABLE_4000
7719: ,x_component_citems OUT NOCOPY JTF_NUMBER_TABLE
7720: ,x_component_citem_ver_ids OUT NOCOPY JTF_NUMBER_TABLE
7721: ,x_component_attrib_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
7722: ,x_component_citem_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
7723: ,x_component_owner_ids OUT NOCOPY JTF_NUMBER_TABLE
7724: ,x_component_owner_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
7725: ,x_component_sort_orders OUT NOCOPY JTF_NUMBER_TABLE

Line 7724: ,x_component_owner_types OUT NOCOPY JTF_VARCHAR2_TABLE_100

7720: ,x_component_citem_ver_ids OUT NOCOPY JTF_NUMBER_TABLE
7721: ,x_component_attrib_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
7722: ,x_component_citem_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
7723: ,x_component_owner_ids OUT NOCOPY JTF_NUMBER_TABLE
7724: ,x_component_owner_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
7725: ,x_component_sort_orders OUT NOCOPY JTF_NUMBER_TABLE
7726: ,x_keywords OUT NOCOPY JTF_VARCHAR2_TABLE_100
7727: ,x_return_status OUT NOCOPY VARCHAR2
7728: ,x_msg_count OUT NOCOPY NUMBER

Line 7726: ,x_keywords OUT NOCOPY JTF_VARCHAR2_TABLE_100

7722: ,x_component_citem_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
7723: ,x_component_owner_ids OUT NOCOPY JTF_NUMBER_TABLE
7724: ,x_component_owner_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
7725: ,x_component_sort_orders OUT NOCOPY JTF_NUMBER_TABLE
7726: ,x_keywords OUT NOCOPY JTF_VARCHAR2_TABLE_100
7727: ,x_return_status OUT NOCOPY VARCHAR2
7728: ,x_msg_count OUT NOCOPY NUMBER
7729: ,x_msg_data OUT NOCOPY VARCHAR2
7730: )

Line 7821: ,x_rendition_mime_types OUT NOCOPY JTF_VARCHAR2_TABLE_100

7817: ,x_attach_mime_type OUT NOCOPY VARCHAR2
7818: ,x_attach_mime_name OUT NOCOPY VARCHAR2
7819: ,x_rendition_file_ids OUT NOCOPY JTF_NUMBER_TABLE
7820: ,x_rendition_file_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
7821: ,x_rendition_mime_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
7822: ,x_rendition_mime_names OUT NOCOPY JTF_VARCHAR2_TABLE_100
7823: ,x_default_rendition OUT NOCOPY NUMBER
7824: ,x_object_version_number OUT NOCOPY NUMBER
7825: ,x_created_by OUT NOCOPY NUMBER

Line 7822: ,x_rendition_mime_names OUT NOCOPY JTF_VARCHAR2_TABLE_100

7818: ,x_attach_mime_name OUT NOCOPY VARCHAR2
7819: ,x_rendition_file_ids OUT NOCOPY JTF_NUMBER_TABLE
7820: ,x_rendition_file_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
7821: ,x_rendition_mime_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
7822: ,x_rendition_mime_names OUT NOCOPY JTF_VARCHAR2_TABLE_100
7823: ,x_default_rendition OUT NOCOPY NUMBER
7824: ,x_object_version_number OUT NOCOPY NUMBER
7825: ,x_created_by OUT NOCOPY NUMBER
7826: ,x_creation_date OUT NOCOPY DATE

Line 7829: ,x_attribute_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100

7825: ,x_created_by OUT NOCOPY NUMBER
7826: ,x_creation_date OUT NOCOPY DATE
7827: ,x_last_updated_by OUT NOCOPY NUMBER
7828: ,x_last_update_date OUT NOCOPY DATE
7829: ,x_attribute_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100
7830: ,x_attribute_type_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
7831: ,x_attributes OUT NOCOPY JTF_VARCHAR2_TABLE_4000
7832: ,x_component_citems OUT NOCOPY JTF_NUMBER_TABLE
7833: ,x_component_citem_ver_ids OUT NOCOPY JTF_NUMBER_TABLE

Line 7834: ,x_component_attrib_types OUT NOCOPY JTF_VARCHAR2_TABLE_100

7830: ,x_attribute_type_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
7831: ,x_attributes OUT NOCOPY JTF_VARCHAR2_TABLE_4000
7832: ,x_component_citems OUT NOCOPY JTF_NUMBER_TABLE
7833: ,x_component_citem_ver_ids OUT NOCOPY JTF_NUMBER_TABLE
7834: ,x_component_attrib_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
7835: ,x_component_citem_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
7836: ,x_component_owner_ids OUT NOCOPY JTF_NUMBER_TABLE
7837: ,x_component_owner_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
7838: ,x_component_sort_orders OUT NOCOPY JTF_NUMBER_TABLE

Line 7837: ,x_component_owner_types OUT NOCOPY JTF_VARCHAR2_TABLE_100

7833: ,x_component_citem_ver_ids OUT NOCOPY JTF_NUMBER_TABLE
7834: ,x_component_attrib_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
7835: ,x_component_citem_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
7836: ,x_component_owner_ids OUT NOCOPY JTF_NUMBER_TABLE
7837: ,x_component_owner_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
7838: ,x_component_sort_orders OUT NOCOPY JTF_NUMBER_TABLE
7839: ,x_keywords OUT NOCOPY JTF_VARCHAR2_TABLE_100
7840: ,x_return_status OUT NOCOPY VARCHAR2
7841: ,x_msg_count OUT NOCOPY NUMBER

Line 7839: ,x_keywords OUT NOCOPY JTF_VARCHAR2_TABLE_100

7835: ,x_component_citem_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
7836: ,x_component_owner_ids OUT NOCOPY JTF_NUMBER_TABLE
7837: ,x_component_owner_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
7838: ,x_component_sort_orders OUT NOCOPY JTF_NUMBER_TABLE
7839: ,x_keywords OUT NOCOPY JTF_VARCHAR2_TABLE_100
7840: ,x_return_status OUT NOCOPY VARCHAR2
7841: ,x_msg_count OUT NOCOPY NUMBER
7842: ,x_msg_data OUT NOCOPY VARCHAR2
7843: ) IS

Line 7936: ,x_rendition_mime_types OUT NOCOPY JTF_VARCHAR2_TABLE_100

7932: ,x_attach_mime_type OUT NOCOPY VARCHAR2
7933: ,x_attach_mime_name OUT NOCOPY VARCHAR2
7934: ,x_rendition_file_ids OUT NOCOPY JTF_NUMBER_TABLE
7935: ,x_rendition_file_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
7936: ,x_rendition_mime_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
7937: ,x_rendition_mime_names OUT NOCOPY JTF_VARCHAR2_TABLE_100
7938: ,x_default_rendition OUT NOCOPY NUMBER
7939: ,x_object_version_number OUT NOCOPY NUMBER
7940: ,x_created_by OUT NOCOPY NUMBER

Line 7937: ,x_rendition_mime_names OUT NOCOPY JTF_VARCHAR2_TABLE_100

7933: ,x_attach_mime_name OUT NOCOPY VARCHAR2
7934: ,x_rendition_file_ids OUT NOCOPY JTF_NUMBER_TABLE
7935: ,x_rendition_file_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
7936: ,x_rendition_mime_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
7937: ,x_rendition_mime_names OUT NOCOPY JTF_VARCHAR2_TABLE_100
7938: ,x_default_rendition OUT NOCOPY NUMBER
7939: ,x_object_version_number OUT NOCOPY NUMBER
7940: ,x_created_by OUT NOCOPY NUMBER
7941: ,x_creation_date OUT NOCOPY DATE

Line 7944: ,x_attribute_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100

7940: ,x_created_by OUT NOCOPY NUMBER
7941: ,x_creation_date OUT NOCOPY DATE
7942: ,x_last_updated_by OUT NOCOPY NUMBER
7943: ,x_last_update_date OUT NOCOPY DATE
7944: ,x_attribute_type_codes OUT NOCOPY JTF_VARCHAR2_TABLE_100
7945: ,x_attribute_type_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
7946: ,x_attributes OUT NOCOPY JTF_VARCHAR2_TABLE_32767
7947: ,x_component_citems OUT NOCOPY JTF_NUMBER_TABLE
7948: ,x_component_citem_ver_ids OUT NOCOPY JTF_NUMBER_TABLE

Line 7949: ,x_component_attrib_types OUT NOCOPY JTF_VARCHAR2_TABLE_100

7945: ,x_attribute_type_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
7946: ,x_attributes OUT NOCOPY JTF_VARCHAR2_TABLE_32767
7947: ,x_component_citems OUT NOCOPY JTF_NUMBER_TABLE
7948: ,x_component_citem_ver_ids OUT NOCOPY JTF_NUMBER_TABLE
7949: ,x_component_attrib_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
7950: ,x_component_citem_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
7951: ,x_component_owner_ids OUT NOCOPY JTF_NUMBER_TABLE
7952: ,x_component_owner_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
7953: ,x_component_sort_orders OUT NOCOPY JTF_NUMBER_TABLE

Line 7952: ,x_component_owner_types OUT NOCOPY JTF_VARCHAR2_TABLE_100

7948: ,x_component_citem_ver_ids OUT NOCOPY JTF_NUMBER_TABLE
7949: ,x_component_attrib_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
7950: ,x_component_citem_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
7951: ,x_component_owner_ids OUT NOCOPY JTF_NUMBER_TABLE
7952: ,x_component_owner_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
7953: ,x_component_sort_orders OUT NOCOPY JTF_NUMBER_TABLE
7954: ,x_keywords OUT NOCOPY JTF_VARCHAR2_TABLE_100
7955: ,x_return_status OUT NOCOPY VARCHAR2
7956: ,x_msg_count OUT NOCOPY NUMBER

Line 7954: ,x_keywords OUT NOCOPY JTF_VARCHAR2_TABLE_100

7950: ,x_component_citem_names OUT NOCOPY JTF_VARCHAR2_TABLE_300
7951: ,x_component_owner_ids OUT NOCOPY JTF_NUMBER_TABLE
7952: ,x_component_owner_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
7953: ,x_component_sort_orders OUT NOCOPY JTF_NUMBER_TABLE
7954: ,x_keywords OUT NOCOPY JTF_VARCHAR2_TABLE_100
7955: ,x_return_status OUT NOCOPY VARCHAR2
7956: ,x_msg_count OUT NOCOPY NUMBER
7957: ,x_msg_data OUT NOCOPY VARCHAR2
7958: ) IS

Line 8033: ,p_attribute_type_codes IN JTF_VARCHAR2_TABLE_100

8029: PROCEDURE insert_components(
8030: p_citem_ver_id IN NUMBER
8031: ,p_content_item_ids IN JTF_NUMBER_TABLE
8032: ,p_citem_ver_ids IN JTF_NUMBER_TABLE
8033: ,p_attribute_type_codes IN JTF_VARCHAR2_TABLE_100
8034: ,p_sort_order IN JTF_NUMBER_TABLE
8035: ,p_commit IN VARCHAR2
8036: ,p_api_version_number IN NUMBER
8037: ,p_init_msg_list IN VARCHAR2

Line 8283: ,p_attribute_type_codes IN JTF_VARCHAR2_TABLE_100

8279: -- --------------------------------------------------------------
8280: PROCEDURE insert_components(
8281: p_citem_ver_id IN NUMBER
8282: ,p_content_item_ids IN JTF_NUMBER_TABLE
8283: ,p_attribute_type_codes IN JTF_VARCHAR2_TABLE_100
8284: ,p_sort_order IN JTF_NUMBER_TABLE
8285: ,p_commit IN VARCHAR2
8286: ,p_api_version_number IN NUMBER
8287: ,p_init_msg_list IN VARCHAR2

Line 8321: ,p_assoc_type_codes IN JTF_VARCHAR2_TABLE_100

8317: -- --------------------------------------------------------------
8318:
8319: PROCEDURE insert_associations(
8320: p_content_item_id IN NUMBER
8321: ,p_assoc_type_codes IN JTF_VARCHAR2_TABLE_100
8322: ,p_assoc_objects1 IN JTF_VARCHAR2_TABLE_300
8323: ,p_assoc_objects2 IN JTF_VARCHAR2_TABLE_300
8324: ,p_assoc_objects3 IN JTF_VARCHAR2_TABLE_300
8325: ,p_assoc_objects4 IN JTF_VARCHAR2_TABLE_300

Line 8357: ,p_assoc_type_codes IN JTF_VARCHAR2_TABLE_100

8353:
8354: PROCEDURE insert_associations(
8355: p_content_item_id IN NUMBER
8356: ,p_citem_version_id IN NUMBER
8357: ,p_assoc_type_codes IN JTF_VARCHAR2_TABLE_100
8358: ,p_assoc_objects1 IN JTF_VARCHAR2_TABLE_300
8359: ,p_assoc_objects2 IN JTF_VARCHAR2_TABLE_300
8360: ,p_assoc_objects3 IN JTF_VARCHAR2_TABLE_300
8361: ,p_assoc_objects4 IN JTF_VARCHAR2_TABLE_300

Line 9414: ,p_attribute_type_codes IN JTF_VARCHAR2_TABLE_100

9410: --
9411: -- --------------------------------------------------------------
9412: PROCEDURE set_attribute_bundle(
9413: p_citem_ver_id IN NUMBER
9414: ,p_attribute_type_codes IN JTF_VARCHAR2_TABLE_100
9415: ,p_attributes IN JTF_VARCHAR2_TABLE_32767
9416: ,p_remove_old IN VARCHAR2
9417: ,p_commit IN VARCHAR2
9418: ,p_api_version_number IN NUMBER

Line 9731: ,p_attribute_type_codes IN JTF_VARCHAR2_TABLE_100

9727:
9728: -- Overloaded to support old 4K limit on attribute values
9729: PROCEDURE set_attribute_bundle(
9730: p_citem_ver_id IN NUMBER
9731: ,p_attribute_type_codes IN JTF_VARCHAR2_TABLE_100
9732: ,p_attributes IN JTF_VARCHAR2_TABLE_4000
9733: ,p_remove_old IN VARCHAR2
9734: ,p_commit IN VARCHAR2
9735: ,p_api_version_number IN NUMBER

Line 11537: ,p_attribute_type_codes IN JTF_VARCHAR2_TABLE_100

11533: ,p_lock_flag IN VARCHAR2
11534: ,p_wd_restricted IN VARCHAR2
11535: ,p_start_date IN DATE
11536: ,p_end_date IN DATE
11537: ,p_attribute_type_codes IN JTF_VARCHAR2_TABLE_100
11538: ,p_attributes IN JTF_VARCHAR2_TABLE_32767
11539: ,p_attach_file_id IN NUMBER
11540: ,p_item_renditions IN JTF_NUMBER_TABLE
11541: ,p_default_rendition IN NUMBER

Line 11544: ,p_component_atypes IN JTF_VARCHAR2_TABLE_100

11540: ,p_item_renditions IN JTF_NUMBER_TABLE
11541: ,p_default_rendition IN NUMBER
11542: ,p_component_citems IN JTF_NUMBER_TABLE
11543: ,p_component_citem_ver_ids IN JTF_NUMBER_TABLE
11544: ,p_component_atypes IN JTF_VARCHAR2_TABLE_100
11545: ,p_sort_order IN JTF_NUMBER_TABLE
11546: ,p_keywords IN JTF_VARCHAR2_TABLE_100
11547: ,p_status IN VARCHAR2
11548: ,p_log_action IN VARCHAR2

Line 11546: ,p_keywords IN JTF_VARCHAR2_TABLE_100

11542: ,p_component_citems IN JTF_NUMBER_TABLE
11543: ,p_component_citem_ver_ids IN JTF_NUMBER_TABLE
11544: ,p_component_atypes IN JTF_VARCHAR2_TABLE_100
11545: ,p_sort_order IN JTF_NUMBER_TABLE
11546: ,p_keywords IN JTF_VARCHAR2_TABLE_100
11547: ,p_status IN VARCHAR2
11548: ,p_log_action IN VARCHAR2
11549: ,p_language IN VARCHAR2
11550: ,p_update IN VARCHAR2

Line 11588: perm_code JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

11584: base_lang IBC_CITEM_VERSIONS_TL.LANGUAGE%TYPE;
11585: temp VARCHAR2(10); -- throw away variable
11586: do_item CHAR(1);
11587: do_version CHAR(1);
11588: perm_code JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();
11589: p_new_owner_resource_type VARCHAR2(11);
11590: p_new_owner_resource_id NUMBER;
11591:
11592:

Line 12644: ,p_attribute_type_codes IN JTF_VARCHAR2_TABLE_100

12640: ,p_lock_flag IN VARCHAR2
12641: ,p_wd_restricted IN VARCHAR2
12642: ,p_start_date IN DATE
12643: ,p_end_date IN DATE
12644: ,p_attribute_type_codes IN JTF_VARCHAR2_TABLE_100
12645: ,p_attributes IN JTF_VARCHAR2_TABLE_4000
12646: ,p_attach_file_id IN NUMBER
12647: ,p_item_renditions IN JTF_NUMBER_TABLE
12648: ,p_default_rendition IN NUMBER

Line 12651: ,p_component_atypes IN JTF_VARCHAR2_TABLE_100

12647: ,p_item_renditions IN JTF_NUMBER_TABLE
12648: ,p_default_rendition IN NUMBER
12649: ,p_component_citems IN JTF_NUMBER_TABLE
12650: ,p_component_citem_ver_ids IN JTF_NUMBER_TABLE
12651: ,p_component_atypes IN JTF_VARCHAR2_TABLE_100
12652: ,p_sort_order IN JTF_NUMBER_TABLE
12653: ,p_keywords IN JTF_VARCHAR2_TABLE_100
12654: ,p_status IN VARCHAR2
12655: ,p_log_action IN VARCHAR2

Line 12653: ,p_keywords IN JTF_VARCHAR2_TABLE_100

12649: ,p_component_citems IN JTF_NUMBER_TABLE
12650: ,p_component_citem_ver_ids IN JTF_NUMBER_TABLE
12651: ,p_component_atypes IN JTF_VARCHAR2_TABLE_100
12652: ,p_sort_order IN JTF_NUMBER_TABLE
12653: ,p_keywords IN JTF_VARCHAR2_TABLE_100
12654: ,p_status IN VARCHAR2
12655: ,p_log_action IN VARCHAR2
12656: ,p_language IN VARCHAR2
12657: ,p_update IN VARCHAR2

Line 12743: ,p_attribute_type_codes IN JTF_VARCHAR2_TABLE_100

12739: ,p_lock_flag IN VARCHAR2
12740: ,p_wd_restricted IN VARCHAR2
12741: ,p_start_date IN DATE
12742: ,p_end_date IN DATE
12743: ,p_attribute_type_codes IN JTF_VARCHAR2_TABLE_100
12744: ,p_attributes IN JTF_VARCHAR2_TABLE_4000
12745: ,p_attach_file_ids IN JTF_NUMBER_TABLE
12746: ,p_default_rendition IN NUMBER
12747: ,p_component_citems IN JTF_NUMBER_TABLE

Line 12749: ,p_component_atypes IN JTF_VARCHAR2_TABLE_100

12745: ,p_attach_file_ids IN JTF_NUMBER_TABLE
12746: ,p_default_rendition IN NUMBER
12747: ,p_component_citems IN JTF_NUMBER_TABLE
12748: ,p_component_citem_ver_ids IN JTF_NUMBER_TABLE
12749: ,p_component_atypes IN JTF_VARCHAR2_TABLE_100
12750: ,p_sort_order IN JTF_NUMBER_TABLE
12751: ,p_keywords IN JTF_VARCHAR2_TABLE_100
12752: ,p_status IN VARCHAR2
12753: ,p_log_action IN VARCHAR2

Line 12751: ,p_keywords IN JTF_VARCHAR2_TABLE_100

12747: ,p_component_citems IN JTF_NUMBER_TABLE
12748: ,p_component_citem_ver_ids IN JTF_NUMBER_TABLE
12749: ,p_component_atypes IN JTF_VARCHAR2_TABLE_100
12750: ,p_sort_order IN JTF_NUMBER_TABLE
12751: ,p_keywords IN JTF_VARCHAR2_TABLE_100
12752: ,p_status IN VARCHAR2
12753: ,p_log_action IN VARCHAR2
12754: ,p_language IN VARCHAR2
12755: ,p_update IN VARCHAR2

Line 12834: ,p_attribute_type_codes IN JTF_VARCHAR2_TABLE_100

12830: ,p_lock_flag IN VARCHAR2
12831: ,p_wd_restricted IN VARCHAR2
12832: ,p_start_date IN DATE
12833: ,p_end_date IN DATE
12834: ,p_attribute_type_codes IN JTF_VARCHAR2_TABLE_100
12835: ,p_attributes IN JTF_VARCHAR2_TABLE_4000
12836: ,p_attach_file_ids IN JTF_NUMBER_TABLE
12837: ,p_default_rendition IN NUMBER
12838: ,p_component_citems IN JTF_NUMBER_TABLE

Line 12840: ,p_component_atypes IN JTF_VARCHAR2_TABLE_100

12836: ,p_attach_file_ids IN JTF_NUMBER_TABLE
12837: ,p_default_rendition IN NUMBER
12838: ,p_component_citems IN JTF_NUMBER_TABLE
12839: ,p_component_citem_ver_ids IN JTF_NUMBER_TABLE
12840: ,p_component_atypes IN JTF_VARCHAR2_TABLE_100
12841: ,p_sort_order IN JTF_NUMBER_TABLE
12842: ,p_status IN VARCHAR2
12843: ,p_log_action IN VARCHAR2
12844: ,p_language IN VARCHAR2

Line 12919: ,p_attribute_type_codes IN JTF_VARCHAR2_TABLE_100

12915: ,p_lock_flag IN VARCHAR2
12916: ,p_wd_restricted IN VARCHAR2
12917: ,p_start_date IN DATE
12918: ,p_end_date IN DATE
12919: ,p_attribute_type_codes IN JTF_VARCHAR2_TABLE_100
12920: ,p_attributes IN JTF_VARCHAR2_TABLE_4000
12921: ,p_attach_file_ids IN JTF_NUMBER_TABLE
12922: ,p_default_rendition IN NUMBER
12923: ,p_component_citems IN JTF_NUMBER_TABLE

Line 12924: ,p_component_atypes IN JTF_VARCHAR2_TABLE_100

12920: ,p_attributes IN JTF_VARCHAR2_TABLE_4000
12921: ,p_attach_file_ids IN JTF_NUMBER_TABLE
12922: ,p_default_rendition IN NUMBER
12923: ,p_component_citems IN JTF_NUMBER_TABLE
12924: ,p_component_atypes IN JTF_VARCHAR2_TABLE_100
12925: ,p_sort_order IN JTF_NUMBER_TABLE
12926: ,p_status IN VARCHAR2
12927: ,p_log_action IN VARCHAR2
12928: ,p_language IN VARCHAR2

Line 13001: ,p_attribute_type_codes IN JTF_VARCHAR2_TABLE_100

12997: ,p_lock_flag IN VARCHAR2
12998: ,p_wd_restricted IN VARCHAR2
12999: ,p_start_date IN DATE
13000: ,p_end_date IN DATE
13001: ,p_attribute_type_codes IN JTF_VARCHAR2_TABLE_100
13002: ,p_attributes IN JTF_VARCHAR2_TABLE_4000
13003: ,p_attach_file_id IN NUMBER
13004: ,p_component_citems IN JTF_NUMBER_TABLE
13005: ,p_component_atypes IN JTF_VARCHAR2_TABLE_100

Line 13005: ,p_component_atypes IN JTF_VARCHAR2_TABLE_100

13001: ,p_attribute_type_codes IN JTF_VARCHAR2_TABLE_100
13002: ,p_attributes IN JTF_VARCHAR2_TABLE_4000
13003: ,p_attach_file_id IN NUMBER
13004: ,p_component_citems IN JTF_NUMBER_TABLE
13005: ,p_component_atypes IN JTF_VARCHAR2_TABLE_100
13006: ,p_sort_order IN JTF_NUMBER_TABLE
13007: ,p_status IN VARCHAR2
13008: ,p_log_action IN VARCHAR2
13009: ,p_language IN VARCHAR2

Line 13092: ,p_attribute_type_codes IN JTF_VARCHAR2_TABLE_100

13088: ,p_lock_flag IN VARCHAR2
13089: ,p_wd_restricted IN VARCHAR2
13090: ,p_start_date IN DATE
13091: ,p_end_date IN DATE
13092: ,p_attribute_type_codes IN JTF_VARCHAR2_TABLE_100
13093: ,p_attributes IN JTF_VARCHAR2_TABLE_4000
13094: ,p_attach_file_id IN NUMBER
13095: ,p_component_citems IN JTF_NUMBER_TABLE
13096: ,p_component_atypes IN JTF_VARCHAR2_TABLE_100

Line 13096: ,p_component_atypes IN JTF_VARCHAR2_TABLE_100

13092: ,p_attribute_type_codes IN JTF_VARCHAR2_TABLE_100
13093: ,p_attributes IN JTF_VARCHAR2_TABLE_4000
13094: ,p_attach_file_id IN NUMBER
13095: ,p_component_citems IN JTF_NUMBER_TABLE
13096: ,p_component_atypes IN JTF_VARCHAR2_TABLE_100
13097: ,p_sort_order IN JTF_NUMBER_TABLE
13098: ,p_status IN VARCHAR2
13099: ,p_log_action IN VARCHAR2
13100: ,p_language IN VARCHAR2

Line 13172: ,p_attribute_type_codes IN JTF_VARCHAR2_TABLE_100

13168: ,p_lock_flag IN VARCHAR2
13169: ,p_wd_restricted IN VARCHAR2
13170: ,p_start_date IN DATE
13171: ,p_end_date IN DATE
13172: ,p_attribute_type_codes IN JTF_VARCHAR2_TABLE_100
13173: ,p_attributes IN JTF_VARCHAR2_TABLE_4000
13174: ,p_attach_file_ids IN JTF_NUMBER_TABLE
13175: ,p_default_rendition IN NUMBER
13176: ,p_component_citems IN JTF_NUMBER_TABLE

Line 13177: ,p_component_atypes IN JTF_VARCHAR2_TABLE_100

13173: ,p_attributes IN JTF_VARCHAR2_TABLE_4000
13174: ,p_attach_file_ids IN JTF_NUMBER_TABLE
13175: ,p_default_rendition IN NUMBER
13176: ,p_component_citems IN JTF_NUMBER_TABLE
13177: ,p_component_atypes IN JTF_VARCHAR2_TABLE_100
13178: ,p_sort_order IN JTF_NUMBER_TABLE
13179: ,p_status IN VARCHAR2
13180: ,p_log_action IN VARCHAR2
13181: ,p_language IN VARCHAR2