DBA Data[Home] [Help]

APPS.AMS_CPAGEUTILITY_PVT dependencies on JTF_VARCHAR2_TABLE_300

Line 287: p_data_source_list IN JTF_VARCHAR2_TABLE_300,

283: p_owner_resource_type IN VARCHAR2,
284: p_has_merge_fields IN VARCHAR2,
285: p_has_page_merge_fields IN VARCHAR2,
286: p_reusable_flag IN VARCHAR2 DEFAULT FND_API.g_false, -- CHANGE to Y or N when IBC folks change the conventions for varchar2 fields.
287: p_data_source_list IN JTF_VARCHAR2_TABLE_300,
288: p_merge_fields_list IN JTF_VARCHAR2_TABLE_300,
289: p_attribute_type_code IN VARCHAR2,
290: p_parent_citem_id IN NUMBER,
291: p_parent_citem_ver_id IN NUMBER,

Line 288: p_merge_fields_list IN JTF_VARCHAR2_TABLE_300,

284: p_has_merge_fields IN VARCHAR2,
285: p_has_page_merge_fields IN VARCHAR2,
286: p_reusable_flag IN VARCHAR2 DEFAULT FND_API.g_false, -- CHANGE to Y or N when IBC folks change the conventions for varchar2 fields.
287: p_data_source_list IN JTF_VARCHAR2_TABLE_300,
288: p_merge_fields_list IN JTF_VARCHAR2_TABLE_300,
289: p_attribute_type_code IN VARCHAR2,
290: p_parent_citem_id IN NUMBER,
291: p_parent_citem_ver_id IN NUMBER,
292: p_parent_ctype_code IN VARCHAR2,

Line 487: x_attribute_type_names OUT JTF_VARCHAR2_TABLE_300,

483: x_attach_file_name OUT VARCHAR2,
484: x_citem_name OUT VARCHAR2,
485: x_description OUT VARCHAR2,
486: x_attribute_type_codes OUT JTF_VARCHAR2_TABLE_100,
487: x_attribute_type_names OUT JTF_VARCHAR2_TABLE_300,
488: x_attributes OUT JTF_VARCHAR2_TABLE_4000,
489: x_cpnt_citem_ids OUT JTF_NUMBER_TABLE,
490: x_cpnt_ctype_codes OUT JTF_VARCHAR2_TABLE_100,
491: x_cpnt_attrib_types OUT JTF_VARCHAR2_TABLE_100,

Line 492: x_cpnt_citem_names OUT JTF_VARCHAR2_TABLE_300,

488: x_attributes OUT JTF_VARCHAR2_TABLE_4000,
489: x_cpnt_citem_ids OUT JTF_NUMBER_TABLE,
490: x_cpnt_ctype_codes OUT JTF_VARCHAR2_TABLE_100,
491: x_cpnt_attrib_types OUT JTF_VARCHAR2_TABLE_100,
492: x_cpnt_citem_names OUT JTF_VARCHAR2_TABLE_300,
493: x_cpnt_sort_orders OUT JTF_NUMBER_TABLE,
494: x_object_version_number OUT NUMBER,
495: x_return_status OUT VARCHAR2,
496: x_msg_count OUT NUMBER,

Line 524: x_attribute_type_names OUT JTF_VARCHAR2_TABLE_300,

520: p_attrib_file_id IN NUMBER DEFAULT NULL,
521: p_api_version IN NUMBER,
522: p_init_msg_list IN VARCHAR2,
523: x_attribute_type_codes OUT JTF_VARCHAR2_TABLE_100,
524: x_attribute_type_names OUT JTF_VARCHAR2_TABLE_300,
525: x_attributes OUT JTF_VARCHAR2_TABLE_4000,
526: x_return_status OUT VARCHAR2,
527: x_msg_count OUT NUMBER,
528: x_msg_data OUT VARCHAR2

Line 861: p_data_source_fields_list IN JTF_VARCHAR2_TABLE_300 DEFAULT NULL,

857: -----------------------------------------------------------------------
858:
859: PROCEDURE generate_select_sql(
860: p_data_source_code IN VARCHAR2,
861: p_data_source_fields_list IN JTF_VARCHAR2_TABLE_300 DEFAULT NULL,
862: p_data_source_field_ids IN JTF_NUMBER_TABLE DEFAULT NULL,
863: x_select_sql_statement OUT VARCHAR2,
864: x_bind_vars OUT JTF_VARCHAR2_TABLE_300,
865: x_return_status OUT VARCHAR2,

Line 864: x_bind_vars OUT JTF_VARCHAR2_TABLE_300,

860: p_data_source_code IN VARCHAR2,
861: p_data_source_fields_list IN JTF_VARCHAR2_TABLE_300 DEFAULT NULL,
862: p_data_source_field_ids IN JTF_NUMBER_TABLE DEFAULT NULL,
863: x_select_sql_statement OUT VARCHAR2,
864: x_bind_vars OUT JTF_VARCHAR2_TABLE_300,
865: x_return_status OUT VARCHAR2,
866: x_msg_count OUT NUMBER,
867: x_msg_data OUT VARCHAR2
868: );