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.AMS_CPAGEUTILITY_PVT dependencies on JTF_VARCHAR2_TABLE_300

Line 103: l_assoc_objects1 JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300() ;

99: l_attribute_type_codes JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100() ;
100: l_attributes JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000() ;
101: --
102: l_assoc_type_codes JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100() ;
103: l_assoc_objects1 JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300() ;
104: l_assoc_objects2 JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300() ;
105: l_assoc_objects3 JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300() ;
106: l_assoc_objects4 JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300() ;
107: l_assoc_objects5 JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300() ;

Line 104: l_assoc_objects2 JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300() ;

100: l_attributes JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000() ;
101: --
102: l_assoc_type_codes JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100() ;
103: l_assoc_objects1 JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300() ;
104: l_assoc_objects2 JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300() ;
105: l_assoc_objects3 JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300() ;
106: l_assoc_objects4 JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300() ;
107: l_assoc_objects5 JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300() ;
108: --

Line 105: l_assoc_objects3 JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300() ;

101: --
102: l_assoc_type_codes JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100() ;
103: l_assoc_objects1 JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300() ;
104: l_assoc_objects2 JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300() ;
105: l_assoc_objects3 JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300() ;
106: l_assoc_objects4 JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300() ;
107: l_assoc_objects5 JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300() ;
108: --
109: l_init_msg_list VARCHAR2(1) := FND_API.g_true;

Line 106: l_assoc_objects4 JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300() ;

102: l_assoc_type_codes JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100() ;
103: l_assoc_objects1 JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300() ;
104: l_assoc_objects2 JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300() ;
105: l_assoc_objects3 JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300() ;
106: l_assoc_objects4 JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300() ;
107: l_assoc_objects5 JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300() ;
108: --
109: l_init_msg_list VARCHAR2(1) := FND_API.g_true;
110: --

Line 107: l_assoc_objects5 JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300() ;

103: l_assoc_objects1 JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300() ;
104: l_assoc_objects2 JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300() ;
105: l_assoc_objects3 JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300() ;
106: l_assoc_objects4 JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300() ;
107: l_assoc_objects5 JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300() ;
108: --
109: l_init_msg_list VARCHAR2(1) := FND_API.g_true;
110: --
111: l_api_version_number CONSTANT NUMBER := 1.0;

Line 485: l_attribute_type_names JTF_VARCHAR2_TABLE_300 ;

481: l_attach_file_name VARCHAR2(240) ;
482: l_citem_name VARCHAR2(240) ;
483: l_description VARCHAR2(2000) ;
484: l_attribute_type_codes JTF_VARCHAR2_TABLE_100 ;
485: l_attribute_type_names JTF_VARCHAR2_TABLE_300 ;
486: l_attributes JTF_VARCHAR2_TABLE_4000 ;
487: l_cpnt_citems JTF_NUMBER_TABLE ;
488: l_cpnt_ctypes JTF_VARCHAR2_TABLE_100 ;
489: l_cpnt_attrib_types JTF_VARCHAR2_TABLE_100 ;

Line 490: l_cpnt_citem_names JTF_VARCHAR2_TABLE_300 ;

486: l_attributes JTF_VARCHAR2_TABLE_4000 ;
487: l_cpnt_citems JTF_NUMBER_TABLE ;
488: l_cpnt_ctypes JTF_VARCHAR2_TABLE_100 ;
489: l_cpnt_attrib_types JTF_VARCHAR2_TABLE_100 ;
490: l_cpnt_citem_names JTF_VARCHAR2_TABLE_300 ;
491: l_cpnt_owner_ids JTF_NUMBER_TABLE ;
492: l_cpnt_owner_types JTF_VARCHAR2_TABLE_100 ;
493: l_cpnt_owner_names JTF_VARCHAR2_TABLE_400 ;
494: l_cpnt_sort_orders JTF_NUMBER_TABLE ;

Line 895: p_data_source_list IN JTF_VARCHAR2_TABLE_300,

