APPS.AS_INTEREST_PVT dependencies on AS_INTERESTS_ALL

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 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 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;