APPS.AME_API3 dependencies on AME_CALLING_APPS

Line 2353: from ame_calling_apps

2349: select *
2350: from ame_temp_insertions
2351: where application_id =
2352: (select application_id
2353: from ame_calling_apps
2354: where sysdate between start_date and nvl(end_date,sysdate)
2355: and transaction_type_id = c_txnTypeId
2356: and fnd_application_id = c_applId)
2357: and transaction_id = c_txnId

Line 2368: from ame_calling_apps

2364: description
2365: from ame_temp_insertions
2366: where application_id =
2367: (select application_id
2368: from ame_calling_apps
2369: where sysdate between start_date and nvl(end_date,sysdate)
2370: and transaction_type_id = c_txnTypeId
2371: and fnd_application_id = c_applId)
2372: and transaction_id = c_txnId

Line 2395: from ame_calling_apps

2391: and insertion_order = anchorList(1).insertion_order
2392: and transaction_id = p_transactionIdIn
2393: and application_id =
2394: (select application_id
2395: from ame_calling_apps
2396: where sysdate between start_date and nvl(end_date,sysdate)
2397: and transaction_type_id = p_transactionTypeIn
2398: and fnd_application_id = p_applicationIdIn);
2399: end if;

Line 2415: from ame_calling_apps

2411: and insertion_order = anchorList(i).insertion_order
2412: and transaction_id = p_transactionIdIn
2413: and application_id =
2414: (select application_id
2415: from ame_calling_apps
2416: where sysdate between start_date and nvl(end_date,sysdate)
2417: and transaction_type_id = p_transactionTypeIn
2418: and fnd_application_id = p_applicationIdIn);
2419:

Line 2440: from ame_calling_apps

2436: bulk collect into nameList
2437: from ame_temp_insertions
2438: where application_id =
2439: (select application_id
2440: from ame_calling_apps
2441: where sysdate between start_date and nvl(end_Date,sysdate)
2442: and transaction_type_id = transactionTypeIn
2443: and fnd_application_id = applicationIdIn)
2444: and transaction_id = transactionIdIn

Line 2458: from ame_calling_apps

2454: delete from ame_temp_insertions
2455: where parameter like nameIn||'%'
2456: and application_id =
2457: (select application_id
2458: from ame_calling_apps
2459: where sysdate between start_date and nvl(end_Date,sysdate)
2460: and transaction_type_id = transactionTypeIn
2461: and fnd_application_id = applicationIdIn)
2462: and transaction_id = transactionIdIn;

Line 2515: from ame_calling_apps

2511: from ame_temp_insertions
2512: where parameter like approverIn.name||'%'
2513: and application_id =
2514: (select application_id
2515: from ame_calling_apps
2516: where sysdate between start_date and end_date
2517: and fnd_application_id = applicationIdIn
2518: and transaction_type_id = transactionTypeIn)
2519: and transaction_id = transactionIdIn;

Line 2527: from ame_calling_apps

2523: from ame_temp_insertions
2524: where transaction_id = transactionIdIn
2525: and application_id =
2526: (select application_id
2527: from ame_calling_apps
2528: where sysdate between start_date and nvl(end_Date,sysdate)
2529: and transaction_type_id = transactionTypeIn
2530: and fnd_application_id = applicationIdIn)
2531: and name = approverIn.name;

Line 2546: from ame_calling_apps

2542: end if;
2543: delete from ame_temp_insertions
2544: where
2545: application_id = (select application_id
2546: from ame_calling_apps
2547: where sysdate between start_date and end_date
2548: and fnd_application_id = applicationIdIn
2549: and transaction_type_id = transactionTypeIn) and
2550: transaction_id = transactionIdIn and