APPS.JTF_TERR_RPT dependencies on JTF_TAE_RPT_STAGING_OUT

Line 32: delete from jtf.jtf_tae_rpt_staging_out

28:
29: PROCEDURE cleanup
30: as
31: begin
32: delete from jtf.jtf_tae_rpt_staging_out
33: where session_id in (select session_id from APPS.icx_sessions
34: where disabled_flag <> 'N');
35:
36: delete from APPS.jtf_tae_rpt_staging_out

Line 36: delete from APPS.jtf_tae_rpt_staging_out

32: delete from jtf.jtf_tae_rpt_staging_out
33: where session_id in (select session_id from APPS.icx_sessions
34: where disabled_flag <> 'N');
35:
36: delete from APPS.jtf_tae_rpt_staging_out
37: where session_id not in (select session_id from APPS.icx_sessions);
38:
39: commit;
40:

Line 52: delete from jtf_tae_rpt_staging_out

48:
49: BEGIN
50: -- delete previous data for the older dead sessions
51: cleanup;
52: delete from jtf_tae_rpt_staging_out
53: where session_id = p_session_id;
54:
55: l_dyn_str :=
56: ' insert into jtf_tae_rpt_staging_out ' ||

Line 56: ' insert into jtf_tae_rpt_staging_out ' ||

52: delete from jtf_tae_rpt_staging_out
53: where session_id = p_session_id;
54:
55: l_dyn_str :=
56: ' insert into jtf_tae_rpt_staging_out ' ||
57: ' (TRANS_OBJECT_ID, ' ||
58: ' TRANS_DETAIL_OBJECT_ID, ' ||
59: ' SOURCE_ID,' ||
60: ' TRANS_OBJECT_TYPE_ID, ' ||

Line 254: delete from jtf_tae_rpt_staging_out

250: lp_active_date DATE := SYSDATE;
251: lp_sysdate DATE := SYSDATE;
252:
253: BEGIN
254: delete from jtf_tae_rpt_staging_out
255: where session_id = p_session_id;
256: /*
257: insert into jtf_tae_rpt_staging_out
258: (TRANS_OBJECT_ID,

Line 257: insert into jtf_tae_rpt_staging_out

253: BEGIN
254: delete from jtf_tae_rpt_staging_out
255: where session_id = p_session_id;
256: /*
257: insert into jtf_tae_rpt_staging_out
258: (TRANS_OBJECT_ID,
259: TRANS_DETAIL_OBJECT_ID,
260: SOURCE_ID,
261: TRANS_OBJECT_TYPE_ID,

Line 276: insert into jtf_tae_rpt_staging_out

272: p_group_id,
273: p_session_id);
274: */
275: lp_active_date := to_date(p_active_date, 'YYYY/MM/DD');
276: insert into jtf_tae_rpt_staging_out
277: (TRANS_OBJECT_ID,
278: TRANS_DETAIL_OBJECT_ID,
279: SOURCE_ID,
280: TRANS_OBJECT_TYPE_ID,