219: END IF;
220:
221: l_LEAD_COMPETITOR_ID := l_Competitor_rec.LEAD_COMPETITOR_ID;
222:
223: -- Invoke table handler(AS_LEAD_COMPETITORS_PKG.Insert_Row)
224: AS_LEAD_COMPETITORS_PKG.Insert_Row(
225: px_LEAD_COMPETITOR_ID => l_LEAD_COMPETITOR_ID,
226: p_LAST_UPDATE_DATE => SYSDATE,
227: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
220:
221: l_LEAD_COMPETITOR_ID := l_Competitor_rec.LEAD_COMPETITOR_ID;
222:
223: -- Invoke table handler(AS_LEAD_COMPETITORS_PKG.Insert_Row)
224: AS_LEAD_COMPETITORS_PKG.Insert_Row(
225: px_LEAD_COMPETITOR_ID => l_LEAD_COMPETITOR_ID,
226: p_LAST_UPDATE_DATE => SYSDATE,
227: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
228: p_CREATION_DATE => SYSDATE,
591: 'Private API: Calling update table handler');
592: END IF;
593:
594:
595: -- Invoke table handler(AS_LEAD_COMPETITORS_PKG.Update_Row)
596: AS_LEAD_COMPETITORS_PKG.Update_Row(
597: p_LEAD_COMPETITOR_ID => l_Competitor_rec.LEAD_COMPETITOR_ID,
598: p_LAST_UPDATE_DATE => SYSDATE,
599: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
592: END IF;
593:
594:
595: -- Invoke table handler(AS_LEAD_COMPETITORS_PKG.Update_Row)
596: AS_LEAD_COMPETITORS_PKG.Update_Row(
597: p_LEAD_COMPETITOR_ID => l_Competitor_rec.LEAD_COMPETITOR_ID,
598: p_LAST_UPDATE_DATE => SYSDATE,
599: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
600: p_CREATION_DATE => SYSDATE,
885: 'Private API: Calling delete table handler');
886: END IF;
887:
888:
889: -- Invoke table handler(AS_LEAD_COMPETITORS_PKG.Delete_Row)
890: AS_LEAD_COMPETITORS_PKG.Delete_Row(
891: p_LEAD_COMPETITOR_ID => l_Competitor_rec.LEAD_COMPETITOR_ID);
892:
893: X_competitor_out_tbl(l_curr_row).LEAD_COMPETITOR_ID :=
886: END IF;
887:
888:
889: -- Invoke table handler(AS_LEAD_COMPETITORS_PKG.Delete_Row)
890: AS_LEAD_COMPETITORS_PKG.Delete_Row(
891: p_LEAD_COMPETITOR_ID => l_Competitor_rec.LEAD_COMPETITOR_ID);
892:
893: X_competitor_out_tbl(l_curr_row).LEAD_COMPETITOR_ID :=
894: l_LEAD_COMPETITOR_ID;