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_NUMBER_TABLE

Line 2057: ,p_content_item_ids IN JTF_NUMBER_TABLE

2053: -- --------------------------------------------------------------
2054: PROCEDURE insert_component_items_int(
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

Line 2058: ,p_citem_ver_ids IN JTF_NUMBER_TABLE DEFAULT NULL

2054: PROCEDURE insert_component_items_int(
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

Line 2061: ,p_sort_order IN JTF_NUMBER_TABLE DEFAULT NULL

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
2064: )
2065: IS

Line 6120: ,x_rendition_file_ids OUT NOCOPY JTF_NUMBER_TABLE

6116: ,x_attach_file_id OUT NOCOPY NUMBER
6117: ,x_attach_file_name OUT NOCOPY VARCHAR2
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

Line 6133: ,x_component_citems OUT NOCOPY JTF_NUMBER_TABLE

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

Line 6134: ,x_component_citem_ver_ids OUT NOCOPY JTF_NUMBER_TABLE

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

Line 6137: ,x_component_owner_ids OUT NOCOPY JTF_NUMBER_TABLE

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
6140: ,x_keywords OUT NOCOPY JTF_VARCHAR2_TABLE_100
6141: ,x_return_status OUT NOCOPY VARCHAR2

Line 6139: ,x_component_sort_orders 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
6143: ,x_msg_data OUT NOCOPY VARCHAR2

Line 6416: x_rendition_file_ids := JTF_NUMBER_TABLE();

6412: FOR r_rendition IN c_renditions(p_citem_ver_id, lang) LOOP
6413: l_index := c_renditions%ROWCOUNT;
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;

Line 6462: x_component_citems := JTF_NUMBER_TABLE();

6458: FOR r_component IN c_components(p_citem_ver_id, lang) LOOP
6459: l_index := c_components%ROWCOUNT;
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();

Line 6463: x_component_citem_ver_ids := JTF_NUMBER_TABLE();

6459: l_index := c_components%ROWCOUNT;
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();

Line 6466: x_component_sort_orders := JTF_NUMBER_TABLE();

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();
6469: END IF;
6470:

Line 6467: x_component_owner_ids := 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();
6469: END IF;
6470:
6471: -- Extend

Line 6673: ,x_rendition_file_ids OUT NOCOPY JTF_NUMBER_TABLE

6669: ,x_attach_file_id OUT NOCOPY NUMBER
6670: ,x_attach_file_name OUT NOCOPY VARCHAR2
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

Line 6686: ,x_component_citems OUT NOCOPY JTF_NUMBER_TABLE

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

Line 6687: ,x_component_citem_ver_ids OUT NOCOPY JTF_NUMBER_TABLE

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

Line 6690: ,x_component_owner_ids OUT NOCOPY JTF_NUMBER_TABLE

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
6693: ,x_keywords OUT NOCOPY JTF_VARCHAR2_TABLE_100
6694: ,x_return_status OUT NOCOPY VARCHAR2

Line 6692: ,x_component_sort_orders 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
6696: ,x_msg_data OUT NOCOPY VARCHAR2

Line 6792: ,x_rendition_file_ids OUT NOCOPY JTF_NUMBER_TABLE

6788: ,x_attach_file_id OUT NOCOPY NUMBER
6789: ,x_attach_file_name OUT NOCOPY VARCHAR2
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

Line 6805: ,x_component_citems OUT NOCOPY JTF_NUMBER_TABLE

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

Line 6806: ,x_component_citem_ver_ids OUT NOCOPY JTF_NUMBER_TABLE

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

Line 6809: ,x_component_owner_ids OUT NOCOPY JTF_NUMBER_TABLE

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
6812: ,x_keywords OUT NOCOPY JTF_VARCHAR2_TABLE_100
6813: ,x_return_status OUT NOCOPY VARCHAR2

Line 6811: ,x_component_sort_orders 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
6815: ,x_msg_data OUT NOCOPY VARCHAR2

Line 6922: ,x_attach_file_ids OUT NOCOPY JTF_NUMBER_TABLE

6918: ,x_trans_required OUT NOCOPY VARCHAR2
6919: ,x_parent_item_id OUT NOCOPY NUMBER
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

Line 6935: ,x_component_citems OUT NOCOPY JTF_NUMBER_TABLE

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

Line 6936: ,x_component_citem_ver_ids OUT NOCOPY JTF_NUMBER_TABLE

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

Line 6939: ,x_component_owner_ids OUT NOCOPY JTF_NUMBER_TABLE

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
6942: ,x_keywords OUT NOCOPY JTF_VARCHAR2_TABLE_100
6943: ,x_return_status OUT NOCOPY VARCHAR2

Line 6941: ,x_component_sort_orders 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
6945: ,x_msg_data OUT NOCOPY VARCHAR2

Line 6953: l_norend_file_ids JTF_NUMBER_TABLE;

6949: l_attach_file_name VARCHAR2(240);
6950: l_attach_mime_type VARCHAR2(80);
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

Line 7014: x_attach_file_ids := JTF_NUMBER_TABLE();

7010: ,x_msg_data => x_msg_data
7011: );
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:

