2933: p_object_type IN VARCHAR2,
2934: p_object_id IN NUMBER ,
2935: p_trigger_type IN VARCHAR2 ,
2936: -- p_bind_values IN AMF_REQUEST.string_tbl_type , -- Modified by ptendulk for 1:1
2937: p_bind_values IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE,
2938: p_bind_names IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE,
2939: x_return_status OUT NOCOPY VARCHAR2
2940: )
2941: IS
2934: p_object_id IN NUMBER ,
2935: p_trigger_type IN VARCHAR2 ,
2936: -- p_bind_values IN AMF_REQUEST.string_tbl_type , -- Modified by ptendulk for 1:1
2937: p_bind_values IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE,
2938: p_bind_names IN JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE,
2939: x_return_status OUT NOCOPY VARCHAR2
2940: )
2941: IS
2942: l_request_history_id NUMBER;
2946: l_fax AMF_REQUEST.string_tbl_type;
2947: l_party_id AMF_REQUEST.number_tbl_type;
2948: */
2949:
2950: l_email JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
2951: l_fax JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
2952: l_party_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE;
2953:
2954:
2947: l_party_id AMF_REQUEST.number_tbl_type;
2948: */
2949:
2950: l_email JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
2951: l_fax JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
2952: l_party_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE;
2953:
2954:
2955: l_msg_count NUMBER;
2948: */
2949:
2950: l_email JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
2951: l_fax JTF_FM_REQUEST_GRP.G_VARCHAR_TBL_TYPE;
2952: l_party_id JTF_FM_REQUEST_GRP.G_NUMBER_TBL_TYPE;
2953:
2954:
2955: l_msg_count NUMBER;
2956: l_logged_in_user_id NUMBER;