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);
1663: l_bind_values AMF_REQUEST.string_tbl_type;
1664: l_party_id AMF_REQUEST.number_tbl_type;
1665: */
1666:
1667: l_email JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
1668: l_fax JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
1669: l_party_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE;
1670: l_bind_names JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
1671: l_bind_values JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
1664: l_party_id AMF_REQUEST.number_tbl_type;
1665: */
1666:
1667: l_email JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
1668: l_fax JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
1669: l_party_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE;
1670: l_bind_names JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
1671: l_bind_values JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
1672:
1665: */
1666:
1667: l_email JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
1668: l_fax JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
1669: l_party_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE;
1670: l_bind_names JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
1671: l_bind_values JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
1672:
1673:
1666:
1667: l_email JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
1668: l_fax JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
1669: l_party_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE;
1670: l_bind_names JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
1671: l_bind_values JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
1672:
1673:
1674:
1667: l_email JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
1668: l_fax JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
1669: l_party_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE;
1670: l_bind_names JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
1671: l_bind_values JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
1672:
1673:
1674:
1675: l_object_type VARCHAR2(30);
2102: l_bind_values AMF_REQUEST.string_tbl_type;
2103: l_party_id AMF_REQUEST.number_tbl_type;
2104: */
2105:
2106: l_email JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
2107: l_fax JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
2108: l_party_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE;
2109: l_bind_names JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
2110: l_bind_values JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
2103: l_party_id AMF_REQUEST.number_tbl_type;
2104: */
2105:
2106: l_email JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
2107: l_fax JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
2108: l_party_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE;
2109: l_bind_names JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
2110: l_bind_values JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
2111:
2104: */
2105:
2106: l_email JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
2107: l_fax JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
2108: l_party_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE;
2109: l_bind_names JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
2110: l_bind_values JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
2111:
2112: l_object_type VARCHAR2(30);
2105:
2106: l_email JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
2107: l_fax JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
2108: l_party_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE;
2109: l_bind_names JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
2110: l_bind_values JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
2111:
2112: l_object_type VARCHAR2(30);
2113: l_request_history_id NUMBER;
2106: l_email JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
2107: l_fax JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
2108: l_party_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE;
2109: l_bind_names JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
2110: l_bind_values JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
2111:
2112: l_object_type VARCHAR2(30);
2113: l_request_history_id NUMBER;
2114:
3109: l_bind_values AMF_REQUEST.string_tbl_type;
3110: l_party_id AMF_REQUEST.number_tbl_type;
3111: */
3112:
3113: l_email JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
3114: l_fax JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
3115: l_party_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE;
3116: l_bind_names JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
3117: l_bind_values JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
3110: l_party_id AMF_REQUEST.number_tbl_type;
3111: */
3112:
3113: l_email JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
3114: l_fax JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
3115: l_party_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE;
3116: l_bind_names JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
3117: l_bind_values JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
3118:
3111: */
3112:
3113: l_email JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
3114: l_fax JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
3115: l_party_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE;
3116: l_bind_names JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
3117: l_bind_values JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
3118:
3119: l_object_type VARCHAR2(30);
3112:
3113: l_email JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
3114: l_fax JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
3115: l_party_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE;
3116: l_bind_names JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
3117: l_bind_values JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
3118:
3119: l_object_type VARCHAR2(30);
3120: l_request_history_id NUMBER;
3113: l_email JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
3114: l_fax JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
3115: l_party_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE;
3116: l_bind_names JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
3117: l_bind_values JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
3118:
3119: l_object_type VARCHAR2(30);
3120: l_request_history_id NUMBER;
3121: