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_CNT_PUB dependencies on IEX_STRATEGIES

Line 286: -- TYPE STRATEGY_ID_TBL_type is Table of IEX_strategies.strategy_id%TYPE INDEX BY BINARY_INTEGER;

282: l_batch_size NUMBER ;
283: l_save_count NUMBER ;
284: l_commit_count NUMBER ;
285: l_str_count NUMBER := 0;
286: -- TYPE STRATEGY_ID_TBL_type is Table of IEX_strategies.strategy_id%TYPE INDEX BY BINARY_INTEGER;
287: -- l_strategy_tbl STRATEGY_ID_TBL_TYPE;
288: -- bug 4141678 end - ctlee
289:
290: -- Begin - Andre Araujo -- 01/18/2005 - 4924879 - Improve performance by selecting less records

Line 452: l_del_query := l_del_query || ' and not exists (select 1 from iex_strategies where JTF_OBJECT_TYPE = ''PARTY'' and JTF_OBJECT_ID = d.party_cust_id and STATUS_CODE = ''OPEN'') ';

448:
449: if l_ignore_switch = 'Y' then
450: --Bug#520231 schekuri 05-MAY-2006
451: --Changed OBJECT_TYPE and OBJECT_ID to JTF_OBJECT_TYPE and JTF_OBJECT_ID
452: l_del_query := l_del_query || ' and not exists (select 1 from iex_strategies where JTF_OBJECT_TYPE = ''PARTY'' and JTF_OBJECT_ID = d.party_cust_id and STATUS_CODE = ''OPEN'') ';
453: end if;
454:
455: l_del_query := l_del_query || ' group by d.party_cust_id';
456: l_del_query := l_del_query || ' order by d.party_cust_id';

Line 503: l_del_query := l_del_query || ' and not exists (select 1 from iex_strategies where JTF_OBJECT_TYPE = ''IEX_ACCOUNT'' and JTF_OBJECT_ID = d.cust_account_id and STATUS_CODE = ''OPEN'') ';

499: end if;
500: if l_ignore_switch = 'Y' then
501: --Bug#520231 schekuri 05-MAY-2006
502: --Changed OBJECT_TYPE and OBJECT_ID to JTF_OBJECT_TYPE and JTF_OBJECT_ID
503: l_del_query := l_del_query || ' and not exists (select 1 from iex_strategies where JTF_OBJECT_TYPE = ''IEX_ACCOUNT'' and JTF_OBJECT_ID = d.cust_account_id and STATUS_CODE = ''OPEN'') ';
504: end if;
505:
506: l_del_query := l_del_query || ' group by d.party_cust_id, d.cust_account_id';
507: l_del_query := l_del_query || ' order by d.party_cust_id, d.cust_account_id';

Line 555: l_del_query := l_del_query || ' and not exists (select 1 from iex_strategies where JTF_OBJECT_TYPE = ''IEX_BILLTO'' and JTF_OBJECT_ID = d.customer_site_use_id and STATUS_CODE = ''OPEN'') ';

551: end if;
552: if l_ignore_switch = 'Y' then
553: --Bug#520231 schekuri 05-MAY-2006
554: --Changed OBJECT_TYPE and OBJECT_ID to JTF_OBJECT_TYPE and JTF_OBJECT_ID
555: l_del_query := l_del_query || ' and not exists (select 1 from iex_strategies where JTF_OBJECT_TYPE = ''IEX_BILLTO'' and JTF_OBJECT_ID = d.customer_site_use_id and STATUS_CODE = ''OPEN'') ';
556: end if;
557:
558: l_del_query := l_del_query || ' group by d.party_cust_id, d.cust_account_id, d.customer_site_use_id';
559: l_del_query := l_del_query || ' order by d.party_cust_id, d.cust_account_id, d.customer_site_use_id';

