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_100

Line 99: l_attribute_type_codes JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100() ;

95: --
96: l_obj_ver_num NUMBER ;
97: l_assoc_id NUMBER ;
98: --
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() ;

Line 102: l_assoc_type_codes JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100() ;

98: --
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() ;

Line 484: l_attribute_type_codes JTF_VARCHAR2_TABLE_100 ;

480: l_attach_file_id NUMBER ;
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 ;

Line 488: l_cpnt_ctypes JTF_VARCHAR2_TABLE_100 ;

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

Line 489: l_cpnt_attrib_types 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 ;
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 ;

Line 492: l_cpnt_owner_types JTF_VARCHAR2_TABLE_100 ;

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 ;
495: l_object_version_number NUMBER ;
496: --

Line 934: l_attribute_type_codes JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100() ;

930: l_msg_data VARCHAR2(2000) ;
931: --
932: l_obj_ver_num NUMBER ;
933: --
934: l_attribute_type_codes JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100() ;
935: l_attributes JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000() ;
936: l_citem_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE() ;
937: l_citem_attrs JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100() ;
938: l_dummy_sort_order JTF_NUMBER_TABLE := JTF_NUMBER_TABLE() ;

Line 937: l_citem_attrs JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100() ;

933: --
934: l_attribute_type_codes JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100() ;
935: l_attributes JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000() ;
936: l_citem_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE() ;
937: l_citem_attrs JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100() ;
938: l_dummy_sort_order JTF_NUMBER_TABLE := JTF_NUMBER_TABLE() ;
939: --
940: l_init_msg_list VARCHAR2(1) := FND_API.g_true;
941: --

Line 1443: p_attr_types IN JTF_VARCHAR2_TABLE_100 DEFAULT NULL,

1439: p_delv_id IN NUMBER,
1440: p_owner_resource_id IN NUMBER,
1441: p_owner_resource_type IN VARCHAR2,
1442: p_reusable_flag IN VARCHAR2 DEFAULT FND_API.g_false, -- CHANGE to Y or N when IBC folks change the conventions for varchar2 fields.
1443: p_attr_types IN JTF_VARCHAR2_TABLE_100 DEFAULT NULL,
1444: p_attr_values IN JTF_VARCHAR2_TABLE_4000 DEFAULT NULL,
1445: p_parent_citem_id IN NUMBER,
1446: p_parent_citem_ver_id IN NUMBER,
1447: p_parent_ctype_code IN VARCHAR2,

Line 1483: l_citem_attrs JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100() ;

1479: --
1480: l_obj_ver_num NUMBER ;
1481: --
1482: l_citem_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE() ;
1483: l_citem_attrs JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100() ;
1484: l_dummy_sort_order JTF_NUMBER_TABLE := JTF_NUMBER_TABLE() ;
1485: --
1486: l_init_msg_list VARCHAR2(1) := FND_API.g_true;
1487: --

Line 1815: x_attribute_types OUT JTF_VARCHAR2_TABLE_100,

1811: x_citem_ver_id OUT NUMBER,
1812: x_attach_file_id OUT NUMBER,
1813: x_attach_file_name OUT VARCHAR2,
1814: x_citem_name OUT VARCHAR2,
1815: x_attribute_types OUT JTF_VARCHAR2_TABLE_100,
1816: x_attribute_values OUT JTF_VARCHAR2_TABLE_4000,
1817: x_object_version_number OUT NUMBER,
1818: x_return_status OUT VARCHAR2,
1819: x_msg_count OUT NUMBER,

Line 1838: l_attribute_type_codes JTF_VARCHAR2_TABLE_100 ;

1834: l_attach_file_id NUMBER ;
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 ;

Line 1842: l_cpnt_ctypes JTF_VARCHAR2_TABLE_100 ;

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

Line 1843: l_cpnt_attrib_types 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 ;
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 ;

Line 1846: l_cpnt_owner_types JTF_VARCHAR2_TABLE_100 ;

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 ;
1849: l_object_version_number NUMBER ;
1850: l_return_status VARCHAR2(1) ;

Line 1967: x_attribute_type_codes OUT JTF_VARCHAR2_TABLE_100,

1963: x_attach_file_id OUT NUMBER,
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,

Line 1971: x_cpnt_ctype_codes OUT JTF_VARCHAR2_TABLE_100,

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

Line 1972: x_cpnt_attrib_types 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,
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,

Line 2011: l_attribute_type_codes JTF_VARCHAR2_TABLE_100 ;

2007: l_created_by NUMBER ;
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 ;

Line 2015: l_cpnt_ctypes JTF_VARCHAR2_TABLE_100 ;

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

Line 2016: l_cpnt_attrib_types 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 ;
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 ;

Line 2019: l_cpnt_owner_types JTF_VARCHAR2_TABLE_100 ;

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 ;
2022: l_return_status VARCHAR2(1) ;
2023: l_msg_count NUMBER ;

