DBA Data[Home] [Help]

APPS.JTF_FM_OCM_REND_REQ dependencies on JTF_VARCHAR2_TABLE_100

Line 9: G_MIME_TBL JTF_VARCHAR2_TABLE_100 :=

5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'jtfgfmrb.pls';
6:
7:
8: --Global Variables
9: G_MIME_TBL JTF_VARCHAR2_TABLE_100 :=
10: JTF_VARCHAR2_TABLE_100(
11: 'TEXT/HTML',
12: 'TEXT/PLAIN',
13: 'APPLICATION/PDF',

Line 10: JTF_VARCHAR2_TABLE_100(

6:
7:
8: --Global Variables
9: G_MIME_TBL JTF_VARCHAR2_TABLE_100 :=
10: JTF_VARCHAR2_TABLE_100(
11: 'TEXT/HTML',
12: 'TEXT/PLAIN',
13: 'APPLICATION/PDF',
14: 'APPLICATION/RTF',

Line 467: rendition_mime_names IN JTF_VARCHAR2_TABLE_100,

463: p_email_format IN VARCHAR2,
464: p_version IN NUMBER,
465: p_content_nm IN VARCHAR2,
466: rendition_file_names IN JTF_VARCHAR2_TABLE_300,
467: rendition_mime_names IN JTF_VARCHAR2_TABLE_100,
468: rendition_mime_types IN JTF_VARCHAR2_TABLE_100,
469: rendition_file_ids IN JTF_NUMBER_TABLE,
470: x_rend_xml OUT NOCOPY VARCHAR2,
471: x_return_status OUT NOCOPY VARCHAR2,

Line 468: rendition_mime_types IN JTF_VARCHAR2_TABLE_100,

464: p_version IN NUMBER,
465: p_content_nm IN VARCHAR2,
466: rendition_file_names IN JTF_VARCHAR2_TABLE_300,
467: rendition_mime_names IN JTF_VARCHAR2_TABLE_100,
468: rendition_mime_types IN JTF_VARCHAR2_TABLE_100,
469: rendition_file_ids IN JTF_NUMBER_TABLE,
470: x_rend_xml OUT NOCOPY VARCHAR2,
471: x_return_status OUT NOCOPY VARCHAR2,
472: x_msg_count OUT NOCOPY NUMBER,

Line 963: attribute_type_codes JTF_VARCHAR2_TABLE_100 DEFAULT NULL;

959: created_by NUMBER;
960: creation_date DATE;
961: last_updated_by NUMBER;
962: last_update_date DATE;
963: attribute_type_codes JTF_VARCHAR2_TABLE_100 DEFAULT NULL;
964: attribute_type_names JTF_VARCHAR2_TABLE_300 DEFAULT NULL;
965: attributes JTF_VARCHAR2_TABLE_32767 DEFAULT NULL;
966: component_citems JTF_NUMBER_TABLE DEFAULT NULL;
967: component_attrib_types JTF_VARCHAR2_TABLE_100 DEFAULT NULL;

Line 967: component_attrib_types JTF_VARCHAR2_TABLE_100 DEFAULT NULL;

963: attribute_type_codes JTF_VARCHAR2_TABLE_100 DEFAULT NULL;
964: attribute_type_names JTF_VARCHAR2_TABLE_300 DEFAULT NULL;
965: attributes JTF_VARCHAR2_TABLE_32767 DEFAULT NULL;
966: component_citems JTF_NUMBER_TABLE DEFAULT NULL;
967: component_attrib_types JTF_VARCHAR2_TABLE_100 DEFAULT NULL;
968: component_citem_names JTF_VARCHAR2_TABLE_300 DEFAULT NULL;
969: component_owner_ids JTF_NUMBER_TABLE DEFAULT NULL;
970: component_owner_types JTF_VARCHAR2_TABLE_100 DEFAULT NULL;
971: component_sort_orders JTF_NUMBER_TABLE DEFAULT NULL;

Line 970: component_owner_types JTF_VARCHAR2_TABLE_100 DEFAULT NULL;

966: component_citems JTF_NUMBER_TABLE DEFAULT NULL;
967: component_attrib_types JTF_VARCHAR2_TABLE_100 DEFAULT NULL;
968: component_citem_names JTF_VARCHAR2_TABLE_300 DEFAULT NULL;
969: component_owner_ids JTF_NUMBER_TABLE DEFAULT NULL;
970: component_owner_types JTF_VARCHAR2_TABLE_100 DEFAULT NULL;
971: component_sort_orders JTF_NUMBER_TABLE DEFAULT NULL;
972: componenet_owner_types JTF_VARCHAR2_TABLE_100 DEFAULT NULL;
973:
974: -- New GET ITEM Params

Line 972: componenet_owner_types JTF_VARCHAR2_TABLE_100 DEFAULT NULL;

968: component_citem_names JTF_VARCHAR2_TABLE_300 DEFAULT NULL;
969: component_owner_ids JTF_NUMBER_TABLE DEFAULT NULL;
970: component_owner_types JTF_VARCHAR2_TABLE_100 DEFAULT NULL;
971: component_sort_orders JTF_NUMBER_TABLE DEFAULT NULL;
972: componenet_owner_types JTF_VARCHAR2_TABLE_100 DEFAULT NULL;
973:
974: -- New GET ITEM Params
975:
976: attach_file_ids NUMBER;

Line 1022: rendition_mime_types JTF_VARCHAR2_TABLE_100 DEFAULT NULL;

1018: l_file_type VARCHAR2(100);
1019: l_userEnvLang VARCHAR2(256) := USERENV('LANG');
1020: rendition_file_ids JTF_NUMBER_TABLE DEFAULT NULL;
1021: rendition_file_names JTF_VARCHAR2_TABLE_300 DEFAULT NULL;
1022: rendition_mime_types JTF_VARCHAR2_TABLE_100 DEFAULT NULL;
1023: rendition_mime_names JTF_VARCHAR2_TABLE_100 DEFAULT NULL;
1024: default_rendition NUMBER;
1025:
1026: keywords JTF_VARCHAR2_TABLE_100 DEFAULT NULL;

Line 1023: rendition_mime_names JTF_VARCHAR2_TABLE_100 DEFAULT NULL;

1019: l_userEnvLang VARCHAR2(256) := USERENV('LANG');
1020: rendition_file_ids JTF_NUMBER_TABLE DEFAULT NULL;
1021: rendition_file_names JTF_VARCHAR2_TABLE_300 DEFAULT NULL;
1022: rendition_mime_types JTF_VARCHAR2_TABLE_100 DEFAULT NULL;
1023: rendition_mime_names JTF_VARCHAR2_TABLE_100 DEFAULT NULL;
1024: default_rendition NUMBER;
1025:
1026: keywords JTF_VARCHAR2_TABLE_100 DEFAULT NULL;
1027:

Line 1026: keywords JTF_VARCHAR2_TABLE_100 DEFAULT NULL;

1022: rendition_mime_types JTF_VARCHAR2_TABLE_100 DEFAULT NULL;
1023: rendition_mime_names JTF_VARCHAR2_TABLE_100 DEFAULT NULL;
1024: default_rendition NUMBER;
1025:
1026: keywords JTF_VARCHAR2_TABLE_100 DEFAULT NULL;
1027:
1028:
1029: BEGIN
1030: