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 674: from fnd_application

670: begin
671:
672: begin
673: select application_id into app_id
674: from fnd_application
675: where application_short_name = X_APP_SHORT_NAME;
676: exception
677: when no_data_found then
678: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');

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

675: where application_short_name = X_APP_SHORT_NAME;
676: exception
677: when no_data_found then
678: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
679: fnd_message.set_token('TABLE', 'FND_APPLICATION');
680: fnd_message.set_token('COLUMN', 'APPLICATION_SHORT_NAME');
681: fnd_message.set_token('VALUE', x_app_short_name);
682: app_exception.raise_exception;
683: end;

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

684:
685: begin
686: select dgu.data_group_id, dgu.application_id
687: into dataGroup_Id, dataGroupApp_id
688: from fnd_data_group_units dgu, fnd_data_groups dg, fnd_application a
689: where dgu.data_group_id = dg.data_group_id
690: and dg.data_group_name = X_DATA_GROUP_NAME
691: and dgu.application_id = a.application_id
692: and a.application_short_name = X_DATA_GROUP_APP_SHORT_NAME;

Line 732: from fnd_application

728: (X_REQUEST_GROUP_NAME is not null)) then
729: begin
730: select application_id
731: into requestGroupApp_id
732: from fnd_application
733: where application_short_name = X_GROUP_APP_SHORT_NAME;
734:
735: exception
736: when no_data_found then

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

734:
735: exception
736: when no_data_found then
737: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
738: fnd_message.set_token('TABLE', 'FND_APPLICATION');
739: fnd_message.set_token('COLUMN', 'GROUP_APP_SHORT_NAME');
740: fnd_message.set_token('VALUE', X_GROUP_APP_SHORT_NAME);
741: app_exception.raise_exception;
742: end;