Line 7061: ,x_attach_file_ids OUT NOCOPY JTF_NUMBER_TABLE

7057: ,x_trans_required OUT NOCOPY VARCHAR2
7058: ,x_parent_item_id OUT NOCOPY NUMBER
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

Line 7074: ,x_component_citems OUT NOCOPY JTF_NUMBER_TABLE

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

Line 7077: ,x_component_owner_ids OUT NOCOPY JTF_NUMBER_TABLE

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
7080: ,x_return_status OUT NOCOPY VARCHAR2
7081: ,x_msg_count OUT NOCOPY NUMBER

Line 7079: ,x_component_sort_orders 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
7083: )

Line 7085: l_component_citem_ver_ids JTF_NUMBER_TABLE;

7081: ,x_msg_count OUT NOCOPY NUMBER
7082: ,x_msg_data OUT NOCOPY VARCHAR2
7083: )
7084: IS
7085: l_component_citem_ver_ids JTF_NUMBER_TABLE;
7086: BEGIN
7087:
7088: get_trans_item(
7089: p_citem_ver_id => p_citem_ver_id

Line 7168: ,x_attach_file_ids OUT NOCOPY JTF_NUMBER_TABLE

7164: ,x_trans_required OUT NOCOPY VARCHAR2
7165: ,x_parent_item_id OUT NOCOPY NUMBER
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

Line 7181: ,x_component_citems OUT NOCOPY JTF_NUMBER_TABLE

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

Line 7182: ,x_component_citem_ver_ids OUT NOCOPY JTF_NUMBER_TABLE

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

Line 7185: ,x_component_owner_ids OUT NOCOPY JTF_NUMBER_TABLE

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
7188: ,x_return_status OUT NOCOPY VARCHAR2
7189: ,x_msg_count OUT NOCOPY NUMBER

Line 7187: ,x_component_sort_orders 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
7191: )

Line 7293: ,x_component_citems OUT NOCOPY JTF_NUMBER_TABLE

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

Line 7296: ,x_component_owner_ids OUT NOCOPY JTF_NUMBER_TABLE

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
7299: ,x_return_status OUT NOCOPY VARCHAR2
7300: ,x_msg_count OUT NOCOPY NUMBER

Line 7298: ,x_component_sort_orders 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
7302: )

Line 7304: l_attach_file_ids JTF_NUMBER_TABLE;

7300: ,x_msg_count OUT NOCOPY NUMBER
7301: ,x_msg_data OUT NOCOPY VARCHAR2
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;

Line 7408: ,x_component_citems OUT NOCOPY JTF_NUMBER_TABLE

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

Line 7411: ,x_component_owner_ids OUT NOCOPY JTF_NUMBER_TABLE

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
7414: ,x_return_status OUT NOCOPY VARCHAR2
7415: ,x_msg_count OUT NOCOPY NUMBER

Line 7413: ,x_component_sort_orders 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
7417: )

Line 7496: ,x_attach_file_ids OUT NOCOPY JTF_NUMBER_TABLE

7492: ,x_trans_required OUT NOCOPY VARCHAR2
7493: ,x_parent_item_id OUT NOCOPY NUMBER
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

Line 7509: ,x_component_citems OUT NOCOPY JTF_NUMBER_TABLE

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

Line 7512: ,x_component_owner_ids OUT NOCOPY JTF_NUMBER_TABLE

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
7515: ,x_return_status OUT NOCOPY VARCHAR2
7516: ,x_msg_count OUT NOCOPY NUMBER

Line 7514: ,x_component_sort_orders 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
7518: )

Line 7600: ,x_attach_file_ids OUT NOCOPY JTF_NUMBER_TABLE

7596: ,x_trans_required OUT NOCOPY VARCHAR2
7597: ,x_parent_item_id OUT NOCOPY NUMBER
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

Line 7613: ,x_component_citems OUT NOCOPY JTF_NUMBER_TABLE

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

Line 7614: ,x_component_citem_ver_ids OUT NOCOPY JTF_NUMBER_TABLE

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

Line 7617: ,x_component_owner_ids OUT NOCOPY JTF_NUMBER_TABLE

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
7620: ,x_return_status OUT NOCOPY VARCHAR2
7621: ,x_msg_count OUT NOCOPY NUMBER

