DBA Data[Home] [Help]

APPS.AST_CAMP_OUTCOME_PVT dependencies on JTF_IH_OUTCOMES_CAMPAIGNS

Line 109: select count(*) into l_count from jtf_ih_outcomes_campaigns

105:
106: l_camp_outcome_Rec.object_version_number := 1.0;
107:
108: -- add check for weird duplicate records created on astsavesc.jsp
109: select count(*) into l_count from jtf_ih_outcomes_campaigns
110: where object_id = l_camp_outcome_Rec.object_id
111: and outcome_id = l_camp_outcome_Rec.outcome_id;
112: if l_count > 0 then
113: return;

Line 116: INSERT INTO jtf_ih_outcomes_campaigns

112: if l_count > 0 then
113: return;
114: end if;
115:
116: INSERT INTO jtf_ih_outcomes_campaigns
117: (outcome_id
118: ,object_id
119: ,object_version_number
120: ,created_by

Line 245: DELETE FROM jtf_ih_outcomes_campaigns

241: --
242: -- Api body
243: --
244:
245: DELETE FROM jtf_ih_outcomes_campaigns
246: WHERE outcome_id = l_camp_outcome_Rec.outcome_id
247: AND source_code = l_camp_outcome_Rec.source_code
248: AND object_id = l_camp_outcome_Rec.object_id;
249: