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_32767

Line 1015: ,p_attributes IN JTF_VARCHAR2_TABLE_32767

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: )
1019: IS

Line 1045: p_parms => JTF_VARCHAR2_TABLE_32767(

1041: p_proc_type => 'PROCEDURE',
1042: p_proc_name => 'Create_Attribute_Bundle',
1043: p_parms => IBC_DEBUG_PVT.make_parameter_list(
1044: p_tag => 'PARAMETERS',
1045: p_parms => JTF_VARCHAR2_TABLE_32767(
1046: 'p_attribute_type_codes', IBC_DEBUG_PVT.make_list(p_attribute_type_codes),
1047: 'p_attributes', IBC_DEBUG_PVT.make_list_VC32767(p_attributes),
1048: 'p_ctype_code', p_ctype_code
1049: )

Line 1623: ,x_attributes OUT NOCOPY JTF_VARCHAR2_TABLE_32767

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: )
1626: IS
1627: temp_bundle CLOB; -- temporary clob to hold text information while creating

Line 1646: attributes JTF_VARCHAR2_TABLE_32767 := JTF_VARCHAR2_TABLE_32767();

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
1649: atn IBC_ATTRIBUTE_TYPES_TL.attribute_type_name%TYPE;
1650: atc IBC_ATTRIBUTE_TYPES_TL.attribute_type_code%TYPE; -- loop variable for attribute type

Line 1827: p_parms => JTF_VARCHAR2_TABLE_32767(

1823: IF IBC_DEBUG_PVT.debug_enabled THEN
1824: IBC_DEBUG_PVT.end_process(
1825: IBC_DEBUG_PVT.make_parameter_list(
1826: p_tag => 'OUTPUT',
1827: p_parms => JTF_VARCHAR2_TABLE_32767(
1828: 'x_attribute_type_codes', IBC_DEBUG_PVT.make_list(x_attribute_type_codes),
1829: 'x_attribute_type_names', IBC_DEBUG_PVT.make_list(x_attribute_type_names),
1830: 'x_attributes', IBC_DEBUG_PVT.make_list_VC32767(x_attributes),
1831: 'x_return_status', x_return_status

Line 1849: p_parms => JTF_VARCHAR2_TABLE_32767(

1845: IF IBC_DEBUG_PVT.debug_enabled THEN
1846: IBC_DEBUG_PVT.end_process(
1847: IBC_DEBUG_PVT.make_parameter_list(
1848: p_tag => 'OUTPUT',
1849: p_parms => JTF_VARCHAR2_TABLE_32767(
1850: 'x_attribute_type_codes', IBC_DEBUG_PVT.make_list(x_attribute_type_codes),
1851: 'x_attribute_type_names', IBC_DEBUG_PVT.make_list(x_attribute_type_names),
1852: 'x_attributes', IBC_DEBUG_PVT.make_list_VC32767(x_attributes),
1853: 'x_return_status', x_return_status,

Line 5811: ,x_attributes OUT NOCOPY JTF_VARCHAR2_TABLE_32767

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
5814: ,x_msg_count OUT NOCOPY NUMBER
5815: ,x_msg_data OUT NOCOPY VARCHAR2

Line 5934: p_parms => JTF_VARCHAR2_TABLE_32767(

5930: IF IBC_DEBUG_PVT.debug_enabled THEN
5931: IBC_DEBUG_PVT.end_process(
5932: IBC_DEBUG_PVT.make_parameter_list(
5933: p_tag => 'OUTPUT',
5934: p_parms => JTF_VARCHAR2_TABLE_32767(
5935: 'x_attribute_type_codes', IBC_DEBUG_PVT.make_list(x_attribute_type_codes),
5936: 'x_attribute_type_names', IBC_DEBUG_PVT.make_list(x_attribute_type_names),
5937: 'x_attributes', IBC_DEBUG_PVT.make_list_VC32767(x_attributes),
5938: 'x_return_status', x_return_status,

Line 5964: p_parms => JTF_VARCHAR2_TABLE_32767(

5960: IF IBC_DEBUG_PVT.debug_enabled THEN
5961: IBC_DEBUG_PVT.end_process(
5962: IBC_DEBUG_PVT.make_parameter_list(
5963: p_tag => 'OUTPUT',
5964: p_parms => JTF_VARCHAR2_TABLE_32767(
5965: 'x_attribute_type_codes', IBC_DEBUG_PVT.make_list(x_attribute_type_codes),
5966: 'x_attribute_type_names', IBC_DEBUG_PVT.make_list(x_attribute_type_names),
5967: 'x_attributes', IBC_DEBUG_PVT.make_list_VC32767(x_attributes),
5968: 'x_return_status', x_return_status,

Line 5992: p_parms => JTF_VARCHAR2_TABLE_32767(

5988: IF IBC_DEBUG_PVT.debug_enabled THEN
5989: IBC_DEBUG_PVT.end_process(
5990: IBC_DEBUG_PVT.make_parameter_list(
5991: p_tag => 'OUTPUT',
5992: p_parms => JTF_VARCHAR2_TABLE_32767(
5993: 'x_attribute_type_codes', IBC_DEBUG_PVT.make_list(x_attribute_type_codes),
5994: 'x_attribute_type_names', IBC_DEBUG_PVT.make_list(x_attribute_type_names),
5995: 'x_attributes', IBC_DEBUG_PVT.make_list_VC32767(x_attributes),
5996: 'x_return_status', x_return_status,

Line 6020: p_parms => JTF_VARCHAR2_TABLE_32767(

6016: IF IBC_DEBUG_PVT.debug_enabled THEN
6017: IBC_DEBUG_PVT.end_process(
6018: IBC_DEBUG_PVT.make_parameter_list(
6019: p_tag => 'OUTPUT',
6020: p_parms => JTF_VARCHAR2_TABLE_32767(
6021: 'x_attribute_type_codes', IBC_DEBUG_PVT.make_list(x_attribute_type_codes),
6022: 'x_attribute_type_names', IBC_DEBUG_PVT.make_list(x_attribute_type_names),
6023: 'x_attributes', IBC_DEBUG_PVT.make_list_VC32767(x_attributes),
6024: 'x_return_status', x_return_status,

Line 6053: l_tmp_attributes JTF_VARCHAR2_TABLE_32767;

6049: ,x_msg_count OUT NOCOPY NUMBER
6050: ,x_msg_data OUT NOCOPY VARCHAR2
6051: )
6052: IS
6053: l_tmp_attributes JTF_VARCHAR2_TABLE_32767;
6054: BEGIN
6055:
6056: get_attribute_bundle(
6057: p_citem_ver_id => p_citem_ver_id

Line 6132: ,x_attributes OUT NOCOPY JTF_VARCHAR2_TABLE_32767

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
6135: ,x_component_attrib_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
6136: ,x_component_citem_names OUT NOCOPY JTF_VARCHAR2_TABLE_300

Line 6511: p_parms => JTF_VARCHAR2_TABLE_32767(

6507: IF IBC_DEBUG_PVT.debug_enabled THEN
6508: IBC_DEBUG_PVT.end_process(
6509: IBC_DEBUG_PVT.make_parameter_list(
6510: p_tag => 'OUTPUT',
6511: p_parms => JTF_VARCHAR2_TABLE_32767(
6512: 'x_content_item_id', x_content_item_id,
6513: 'x_citem_name', x_citem_name,
6514: 'x_citem_version', x_citem_version,
6515: 'x_dir_node_id', x_dir_node_id,

Line 6685: ,x_attributes OUT NOCOPY JTF_VARCHAR2_TABLE_32767

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
6688: ,x_component_attrib_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
6689: ,x_component_citem_names OUT NOCOPY JTF_VARCHAR2_TABLE_300

Line 6818: l_tmp_attributes JTF_VARCHAR2_TABLE_32767;

6814: ,x_msg_count OUT NOCOPY NUMBER
6815: ,x_msg_data OUT NOCOPY VARCHAR2
6816: )
6817: IS
6818: l_tmp_attributes JTF_VARCHAR2_TABLE_32767;
6819: BEGIN
6820: get_trans_item(
6821: p_citem_ver_id => p_citem_ver_id
6822: ,p_language => p_language

Line 7946: ,x_attributes OUT NOCOPY JTF_VARCHAR2_TABLE_32767

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
7949: ,x_component_attrib_types OUT NOCOPY JTF_VARCHAR2_TABLE_100
7950: ,x_component_citem_names OUT NOCOPY JTF_VARCHAR2_TABLE_300

Line 9415: ,p_attributes IN JTF_VARCHAR2_TABLE_32767

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
9419: ,p_init_msg_list IN VARCHAR2

Line 9465: p_parms => JTF_VARCHAR2_TABLE_32767(

9461: p_proc_type => 'PROCEDURE',
9462: p_proc_name => 'Set_Attribute_Bundle',
9463: p_parms => IBC_DEBUG_PVT.make_parameter_list(
9464: p_tag => 'PARAMETERS',
9465: p_parms => JTF_VARCHAR2_TABLE_32767(
9466: 'p_citem_ver_id', p_citem_ver_id,
9467: 'p_attribute_type_codes', IBC_DEBUG_PVT.make_list(p_attribute_type_codes),
9468: 'p_attributes', IBC_DEBUG_PVT.make_list_VC32767(p_attributes),
9469: 'p_remove_old', p_remove_old,

Line 9743: l_tmp_attributes JTF_VARCHAR2_TABLE_32767;

9739: ,x_msg_count OUT NOCOPY NUMBER
9740: ,x_msg_data OUT NOCOPY VARCHAR2
9741: )
9742: IS
9743: l_tmp_attributes JTF_VARCHAR2_TABLE_32767;
9744: BEGIN
9745:
9746: IF p_attributes IS NOT NULL AND p_attributes.COUNT > 0 THEN
9747: l_tmp_attributes := JTF_VARCHAR2_TABLE_32767();

Line 9747: l_tmp_attributes := JTF_VARCHAR2_TABLE_32767();

9743: l_tmp_attributes JTF_VARCHAR2_TABLE_32767;
9744: BEGIN
9745:
9746: IF p_attributes IS NOT NULL AND p_attributes.COUNT > 0 THEN
9747: l_tmp_attributes := JTF_VARCHAR2_TABLE_32767();
9748: l_tmp_attributes.extend(p_attributes.COUNT);
9749: FOR I IN 1..p_attributes.COUNT LOOP
9750: l_tmp_attributes(I) := p_attributes(I);
9751: END LOOP;

Line 11538: ,p_attributes IN JTF_VARCHAR2_TABLE_32767

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
11542: ,p_component_citems IN JTF_NUMBER_TABLE

Line 11627: p_parms => JTF_VARCHAR2_TABLE_32767(

11623: p_proc_type => 'PROCEDURE',
11624: p_proc_name => 'Begin Upsert_Item_Full',
11625: p_parms => IBC_DEBUG_PVT.make_parameter_list(
11626: p_tag => 'PARAMETERS',
11627: p_parms => JTF_VARCHAR2_TABLE_32767(
11628: 'p_ctype_code', p_ctype_code,
11629: 'p_citem_name', p_citem_name,
11630: 'p_citem_description', p_citem_description,
11631: 'p_dir_node_id', p_dir_node_id,

Line 12487: p_parms => JTF_VARCHAR2_TABLE_32767(

12483: p_proc_type => 'PROCEDURE',
12484: p_proc_name => 'End Upsert_Item_Full',
12485: p_parms => IBC_DEBUG_PVT.make_parameter_list(
12486: p_tag => 'PARAMETERS',
12487: p_parms => JTF_VARCHAR2_TABLE_32767(
12488: 'p_ctype_code', p_ctype_code,
12489: 'p_citem_name', p_citem_name,
12490: 'p_citem_description', p_citem_description,
12491: 'p_dir_node_id', p_dir_node_id,

Line 12669: l_tmp_attributes JTF_VARCHAR2_TABLE_32767;

12665: ,x_return_status OUT NOCOPY VARCHAR2
12666: ,x_msg_count OUT NOCOPY NUMBER
12667: ,x_msg_data OUT NOCOPY VARCHAR2
12668: )IS
12669: l_tmp_attributes JTF_VARCHAR2_TABLE_32767;
12670: BEGIN
12671:
12672: IF p_attributes IS NOT NULL AND p_attributes.COUNT > 0 THEN
12673: l_tmp_attributes := JTF_VARCHAR2_TABLE_32767();

Line 12673: l_tmp_attributes := JTF_VARCHAR2_TABLE_32767();

12669: l_tmp_attributes JTF_VARCHAR2_TABLE_32767;
12670: BEGIN
12671:
12672: IF p_attributes IS NOT NULL AND p_attributes.COUNT > 0 THEN
12673: l_tmp_attributes := JTF_VARCHAR2_TABLE_32767();
12674: l_tmp_attributes.extend(p_attributes.COUNT);
12675: FOR I IN 1..p_attributes.COUNT LOOP
12676: l_tmp_attributes(I) := p_attributes(I);
12677: END LOOP;