Line 7619: ,x_component_sort_orders 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
7623: )

Line 7706: ,x_attach_file_ids OUT NOCOPY JTF_NUMBER_TABLE

7702: ,x_trans_required OUT NOCOPY VARCHAR2
7703: ,x_parent_item_id OUT NOCOPY NUMBER
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

Line 7719: ,x_component_citems OUT NOCOPY JTF_NUMBER_TABLE

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

Line 7720: ,x_component_citem_ver_ids OUT NOCOPY JTF_NUMBER_TABLE

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

Line 7723: ,x_component_owner_ids OUT NOCOPY JTF_NUMBER_TABLE

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
7726: ,x_keywords OUT NOCOPY JTF_VARCHAR2_TABLE_100
7727: ,x_return_status OUT NOCOPY VARCHAR2

Line 7725: ,x_component_sort_orders 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
7729: ,x_msg_data OUT NOCOPY VARCHAR2

Line 7819: ,x_rendition_file_ids OUT NOCOPY JTF_NUMBER_TABLE

7815: ,x_attach_file_id OUT NOCOPY NUMBER
7816: ,x_attach_file_name OUT NOCOPY VARCHAR2
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

Line 7832: ,x_component_citems OUT NOCOPY JTF_NUMBER_TABLE

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

Line 7833: ,x_component_citem_ver_ids OUT NOCOPY JTF_NUMBER_TABLE

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

Line 7836: ,x_component_owner_ids OUT NOCOPY JTF_NUMBER_TABLE

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
7839: ,x_keywords OUT NOCOPY JTF_VARCHAR2_TABLE_100
7840: ,x_return_status OUT NOCOPY VARCHAR2

Line 7838: ,x_component_sort_orders 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
7842: ,x_msg_data OUT NOCOPY VARCHAR2

Line 7934: ,x_rendition_file_ids OUT NOCOPY JTF_NUMBER_TABLE

7930: ,x_attach_file_id OUT NOCOPY NUMBER
7931: ,x_attach_file_name OUT NOCOPY VARCHAR2
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

Line 7947: ,x_component_citems OUT NOCOPY JTF_NUMBER_TABLE

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

Line 7948: ,x_component_citem_ver_ids OUT NOCOPY JTF_NUMBER_TABLE

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

Line 7951: ,x_component_owner_ids OUT NOCOPY JTF_NUMBER_TABLE

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
7954: ,x_keywords OUT NOCOPY JTF_VARCHAR2_TABLE_100
7955: ,x_return_status OUT NOCOPY VARCHAR2

Line 7953: ,x_component_sort_orders 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
7957: ,x_msg_data OUT NOCOPY VARCHAR2

Line 8031: ,p_content_item_ids IN JTF_NUMBER_TABLE

8027: --
8028: -- --------------------------------------------------------------
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

Line 8032: ,p_citem_ver_ids IN JTF_NUMBER_TABLE

8028: -- --------------------------------------------------------------
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

Line 8034: ,p_sort_order IN JTF_NUMBER_TABLE

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
8038: ,x_return_status OUT NOCOPY VARCHAR2

Line 8282: ,p_content_item_ids IN JTF_NUMBER_TABLE

8278: -- Overloaded - no subitem citem_ver_ids
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

Line 8284: ,p_sort_order IN JTF_NUMBER_TABLE

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
8288: ,x_return_status OUT NOCOPY VARCHAR2

Line 11540: ,p_item_renditions IN JTF_NUMBER_TABLE

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

Line 11542: ,p_component_citems IN JTF_NUMBER_TABLE

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

Line 11543: ,p_component_citem_ver_ids IN JTF_NUMBER_TABLE

11539: ,p_attach_file_id IN NUMBER
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

Line 11545: ,p_sort_order 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
11549: ,p_language IN VARCHAR2

Line 12647: ,p_item_renditions IN JTF_NUMBER_TABLE

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

Line 12649: ,p_component_citems IN JTF_NUMBER_TABLE

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

Line 12650: ,p_component_citem_ver_ids IN JTF_NUMBER_TABLE

12646: ,p_attach_file_id IN NUMBER
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

Line 12652: ,p_sort_order 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
12656: ,p_language IN VARCHAR2

Line 12745: ,p_attach_file_ids IN JTF_NUMBER_TABLE

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
12748: ,p_component_citem_ver_ids IN JTF_NUMBER_TABLE
12749: ,p_component_atypes IN JTF_VARCHAR2_TABLE_100

Line 12747: ,p_component_citems IN JTF_NUMBER_TABLE

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

