96: l_bind_values AMF_REQUEST.string_tbl_type;
97: l_party_id AMF_REQUEST.number_tbl_type;
98: */
99:
100: l_email JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
101: l_fax JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
102: l_party_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE;
103: l_bind_names JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
104: l_bind_values JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
97: l_party_id AMF_REQUEST.number_tbl_type;
98: */
99:
100: l_email JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
101: l_fax JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
102: l_party_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE;
103: l_bind_names JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
104: l_bind_values JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
105:
98: */
99:
100: l_email JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
101: l_fax JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
102: l_party_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE;
103: l_bind_names JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
104: l_bind_values JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
105:
106:
99:
100: l_email JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
101: l_fax JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
102: l_party_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE;
103: l_bind_names JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
104: l_bind_values JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
105:
106:
107:
100: l_email JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
101: l_fax JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
102: l_party_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE;
103: l_bind_names JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
104: l_bind_values JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
105:
106:
107:
108: l_return_status VARCHAR2(1);
1648: l_bind_values AMF_REQUEST.string_tbl_type;
1649: l_party_id AMF_REQUEST.number_tbl_type;
1650: */
1651:
1652: l_email JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
1653: l_fax JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
1654: l_party_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE;
1655: l_bind_names JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
1656: l_bind_values JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
1649: l_party_id AMF_REQUEST.number_tbl_type;
1650: */
1651:
1652: l_email JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
1653: l_fax JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
1654: l_party_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE;
1655: l_bind_names JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
1656: l_bind_values JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
1657:
1650: */
1651:
1652: l_email JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
1653: l_fax JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
1654: l_party_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE;
1655: l_bind_names JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
1656: l_bind_values JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
1657:
1658:
1651:
1652: l_email JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
1653: l_fax JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
1654: l_party_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE;
1655: l_bind_names JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
1656: l_bind_values JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
1657:
1658:
1659:
1652: l_email JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
1653: l_fax JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
1654: l_party_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE;
1655: l_bind_names JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
1656: l_bind_values JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
1657:
1658:
1659:
1660: l_object_type VARCHAR2(30);
2087: l_bind_values AMF_REQUEST.string_tbl_type;
2088: l_party_id AMF_REQUEST.number_tbl_type;
2089: */
2090:
2091: l_email JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
2092: l_fax JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
2093: l_party_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE;
2094: l_bind_names JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
2095: l_bind_values JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
2088: l_party_id AMF_REQUEST.number_tbl_type;
2089: */
2090:
2091: l_email JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
2092: l_fax JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
2093: l_party_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE;
2094: l_bind_names JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
2095: l_bind_values JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
2096:
2089: */
2090:
2091: l_email JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
2092: l_fax JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
2093: l_party_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE;
2094: l_bind_names JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
2095: l_bind_values JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
2096:
2097: l_object_type VARCHAR2(30);
2090:
2091: l_email JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
2092: l_fax JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
2093: l_party_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE;
2094: l_bind_names JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
2095: l_bind_values JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
2096:
2097: l_object_type VARCHAR2(30);
2098: l_request_history_id NUMBER;
2091: l_email JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
2092: l_fax JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
2093: l_party_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE;
2094: l_bind_names JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
2095: l_bind_values JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
2096:
2097: l_object_type VARCHAR2(30);
2098: l_request_history_id NUMBER;
2099:
3094: l_bind_values AMF_REQUEST.string_tbl_type;
3095: l_party_id AMF_REQUEST.number_tbl_type;
3096: */
3097:
3098: l_email JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
3099: l_fax JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
3100: l_party_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE;
3101: l_bind_names JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
3102: l_bind_values JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
3095: l_party_id AMF_REQUEST.number_tbl_type;
3096: */
3097:
3098: l_email JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
3099: l_fax JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
3100: l_party_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE;
3101: l_bind_names JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
3102: l_bind_values JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
3103:
3096: */
3097:
3098: l_email JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
3099: l_fax JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
3100: l_party_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE;
3101: l_bind_names JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
3102: l_bind_values JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
3103:
3104: l_object_type VARCHAR2(30);
3097:
3098: l_email JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
3099: l_fax JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
3100: l_party_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE;
3101: l_bind_names JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
3102: l_bind_values JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
3103:
3104: l_object_type VARCHAR2(30);
3105: l_request_history_id NUMBER;
3098: l_email JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
3099: l_fax JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
3100: l_party_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE;
3101: l_bind_names JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
3102: l_bind_values JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
3103:
3104: l_object_type VARCHAR2(30);
3105: l_request_history_id NUMBER;
3106: