APPS.EDR_UTILITIES dependencies on FND_APPLICATION

Line 195: FROM FND_APPLICATION

191: /* AME Processing, Select APPLICATION_ID of the Event. */
192: /* Required by AME. Assumption made here is OWNER_TAG will always be set to application Short Name*/
193: BEGIN
194: SELECT application_id,APPLICATION_SHORT_NAME into l_application_id,l_application_code
195: FROM FND_APPLICATION
196: WHERE APPLICATION_SHORT_NAME in
197: (SELECT OWNER_TAG from WF_EVENTS WHERE NAME=evt.getEventName( ));
198:
199: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_EVENT_APP_CODE');

Line 233: where FND_APPLICATION_ID=l_application_id

229: fnd_file.put_line(fnd_file.output, fnd_message.get);
230:
231: select application_name into l_application_name
232: from ame_Calling_Apps
233: where FND_APPLICATION_ID=l_application_id
234: and TRANSACTION_TYPE_ID=NVL(l_ame_transaction_type,evt.getEventName( ))
235: --Bug 4652277: Start
236: --and end_Date is null;
237: and sysdate between START_DATE AND NVL(END_DATE, SYSDATE);

Line 1790: FROM FND_APPLICATION

1786:
1787: --Obtain the application id and code.
1788: SELECT application_id,APPLICATION_SHORT_NAME into l_application_id,
1789: l_application_code
1790: FROM FND_APPLICATION
1791: WHERE APPLICATION_SHORT_NAME in
1792: (SELECT OWNER_TAG from WF_EVENTS
1793: WHERE NAME=evt.getEventName( ));
1794: --For the obtained AME transaction, fetch the rules that are are

Line 1832: where FND_APPLICATION_ID=l_application_id

1828: -- Bug 5167817 : end
1829: --Obtain the application name
1830: select application_name into l_application_name
1831: from ame_Calling_Apps
1832: where FND_APPLICATION_ID=l_application_id
1833: and TRANSACTION_TYPE_ID=NVL(l_ame_transaction_type,evt.getEventName( ))
1834: --Bug 4652277: Start
1835: --and end_Date is null;
1836: and sysdate between START_DATE AND NVL(END_DATE, SYSDATE);