Line 12748: ,p_component_citem_ver_ids IN JTF_NUMBER_TABLE

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

Line 12750: ,p_sort_order 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
12754: ,p_language IN VARCHAR2

Line 12836: ,p_attach_file_ids IN JTF_NUMBER_TABLE

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
12839: ,p_component_citem_ver_ids IN JTF_NUMBER_TABLE
12840: ,p_component_atypes IN JTF_VARCHAR2_TABLE_100

Line 12838: ,p_component_citems IN JTF_NUMBER_TABLE

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

Line 12839: ,p_component_citem_ver_ids IN JTF_NUMBER_TABLE

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

Line 12841: ,p_sort_order 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
12845: ,p_update IN VARCHAR2

Line 12921: ,p_attach_file_ids IN JTF_NUMBER_TABLE

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
12924: ,p_component_atypes IN JTF_VARCHAR2_TABLE_100
12925: ,p_sort_order IN JTF_NUMBER_TABLE

Line 12923: ,p_component_citems IN JTF_NUMBER_TABLE

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

Line 12925: ,p_sort_order IN JTF_NUMBER_TABLE

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
12929: ,p_update IN VARCHAR2

Line 13004: ,p_component_citems IN JTF_NUMBER_TABLE

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
13006: ,p_sort_order IN JTF_NUMBER_TABLE
13007: ,p_status IN VARCHAR2
13008: ,p_log_action IN VARCHAR2

Line 13006: ,p_sort_order IN JTF_NUMBER_TABLE

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
13010: ,p_update IN VARCHAR2

Line 13021: l_attach_file_ids JTF_NUMBER_TABLE;

13017: ,x_return_status OUT NOCOPY VARCHAR2
13018: ,x_msg_count OUT NOCOPY NUMBER
13019: ,x_msg_data OUT NOCOPY VARCHAR2
13020: ) IS
13021: l_attach_file_ids JTF_NUMBER_TABLE;
13022: l_default_rendition NUMBER;
13023: BEGIN
13024: --DBMS_OUTPUT.put_line('----- upsert_item -----');
13025: IF p_attach_file_id IS NOT NULL THEN

Line 13026: l_attach_file_ids := JTF_NUMBER_TABLE();

13022: l_default_rendition NUMBER;
13023: BEGIN
13024: --DBMS_OUTPUT.put_line('----- upsert_item -----');
13025: IF p_attach_file_id IS NOT NULL THEN
13026: l_attach_file_ids := JTF_NUMBER_TABLE();
13027: l_attach_file_ids.extend;
13028: l_attach_file_ids(1) := p_attach_file_id;
13029: l_default_rendition := 1;
13030: END IF;

Line 13095: ,p_component_citems IN JTF_NUMBER_TABLE

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
13097: ,p_sort_order IN JTF_NUMBER_TABLE
13098: ,p_status IN VARCHAR2
13099: ,p_log_action IN VARCHAR2

Line 13097: ,p_sort_order IN JTF_NUMBER_TABLE

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
13101: ,p_commit IN VARCHAR2

Line 13174: ,p_attach_file_ids IN JTF_NUMBER_TABLE

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
13177: ,p_component_atypes IN JTF_VARCHAR2_TABLE_100
13178: ,p_sort_order IN JTF_NUMBER_TABLE

Line 13176: ,p_component_citems IN JTF_NUMBER_TABLE

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

Line 13178: ,p_sort_order IN JTF_NUMBER_TABLE

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
13182: ,p_commit IN VARCHAR2

Line 13243: ,p_citem_version_ids IN JTF_NUMBER_TABLE

13239: PROCEDURE hard_delete_item_versions(
13240: p_api_version IN NUMBER
13241: ,p_init_msg_list IN VARCHAR2
13242: ,p_commit IN VARCHAR2
13243: ,p_citem_version_ids IN JTF_NUMBER_TABLE
13244: ,x_return_status OUT NOCOPY VARCHAR2
13245: ,x_msg_count OUT NOCOPY NUMBER
13246: ,x_msg_data OUT NOCOPY VARCHAR2
13247: ) AS

Line 13534: p_content_item_ids IN JTF_NUMBER_TABLE,

13530: PROCEDURE hard_delete_items (
13531: p_api_version IN NUMBER,
13532: p_init_msg_list IN VARCHAR2,
13533: p_commit IN VARCHAR2,
13534: p_content_item_ids IN JTF_NUMBER_TABLE,
13535: x_return_status OUT NOCOPY VARCHAR2,
13536: x_msg_count OUT NOCOPY NUMBER,
13537: x_msg_data OUT NOCOPY VARCHAR2
13538: ) AS