Line 2310: p_attr_types_cp_image IN JTF_VARCHAR2_TABLE_100 DEFAULT NULL,

2306: p_delv_id IN NUMBER,
2307: p_resource_id IN NUMBER,
2308: p_resource_type IN VARCHAR2,
2309: p_reusable_flag IN VARCHAR2 DEFAULT FND_API.g_true, -- CHANGE to Y or N when IBC folks change the conventions for varchar2 fields.
2310: p_attr_types_cp_image IN JTF_VARCHAR2_TABLE_100 DEFAULT NULL,
2311: p_attr_values_cp_image IN JTF_VARCHAR2_TABLE_4000 DEFAULT NULL,
2312: p_attach_file_id IN NUMBER,
2313: p_attach_file_name IN VARCHAR2,
2314: p_attr_types_image IN JTF_VARCHAR2_TABLE_100 DEFAULT NULL,

Line 2314: p_attr_types_image IN JTF_VARCHAR2_TABLE_100 DEFAULT NULL,

2310: p_attr_types_cp_image IN JTF_VARCHAR2_TABLE_100 DEFAULT NULL,
2311: p_attr_values_cp_image IN JTF_VARCHAR2_TABLE_4000 DEFAULT NULL,
2312: p_attach_file_id IN NUMBER,
2313: p_attach_file_name IN VARCHAR2,
2314: p_attr_types_image IN JTF_VARCHAR2_TABLE_100 DEFAULT NULL,
2315: p_attr_values_image IN JTF_VARCHAR2_TABLE_4000 DEFAULT NULL,
2316: p_parent_attr_type_code IN VARCHAR2,
2317: p_parent_citem_id IN NUMBER,
2318: p_parent_citem_ver_id IN NUMBER,

Line 2356: l_attribute_type_codes JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100() ;

2352: l_image_citem_ver_id NUMBER ;
2353: l_image_obj_ver_num NUMBER ;
2354: l_created_image VARCHAR2(1) := FND_API.g_false;
2355: --
2356: l_attribute_type_codes JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100() ;
2357: l_attributes JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000() ;
2358: l_citem_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE() ;
2359: l_dummy_sort_order JTF_NUMBER_TABLE := JTF_NUMBER_TABLE() ;
2360: l_citem_attrs JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100() ;

Line 2360: l_citem_attrs JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100() ;

2356: l_attribute_type_codes JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100() ;
2357: l_attributes JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000() ;
2358: l_citem_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE() ;
2359: l_dummy_sort_order JTF_NUMBER_TABLE := JTF_NUMBER_TABLE() ;
2360: l_citem_attrs JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100() ;
2361: --
2362: l_api_name CONSTANT VARCHAR2(30) := 'Create_CP_Image';
2363: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
2364: --

Line 2849: p_attr_types_cp_image IN JTF_VARCHAR2_TABLE_100 DEFAULT NULL,

2845: p_cp_image_citem_ver_id IN NUMBER,
2846: p_delv_id IN NUMBER,
2847: p_resource_id IN NUMBER,
2848: p_resource_type IN VARCHAR2,
2849: p_attr_types_cp_image IN JTF_VARCHAR2_TABLE_100 DEFAULT NULL,
2850: p_attr_values_cp_image IN JTF_VARCHAR2_TABLE_4000 DEFAULT NULL,
2851: p_description IN VARCHAR2,
2852: p_attach_file_id IN NUMBER,
2853: p_attach_file_name IN VARCHAR2,

Line 2854: p_attr_types_image IN JTF_VARCHAR2_TABLE_100 DEFAULT NULL,

2850: p_attr_values_cp_image IN JTF_VARCHAR2_TABLE_4000 DEFAULT NULL,
2851: p_description IN VARCHAR2,
2852: p_attach_file_id IN NUMBER,
2853: p_attach_file_name IN VARCHAR2,
2854: p_attr_types_image IN JTF_VARCHAR2_TABLE_100 DEFAULT NULL,
2855: p_attr_values_image IN JTF_VARCHAR2_TABLE_4000 DEFAULT NULL,
2856: p_commit IN VARCHAR2 DEFAULT FND_API.g_false,
2857: p_api_version IN NUMBER DEFAULT 1.0,
2858: p_api_validation_level IN NUMBER DEFAULT FND_API.g_valid_level_full,

Line 2879: l_attribute_type_codes JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100() ;

2875: l_cp_image_citem_ver_id NUMBER ;
2876: l_image_obj_ver_num NUMBER ;
2877: l_created_image VARCHAR2(1) := FND_API.g_false;
2878: --
2879: l_attribute_type_codes JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100() ;
2880: l_attributes JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000() ;
2881: l_citem_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE() ;
2882: l_dummy_sort_order JTF_NUMBER_TABLE := JTF_NUMBER_TABLE() ;
2883: l_citem_attrs JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100() ;

Line 2883: l_citem_attrs JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100() ;