Line 603: l_del_query := l_del_query || ' and not exists (select 1 from iex_strategies where JTF_OBJECT_TYPE = ''IEX_DELINQUENCY'' and JTF_OBJECT_ID = d.delinquency_id and STATUS_CODE = ''OPEN'') ';

599: end if;
600: if l_ignore_switch = 'Y' then
601: --Bug#520231 schekuri 05-MAY-2006
602: --Changed OBJECT_TYPE and OBJECT_ID to JTF_OBJECT_TYPE and JTF_OBJECT_ID
603: l_del_query := l_del_query || ' and not exists (select 1 from iex_strategies where JTF_OBJECT_TYPE = ''IEX_DELINQUENCY'' and JTF_OBJECT_ID = d.delinquency_id and STATUS_CODE = ''OPEN'') ';
604: end if;
605: -- End - Andre Araujo -- 01/18/2005 - 4924879 - Improve performance by selecting less records
606: else
607: -- Begin - Andre Araujo -- 01/18/2005 - 4924879 - Improve performance by selecting less records

Line 647: l_del_query := l_del_query || ' and not exists (select 1 from iex_strategies where JTF_OBJECT_TYPE = ''IEX_DELINQUENCY'' and JTF_OBJECT_ID = d.delinquency_id and STATUS_CODE = ''OPEN'') ';

643: end if;
644: if l_ignore_switch = 'Y' then
645: --Bug#520231 schekuri 05-MAY-2006
646: --Changed OBJECT_TYPE and OBJECT_ID to JTF_OBJECT_TYPE and JTF_OBJECT_ID
647: l_del_query := l_del_query || ' and not exists (select 1 from iex_strategies where JTF_OBJECT_TYPE = ''IEX_DELINQUENCY'' and JTF_OBJECT_ID = d.delinquency_id and STATUS_CODE = ''OPEN'') ';
648: end if;
649: -- End - Andre Araujo -- 01/18/2005 - 4924879 - Improve performance by selecting less records
650: end if;
651: END IF;

Line 843: from iex_strategies where party_id = l_stry_cnt_rec.PARTY_CUST_ID

839:
840: IF l_DefaultStrategyLevel = 10 THEN
841: OPEN c_strategy_exists FOR
842: select status_code, decode(score_value, null, 0, score_value), strategy_id, strategy_template_id
843: from iex_strategies where party_id = l_stry_cnt_rec.PARTY_CUST_ID
844: and jtf_object_id = l_stry_cnt_rec.jtf_object_id
845: and jtf_object_type = l_stry_cnt_rec.jtf_object_type
846: and checklist_yn = vCheckList;
847: elsif l_DefaultStrategyLevel = 20 THEN

Line 850: from iex_strategies where CUST_ACCOUNT_ID = l_stry_cnt_rec.CUST_ACCOUNT_ID

846: and checklist_yn = vCheckList;
847: elsif l_DefaultStrategyLevel = 20 THEN
848: OPEN c_strategy_exists FOR
849: select status_code, decode(score_value, null, 0, score_value), strategy_id, strategy_template_id
850: from iex_strategies where CUST_ACCOUNT_ID = l_stry_cnt_rec.CUST_ACCOUNT_ID
851: and jtf_object_id = l_stry_cnt_rec.jtf_object_id
852: and jtf_object_type = l_stry_cnt_rec.jtf_object_type
853: and checklist_yn = vCheckList;
854: elsif l_DefaultStrategyLevel = 30 THEN

Line 857: from iex_strategies where customer_site_use_ID = l_stry_cnt_rec.customer_site_use_ID

853: and checklist_yn = vCheckList;
854: elsif l_DefaultStrategyLevel = 30 THEN
855: OPEN c_strategy_exists FOR
856: select status_code, decode(score_value, null, 0, score_value), strategy_id, strategy_template_id
857: from iex_strategies where customer_site_use_ID = l_stry_cnt_rec.customer_site_use_ID
858: and jtf_object_id = l_stry_cnt_rec.jtf_object_id
859: and jtf_object_type = l_stry_cnt_rec.jtf_object_type
860: and checklist_yn = vCheckList;
861: ELSE

