DBA Data[Home] [Help]

APPS.FA_LOOKUPS_PKG dependencies on FA_LOOKUPS_PKG

Line 1: package body FA_LOOKUPS_PKG as

1: package body FA_LOOKUPS_PKG as
2: /* $Header: faxilob.pls 120.13 2011/03/11 02:37:44 saalampa ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out nocopy VARCHAR2,
5: X_LOOKUP_TYPE in VARCHAR2,

Line 491: fa_lookups_pkg.update_row (

487: where lookup_type = X_Lookup_Type
488: and lookup_code = X_Lookup_Code;
489:
490: if (h_record_exists > 0) then
491: fa_lookups_pkg.update_row (
492: X_Lookup_Type => X_Lookup_Type,
493: X_Lookup_Code => X_Lookup_Code,
494: X_Enabled_Flag => X_Enabled_Flag,
495: X_Start_Date_Active => X_Start_Date_Active,

Line 520: fa_lookups_pkg.insert_row (

516: X_Last_Updated_By => user_id,
517: X_Last_Update_Login => 0
518: , p_log_level_rec => p_log_level_rec);
519: else
520: fa_lookups_pkg.insert_row (
521: X_Rowid => row_id,
522: X_Lookup_Type => X_Lookup_Type,
523: X_Lookup_Code => X_Lookup_Code,
524: X_Enabled_Flag => X_Enabled_Flag,

Line 556: CALLED_FN => 'fa_lookups_pkg.load_row',

552:
553: exception
554: when others then
555: FA_STANDARD_PKG.RAISE_ERROR(
556: CALLED_FN => 'fa_lookups_pkg.load_row',
557: CALLING_FN => 'upload fa_lookups',
558: p_log_level_rec => p_log_level_rec);
559:
560: end LOAD_ROW;

Line 621: fa_lookups_pkg.update_row (

617: if (fnd_load_util.upload_test(user_id, x_last_update_date,
618: db_last_updated_by, db_last_update_date,
619: X_CUSTOM_MODE)) then
620:
621: fa_lookups_pkg.update_row (
622: X_Lookup_Type => X_Lookup_Type,
623: X_Lookup_Code => X_Lookup_Code,
624: X_Enabled_Flag => X_Enabled_Flag,
625: X_Start_Date_Active => X_Start_Date_Active,

Line 651: fa_lookups_pkg.insert_row (

647: X_Last_Update_Login => 0
648: ,p_log_level_rec => p_log_level_rec);
649: end if;
650: else
651: fa_lookups_pkg.insert_row (
652: X_Rowid => row_id,
653: X_Lookup_Type => X_Lookup_Type,
654: X_Lookup_Code => X_Lookup_Code,
655: X_Enabled_Flag => X_Enabled_Flag,

Line 687: CALLED_FN => 'fa_lookups_pkg.load_row',

683:
684: exception
685: when others then
686: FA_STANDARD_PKG.RAISE_ERROR(
687: CALLED_FN => 'fa_lookups_pkg.load_row',
688: CALLING_FN => 'upload fa_lookups'
689: ,p_log_level_rec => p_log_level_rec);
690:
691: end LOAD_ROW;

Line 802: fa_lookups_pkg.TRANSLATE_ROW (

798:
799: BEGIN
800:
801: if (x_upload_mode = 'NLS') then
802: fa_lookups_pkg.TRANSLATE_ROW (
803: x_custom_mode => x_custom_mode,
804: x_lookup_type => x_lookup_type,
805: x_lookup_code => x_lookup_code,
806: x_owner => x_owner,

Line 811: fa_lookups_pkg.LOAD_ROW (

807: x_last_update_date => x_last_update_date,
808: x_meaning => x_meaning,
809: x_description => x_description);
810: else
811: fa_lookups_pkg.LOAD_ROW (
812: x_custom_mode => x_custom_mode,
813: x_lookup_type => x_lookup_type,
814: x_lookup_code => x_lookup_code,
815: x_owner => x_owner,

Line 843: end FA_LOOKUPS_PKG;

839: end if;
840:
841: END LOAD_SEED_ROW;
842:
843: end FA_LOOKUPS_PKG;