The following lines contain the word 'select', 'insert', 'update' or 'delete':
just before calling send request we will insert a record into
history table. Reason. GET_ATTACH_FILE_ID AND GET_FILE_ID in jtfgfmob.pls should
know about REQUEST_TYPE 'T'
other details in GET_ATTACH_FILE_ID and GET_FILE_ID
**/
IF (upper(p_fulfill_electronic_rec.request_type) = 'T') THEN
JTF_FM_UTL_V.PRINT_MESSAGE('THE REQUEST TYPE IS TEST',JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
INSERT INTO JTF_FM_TEST_REQUESTS (REQUEST_ID) VALUES (x_request_history_id);
UPDATE JTF_FM_REQUEST_HISTORY_ALL
SET request_type = 'T'
WHERE hist_req_id = x_request_history_id;