APPS.FA_CATEGORIES_PKG dependencies on FA_CATEGORIES_B

Line 69: cursor C is select ROWID from FA_CATEGORIES_B

65: X_LAST_UPDATE_DATE in DATE,
66: X_LAST_UPDATED_BY in NUMBER,
67: X_LAST_UPDATE_LOGIN in NUMBER
68: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
69: cursor C is select ROWID from FA_CATEGORIES_B
70: where CATEGORY_ID = X_CATEGORY_ID
71: ;
72: begin
73: insert into FA_CATEGORIES_B (

Line 73: insert into FA_CATEGORIES_B (

69: cursor C is select ROWID from FA_CATEGORIES_B
70: where CATEGORY_ID = X_CATEGORY_ID
71: ;
72: begin
73: insert into FA_CATEGORIES_B (
74: CATEGORY_ID,
75: SUMMARY_FLAG,
76: ENABLED_FLAG,
77: OWNED_LEASED,

Line 356: from FA_CATEGORIES_B

352: GLOBAL_ATTRIBUTE19,
353: GLOBAL_ATTRIBUTE20,
354: GLOBAL_ATTRIBUTE_CATEGORY,
355: INVENTORIAL
356: from FA_CATEGORIES_B
357: where CATEGORY_ID = X_CATEGORY_ID
358: for update of CATEGORY_ID nowait;
359: recinfo c%rowtype;
360:

Line 570: update FA_CATEGORIES_B set

566: X_LAST_UPDATED_BY in NUMBER,
567: X_LAST_UPDATE_LOGIN in NUMBER
568: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
569: begin
570: update FA_CATEGORIES_B set
571: SUMMARY_FLAG = X_SUMMARY_FLAG,
572: ENABLED_FLAG = X_ENABLED_FLAG,
573: OWNED_LEASED = X_OWNED_LEASED,
574: CATEGORY_TYPE = X_CATEGORY_TYPE,

Line 661: delete from FA_CATEGORIES_B

657: if (sql%notfound) then
658: raise no_data_found;
659: end if;
660:
661: delete from FA_CATEGORIES_B
662: where CATEGORY_ID = X_CATEGORY_ID;
663:
664: if (sql%notfound) then
665: raise no_data_found;

Line 675: from FA_CATEGORIES_B B

671: begin
672: delete from FA_CATEGORIES_TL T
673: where not exists
674: (select NULL
675: from FA_CATEGORIES_B B
676: where B.CATEGORY_ID = T.CATEGORY_ID
677: );
678:
679: update FA_CATEGORIES_TL T set (

Line 803: from fa_categories_b

799: user_id := 0;
800:
801: select count(*)
802: into h_record_exists
803: from fa_categories_b
804: where category_id = X_Category_Id;
805:
806: if (h_record_exists > 0) then
807: fa_categories_pkg.update_row (

Line 1023: from fa_categories_b

1019: user_id := fnd_load_util.owner_id (X_Owner);
1020:
1021: select count(*)
1022: into h_record_exists
1023: from fa_categories_b
1024: where category_id = X_Category_Id;
1025:
1026: if (h_record_exists > 0) then
1027:

Line 1030: from fa_categories_b

1026: if (h_record_exists > 0) then
1027:
1028: select last_updated_by, last_update_date
1029: into db_last_updated_by, db_last_update_date
1030: from fa_categories_b
1031: where category_id = X_Category_Id;
1032:
1033: if (fnd_load_util.upload_test(user_id, x_last_update_date,
1034: db_last_updated_by, db_last_update_date,