APPS.AS_INTEREST_PVT dependencies on AS_INTERESTS

Line 368: from AS_INTERESTS_ALL

364: CURSOR duplicate_cat_cur(p_customer_id IN NUMBER,
365: p_product_category_id IN NUMBER,
366: p_product_cat_set_id IN NUMBER) IS
367: select 1
368: from AS_INTERESTS_ALL
369: where customer_id = p_customer_id
370: and interest_use_code = 'CONTACT_INTEREST'
371: and product_category_id = p_product_category_id
372: and product_cat_set_id = p_product_cat_set_id;

Line 619: -- AS_INTERESTS

615: END IF;
616:
617: --
618: -- Loop through the pl/sql interest table, and insert the records into
619: -- AS_INTERESTS
620: --
621: FOR l_curr_row IN 1..l_interest_count
622: LOOP
623:

Line 690: AS_INTERESTS_PKG.Insert_Row ( X_Rowid => l_rowid,

686: l_rowid := NULL;
687: l_interest_id := NULL;
688:
689: -- Insert interest row
690: AS_INTERESTS_PKG.Insert_Row ( X_Rowid => l_rowid,
691: X_Interest_Id => l_interest_tbl(l_curr_row).interest_id,
692: X_Last_Update_Date =>sysdate,
693: X_Last_Updated_By =>FND_GLOBAL.User_Id,
694: X_Creation_Date => SYSDATE,

Line 990: FROM as_interests

986: x_lead_id NUMBER;
987:
988: cursor get_interest_info_csr is
989: SELECT rowid, last_update_date
990: FROM as_interests
991: WHERE interest_id = p_interest_rec.interest_id
992: FOR UPDATE of interest_Id NOWAIT;
993:
994: CURSOR duplicate_cat_cur(p_customer_id IN NUMBER,

Line 999: from AS_INTERESTS_ALL

995: p_interest_id IN NUMBER,
996: p_product_category_id IN NUMBER,
997: p_product_cat_set_id IN NUMBER) IS
998: select 1
999: from AS_INTERESTS_ALL
1000: where customer_id = p_customer_id
1001: and interest_use_code = 'CONTACT_INTEREST'
1002: and product_category_id = p_product_category_id
1003: and product_cat_set_id = p_product_cat_set_id

Line 1275: FND_MESSAGE.Set_Token('INFO', 'AS_INTERESTS', FALSE);

1271: then
1272: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1273: THEN
1274: FND_MESSAGE.Set_Name('AS', 'API_RECORD_CHANGED');
1275: FND_MESSAGE.Set_Token('INFO', 'AS_INTERESTS', FALSE);
1276: FND_MSG_PUB.ADD;
1277: END IF;
1278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1279: else

Line 1281: AS_INTERESTS_PKG.Update_Row ( X_Rowid => l_rowid,

1277: END IF;
1278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1279: else
1280:
1281: AS_INTERESTS_PKG.Update_Row ( X_Rowid => l_rowid,
1282: X_Interest_Id => p_interest_rec.interest_id,
1283: X_Last_Update_Date => SYSDATE,
1284: X_Last_Updated_By => FND_GLOBAL.USER_ID,
1285: X_Last_Update_Login => FND_GLOBAL.Conc_Login_Id,

Line 1445: from as_interests_all

1441: x_msg_data OUT NOCOPY VARCHAR2
1442: ) is
1443: cursor get_interest_info_csr(p_interest_id NUMBER) is
1444: select 1
1445: from as_interests_all
1446: where interest_id = p_interest_id;
1447:
1448: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Interest';
1449: l_api_version_number CONSTANT NUMBER := 2.0;

Line 1615: delete from as_interests_all

1611: END IF;
1612: END IF;
1613: end if; -- p_check_access_flag = 'Y'
1614:
1615: delete from as_interests_all
1616: where interest_id = p_interest_rec.interest_id;
1617:
1618: -- Fix bug 2304022
1619: IF (p_interest_rec.lead_id is not NULL AND

Line 1712: FROM AS_INTERESTS_ALL

1708: IS
1709:
1710: CURSOR C_GET_OLD_PROD_CAT_INFO(l_interest_id NUMBER) IS
1711: SELECT PRODUCT_CATEGORY_ID, PRODUCT_CAT_SET_ID
1712: FROM AS_INTERESTS_ALL
1713: WHERE INTEREST_ID = l_interest_id;
1714:
1715: l_return_status VARCHAR2(1);
1716: l_interest_fields_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;