APPS.FND_RESPONSIBILITY_PKG dependencies on FND_APPLICATION

Line 182: from fnd_responsibility r, fnd_application a

178: into db_luby, db_ludate
179: from fnd_responsibility_tl
180: where (RESPONSIBILITY_ID, APPLICATION_ID)
181: = (select r.responsibility_id, r.application_id
182: from fnd_responsibility r, fnd_application a
183: where r.responsibility_key = X_RESP_KEY
184: and r.application_id = a.application_id
185: and a.application_short_name = X_APP_SHORT_NAME)
186: and LANGUAGE = userenv('LANG');

Line 199: from fnd_responsibility r, fnd_application a

195: LAST_UPDATE_LOGIN = 0,
196: SOURCE_LANG = userenv('LANG')
197: where (RESPONSIBILITY_ID, APPLICATION_ID)
198: = (select r.responsibility_id, r.application_id
199: from fnd_responsibility r, fnd_application a
200: where r.responsibility_key = X_RESP_KEY
201: and r.application_id = a.application_id
202: and a.application_short_name = X_APP_SHORT_NAME)
203: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line 207: from fnd_application

203: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
204:
205: -- Sync with WF --
206: select application_id into appl_id
207: from fnd_application
208: where application_short_name = X_APP_SHORT_NAME;
209:
210: select responsibility_id into resp_id
211: from fnd_responsibility

Line 679: from fnd_application

675: begin
676:
677: begin
678: select application_id into app_id
679: from fnd_application
680: where application_short_name = X_APP_SHORT_NAME;
681: exception
682: when no_data_found then
683: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');

Line 684: fnd_message.set_token('TABLE', 'FND_APPLICATION');

680: where application_short_name = X_APP_SHORT_NAME;
681: exception
682: when no_data_found then
683: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
684: fnd_message.set_token('TABLE', 'FND_APPLICATION');
685: fnd_message.set_token('COLUMN', 'APPLICATION_SHORT_NAME');
686: fnd_message.set_token('VALUE', x_app_short_name);
687: app_exception.raise_exception;
688: end;

Line 693: from fnd_data_group_units dgu, fnd_data_groups dg, fnd_application a

689:
690: begin
691: select dgu.data_group_id, dgu.application_id
692: into dataGroup_Id, dataGroupApp_id
693: from fnd_data_group_units dgu, fnd_data_groups dg, fnd_application a
694: where dgu.data_group_id = dg.data_group_id
695: and dg.data_group_name = X_DATA_GROUP_NAME
696: and dgu.application_id = a.application_id
697: and a.application_short_name = X_DATA_GROUP_APP_SHORT_NAME;

Line 737: from fnd_application

733: (X_REQUEST_GROUP_NAME is not null)) then
734: begin
735: select application_id
736: into requestGroupApp_id
737: from fnd_application
738: where application_short_name = X_GROUP_APP_SHORT_NAME;
739:
740: exception
741: when no_data_found then

Line 743: fnd_message.set_token('TABLE', 'FND_APPLICATION');

739:
740: exception
741: when no_data_found then
742: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
743: fnd_message.set_token('TABLE', 'FND_APPLICATION');
744: fnd_message.set_token('COLUMN', 'GROUP_APP_SHORT_NAME');
745: fnd_message.set_token('VALUE', X_GROUP_APP_SHORT_NAME);
746: app_exception.raise_exception;
747: end;