APPS.IEM_REROUTING_HISTS_PVT dependencies on IEM_REROUTE_HISTS

Line 54: select iem_reroute_hists_s1.nextval into l_seq_id from dual;

50: IF p_init_msg_list ='T'
51: THEN
52: FND_MSG_PUB.initialize;
53: END IF;
54: select iem_reroute_hists_s1.nextval into l_seq_id from dual;
55: INSERT INTO IEM_REROUTE_HISTS (
56: reroute_id,
57: MESSAGE_ID ,
58: AGENT_ID ,

Line 55: INSERT INTO IEM_REROUTE_HISTS (

51: THEN
52: FND_MSG_PUB.initialize;
53: END IF;
54: select iem_reroute_hists_s1.nextval into l_seq_id from dual;
55: INSERT INTO IEM_REROUTE_HISTS (
56: reroute_id,
57: MESSAGE_ID ,
58: AGENT_ID ,
59: CREATED_BY ,

Line 171: delete from IEM_REROUTE_HISTS

167: IF p_init_msg_list ='T'
168: THEN
169: FND_MSG_PUB.initialize;
170: END IF;
171: delete from IEM_REROUTE_HISTS
172: where message_id=p_message_id;
173:
174: -- Standard Check Of p_commit.
175: IF p_commit='T' THEN