APPS.AS_OPP_COMPETITOR_PVT dependencies on AS_LEAD_COMPETITORS

Line 223: -- Invoke table handler(AS_LEAD_COMPETITORS_PKG.Insert_Row)

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,

Line 224: AS_LEAD_COMPETITORS_PKG.Insert_Row(

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,

Line 371: From AS_LEAD_COMPETITORS

367:
368: IS
369: Cursor C_Get_competitor(c_LEAD_COMPETITOR_ID Number) IS
370: Select LAST_UPDATE_DATE
371: From AS_LEAD_COMPETITORS
372: WHERE LEAD_COMPETITOR_ID = c_LEAD_COMPETITOR_ID
373: For Update NOWAIT;
374:
375: L_Api_Name CONSTANT VARCHAR2(30) := 'Update_competitors';

Line 595: -- Invoke table handler(AS_LEAD_COMPETITORS_PKG.Update_Row)

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,

Line 596: AS_LEAD_COMPETITORS_PKG.Update_Row(

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,

Line 889: -- Invoke table handler(AS_LEAD_COMPETITORS_PKG.Delete_Row)

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 :=

Line 890: AS_LEAD_COMPETITORS_PKG.Delete_Row(

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;

Line 996: FROM as_lead_competitors

992: )
993: IS
994: CURSOR C_Lead_Competitor_Id_Exists (c_Lead_Competitor_Id NUMBER) IS
995: SELECT 'X'
996: FROM as_lead_competitors
997: WHERE lead_competitor_id = c_Lead_Competitor_Id;
998:
999: l_val VARCHAR2(1);
1000: l_module CONSTANT VARCHAR2(255) := 'as.plsql.cmppv.Validate_LEAD_COMPETITOR_ID';