891: p_owner_resource_type IN VARCHAR2,
892: p_has_merge_fields IN VARCHAR2,
893: p_has_page_merge_fields IN VARCHAR2,
894: p_reusable_flag IN VARCHAR2 DEFAULT FND_API.g_false, -- CHANGE to Y or N when IBC folks change the conventions for varchar2 fields.
895: p_data_source_list IN JTF_VARCHAR2_TABLE_300,
896: p_merge_fields_list IN JTF_VARCHAR2_TABLE_300,
897: p_attribute_type_code IN VARCHAR2,
898: p_parent_citem_id IN NUMBER,
899: p_parent_citem_ver_id IN NUMBER,

Line 896: p_merge_fields_list IN JTF_VARCHAR2_TABLE_300,

892: p_has_merge_fields IN VARCHAR2,
893: p_has_page_merge_fields IN VARCHAR2,
894: p_reusable_flag IN VARCHAR2 DEFAULT FND_API.g_false, -- CHANGE to Y or N when IBC folks change the conventions for varchar2 fields.
895: p_data_source_list IN JTF_VARCHAR2_TABLE_300,
896: p_merge_fields_list IN JTF_VARCHAR2_TABLE_300,
897: p_attribute_type_code IN VARCHAR2,
898: p_parent_citem_id IN NUMBER,
899: p_parent_citem_ver_id IN NUMBER,
900: p_parent_ctype_code IN VARCHAR2,

Line 947: l_bind_vars_list JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300() ;

943: l_api_name CONSTANT VARCHAR2(30) := 'manage_rich_content';
944: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
945: --
946: l_attr_count NUMBER ;
947: l_bind_vars_list JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300() ;
948: l_select_sql_statement VARCHAR2(4000) ;
949: l_data_src_type_code VARCHAR2(300) ;
950: BEGIN
951: --

Line 1839: l_attribute_type_names JTF_VARCHAR2_TABLE_300 ;

1835: l_attach_file_name VARCHAR2(240) ;
1836: l_citem_name VARCHAR2(240) ;
1837: l_description VARCHAR2(2000) ;
1838: l_attribute_type_codes JTF_VARCHAR2_TABLE_100 ;
1839: l_attribute_type_names JTF_VARCHAR2_TABLE_300 ;
1840: l_attributes JTF_VARCHAR2_TABLE_4000 ;
1841: l_cpnt_citems JTF_NUMBER_TABLE ;
1842: l_cpnt_ctypes JTF_VARCHAR2_TABLE_100 ;
1843: l_cpnt_attrib_types JTF_VARCHAR2_TABLE_100 ;

Line 1844: l_cpnt_citem_names JTF_VARCHAR2_TABLE_300 ;

1840: l_attributes JTF_VARCHAR2_TABLE_4000 ;
1841: l_cpnt_citems JTF_NUMBER_TABLE ;
1842: l_cpnt_ctypes JTF_VARCHAR2_TABLE_100 ;
1843: l_cpnt_attrib_types JTF_VARCHAR2_TABLE_100 ;
1844: l_cpnt_citem_names JTF_VARCHAR2_TABLE_300 ;
1845: l_cpnt_owner_ids JTF_NUMBER_TABLE ;
1846: l_cpnt_owner_types JTF_VARCHAR2_TABLE_100 ;
1847: l_cpnt_owner_names JTF_VARCHAR2_TABLE_400 ;
1848: l_cpnt_sort_orders JTF_NUMBER_TABLE ;

Line 1968: x_attribute_type_names OUT JTF_VARCHAR2_TABLE_300,

1964: x_attach_file_name OUT VARCHAR2,
1965: x_citem_name OUT VARCHAR2,
1966: x_description OUT VARCHAR2,
1967: x_attribute_type_codes OUT JTF_VARCHAR2_TABLE_100,
1968: x_attribute_type_names OUT JTF_VARCHAR2_TABLE_300,
1969: x_attributes OUT JTF_VARCHAR2_TABLE_4000,
1970: x_cpnt_citem_ids OUT JTF_NUMBER_TABLE,
1971: x_cpnt_ctype_codes OUT JTF_VARCHAR2_TABLE_100,
1972: x_cpnt_attrib_types OUT JTF_VARCHAR2_TABLE_100,

