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 default null) 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 (
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,
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:
564: X_LAST_UPDATED_BY in NUMBER,
565: X_LAST_UPDATE_LOGIN in NUMBER,
566: p_log_level_rec in fa_api_types.log_level_rec_type default null) is
567: begin
568: update FA_CATEGORIES_B set
569: SUMMARY_FLAG = X_SUMMARY_FLAG,
570: ENABLED_FLAG = X_ENABLED_FLAG,
571: OWNED_LEASED = X_OWNED_LEASED,
572: CATEGORY_TYPE = X_CATEGORY_TYPE,
655: if (sql%notfound) then
656: raise no_data_found;
657: end if;
658:
659: delete from FA_CATEGORIES_B
660: where CATEGORY_ID = X_CATEGORY_ID;
661:
662: if (sql%notfound) then
663: raise no_data_found;
669: begin
670: delete from FA_CATEGORIES_TL T
671: where not exists
672: (select NULL
673: from FA_CATEGORIES_B B
674: where B.CATEGORY_ID = T.CATEGORY_ID
675: );
676:
677: update FA_CATEGORIES_TL T set (
802: user_id := fnd_load_util.owner_id (X_Owner);
803:
804: select count(*)
805: into h_record_exists
806: from fa_categories_b
807: where category_id = X_Category_Id;
808:
809: if (h_record_exists > 0) then
810:
809: if (h_record_exists > 0) then
810:
811: select last_updated_by, last_update_date
812: into db_last_updated_by, db_last_update_date
813: from fa_categories_b
814: where category_id = X_Category_Id;
815:
816: if (fnd_load_util.upload_test(user_id, x_last_update_date,
817: db_last_updated_by, db_last_update_date,