Line 864: from iex_strategies where delinquency_id = l_stry_cnt_rec.delinquency_id

860: and checklist_yn = vCheckList;
861: ELSE
862: OPEN c_strategy_exists FOR
863: select status_code, decode(score_value, null, 0, score_value), strategy_id, strategy_template_id
864: from iex_strategies where delinquency_id = l_stry_cnt_rec.delinquency_id
865: and jtf_object_id = l_stry_cnt_rec.jtf_object_id
866: and jtf_object_type = l_stry_cnt_rec.jtf_object_type
867: and checklist_yn = vCheckList;
868: END IF;

Line 920: -- score in iex_strategies diff from score_histories/iex_delinquencies_all table

916: write_log(FND_LOG.LEVEL_PROCEDURE, 'Strategy score tolerance = ' || vScoreTolerance );
917: write_log(FND_LOG.LEVEL_PROCEDURE, 'Change Strategy = ' || vChangeStrategy );
918: END IF;
919:
920: -- score in iex_strategies diff from score_histories/iex_delinquencies_all table
921: -- and score history out of the strategy template score tolerance
922: -- and strategy template change strategy flag is Y
923: if (
924: ( (vScoreValue <> l_stry_cnt_rec.score_value)

Line 951: -- UPDATE IEX_STRATEGIES SET STATUS_code = 'CANCELLED' WHERE STRATEGY_ID = vStrategyId;

947: -- status => 'CANCELLED' ) ;
948: -- EXCEPTION
949: -- WHEN OTHERS THEN
950: -- write_log(FND_LOG.LEVEL_PROCEDURE, 'cancel strategy exception occurred = ' );
951: -- UPDATE IEX_STRATEGIES SET STATUS_code = 'CANCELLED' WHERE STRATEGY_ID = vStrategyId;
952: -- END;
953: -- end bug 4944801 ctlee 01/18/2006, cancel strategy only if the new strategy template id different from the old one
954: vStrategyStatus := 'CANCELLED';
955: vStrategyStatus1 := 'CANCELLED'; --Added for bug#5126770 by schekuri on 04-Apr-2006

Line 1018: UPDATE IEX_STRATEGIES SET STATUS_code = 'CANCELLED',

1014: EXCEPTION
1015: WHEN OTHERS THEN
1016: -- Added for bug 5877743 by gnramasa on 28-02-2007
1017: write_log(FND_LOG.LEVEL_PROCEDURE, 'cancel strategy exception occurred = ' || ' sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);
1018: UPDATE IEX_STRATEGIES SET STATUS_code = 'CANCELLED',
1019: last_update_date=sysdate --Added for bug#7594370 by PNAVEENK
1020: WHERE STRATEGY_ID = vStrategyId;
1021: END;
1022: end if; --if p_strategy_mode = 'FINAL' then

Line 1035: UPDATE IEX_STRATEGIES SET STATUS_code = 'CANCELLED' WHERE STRATEGY_ID = vStrategyId;*/

1031: --Begin bug#5126770 schekuri 04-Apr-2006
1032: --Moved the exception handler to the inner block
1033: NULL;
1034: /*write_log(FND_LOG.LEVEL_PROCEDURE, 'cancel strategy exception occurred = ' );
1035: UPDATE IEX_STRATEGIES SET STATUS_code = 'CANCELLED' WHERE STRATEGY_ID = vStrategyId;*/
1036: --End bug#5126770 schekuri 04-Apr-2006
1037: END;
1038: -- end bug 4944801 ctlee 01/18/2006
1039:

Line 1081: from iex_strategies

1077: l_temp_grace_period:=0;
1078: else
1079: select count(1)
1080: into l_strat_count
1081: from iex_strategies
1082: where jtf_object_id = l_stry_cnt_rec.jtf_object_id
1083: and jtf_object_type = l_stry_cnt_rec.jtf_object_type
1084: and checklist_yn = vCheckList
1085: and last_update_date>=trunc(sysdate)-1

Line 1429: from iex_strategies s where s.status_code IN (l_StratStatusOpen, l_StratStatusOnhold) AND

1425:
1426: Cursor c_open_strategies is
1427: select s.strategy_id, s.delinquency_id,
1428: s.object_id, s.object_type, s.strategy_template_id, s.jtf_object_type, s.jtf_object_id
1429: from iex_strategies s where s.status_code IN (l_StratStatusOpen, l_StratStatusOnhold) AND
1430: checklist_yn = 'N';
1431:
1432: l_stry_cnt_rec IEX_STRATEGY_TYPE_PUB.STRY_CNT_REC_TYPE ;
1433:

Line 1557: vPLSQL := 'select s.strategy_id, s.strategy_template_id, S.STATUS_CODE from iex_strategies s, iex_delinquencies_all d '||

1553: --end if;
1554:
1555: --Start adding for bug 8756947 gnramasa 3rd Aug 09
1556: IF l_DefaultStrategyLevel = 10 THEN
1557: vPLSQL := 'select s.strategy_id, s.strategy_template_id, S.STATUS_CODE from iex_strategies s, iex_delinquencies_all d '||
1558: ' where s.strategy_level = ' || l_DefaultStrategyLevel || ' and '||
1559: ' s.status_code IN (''' || l_StratStatusOpen || ''', ''' || l_StratStatusOnhold || ''', ''' || l_StratStatusPending || ''') and '||
1560: /* begin add for bug 4408860 - add checking CLOSE status from case delinquency */
1561: ' (d.status = ''' || l_DelStatusCurrent || ''' or d.status = ''' || l_DelStatusClose || ''') and d.party_cust_id = s.party_id '||

Line 1582: vPLSQL := 'select s.strategy_id, s.strategy_template_id, S.STATUS_CODE from iex_strategies s, iex_delinquencies_all d '||

1578: end if;
1579: vPLSQL := vPLSQL || ' group by s.strategy_id, s.strategy_template_id, S.STATUS_CODE';
1580:
1581: elsif l_DefaultStrategyLevel = 20 THEN
1582: vPLSQL := 'select s.strategy_id, s.strategy_template_id, S.STATUS_CODE from iex_strategies s, iex_delinquencies_all d '||
1583: ' where s.strategy_level = ' || l_DefaultStrategyLevel ||' and '||
1584: ' s.status_code IN (''' || l_StratStatusOpen || ''', ''' || l_StratStatusOnhold || ''', ''' || l_StratStatusPending || ''') and '||
1585: /* begin add for bug 4408860 - add checking CLOSE status from case delinquency */
1586: ' (d.status = ''' || l_DelStatusCurrent || ''' or d.status = ''' || l_DelStatusClose || ''') and d.CUST_ACCOUNT_id = s.CUST_ACCOUNT_id '||

Line 1606: vPLSQL := 'select s.strategy_id, s.strategy_template_id, S.STATUS_CODE from iex_strategies s, iex_delinquencies_all d '||

1602: end if;
1603: vPLSQL := vPLSQL || ' group by s.strategy_id, s.strategy_template_id, S.STATUS_CODE';
1604:
1605: elsif l_DefaultStrategyLevel = 30 THEN
1606: vPLSQL := 'select s.strategy_id, s.strategy_template_id, S.STATUS_CODE from iex_strategies s, iex_delinquencies_all d '||
1607: ' where s.strategy_level = ' || l_DefaultStrategyLevel || ' and '||
1608: ' s.status_code IN (''' || l_StratStatusOpen || ''', ''' || l_StratStatusOnhold || ''', ''' || l_StratStatusPending || ''') and '||
1609: /* begin add for bug 4408860 - add checking CLOSE status from case delinquency */
1610: ' (d.status = ''' || l_DelStatusCurrent || ''' or d.status = ''' || l_DelStatusClose || ''') and d.customer_site_use_id = s.customer_site_use_id '||

Line 1635: from iex_strategies s, iex_delinquencies_all d where d.status = l_DelStatusCurrent and

1631: /*
1632: OPEN c_open_strategies
1633: FOR
1634: select s.strategy_id, s.strategy_template_id, s.status_code
1635: from iex_strategies s, iex_delinquencies_all d where d.status = l_DelStatusCurrent and
1636: s.strategy_level = l_DefaultStrategyLevel and
1637: s.object_id = d.delinquency_id and
1638: s.status_code IN (l_StratStatusOpen, l_StratStatusOnhold, l_StratStatusPending);
1639: */

Line 1642: ' from iex_strategies s, iex_delinquencies_all d '||

1638: s.status_code IN (l_StratStatusOpen, l_StratStatusOnhold, l_StratStatusPending);
1639: */
1640: /* end bug 4253030 by ctlee 03/29/2005 */
1641: vPLSQL := 'select s.strategy_id, s.strategy_template_id, s.status_code '||
1642: ' from iex_strategies s, iex_delinquencies_all d '||
1643: /* begin add for bug 4408860 - add checking CLOSE status from case delinquency */
1644: ' where (d.status = ''' || l_DelStatusCurrent || ''' or d.status = ''' || l_DelStatusClose || ''') and '||
1645: /* end add for bug 4408860 - add checking CLOSE status from case delinquency */
1646: /* Begin add for bug 16568002 gnramasa 1st Apr 2013 */

Line 1740: from iex_strategies s, iex_delinquencies_all d

1736: select s.strategy_id strategy_id,
1737: s.strategy_template_id strategy_template_id,
1738: S.STATUS_CODE STATUS_CODE,
1739: d.party_cust_id party_id
1740: from iex_strategies s, iex_delinquencies_all d
1741: where s.strategy_level = 10 and
1742: s.status_code = 'ONHOLD' and
1743: d.status in ('DELINQUENT','PREDELINQUENT') and
1744: d.party_cust_id = s.party_id and

Line 1757: from iex_strategies s, iex_delinquencies_all d

1753: select s.strategy_id strategy_id,
1754: s.strategy_template_id strategy_template_id,
1755: S.STATUS_CODE STATUS_CODE,
1756: d.cust_account_id cust_account_id
1757: from iex_strategies s, iex_delinquencies_all d
1758: where s.strategy_level = 20 and
1759: s.status_code = 'ONHOLD' and
1760: d.status in ('DELINQUENT','PREDELINQUENT') and
1761: d.CUST_ACCOUNT_id = s.CUST_ACCOUNT_id and

Line 1774: from iex_strategies s, iex_delinquencies_all d

1770: select s.strategy_id strategy_id,
1771: s.strategy_template_id strategy_template_id,
1772: S.STATUS_CODE STATUS_CODE,
1773: d.customer_site_use_id billto_id
1774: from iex_strategies s, iex_delinquencies_all d
1775: where s.strategy_level = 30 and
1776: s.status_code = 'ONHOLD' and
1777: d.status in ('DELINQUENT','PREDELINQUENT') and
1778: d.customer_site_use_id = s.customer_site_use_id and

Line 1817: ' from iex_strategies s, iex_delinquencies_all d '||

1813: vPLSQL := 'select s.strategy_id strategy_id, '||
1814: ' s.strategy_template_id strategy_template_id, '||
1815: ' S.STATUS_CODE STATUS_CODE, '||
1816: ' d.party_cust_id party_id '||
1817: ' from iex_strategies s, iex_delinquencies_all d '||
1818: ' where s.strategy_level = 10 and '||
1819: ' s.status_code = ''ONHOLD'' and '||
1820: ' nvl(s.release_date,sysdate) <= SYSDATE and ' || -- Bug 14804876 bibeura
1821: ' d.status in (''DELINQUENT'',''PREDELINQUENT'') and '||

Line 1886: ' from iex_strategies s, iex_delinquencies_all d '||

1882: vPLSQL := 'select s.strategy_id strategy_id, '||
1883: ' s.strategy_template_id strategy_template_id, '||
1884: ' S.STATUS_CODE STATUS_CODE, '||
1885: ' d.cust_account_id cust_account_id '||
1886: ' from iex_strategies s, iex_delinquencies_all d '||
1887: ' where s.strategy_level = 20 and '||
1888: ' s.status_code = ''ONHOLD'' and '||
1889: ' nvl(s.release_date,sysdate) <= SYSDATE and ' || -- Bug 14804876 bibeura
1890: ' d.status in (''DELINQUENT'',''PREDELINQUENT'') and '||

Line 1955: ' from iex_strategies s, iex_delinquencies_all d '||

1951: vPLSQL := 'select s.strategy_id strategy_id, '||
1952: ' s.strategy_template_id strategy_template_id, '||
1953: ' S.STATUS_CODE STATUS_CODE, '||
1954: ' d.customer_site_use_id billto_id '||
1955: ' from iex_strategies s, iex_delinquencies_all d '||
1956: ' where s.strategy_level = 30 and '||
1957: ' s.status_code = ''ONHOLD'' and '||
1958: ' nvl(s.release_date,sysdate) <= SYSDATE and ' || -- Bug 14804876 bibeura
1959: ' d.status in (''DELINQUENT'',''PREDELINQUENT'') and '||

Line 2023: ' from iex_strategies s, iex_delinquencies_all d '||

2019: vPLSQL := 'select s.strategy_id strategy_id, '||
2020: ' s.strategy_template_id strategy_template_id, '||
2021: ' S.STATUS_CODE STATUS_CODE, '||
2022: ' d.delinquency_id delinquency_id '||
2023: ' from iex_strategies s, iex_delinquencies_all d '||
2024: ' where s.strategy_level = 40 and '||
2025: ' s.status_code = ''ONHOLD'' and '||
2026: ' nvl(s.release_date,sysdate) <= SYSDATE and ' || -- Bug 14804876 bibeura
2027: ' d.status in (''DELINQUENT'',''PREDELINQUENT'') and '||

Line 2109: (select 'x' from iex_strategies SS where SS.delinquency_id = pDelinquencyID

2105: where ST.category_type = pCategoryType and ST.Check_List_YN = 'N' AND
2106: OBF.OBJECT_ID(+) = ST.Strategy_temp_Group_ID and
2107: OBF.OBJECT_FILTER_TYPE(+) = 'IEXSTRAT'
2108: and not exists
2109: (select 'x' from iex_strategies SS where SS.delinquency_id = pDelinquencyID
2110: and SS.OBJECT_TYPE = pCategoryType)
2111: ORDER BY strategy_rank DESC;
2112: */
2113: C_DynSql varchar2(1000);

Line 2540: from iex_strategies

2536: fnd_file.put_line(FND_FILE.LOG, 'Profile for processing strategies by operating unit is On ' || ' Org Id = ' || l_org_id);
2537:
2538: select count(1)
2539: into l_count
2540: from iex_strategies
2541: where org_id is null
2542: and strategy_level=l_DefaultStrategyLevel;
2543:
2544: if l_count>0 then

Line 2770: from iex_strategies

2766: fnd_file.put_line(FND_FILE.LOG, ' Operating Unit Level Strategy Override value ' || l_org_override);
2767:
2768: select count(1)
2769: into l_count
2770: from iex_strategies
2771: where org_id is not null
2772: and strategy_level=l_DefaultStrategyLevel;
2773:
2774: if l_count>0 then

Line 2947: from iex_strategies

2943:
2944: --Start for bug 9742245 gnramasa 7th June 10
2945: cursor c_str_ids (c_party_id number , c_str_level varchar2) is
2946: select strategy_id
2947: from iex_strategies
2948: where jtf_object_type in ('PARTY','IEX_ACCOUNT','IEX_BILLTO','IEX_DELINQUENCY')
2949: and party_id = c_party_id
2950: and strategy_level <> c_str_level
2951: and status_code in ('OPEN' , 'ONHOLD');

Line 3008: update iex_strategies set status_code='CANCELLED' where strategy_id = l_str_id.strategy_id;

3004: EXCEPTION
3005: WHEN OTHERS THEN
3006: fnd_file.put_line(FND_FILE.LOG, 'Strategy Cancelled Raised Exception = '
3007: || l_str_id.strategy_id || ' sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);
3008: update iex_strategies set status_code='CANCELLED' where strategy_id = l_str_id.strategy_id;
3009: commit;
3010: END;
3011: end if;
3012:

Line 3045: from iex_strategies st,

3041: RETCODE OUT NOCOPY VARCHAR2
3042: ) IS
3043: cursor c_bill_strat_wo_ou(p_org_id number)
3044: is select st.strategy_id,su.org_id
3045: from iex_strategies st,
3046: hz_cust_site_uses_all su
3047: where st.object_type='BILL_TO'
3048: and st.org_id is null
3049: and st.object_id=su.site_use_id

Line 3054: from iex_strategies st,

3050: and su.org_id = p_org_id;
3051:
3052: cursor c_cust_strat_wo_ou(p_org_id number)
3053: is select st.strategy_id,p_org_id
3054: from iex_strategies st,
3055: hz_parties hp
3056: where st.object_type='PARTY'
3057: and st.org_id is null
3058: and st.object_id=hp.party_id

Line 3071: from iex_strategies st,

3067: group by st.strategy_id,p_org_id;
3068:
3069: cursor c_account_strat_wo_ou(p_org_id number)
3070: is select st.strategy_id,p_org_id
3071: from iex_strategies st,
3072: hz_cust_accounts ca
3073: where st.object_type='ACCOUNT'
3074: and st.org_id is null
3075: and st.object_id=ca.cust_account_id

Line 3086: from iex_strategies st,

3082:
3083:
3084: cursor c_del_strat_wo_ou(p_org_id number)
3085: is select st.strategy_id,del.org_id
3086: from iex_strategies st,
3087: iex_delinquencies_all del
3088: where st.object_type='DELINQUENT'
3089: and st.org_id is null
3090: and st.object_id=del.delinquency_id

Line 3095: from iex_strategies st

3091: and del.org_id = p_org_id;
3092:
3093: cursor c_strat_with_ou(p_object_type varchar2)
3094: is select st.strategy_id,null
3095: from iex_strategies st
3096: where st.object_type=p_object_type
3097: and st.org_id is not null;
3098: --and st.org_id = p_org_id;
3099:

Line 3100: TYPE strat_list IS TABLE OF IEX_STRATEGIES.STRATEGY_ID%TYPE;

3096: where st.object_type=p_object_type
3097: and st.org_id is not null;
3098: --and st.org_id = p_org_id;
3099:
3100: TYPE strat_list IS TABLE OF IEX_STRATEGIES.STRATEGY_ID%TYPE;
3101: TYPE org_list IS TABLE OF IEX_STRATEGIES.ORG_ID%TYPE;
3102:
3103: strategies strat_list;
3104: orgs org_list;

Line 3101: TYPE org_list IS TABLE OF IEX_STRATEGIES.ORG_ID%TYPE;

3097: and st.org_id is not null;
3098: --and st.org_id = p_org_id;
3099:
3100: TYPE strat_list IS TABLE OF IEX_STRATEGIES.STRATEGY_ID%TYPE;
3101: TYPE org_list IS TABLE OF IEX_STRATEGIES.ORG_ID%TYPE;
3102:
3103: strategies strat_list;
3104: orgs org_list;
3105:

Line 3117: update iex_strategies

3113: OPEN c_cust_strat_wo_ou(l_org_id);
3114: FETCH c_cust_strat_wo_ou BULK COLLECT INTO strategies,orgs;
3115: CLOSE c_cust_strat_wo_ou;
3116: /*for rec1 in c_cust_strat_wo_ou(l_org_id) loop
3117: update iex_strategies
3118: set org_id=rec1.org_id
3119: where strategy_id = rec1.strategy_id;
3120: end loop;*/
3121: ELSE

Line 3126: update iex_strategies

3122: OPEN c_strat_with_ou('PARTY');
3123: FETCH c_strat_with_ou BULK COLLECT INTO strategies,orgs;
3124: CLOSE c_strat_with_ou;
3125: /*for rec1 in c_cust_strat_with_ou(l_org_id) loop
3126: update iex_strategies
3127: set org_id=null
3128: where strategy_id = rec1.strategy_id;
3129: end loop;*/
3130: END IF;

Line 3149: update iex_strategies

3145: OPEN c_bill_strat_wo_ou(l_org_id);
3146: FETCH c_bill_strat_wo_ou BULK COLLECT INTO strategies,orgs;
3147: CLOSE c_bill_strat_wo_ou;
3148: /*for rec1 in c_bill_strat_wo_ou(l_org_id) loop
3149: update iex_strategies
3150: set org_id=rec1.org_id
3151: where strategy_id = rec1.strategy_id;
3152: end loop;*/
3153: ELSE

Line 3158: update iex_strategies

3154: OPEN c_strat_with_ou('BILL_TO');
3155: FETCH c_strat_with_ou BULK COLLECT INTO strategies,orgs;
3156: CLOSE c_strat_with_ou;
3157: /*for rec1 in c_bill_strat_with_ou(l_org_id) loop
3158: update iex_strategies
3159: set org_id=null
3160: where strategy_id = rec1.strategy_id;
3161: end loop;*/
3162: END IF;

Line 3181: update iex_strategies

3177: fnd_file.put_line(FND_FILE.LOG, 'Updating number of strategies ' || strategies.count);
3178: if strategies.count>0 then
3179:
3180: forall i in strategies.first..strategies.last
3181: update iex_strategies
3182: set org_id=orgs(i)
3183: where strategy_id = strategies(i);
3184: commit;
3185: end if;

Line 3612: from iex_strategies sty,

3608: jtf.source_name,
3609: iex_utilities.get_lookup_meaning('IEX_RUNNING_LEVEL',(decode(sty.strategy_level, 10, 'CUSTOMER', 20, 'ACCOUNT',
3610: 30, 'BILL_TO', 40, 'DELINQUENCY'))) strategy_level_name,
3611: sty.strategy_level strategy_level
3612: from iex_strategies sty,
3613: iex_strategy_templates_tl tpl,
3614: iex_strategy_work_items swi,
3615: iex_stry_temp_work_items_vl stry_temp_wkitem,
3616: jtf_rs_resource_extns jtf

Line 3637: from iex_strategies sty,

3633: tpl.strategy_name,
3634: iex_utilities.get_lookup_meaning('IEX_RUNNING_LEVEL',(decode(sty.strategy_level, 10, 'CUSTOMER', 20, 'ACCOUNT',
3635: 30, 'BILL_TO', 40, 'DELINQUENCY'))) strategy_level_name,
3636: sty.strategy_level strategy_level
3637: from iex_strategies sty,
3638: iex_strategy_templates_tl tpl
3639: where sty.strategy_id = p_strategy_id
3640: and sty.strategy_template_id = tpl.strategy_temp_id
3641: and tpl.language = userenv('LANG');

Line 3711: iex_strategies a,

3707: c.location
3708: from iex_delinquencies_all del,
3709: ar_payment_schedules_all aps ,
3710: hz_parties p,
3711: iex_strategies a,
3712: hz_cust_accounts b,
3713: hz_cust_site_uses_all c
3714: where del.delinquency_id = p_delinquency_id
3715: and del.payment_Schedule_id = aps.payment_Schedule_id