APPS.AS_COMPETITOR_PROD_PVT dependencies on AS_LEAD_COMP_PRODUCTS

Line 52: from as_lead_comp_products

48: RETURN BOOLEAN IS
49:
50: CURSOR dup_exist IS
51: select 'Y'
52: from as_lead_comp_products
53: where lead_line_id = p_Competitor_Prod_rec.lead_line_id
54: and competitor_product_id = p_Competitor_Prod_rec.competitor_product_id;
55:
56: l_dup_exist varchar2(1);

Line 249: FND_MESSAGE.Set_Token ('ROW', 'AS_LEAD_COMP_PRODUCTS', TRUE);

245: --
246: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
247: THEN
248: FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
249: FND_MESSAGE.Set_Token ('ROW', 'AS_LEAD_COMP_PRODUCTS', TRUE);
250: FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(l_curr_row), FALSE);
251: FND_MSG_PUB.Add;
252: END IF;
253:

Line 310: -- Invoke table handler(AS_LEAD_COMP_PRODUCTS_PKG.Insert_Row)

306: END IF;
307:
308: l_LEAD_COMPETITOR_PROD_ID := l_Competitor_Prod_rec.LEAD_COMPETITOR_PROD_ID;
309:
310: -- Invoke table handler(AS_LEAD_COMP_PRODUCTS_PKG.Insert_Row)
311: AS_LEAD_COMP_PRODUCTS_PKG.Insert_Row(
312: p_ATTRIBUTE15 => l_competitor_prod_rec.ATTRIBUTE15,
313: p_ATTRIBUTE14 => l_competitor_prod_rec.ATTRIBUTE14,
314: p_ATTRIBUTE13 => l_competitor_prod_rec.ATTRIBUTE13,

Line 311: AS_LEAD_COMP_PRODUCTS_PKG.Insert_Row(

307:
308: l_LEAD_COMPETITOR_PROD_ID := l_Competitor_Prod_rec.LEAD_COMPETITOR_PROD_ID;
309:
310: -- Invoke table handler(AS_LEAD_COMP_PRODUCTS_PKG.Insert_Row)
311: AS_LEAD_COMP_PRODUCTS_PKG.Insert_Row(
312: p_ATTRIBUTE15 => l_competitor_prod_rec.ATTRIBUTE15,
313: p_ATTRIBUTE14 => l_competitor_prod_rec.ATTRIBUTE14,
314: p_ATTRIBUTE13 => l_competitor_prod_rec.ATTRIBUTE13,
315: p_ATTRIBUTE12 => l_competitor_prod_rec.ATTRIBUTE12,

Line 484: From AS_LEAD_COMP_PRODUCTS

480:
481: IS
482: Cursor C_Get_competitor_prod(c_LEAD_COMPETITOR_PROD_ID Number) IS
483: Select LAST_UPDATE_DATE
484: From AS_LEAD_COMP_PRODUCTS
485: WHERE LEAD_COMPETITOR_PROD_ID = c_LEAD_COMPETITOR_PROD_ID
486: For Update NOWAIT;
487:
488: L_Api_Name CONSTANT VARCHAR2(30) := 'Update_competitor_prods';

Line 621: FND_MESSAGE.Set_Token ('ROW', 'AS_LEAD_COMP_PRODUCTS', TRUE);

617: --
618: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
619: THEN
620: FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
621: FND_MESSAGE.Set_Token ('ROW', 'AS_LEAD_COMP_PRODUCTS', TRUE);
622: FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(l_curr_row), FALSE);
623: FND_MSG_PUB.Add;
624: END IF;
625:

Line 721: -- Invoke table handler(AS_LEAD_COMP_PRODUCTS_PKG.Update_Row)

717: 'Private API: Calling update table handler');
718: END IF;
719:
720:
721: -- Invoke table handler(AS_LEAD_COMP_PRODUCTS_PKG.Update_Row)
722: AS_LEAD_COMP_PRODUCTS_PKG.Update_Row(
723: p_ATTRIBUTE15 => l_competitor_prod_rec.ATTRIBUTE15,
724: p_ATTRIBUTE14 => l_competitor_prod_rec.ATTRIBUTE14,
725: p_ATTRIBUTE13 => l_competitor_prod_rec.ATTRIBUTE13,

Line 722: AS_LEAD_COMP_PRODUCTS_PKG.Update_Row(

718: END IF;
719:
720:
721: -- Invoke table handler(AS_LEAD_COMP_PRODUCTS_PKG.Update_Row)
722: AS_LEAD_COMP_PRODUCTS_PKG.Update_Row(
723: p_ATTRIBUTE15 => l_competitor_prod_rec.ATTRIBUTE15,
724: p_ATTRIBUTE14 => l_competitor_prod_rec.ATTRIBUTE14,
725: p_ATTRIBUTE13 => l_competitor_prod_rec.ATTRIBUTE13,
726: p_ATTRIBUTE12 => l_competitor_prod_rec.ATTRIBUTE12,

Line 1013: FND_MESSAGE.Set_Token ('ROW', 'AS_LEAD_COMP_PRODUCTS', TRUE);

1009: --
1010: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1011: THEN
1012: FND_MESSAGE.Set_Name ('AS', 'API_PROCESSING_ROW');
1013: FND_MESSAGE.Set_Token ('ROW', 'AS_LEAD_COMP_PRODUCTS', TRUE);
1014: FND_MESSAGE.Set_Token ('RECORD_NUM', to_char(l_curr_row), FALSE);
1015: FND_MSG_PUB.Add;
1016: END IF;
1017:

Line 1027: -- Invoke table handler(AS_LEAD_COMP_PRODUCTS_PKG.Delete_Row)

1023: 'Private API: Calling delete table handler');
1024: END IF;
1025:
1026:
1027: -- Invoke table handler(AS_LEAD_COMP_PRODUCTS_PKG.Delete_Row)
1028: AS_LEAD_COMP_PRODUCTS_PKG.Delete_Row(
1029: p_LEAD_COMPETITOR_PROD_ID => l_Competitor_Prod_rec.LEAD_COMPETITOR_PROD_ID);
1030:
1031: X_competitor_prod_out_tbl(l_curr_row).LEAD_COMPETITOR_PROD_ID :=

Line 1028: AS_LEAD_COMP_PRODUCTS_PKG.Delete_Row(

1024: END IF;
1025:
1026:
1027: -- Invoke table handler(AS_LEAD_COMP_PRODUCTS_PKG.Delete_Row)
1028: AS_LEAD_COMP_PRODUCTS_PKG.Delete_Row(
1029: p_LEAD_COMPETITOR_PROD_ID => l_Competitor_Prod_rec.LEAD_COMPETITOR_PROD_ID);
1030:
1031: X_competitor_prod_out_tbl(l_curr_row).LEAD_COMPETITOR_PROD_ID :=
1032: l_LEAD_COMPETITOR_PROD_ID;

Line 1440: FROM as_lead_comp_products

1436: )
1437: IS
1438: CURSOR C_Lead_CProd_Id_Exists (c_Lead_Competitor_Prod_Id NUMBER) IS
1439: SELECT 'X'
1440: FROM as_lead_comp_products
1441: WHERE lead_competitor_prod_id = c_Lead_Competitor_Prod_Id;
1442:
1443: l_val VARCHAR2(1);
1444: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);