1: package body FA_LOOKUPS_PKG as
2: /* $Header: faxilob.pls 120.9 2006/06/29 20:49:14 glchen ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out nocopy VARCHAR2,
5: X_LOOKUP_TYPE in VARCHAR2,
491: if (fnd_load_util.upload_test(user_id, x_last_update_date,
492: db_last_updated_by, db_last_update_date,
493: X_CUSTOM_MODE)) then
494:
495: fa_lookups_pkg.update_row (
496: X_Lookup_Type => X_Lookup_Type,
497: X_Lookup_Code => X_Lookup_Code,
498: X_Enabled_Flag => X_Enabled_Flag,
499: X_Start_Date_Active => X_Start_Date_Active,
521: X_Last_Update_Login => 0
522: ,p_log_level_rec => p_log_level_rec);
523: end if;
524: else
525: fa_lookups_pkg.insert_row (
526: X_Rowid => row_id,
527: X_Lookup_Type => X_Lookup_Type,
528: X_Lookup_Code => X_Lookup_Code,
529: X_Enabled_Flag => X_Enabled_Flag,
557:
558: exception
559: when others then
560: FA_STANDARD_PKG.RAISE_ERROR(
561: CALLED_FN => 'fa_lookups_pkg.load_row',
562: CALLING_FN => 'upload fa_lookups'
563: ,p_log_level_rec => p_log_level_rec);
564:
565: end LOAD_ROW;
641:
642: BEGIN
643:
644: if (x_upload_mode = 'NLS') then
645: fa_lookups_pkg.TRANSLATE_ROW (
646: x_custom_mode => x_custom_mode,
647: x_lookup_type => x_lookup_type,
648: x_lookup_code => x_lookup_code,
649: x_owner => x_owner,
650: x_last_update_date => x_last_update_date,
651: x_meaning => x_meaning,
652: x_description => x_description);
653: else
654: fa_lookups_pkg.LOAD_ROW (
655: x_custom_mode => x_custom_mode,
656: x_lookup_type => x_lookup_type,
657: x_lookup_code => x_lookup_code,
658: x_owner => x_owner,
682: end if;
683:
684: END LOAD_SEED_ROW;
685:
686: end FA_LOOKUPS_PKG;