APPS.AS_INTEREST_CODES_PKG dependencies on AS_INTEREST_CODES_B

Line 42: select ROWID from AS_INTEREST_CODES_B

38: X_PROD_CAT_SET_ID in NUMBER,
39: X_PROD_CAT_ID in NUMBER
40: ) is
41: cursor C is
42: select ROWID from AS_INTEREST_CODES_B
43: where INTEREST_CODE_ID = X_INTEREST_CODE_ID;
44:
45: BEGIN
46: insert into AS_INTEREST_CODES_B (

Line 46: insert into AS_INTEREST_CODES_B (

42: select ROWID from AS_INTEREST_CODES_B
43: where INTEREST_CODE_ID = X_INTEREST_CODE_ID;
44:
45: BEGIN
46: insert into AS_INTEREST_CODES_B (
47: INTEREST_CODE_ID,
48: INTEREST_TYPE_ID,
49: ENABLED_FLAG,
50: PARENT_INTEREST_CODE_ID,

Line 226: from AS_INTEREST_CODES_B

222: ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10,
223: ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13,
224: ATTRIBUTE14, ATTRIBUTE15,
225: PRODUCT_CAT_SET_ID, PRODUCT_CATEGORY_ID
226: from AS_INTEREST_CODES_B
227: where INTEREST_CODE_ID = X_INTEREST_CODE_ID
228: for update of INTEREST_CODE_ID nowait;
229:
230: recinfo c%rowtype;

Line 399: AS_INTEREST_CODES_B set

395: X_PROD_CAT_ID in NUMBER
396: ) is
397: begin
398: update
399: AS_INTEREST_CODES_B set
400: INTEREST_TYPE_ID = X_INTEREST_TYPE_ID,
401: ENABLED_FLAG = X_ENABLED_FLAG,
402: PARENT_INTEREST_CODE_ID = X_PARENT_INTEREST_CODE_ID,
403: CATEGORY_ID = X_CATEGORY_ID,

Line 481: delete from AS_INTEREST_CODES_B

477: if (sql%notfound) then
478: raise no_data_found;
479: end if;
480:
481: delete from AS_INTEREST_CODES_B
482: where INTEREST_CODE_ID = X_INTEREST_CODE_ID;
483:
484: if (sql%notfound) then
485: raise no_data_found;

Line 514: from AS_INTEREST_CODES_B B

510: begin
511: delete from AS_INTEREST_CODES_TL T
512: where not exists
513: (select NULL
514: from AS_INTEREST_CODES_B B
515: where B.INTEREST_CODE_ID = T.INTEREST_CODE_ID
516: );
517:
518: update AS_INTEREST_CODES_TL T set (