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_NUMBER_TABLE

Line 487: l_cpnt_citems JTF_NUMBER_TABLE ;

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 ;
491: l_cpnt_owner_ids JTF_NUMBER_TABLE ;

Line 491: l_cpnt_owner_ids JTF_NUMBER_TABLE ;

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

Line 494: l_cpnt_sort_orders JTF_NUMBER_TABLE ;

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: --
497: l_api_name CONSTANT VARCHAR2(30) := 'Approve_Citem_For_Delv';
498: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;

Line 936: l_citem_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE() ;

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

Line 938: l_dummy_sort_order JTF_NUMBER_TABLE := JTF_NUMBER_TABLE() ;

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: --
942: l_api_version_number CONSTANT NUMBER := 1.0;

Line 1482: l_citem_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE() ;

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

Line 1484: l_dummy_sort_order JTF_NUMBER_TABLE := JTF_NUMBER_TABLE() ;

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: --
1488: l_api_version_number CONSTANT NUMBER := 1.0;

Line 1841: l_cpnt_citems JTF_NUMBER_TABLE ;

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 ;
1845: l_cpnt_owner_ids JTF_NUMBER_TABLE ;

Line 1845: l_cpnt_owner_ids JTF_NUMBER_TABLE ;

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

Line 1848: l_cpnt_sort_orders JTF_NUMBER_TABLE ;

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) ;
1851: l_msg_count NUMBER ;
1852: l_msg_data VARCHAR2(2000) ;

Line 1970: x_cpnt_citem_ids OUT JTF_NUMBER_TABLE,

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,
1974: x_cpnt_sort_orders OUT JTF_NUMBER_TABLE,

Line 1974: x_cpnt_sort_orders OUT JTF_NUMBER_TABLE,

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

Line 2014: l_cpnt_citems JTF_NUMBER_TABLE ;

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 ;
2018: l_cpnt_owner_ids JTF_NUMBER_TABLE ;

Line 2018: l_cpnt_owner_ids JTF_NUMBER_TABLE ;

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

Line 2021: l_cpnt_sort_orders JTF_NUMBER_TABLE ;

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

Line 2358: l_citem_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE() ;

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: --
2362: l_api_name CONSTANT VARCHAR2(30) := 'Create_CP_Image';

Line 2359: l_dummy_sort_order JTF_NUMBER_TABLE := JTF_NUMBER_TABLE() ;

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: --
2362: l_api_name CONSTANT VARCHAR2(30) := 'Create_CP_Image';
2363: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;

Line 2881: l_citem_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE() ;

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: --
2885: l_api_name CONSTANT VARCHAR2(30) := 'Update_CP_Image';

Line 2882: l_dummy_sort_order JTF_NUMBER_TABLE := JTF_NUMBER_TABLE() ;

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: --
2885: l_api_name CONSTANT VARCHAR2(30) := 'Update_CP_Image';
2886: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;

Line 3432: l_cpnt_citems JTF_NUMBER_TABLE ;

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

Line 3436: l_cpnt_owner_ids JTF_NUMBER_TABLE ;

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

Line 3439: l_cpnt_sort_orders JTF_NUMBER_TABLE ;

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;
3442: --
3443: l_api_version_number CONSTANT NUMBER := 1.0;

Line 4385: l_citem_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE() ;

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

Line 4387: l_dummy_sort_order JTF_NUMBER_TABLE := JTF_NUMBER_TABLE() ;

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

Line 4652: p_data_source_field_ids IN JTF_NUMBER_TABLE DEFAULT NULL,

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,
4656: x_msg_count OUT NUMBER,

Line 4668: l_data_src_fld_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE() ;

4664: l_return_status VARCHAR2(1) := FND_API.g_ret_sts_success ;
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) ;

Line 5027: l_citem_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE() ;

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() ;
5030: --
5031: l_api_name CONSTANT VARCHAR2(30) := 'Create_Submit_Section';

Line 5029: l_dummy_sort_order JTF_NUMBER_TABLE := JTF_NUMBER_TABLE() ;

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

Line 5706: l_data_src_fld_ids JTF_NUMBER_TABLE ; -- This is initilized below.

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;
5709: --
5710: l_api_version_number CONSTANT NUMBER := 1.0;

Line 5846: l_data_src_fld_ids := JTF_NUMBER_TABLE();

5842: -- where ques.profile_field_id = flds.list_source_field_id
5843: -- and flds.de_list_source_type_code =
5844:
5845: l_fld_cnt := 0;
5846: l_data_src_fld_ids := JTF_NUMBER_TABLE();
5847:
5848: OPEN c_data_src_flds ;
5849: LOOP
5850: FETCH c_data_src_flds INTO l_data_src_fld_id ;