2879: l_attribute_type_codes JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100() ;
2880: l_attributes JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000() ;
2881: l_citem_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE() ;
2882: l_dummy_sort_order JTF_NUMBER_TABLE := JTF_NUMBER_TABLE() ;
2883: l_citem_attrs JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100() ;
2884: --
2885: l_api_name CONSTANT VARCHAR2(30) := 'Update_CP_Image';
2886: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
2887: --

Line 3267: x_attribute_type_codes OUT JTF_VARCHAR2_TABLE_100,

3263: p_citem_ver_id IN NUMBER,
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,

Line 3276: l_attribute_type_codes JTF_VARCHAR2_TABLE_100 ;

3272: x_msg_data OUT VARCHAR2
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) ;

Line 3399: p_attr_types_for_update IN JTF_VARCHAR2_TABLE_100 DEFAULT NULL,

3395: p_content_type_code IN VARCHAR2,
3396: p_content_item_name IN VARCHAR2,
3397: p_description IN VARCHAR2,
3398: p_delv_id IN NUMBER,
3399: p_attr_types_for_update IN JTF_VARCHAR2_TABLE_100 DEFAULT NULL,
3400: p_attr_values_for_update IN JTF_VARCHAR2_TABLE_4000 DEFAULT NULL,
3401: p_attach_file_id IN NUMBER DEFAULT NULL,
3402: p_attach_file_name IN VARCHAR2 DEFAULT NULL,
3403: p_commit IN VARCHAR2 DEFAULT FND_API.g_false,

Line 3413: l_attribute_type_codes JTF_VARCHAR2_TABLE_100 ;

3409: p_replace_attr_bundle IN VARCHAR2 DEFAULT FND_API.g_false
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 ;

Line 3433: l_cpnt_ctypes JTF_VARCHAR2_TABLE_100 ;

3429: l_attach_file_name VARCHAR2(240) ;
3430: l_citem_name VARCHAR2(240) ;
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 ;

Line 3434: l_cpnt_attrib_types JTF_VARCHAR2_TABLE_100 ;

3430: l_citem_name VARCHAR2(240) ;
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 ;

Line 3437: l_cpnt_owner_types JTF_VARCHAR2_TABLE_100 ;

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 ;
3440: --
3441: l_init_msg_list VARCHAR2(1) := FND_API.g_true;

Line 3813: l_attribute_type_codes JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100() ;

3809: --
3810: l_obj_ver_num NUMBER ;
3811: l_citem_ver_id NUMBER ;
3812: --
3813: l_attribute_type_codes JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100() ;
3814: l_attributes JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000() ;
3815: --
3816: l_api_name CONSTANT VARCHAR2(30) := 'Update_Citem_For_Delv';
3817: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;

Line 4080: l_attribute_type_codes JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100() ;

4076: l_msg_data VARCHAR2(2000) ;
4077: --
4078: l_obj_ver_num NUMBER ;
4079: --
4080: l_attribute_type_codes JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100() ;
4081: l_attributes JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000() ;
4082: --
4083: l_api_name CONSTANT VARCHAR2(30) := 'Create_Display_Template';
4084: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;

Line 4386: l_citem_attrs JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100() ;

4382: --
4383: l_obj_ver_num NUMBER ;
4384: --
4385: l_citem_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE() ;
4386: l_citem_attrs JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100() ;
4387: l_dummy_sort_order JTF_NUMBER_TABLE := JTF_NUMBER_TABLE() ;
4388: --
4389: l_api_name CONSTANT VARCHAR2(30) := 'Create_Basic-Questions_Item';
4390: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;

Line 5024: l_attribute_type_codes JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100() ;

5020: --
5021: l_parent_obj_ver_num NUMBER ;
5022: l_parent_citem_ver_id NUMBER ;
5023: --
5024: l_attribute_type_codes JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100() ;
5025: l_attributes JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000() ;
5026: --
5027: l_citem_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE() ;
5028: l_citem_attrs JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100() ;

Line 5028: l_citem_attrs JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100() ;

5024: l_attribute_type_codes JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100() ;
5025: l_attributes JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000() ;
5026: --
5027: l_citem_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE() ;
5028: l_citem_attrs JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100() ;
5029: l_dummy_sort_order JTF_NUMBER_TABLE := JTF_NUMBER_TABLE() ;
5030: --
5031: l_api_name CONSTANT VARCHAR2(30) := 'Create_Submit_Section';
5032: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;

Line 5406: l_attribute_type_codes JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100() ;

5402: l_citem_id NUMBER ;
5403: l_citem_ver_id NUMBER ;
5404: l_obj_ver_num NUMBER ;
5405: --
5406: l_attribute_type_codes JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100() ;
5407: l_attributes JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000() ;
5408: --
5409: l_api_name CONSTANT VARCHAR2(30) := 'Update_Submit_Section';
5410: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;

Line 5701: l_attribute_type_codes JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100() ;

5697: l_err_msg VARCHAR2(4000);
5698: --
5699: l_obj_ver_num NUMBER ;
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: --