DBA Data[Home] [Help]

APPS.FND_USER_PKG dependencies on FND_DICTIONARY_PKG

Line 2672: colnames fnd_dictionary_pkg.NameArrayTyp;

2668: -- Private
2669: -- Called by user_synch when user_name is changed
2670: procedure UpdateUserNameChildren(old_name in varchar2,
2671: new_name in varchar2) is
2672: colnames fnd_dictionary_pkg.NameArrayTyp;
2673: colold fnd_dictionary_pkg.NameArrayTyp;
2674: colnew fnd_dictionary_pkg.NameArrayTyp;
2675: l_api_name CONSTANT varchar2(30) := 'UpdateUsernameChildren';
2676: tmpbuf varchar2(240);

Line 2673: colold fnd_dictionary_pkg.NameArrayTyp;

2669: -- Called by user_synch when user_name is changed
2670: procedure UpdateUserNameChildren(old_name in varchar2,
2671: new_name in varchar2) is
2672: colnames fnd_dictionary_pkg.NameArrayTyp;
2673: colold fnd_dictionary_pkg.NameArrayTyp;
2674: colnew fnd_dictionary_pkg.NameArrayTyp;
2675: l_api_name CONSTANT varchar2(30) := 'UpdateUsernameChildren';
2676: tmpbuf varchar2(240);
2677: reason varchar2(2000);

Line 2674: colnew fnd_dictionary_pkg.NameArrayTyp;

2670: procedure UpdateUserNameChildren(old_name in varchar2,
2671: new_name in varchar2) is
2672: colnames fnd_dictionary_pkg.NameArrayTyp;
2673: colold fnd_dictionary_pkg.NameArrayTyp;
2674: colnew fnd_dictionary_pkg.NameArrayTyp;
2675: l_api_name CONSTANT varchar2(30) := 'UpdateUsernameChildren';
2676: tmpbuf varchar2(240);
2677: reason varchar2(2000);
2678: ret boolean;

Line 2688: tmpbuf := 'Start calling fnd_dictionary_pkg.updatepkcolumns('||

2684: colold(1) := '';
2685: colnew(0) := new_name;
2686: colnew(1) := '';
2687:
2688: tmpbuf := 'Start calling fnd_dictionary_pkg.updatepkcolumns('||
2689: old_name||','||new_name||')';
2690: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2691: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name || '.',
2692: tmpbuf);

Line 2694: ret := fnd_dictionary_pkg.updatepkcolumns('FND', 'FND_USER', colnames, colold,

2690: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2691: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name || '.',
2692: tmpbuf);
2693: end if;
2694: ret := fnd_dictionary_pkg.updatepkcolumns('FND', 'FND_USER', colnames, colold,
2695: colnew);
2696: tmpbuf := 'Finished fnd_dictionary_pkg.updatepkcolumns';
2697: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2698: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name || '.',

Line 2696: tmpbuf := 'Finished fnd_dictionary_pkg.updatepkcolumns';

2692: tmpbuf);
2693: end if;
2694: ret := fnd_dictionary_pkg.updatepkcolumns('FND', 'FND_USER', colnames, colold,
2695: colnew);
2696: tmpbuf := 'Finished fnd_dictionary_pkg.updatepkcolumns';
2697: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
2698: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name || '.',
2699: tmpbuf);
2700: end if;