eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEX_STRATEGY_WORK_PUB dependencies on IEX_DUNNINGS

Line 72: select a.dunning_id from iex_dunnings a

68: l_dunning_method varchar2(2000);
69:
70: l_DUNNING_rec_upd_old IEX_DUNNING_PUB.DUNNING_REC_TYPE;
71: cursor c_get_dunning(p_workitem_id number) is
72: select a.dunning_id from iex_dunnings a
73: where a.object_id = p_workitem_id
74: and a.object_type = 'IEX_STRATEGY'
75: and a.status <> 'CLOSE';
76:

Line 1408: select count(*) into l_count from iex_dunnings where dunning_id in (

1404: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1405: iex_debug_pub.logmessage ('check_dunning: level 10' || ' check dunning, party_id = ' || l_party_id);
1406: END IF;
1407: if l_party_id is not null then
1408: select count(*) into l_count from iex_dunnings where dunning_id in (
1409: select dun.dunning_id from iex_dunnings dun
1410: where dun.dunning_object_id = l_party_id
1411: and dun.dunning_level = l_strategy_level
1412: and dun.status = 'CLOSE'

Line 1409: select dun.dunning_id from iex_dunnings dun

1405: iex_debug_pub.logmessage ('check_dunning: level 10' || ' check dunning, party_id = ' || l_party_id);
1406: END IF;
1407: if l_party_id is not null then
1408: select count(*) into l_count from iex_dunnings where dunning_id in (
1409: select dun.dunning_id from iex_dunnings dun
1410: where dun.dunning_object_id = l_party_id
1411: and dun.dunning_level = l_strategy_level
1412: and dun.status = 'CLOSE'
1413: and trunc(sysdate) = trunc(dun.creation_date) );

Line 1437: select count(*) into l_count from iex_dunnings where dunning_id in (

1433: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1434: iex_debug_pub.logmessage ('check_dunning: level 20' || ' check dunning, cust_account_id = ' || l_cust_account_id);
1435: END IF;
1436: if l_cust_account_id is not null then
1437: select count(*) into l_count from iex_dunnings where dunning_id in (
1438: select dun.dunning_id from iex_dunnings dun
1439: where dun.dunning_object_id = l_cust_account_id
1440: and dun.dunning_level = l_strategy_level
1441: and dun.status = 'CLOSE'

Line 1438: select dun.dunning_id from iex_dunnings dun

1434: iex_debug_pub.logmessage ('check_dunning: level 20' || ' check dunning, cust_account_id = ' || l_cust_account_id);
1435: END IF;
1436: if l_cust_account_id is not null then
1437: select count(*) into l_count from iex_dunnings where dunning_id in (
1438: select dun.dunning_id from iex_dunnings dun
1439: where dun.dunning_object_id = l_cust_account_id
1440: and dun.dunning_level = l_strategy_level
1441: and dun.status = 'CLOSE'
1442: and trunc(sysdate) = trunc(dun.creation_date) );

Line 1466: select count(*) into l_count from iex_dunnings where dunning_id in (

1462: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1463: iex_debug_pub.logmessage ('check_dunning: level 30' || ' check dunning, customer_site_use_id = ' || l_customer_site_use_id);
1464: END IF;
1465: if l_customer_site_use_id is not null then
1466: select count(*) into l_count from iex_dunnings where dunning_id in (
1467: select dun.dunning_id from iex_dunnings dun
1468: where dun.dunning_object_id = l_customer_site_use_id
1469: and dun.dunning_level = l_strategy_level
1470: and dun.status = 'CLOSE'

Line 1467: select dun.dunning_id from iex_dunnings dun

1463: iex_debug_pub.logmessage ('check_dunning: level 30' || ' check dunning, customer_site_use_id = ' || l_customer_site_use_id);
1464: END IF;
1465: if l_customer_site_use_id is not null then
1466: select count(*) into l_count from iex_dunnings where dunning_id in (
1467: select dun.dunning_id from iex_dunnings dun
1468: where dun.dunning_object_id = l_customer_site_use_id
1469: and dun.dunning_level = l_strategy_level
1470: and dun.status = 'CLOSE'
1471: and trunc(sysdate) = trunc(dun.creation_date) );

Line 1497: -- select count(*) into l_count from iex_dunnings where dunning_id in (

1493: iex_debug_pub.logmessage ('check_dunning: 40 ' || ' check dunning, delinquency_id = ' || l_delinquency_id);
1494: END IF;
1495: if l_cust_account_id is not null then
1496: -- begin bug #4230209 03/09/2005 by ctlee, multiple letters were sent in the same day even unique = 'Y'
1497: -- select count(*) into l_count from iex_dunnings where dunning_id in (
1498: -- select dun.dunning_id from iex_delinquencies del, iex_dunnings dun
1499: -- where del.cust_account_id = l_cust_account_id
1500: -- and del.delinquency_id = dun.delinquency_id
1501: -- and dun.status = 'CLOSE'

Line 1498: -- select dun.dunning_id from iex_delinquencies del, iex_dunnings dun

1494: END IF;
1495: if l_cust_account_id is not null then
1496: -- begin bug #4230209 03/09/2005 by ctlee, multiple letters were sent in the same day even unique = 'Y'
1497: -- select count(*) into l_count from iex_dunnings where dunning_id in (
1498: -- select dun.dunning_id from iex_delinquencies del, iex_dunnings dun
1499: -- where del.cust_account_id = l_cust_account_id
1500: -- and del.delinquency_id = dun.delinquency_id
1501: -- and dun.status = 'CLOSE'
1502: -- and trunc(sysdate) = trunc(dun.creation_date) );

Line 1503: select count(*) into l_count from iex_dunnings where dunning_id in (

1499: -- where del.cust_account_id = l_cust_account_id
1500: -- and del.delinquency_id = dun.delinquency_id
1501: -- and dun.status = 'CLOSE'
1502: -- and trunc(sysdate) = trunc(dun.creation_date) );
1503: select count(*) into l_count from iex_dunnings where dunning_id in (
1504: select dun.dunning_id from iex_delinquencies del, iex_dunnings dun
1505: where del.cust_account_id = l_cust_account_id
1506: and ((del.delinquency_id = dun.delinquency_id and dun.status = 'CLOSE') or
1507: (del.delinquency_id = dun.delinquency_id and dun.status = 'OPEN' and

Line 1504: select dun.dunning_id from iex_delinquencies del, iex_dunnings dun

1500: -- and del.delinquency_id = dun.delinquency_id
1501: -- and dun.status = 'CLOSE'
1502: -- and trunc(sysdate) = trunc(dun.creation_date) );
1503: select count(*) into l_count from iex_dunnings where dunning_id in (
1504: select dun.dunning_id from iex_delinquencies del, iex_dunnings dun
1505: where del.cust_account_id = l_cust_account_id
1506: and ((del.delinquency_id = dun.delinquency_id and dun.status = 'CLOSE') or
1507: (del.delinquency_id = dun.delinquency_id and dun.status = 'OPEN' and
1508: del.delinquency_id <> l_delinquency_id )

Line 1596: select a.dunning_id from iex_dunnings a

1592: l_dunning_method varchar2(2000);
1593:
1594: l_DUNNING_rec_upd_old IEX_DUNNING_PUB.DUNNING_REC_TYPE;
1595: cursor c_get_dunning(p_workitem_id number) is
1596: select a.dunning_id from iex_dunnings a
1597: where a.object_id = p_workitem_id
1598: and a.object_type = 'WORK_ITEM'
1599: and a.status <> 'CLOSE';
1600: