APPS.JTF_FM_IH_LOGGER_PVT dependencies on JTF_FM_PROCESSED

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 200: from jtf_fm_processed

196: --Query lines for the readytolog request id
197: cursor ih_lines (l_request_id IN NUMBER, l_sent_result_id IN NUMBER, l_not_sent_result_id IN NUMBER) is
198: select REQUEST_ID, JOB, PARTY_ID, EMAIL_ADDRESS, OUTCOME_CODE, decode(EMAIL_STATUS,'SENT',l_sent_result_id,l_not_sent_result_id) as RESULT_ID,
199: to_char(CREATION_DATE, 'MON DD RRRR HH24:MI:SS') as CREATION_DATE
200: from jtf_fm_processed
201: where request_id = l_request_id;
202:
203: --Resource id cursor
204: cursor resource_cur (l_user_id IN NUMBER) IS