APPS.AS_INTEREST_TYPES_PKG dependencies on AS_INTEREST_TYPES_B

Line 31: FROM AS_INTEREST_TYPES_B

27: ) IS
28:
29: CURSOR C is
30: SELECT ROWID
31: FROM AS_INTEREST_TYPES_B
32: WHERE INTEREST_TYPE_ID = X_INTEREST_TYPE_ID ;
33:
34: BEGIN
35:

Line 42: INSERT INTO AS_INTEREST_TYPES_B

38: -- Inserting into _B table
39:
40: BEGIN
41:
42: INSERT INTO AS_INTEREST_TYPES_B
43: (
44: INTEREST_TYPE_ID,
45: ENABLED_FLAG,
46: COMPANY_CLASSIFICATION_FLAG,

Line 203: from AS_INTEREST_TYPES_B

199: LEAD_CLASSIFICATION_FLAG,
200: EXPECTED_PURCHASE_FLAG,
201: CURRENT_ENVIRONMENT_FLAG,
202: PRODUCT_CAT_SET_ID, PRODUCT_CATEGORY_ID
203: from AS_INTEREST_TYPES_B
204: where INTEREST_TYPE_ID = X_INTEREST_TYPE_ID
205: for update of INTEREST_TYPE_ID nowait;
206: binfo cb%rowtype;
207:

Line 315: UPDATE AS_INTEREST_TYPES_B set

311: ) is
312:
313: BEGIN
314: BEGIN
315: UPDATE AS_INTEREST_TYPES_B set
316: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
317: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
318: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
319: ENABLED_FLAG = X_MASTER_ENABLED_FLAG,

Line 424: delete from AS_INTEREST_TYPES_B

420: raise no_data_found;
421: end if;
422: */
423:
424: delete from AS_INTEREST_TYPES_B
425: where INTEREST_TYPE_ID = X_INTEREST_TYPE_ID;
426:
427: if (sql%notfound) then
428: raise no_data_found;

Line 457: from AS_INTEREST_TYPES_B B

453: begin
454: delete from AS_INTEREST_TYPES_TL T
455: where not exists
456: (select NULL
457: from AS_INTEREST_TYPES_B B
458: where B.INTEREST_TYPE_ID = T.INTEREST_TYPE_ID
459: );
460:
461: update AS_INTEREST_TYPES_TL T