APPS.JTF_FM_IH_LOGGER_PVT dependencies on JTF_FM_REQUEST_HISTORY_ALL

Line 130: --Procedure looks up for READYTOLOG records in jtf_fm_request_history_all. Calls api to move line records to jtf_fm_processed for this request_id and then creates an interaction string for the lines

126: return l_Header_Str;
127:
128: END ADD_HEADER;
129:
130: --Procedure looks up for READYTOLOG records in jtf_fm_request_history_all. Calls api to move line records to jtf_fm_processed for this request_id and then creates an interaction string for the lines
131: PROCEDURE Log_Interaction_History(P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
132: p_server_id IN NUMBER,
133: x_request_id out nocopy NUMBER,
134: x_return_status out nocopy varchar2,

Line 188: from JTF_FM_REQUEST_HISTORY_ALL fm

184:
185: --Header table for Readytolog status
186: cursor ih_header is
187: select fm.HIST_REQ_ID , fm.SOURCE_CODE_ID, fm.SOURCE_CODE, fm.OBJECT_ID, fm.OBJECT_TYPE, fm.OUTCOME_DESC, fm.SERVER_ID, fm.USER_ID, fm.OUTCOME_CODE
188: from JTF_FM_REQUEST_HISTORY_ALL fm
189: where fm.OUTCOME_CODE = 'READYTOLOG'
190: and fm.SERVER_ID = p_server_id
191: and rownum < 2
192: order by fm.PRIORITY, fm.HIST_REQ_ID;

Line 407: --Update jtf_fm_request_history_all to success

403:
404: --remove header from the jtf_fm_status_all table
405: Remove_from_status(l_header_rec.hist_req_id);
406:
407: --Update jtf_fm_request_history_all to success
408: if ( ( l_header_status_success_flag = 'T') and ( l_header_status_failure_flag = 'F')) then
409: Update_history(l_header_rec.hist_req_id, 'SUCCESS');
410: elsif ( ( l_header_status_success_flag = 'F') and ( l_header_status_failure_flag = 'T')) then
411: Update_history(l_header_rec.hist_req_id, 'FAILURE');

Line 517: update JTF_FM_REQUEST_HISTORY_ALL

513:
514: PROCEDURE Update_history(P_Request_ID IN NUMBER, P_Status IN VARCHAR) Is
515: BEGIN
516:
517: update JTF_FM_REQUEST_HISTORY_ALL
518: set outcome_code = P_Status
519: where hist_req_id = P_Request_id;
520:
521: --commit;