DBA Data[Home] [Help]

APPS.AMS_CPAGEUTILITY_PVT dependencies on JTF_VARCHAR2_TABLE_4000

Line 100: l_attributes JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000() ;

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() ;
104: l_assoc_objects2 JTF_VARCHAR2_TABLE_300 := JTF_VARCHAR2_TABLE_300() ;

Line 486: l_attributes JTF_VARCHAR2_TABLE_4000 ;

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 ;
490: l_cpnt_citem_names JTF_VARCHAR2_TABLE_300 ;

Line 935: l_attributes JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000() ;

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

Line 1444: p_attr_values IN JTF_VARCHAR2_TABLE_4000 DEFAULT NULL,

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,
1448: p_attribute_type_code IN VARCHAR2,

Line 1816: x_attribute_values OUT JTF_VARCHAR2_TABLE_4000,

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,
1820: x_msg_data OUT VARCHAR2

Line 1840: l_attributes JTF_VARCHAR2_TABLE_4000 ;

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 ;
1844: l_cpnt_citem_names JTF_VARCHAR2_TABLE_300 ;

Line 1969: x_attributes OUT JTF_VARCHAR2_TABLE_4000,

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,
1973: x_cpnt_citem_names OUT JTF_VARCHAR2_TABLE_300,

Line 2013: l_attributes JTF_VARCHAR2_TABLE_4000 ;

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 ;
2017: l_cpnt_citem_names JTF_VARCHAR2_TABLE_300 ;

Line 2311: p_attr_values_cp_image IN JTF_VARCHAR2_TABLE_4000 DEFAULT NULL,

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,
2315: p_attr_values_image IN JTF_VARCHAR2_TABLE_4000 DEFAULT NULL,

Line 2315: p_attr_values_image IN JTF_VARCHAR2_TABLE_4000 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,
2319: p_parent_ctype_code IN VARCHAR2,

Line 2357: l_attributes JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000() ;

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

Line 2850: p_attr_values_cp_image IN JTF_VARCHAR2_TABLE_4000 DEFAULT NULL,

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,
2854: p_attr_types_image IN JTF_VARCHAR2_TABLE_100 DEFAULT NULL,

Line 2855: p_attr_values_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,
2859: x_return_status OUT VARCHAR2,

Line 2880: l_attributes JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000() ;

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

Line 3269: x_attributes OUT JTF_VARCHAR2_TABLE_4000,

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
3273: )

Line 3278: l_attributes JTF_VARCHAR2_TABLE_4000 ;

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 ;
3282: l_msg_data VARCHAR2(2000) ;

Line 3400: p_attr_values_for_update IN JTF_VARCHAR2_TABLE_4000 DEFAULT NULL,

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,
3404: p_api_version IN NUMBER DEFAULT 1.0,

Line 3415: l_attributes JTF_VARCHAR2_TABLE_4000 ;

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) ;
3419: l_msg_count NUMBER ;

Line 3814: l_attributes JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000() ;

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

Line 4081: l_attributes JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000() ;

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

Line 5025: l_attributes JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000() ;

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() ;
5029: l_dummy_sort_order JTF_NUMBER_TABLE := JTF_NUMBER_TABLE() ;

Line 5407: l_attributes JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_4000() ;

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

Line 5702: l_attributes JTF_VARCHAR2_TABLE_4000 := JTF_VARCHAR2_TABLE_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: --
5706: l_data_src_fld_ids JTF_NUMBER_TABLE ; -- This is initilized below.