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 73: select a.dunning_id from iex_dunnings a

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

Line 791: from iex_dunnings

787: set status='CANCELLED'
788: where object_type='IEX_STRATEGY'
789: and status<>'CANCELLED'
790: and xml_request_id in (select xml_request_id
791: from iex_dunnings
792: where object_type='IEX_STRATEGY'
793: and object_id=l_workitem_id);
794: EXCEPTION
795: WHEN NO_DATA_FOUND THEN

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

1652: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1653: iex_debug_pub.logmessage ('check_dunning: level 10' || ' check dunning, party_id = ' || l_party_id);
1654: END IF;
1655: if l_party_id is not null then
1656: select count(*) into l_count from iex_dunnings where dunning_id in (
1657: select dun.dunning_id from iex_dunnings dun
1658: where dun.dunning_object_id = l_party_id
1659: and dun.dunning_level = l_strategy_level
1660: and dun.status = 'CLOSE'

Line 1657: select dun.dunning_id from iex_dunnings dun

1653: iex_debug_pub.logmessage ('check_dunning: level 10' || ' check dunning, party_id = ' || l_party_id);
1654: END IF;
1655: if l_party_id is not null then
1656: select count(*) into l_count from iex_dunnings where dunning_id in (
1657: select dun.dunning_id from iex_dunnings dun
1658: where dun.dunning_object_id = l_party_id
1659: and dun.dunning_level = l_strategy_level
1660: and dun.status = 'CLOSE'
1661: and trunc(sysdate) = trunc(dun.creation_date) );

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

1681: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1682: iex_debug_pub.logmessage ('check_dunning: level 20' || ' check dunning, cust_account_id = ' || l_cust_account_id);
1683: END IF;
1684: if l_cust_account_id is not null then
1685: select count(*) into l_count from iex_dunnings where dunning_id in (
1686: select dun.dunning_id from iex_dunnings dun
1687: where dun.dunning_object_id = l_cust_account_id
1688: and dun.dunning_level = l_strategy_level
1689: and dun.status = 'CLOSE'

Line 1686: select dun.dunning_id from iex_dunnings dun

1682: iex_debug_pub.logmessage ('check_dunning: level 20' || ' check dunning, cust_account_id = ' || l_cust_account_id);
1683: END IF;
1684: if l_cust_account_id is not null then
1685: select count(*) into l_count from iex_dunnings where dunning_id in (
1686: select dun.dunning_id from iex_dunnings dun
1687: where dun.dunning_object_id = l_cust_account_id
1688: and dun.dunning_level = l_strategy_level
1689: and dun.status = 'CLOSE'
1690: and trunc(sysdate) = trunc(dun.creation_date) );

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

1710: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1711: iex_debug_pub.logmessage ('check_dunning: level 30' || ' check dunning, customer_site_use_id = ' || l_customer_site_use_id);
1712: END IF;
1713: if l_customer_site_use_id is not null then
1714: select count(*) into l_count from iex_dunnings where dunning_id in (
1715: select dun.dunning_id from iex_dunnings dun
1716: where dun.dunning_object_id = l_customer_site_use_id
1717: and dun.dunning_level = l_strategy_level
1718: and dun.status = 'CLOSE'

Line 1715: select dun.dunning_id from iex_dunnings dun

1711: iex_debug_pub.logmessage ('check_dunning: level 30' || ' check dunning, customer_site_use_id = ' || l_customer_site_use_id);
1712: END IF;
1713: if l_customer_site_use_id is not null then
1714: select count(*) into l_count from iex_dunnings where dunning_id in (
1715: select dun.dunning_id from iex_dunnings dun
1716: where dun.dunning_object_id = l_customer_site_use_id
1717: and dun.dunning_level = l_strategy_level
1718: and dun.status = 'CLOSE'
1719: and trunc(sysdate) = trunc(dun.creation_date) );

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

1741: iex_debug_pub.logmessage ('check_dunning: 40 ' || ' check dunning, delinquency_id = ' || l_delinquency_id);
1742: END IF;
1743: if l_cust_account_id is not null then
1744: -- begin bug #4230209 03/09/2005 by ctlee, multiple letters were sent in the same day even unique = 'Y'
1745: -- select count(*) into l_count from iex_dunnings where dunning_id in (
1746: -- select dun.dunning_id from iex_delinquencies del, iex_dunnings dun
1747: -- where del.cust_account_id = l_cust_account_id
1748: -- and del.delinquency_id = dun.delinquency_id
1749: -- and dun.status = 'CLOSE'

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

1742: END IF;
1743: if l_cust_account_id is not null then
1744: -- begin bug #4230209 03/09/2005 by ctlee, multiple letters were sent in the same day even unique = 'Y'
1745: -- select count(*) into l_count from iex_dunnings where dunning_id in (
1746: -- select dun.dunning_id from iex_delinquencies del, iex_dunnings dun
1747: -- where del.cust_account_id = l_cust_account_id
1748: -- and del.delinquency_id = dun.delinquency_id
1749: -- and dun.status = 'CLOSE'
1750: -- and trunc(sysdate) = trunc(dun.creation_date) );

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

1747: -- where del.cust_account_id = l_cust_account_id
1748: -- and del.delinquency_id = dun.delinquency_id
1749: -- and dun.status = 'CLOSE'
1750: -- and trunc(sysdate) = trunc(dun.creation_date) );
1751: select count(*) into l_count from iex_dunnings where dunning_id in (
1752: select dun.dunning_id from iex_delinquencies_all del, iex_dunnings dun
1753: where del.cust_account_id = l_cust_account_id
1754: and ((del.delinquency_id = dun.delinquency_id and dun.status = 'CLOSE') or
1755: (del.delinquency_id = dun.delinquency_id and dun.status = 'OPEN' and

Line 1752: select dun.dunning_id from iex_delinquencies_all del, iex_dunnings dun

1748: -- and del.delinquency_id = dun.delinquency_id
1749: -- and dun.status = 'CLOSE'
1750: -- and trunc(sysdate) = trunc(dun.creation_date) );
1751: select count(*) into l_count from iex_dunnings where dunning_id in (
1752: select dun.dunning_id from iex_delinquencies_all del, iex_dunnings dun
1753: where del.cust_account_id = l_cust_account_id
1754: and ((del.delinquency_id = dun.delinquency_id and dun.status = 'CLOSE') or
1755: (del.delinquency_id = dun.delinquency_id and dun.status = 'OPEN' and
1756: del.delinquency_id <> l_delinquency_id )

Line 1844: select a.dunning_id from iex_dunnings a

1840: l_dunning_method varchar2(2000);
1841:
1842: l_DUNNING_rec_upd_old IEX_DUNNING_PUB.DUNNING_REC_TYPE;
1843: cursor c_get_dunning(p_workitem_id number) is
1844: select a.dunning_id from iex_dunnings a
1845: where a.object_id = p_workitem_id
1846: and a.object_type = 'WORK_ITEM'
1847: and a.status <> 'CLOSE';
1848:

Line 2328: select max(dunning_id) into l_parent_dunning_id from iex_dunnings where object_id = p_work_item_id; -- added to fix 16433137 SNUTHALA MAR/08/2013

2324: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2325: iex_debug_pub.logmessage ('resend_fulfillment: ' || ' after fulfil method');
2326: END IF;
2327:
2328: select max(dunning_id) into l_parent_dunning_id from iex_dunnings where object_id = p_work_item_id; -- added to fix 16433137 SNUTHALA MAR/08/2013
2329: -- ctlee - 5/20 create dunning record
2330: -- l_unique_fulfillment := nvl(fnd_profile.value('IEX_STRY_UNIQUE_FULFILMENT'), 'N');
2331: -- if (l_unique_fulfillment = 'Y') then
2332: l_dunning_rec.delinquency_id := l_delinquency_id;

Line 2803: from iex_dunnings dun,

2799:
2800: BEGIN
2801: select dun.object_id
2802: into l_work_item_id
2803: from iex_dunnings dun,
2804: iex_strategy_work_items wi
2805: where dun.object_id=wi.work_item_id
2806: and dun.object_type='IEX_STRATEGY'
2807: and wi.status_code in ('OPEN','INERROR_CHECK_NOTIFY')

Line 2867: from iex_dunnings dun,

2863: PROCEDURE auto_retry_notifications(p_from_date in date,
2864: x_error_message out NOCOPY varchar2) IS
2865: cursor c_error_workitems(l_from_date date) is
2866: select wi.work_item_id work_item_id
2867: from iex_dunnings dun,
2868: iex_strategy_work_items wi,
2869: iex_xml_request_histories xrh
2870: where dun.object_id=wi.work_item_id
2871: and xrh.object_type='IEX_STRATEGY'

Line 2950: from iex_dunnings

2946: where object_type='IEX_STRATEGY'
2947: --and status<>'CANCELLED'
2948: and status in ('IN PROCESS','XMLDATA','XMLDOC')
2949: and xml_request_id in (select xml_request_id
2950: from iex_dunnings
2951: where object_type='IEX_STRATEGY'
2952: and object_id=l_work_item_id);
2953:
2954: wf_engine.SetItemAttrText(itemtype => 'IEXSTFFM',

Line 2974: iex_dunnings

2970: result := wf_engine.eng_completed;
2971:
2972: -- Start for the bug#8435665 by PNAVEENK on 15-May-2009
2973: select failure_reason into l_failure_reason from iex_xml_request_histories where xml_request_id = (select max(xml_request_id) from
2974: iex_dunnings
2975: where object_type='IEX_STRATEGY'
2976: and object_id=l_work_item_id)
2977: and failure_reason is not null;
2978: if l_failure_reason is not null then