Line 1973: x_cpnt_citem_names OUT JTF_VARCHAR2_TABLE_300,

1969: x_attributes OUT JTF_VARCHAR2_TABLE_4000,
1970: x_cpnt_citem_ids OUT JTF_NUMBER_TABLE,
1971: x_cpnt_ctype_codes OUT JTF_VARCHAR2_TABLE_100,
1972: x_cpnt_attrib_types OUT JTF_VARCHAR2_TABLE_100,
1973: x_cpnt_citem_names OUT JTF_VARCHAR2_TABLE_300,
1974: x_cpnt_sort_orders OUT JTF_NUMBER_TABLE,
1975: x_object_version_number OUT NUMBER,
1976: x_return_status OUT VARCHAR2,
1977: x_msg_count OUT NUMBER,

Line 2012: l_attribute_type_names JTF_VARCHAR2_TABLE_300 ;

2008: l_creation_date DATE ;
2009: l_last_updated_by NUMBER ;
2010: l_last_update_date DATE ;
2011: l_attribute_type_codes JTF_VARCHAR2_TABLE_100 ;
2012: l_attribute_type_names JTF_VARCHAR2_TABLE_300 ;
2013: l_attributes JTF_VARCHAR2_TABLE_4000 ;
2014: l_cpnt_citems JTF_NUMBER_TABLE ;
2015: l_cpnt_ctypes JTF_VARCHAR2_TABLE_100 ;
2016: l_cpnt_attrib_types JTF_VARCHAR2_TABLE_100 ;

Line 2017: l_cpnt_citem_names JTF_VARCHAR2_TABLE_300 ;

2013: l_attributes JTF_VARCHAR2_TABLE_4000 ;
2014: l_cpnt_citems JTF_NUMBER_TABLE ;
2015: l_cpnt_ctypes JTF_VARCHAR2_TABLE_100 ;
2016: l_cpnt_attrib_types JTF_VARCHAR2_TABLE_100 ;
2017: l_cpnt_citem_names JTF_VARCHAR2_TABLE_300 ;
2018: l_cpnt_owner_ids JTF_NUMBER_TABLE ;
2019: l_cpnt_owner_types JTF_VARCHAR2_TABLE_100 ;
2020: l_cpnt_owner_names JTF_VARCHAR2_TABLE_400 ;
2021: l_cpnt_sort_orders JTF_NUMBER_TABLE ;

Line 3268: x_attribute_type_names OUT JTF_VARCHAR2_TABLE_300,

3264: p_attrib_file_id IN NUMBER DEFAULT NULL,
3265: p_api_version IN NUMBER,
3266: p_init_msg_list IN VARCHAR2,
3267: x_attribute_type_codes OUT JTF_VARCHAR2_TABLE_100,
3268: x_attribute_type_names OUT JTF_VARCHAR2_TABLE_300,
3269: x_attributes OUT JTF_VARCHAR2_TABLE_4000,
3270: x_return_status OUT VARCHAR2,
3271: x_msg_count OUT NUMBER,
3272: x_msg_data OUT VARCHAR2

Line 3277: l_attribute_type_names JTF_VARCHAR2_TABLE_300 ;

3273: )
3274: IS
3275: --
3276: l_attribute_type_codes JTF_VARCHAR2_TABLE_100 ;
3277: l_attribute_type_names JTF_VARCHAR2_TABLE_300 ;
3278: l_attributes JTF_VARCHAR2_TABLE_4000 ;
3279: l_obj_ver_num NUMBER ;
3280: l_return_status VARCHAR2(1) ;
3281: l_msg_count NUMBER ;

Line 3414: l_attribute_type_names JTF_VARCHAR2_TABLE_300 ;

3410: )
3411: IS
3412: --
3413: l_attribute_type_codes JTF_VARCHAR2_TABLE_100 ;
3414: l_attribute_type_names JTF_VARCHAR2_TABLE_300 ;
3415: l_attributes JTF_VARCHAR2_TABLE_4000 ;
3416: l_citem_ver_id NUMBER ;
3417: l_citem_id NUMBER ;
3418: l_return_status VARCHAR2(1) ;

Line 3435: l_cpnt_citem_names JTF_VARCHAR2_TABLE_300 ;

3431: l_description VARCHAR2(2000) ;
3432: l_cpnt_citems JTF_NUMBER_TABLE ;
3433: l_cpnt_ctypes JTF_VARCHAR2_TABLE_100 ;
3434: l_cpnt_attrib_types JTF_VARCHAR2_TABLE_100 ;
3435: l_cpnt_citem_names JTF_VARCHAR2_TABLE_300 ;
3436: l_cpnt_owner_ids JTF_NUMBER_TABLE ;
3437: l_cpnt_owner_types JTF_VARCHAR2_TABLE_100 ;
3438: l_cpnt_owner_names JTF_VARCHAR2_TABLE_400 ;
3439: l_cpnt_sort_orders JTF_NUMBER_TABLE ;

Line 4651: p_data_source_fields_list IN JTF_VARCHAR2_TABLE_300 DEFAULT NULL,

4647: -----------------------------------------------------------------------
4648:
4649: PROCEDURE generate_select_sql(
4650: p_data_source_code IN VARCHAR2,
4651: p_data_source_fields_list IN JTF_VARCHAR2_TABLE_300 DEFAULT NULL,
4652: p_data_source_field_ids IN JTF_NUMBER_TABLE DEFAULT NULL,
4653: x_select_sql_statement OUT VARCHAR2,
4654: x_bind_vars OUT JTF_VARCHAR2_TABLE_300,
4655: x_return_status OUT VARCHAR2,

Line 4654: x_bind_vars OUT JTF_VARCHAR2_TABLE_300,

4650: p_data_source_code IN VARCHAR2,
4651: p_data_source_fields_list IN JTF_VARCHAR2_TABLE_300 DEFAULT NULL,
4652: p_data_source_field_ids IN JTF_NUMBER_TABLE DEFAULT NULL,
4653: x_select_sql_statement OUT VARCHAR2,
4654: x_bind_vars OUT JTF_VARCHAR2_TABLE_300,
4655: x_return_status OUT VARCHAR2,
4656: x_msg_count OUT NUMBER,
4657: x_msg_data OUT VARCHAR2
4658: )

Line 4669: l_data_src_fld_cols JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300() ;

4665: l_msg_count NUMBER ;
4666: l_msg_data VARCHAR2(2000) ;
4667:
4668: l_data_src_fld_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE() ;
4669: l_data_src_fld_cols JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300() ;
4670: l_bind_vars JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300() ;
4671:
4672: l_source_object_name VARCHAR2(240) ;
4673: l_source_object_pk_field VARCHAR2(240) ;

Line 4670: l_bind_vars JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300() ;

4666: l_msg_data VARCHAR2(2000) ;
4667:
4668: l_data_src_fld_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE() ;
4669: l_data_src_fld_cols JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300() ;
4670: l_bind_vars JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300() ;
4671:
4672: l_source_object_name VARCHAR2(240) ;
4673: l_source_object_pk_field VARCHAR2(240) ;
4674: l_master_source_type_flag VARCHAR2(1) ;

Line 5704: l_data_src_type_codes JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300() ;

5700: --
5701: l_attribute_type_codes JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100() ;
5702: l_attributes JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000() ;
5703:
5704: l_data_src_type_codes JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300() ;
5705: --
5706: l_data_src_fld_ids JTF_NUMBER_TABLE ; -- This is initilized below.
5707: --
5708: l_init_msg_list VARCHAR2(1) := FND_API.g_true;

Line 5716: l_bind_vars_list JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300() ;

5712: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
5713: --
5714: l_attr_count NUMBER ;
5715:
5716: l_bind_vars_list JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300() ;
5717: l_select_sql_statement VARCHAR2(4000) ;
5718:
5719: BEGIN
5720: