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_DUNNING_PVT dependencies on IEX_SCORE_HISTORIES

Line 4003: FROM IEX_SCORE_HISTORIES a

3999: --
4000: -- begin bug 4914799 ctlee 12/30/2005 add p_dunning_plan_id
4001: CURSOR C_GET_SCORE (IN_ID NUMBER, IN_CODE VARCHAR2, p_dunning_plan_id number) IS
4002: SELECT a.score_value
4003: FROM IEX_SCORE_HISTORIES a
4004: , IEX_DUNNING_PLANS_VL c -- bug 4914799 ctlee 12/30/2005
4005: WHERE a.score_object_ID = in_ID
4006: AND a.score_object_code = IN_CODE
4007: and c.score_id = a.score_id -- bug 4914799 ctlee 12/30/2005

Line 4010: from iex_score_histories b

4006: AND a.score_object_code = IN_CODE
4007: and c.score_id = a.score_id -- bug 4914799 ctlee 12/30/2005
4008: and c.dunning_plan_id = p_dunning_plan_id -- bug 4914799 ctlee 12/30/2005
4009: AND a.creation_date = (select max(b.creation_date)
4010: from iex_score_histories b
4011: where b.score_object_id = in_id
4012: AND b.score_object_code = IN_CODE
4013: AND b.score_id = a.score_id );
4014: -- end bug 4914799 ctlee 12/30/2005 add p_dunning_plan_id

Line 4423: * Get Score From IEX_SCORE_HISTORIES

4419: -- init the msg (not including the msg from dispute api)
4420: FND_MSG_PUB.initialize;
4421:
4422: /*===========================================
4423: * Get Score From IEX_SCORE_HISTORIES
4424: * If NotFound => Call API to getScore;
4425: *===========================================*/
4426: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Get Score');
4427: Open C_Get_SCORE(l_object_id, l_object_Code, p_dunning_plan_id);

Line 5270: FROM IEX_SCORE_HISTORIES a

5266: --
5267: -- begin bug 4914799 ctlee 12/30/2005 add p_dunning_plan_id
5268: CURSOR C_GET_SCORE (IN_ID NUMBER, IN_CODE VARCHAR2, p_dunning_plan_id number) IS
5269: SELECT a.score_value
5270: FROM IEX_SCORE_HISTORIES a
5271: , IEX_DUNNING_PLANS_VL c -- bug 4914799 ctlee 12/30/2005
5272: WHERE a.score_object_ID = in_ID
5273: AND a.score_object_code = IN_CODE
5274: and c.score_id = a.score_id -- bug 4914799 ctlee 12/30/2005

Line 5277: from iex_score_histories b

5273: AND a.score_object_code = IN_CODE
5274: and c.score_id = a.score_id -- bug 4914799 ctlee 12/30/2005
5275: and c.dunning_plan_id = p_dunning_plan_id -- bug 4914799 ctlee 12/30/2005
5276: AND a.creation_date = (select max(b.creation_date)
5277: from iex_score_histories b
5278: where b.score_object_id = in_id
5279: AND b.score_object_code = IN_CODE
5280: AND b.score_id = a.score_id );
5281: -- end bug 4914799 ctlee 12/30/2005 add p_dunning_plan_id

Line 5606: * Get Score From IEX_SCORE_HISTORIES

5602: -- init the msg (not including the msg from dispute api)
5603: FND_MSG_PUB.initialize;
5604:
5605: /*===========================================
5606: * Get Score From IEX_SCORE_HISTORIES
5607: * If NotFound => Call API to getScore;
5608: *===========================================*/
5609: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Get Score');
5610: Open C_Get_SCORE(l_object_id, l_object_Code, p_dunning_plan_id);

Line 6908: FROM IEX_SCORE_HISTORIES a

6904: WHERE delinquency_ID = in_del_ID;
6905: --
6906: CURSOR C_GET_SCORE (IN_ID NUMBER) IS
6907: SELECT a.score_value
6908: FROM IEX_SCORE_HISTORIES a
6909: WHERE a.score_object_ID = in_ID
6910: AND a.score_object_code = 'IEX_DELINQUENCY'
6911: AND a.creation_date = (select max(b.creation_date)
6912: from iex_score_histories b

Line 6912: from iex_score_histories b

6908: FROM IEX_SCORE_HISTORIES a
6909: WHERE a.score_object_ID = in_ID
6910: AND a.score_object_code = 'IEX_DELINQUENCY'
6911: AND a.creation_date = (select max(b.creation_date)
6912: from iex_score_histories b
6913: where b.score_object_id = in_id
6914: AND b.score_object_code = 'IEX_DELINQUENCY');
6915:
6916: --Start bug 10226333 by gnramasa 4-Nov-10

Line 6919: from iex_score_histories

6915:
6916: --Start bug 10226333 by gnramasa 4-Nov-10
6917: Cursor c_get_score_del(p_object_id number, p_object_type varchar2) is
6918: select score_value
6919: from iex_score_histories
6920: where score_object_id = p_object_id
6921: and score_object_code = p_object_type
6922: order by creation_date desc;
6923:

Line 7264: * Get Score From IEX_SCORE_HISTORIES

7260: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - No Dispute or status is COMPLETE');
7261: END IF;*/
7262:
7263: /*===========================================
7264: * Get Score From IEX_SCORE_HISTORIES
7265: * If NotFound => Call API to getScore;
7266: *===========================================*/
7267:
7268: /*===========================================

Line 7954: FROM IEX_SCORE_HISTORIES a

7950: WHERE delinquency_ID = in_del_ID;
7951: --
7952: CURSOR C_GET_SCORE (IN_ID NUMBER) IS
7953: SELECT a.score_value
7954: FROM IEX_SCORE_HISTORIES a
7955: WHERE a.score_object_ID = in_ID
7956: AND a.score_object_code = 'IEX_DELINQUENCY'
7957: AND a.creation_date = (select max(b.creation_date)
7958: from iex_score_histories b

Line 7958: from iex_score_histories b

7954: FROM IEX_SCORE_HISTORIES a
7955: WHERE a.score_object_ID = in_ID
7956: AND a.score_object_code = 'IEX_DELINQUENCY'
7957: AND a.creation_date = (select max(b.creation_date)
7958: from iex_score_histories b
7959: where b.score_object_id = in_id
7960: AND b.score_object_code = 'IEX_DELINQUENCY');
7961:
7962: --Start bug 10226333 by gnramasa 4-Nov-10

Line 7965: from iex_score_histories

7961:
7962: --Start bug 10226333 by gnramasa 4-Nov-10
7963: Cursor c_get_score_del(p_object_id number, p_object_type varchar2) is
7964: select score_value
7965: from iex_score_histories
7966: where score_object_id = p_object_id
7967: and score_object_code = p_object_type
7968: order by creation_date desc;
7969:

Line 9146: FROM IEX_SCORE_HISTORIES a

9142: --
9143: -- begin bug 4914799 ctlee 12/30/2005 add p_dunning_plan_id
9144: CURSOR C_GET_SCORE (IN_ID NUMBER, IN_CODE VARCHAR2, p_dunning_plan_id number) IS
9145: SELECT a.score_value
9146: FROM IEX_SCORE_HISTORIES a
9147: , IEX_DUNNING_PLANS_VL c -- bug 4914799 ctlee 12/30/2005
9148: WHERE a.score_object_ID = in_ID
9149: AND a.score_object_code = IN_CODE
9150: and c.score_id = a.score_id -- bug 4914799 ctlee 12/30/2005

Line 9153: from iex_score_histories b

9149: AND a.score_object_code = IN_CODE
9150: and c.score_id = a.score_id -- bug 4914799 ctlee 12/30/2005
9151: and c.dunning_plan_id = p_dunning_plan_id -- bug 4914799 ctlee 12/30/2005
9152: AND a.creation_date = (select max(b.creation_date)
9153: from iex_score_histories b
9154: where b.score_object_id = in_id
9155: AND b.score_object_code = IN_CODE);
9156: -- end bug 4914799 ctlee 12/30/2005 add p_dunning_plan_id
9157: --

Line 9442: * Get Score From IEX_SCORE_HISTORIES

9438: -- init the msg (not including the msg from dispute api)
9439: FND_MSG_PUB.initialize;
9440:
9441: /*===========================================
9442: * Get Score From IEX_SCORE_HISTORIES
9443: * If NotFound => Call API to getScore;
9444: *===========================================*/
9445: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Get Score');
9446: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - objectCode='||l_object_Code);

Line 10227: FROM IEX_SCORE_HISTORIES a

10223: --
10224: -- begin bug 4914799 ctlee 12/30/2005 add p_dunning_plan_id
10225: CURSOR C_GET_SCORE (IN_ID NUMBER, IN_CODE VARCHAR2, p_dunning_plan_id number) IS
10226: SELECT a.score_value
10227: FROM IEX_SCORE_HISTORIES a
10228: , IEX_DUNNING_PLANS_VL c -- bug 4914799 ctlee 12/30/2005
10229: WHERE a.score_object_ID = in_ID
10230: AND a.score_object_code = IN_CODE
10231: and c.score_id = a.score_id -- bug 4914799 ctlee 12/30/2005

Line 10234: from iex_score_histories b

10230: AND a.score_object_code = IN_CODE
10231: and c.score_id = a.score_id -- bug 4914799 ctlee 12/30/2005
10232: and c.dunning_plan_id = p_dunning_plan_id -- bug 4914799 ctlee 12/30/2005
10233: AND a.creation_date = (select max(b.creation_date)
10234: from iex_score_histories b
10235: where b.score_object_id = in_id
10236: AND b.score_object_code = IN_CODE);
10237: -- end bug 4914799 ctlee 12/30/2005 add p_dunning_plan_id
10238: --

Line 10577: * Get Score From IEX_SCORE_HISTORIES

10573: -- init the msg (not including the msg from dispute api)
10574: --FND_MSG_PUB.initialize;
10575:
10576: /*===========================================
10577: * Get Score From IEX_SCORE_HISTORIES
10578: * If NotFound => Call API to getScore;
10579: *===========================================*/
10580: /*
10581: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Get Score');

Line 11181: FROM IEX_SCORE_HISTORIES a

11177: WHERE delinquency_ID = in_del_ID;
11178: --
11179: CURSOR C_GET_SCORE (IN_ID NUMBER) IS
11180: SELECT a.score_value
11181: FROM IEX_SCORE_HISTORIES a
11182: WHERE a.score_object_ID = in_ID
11183: AND a.score_object_code = 'IEX_DELINQUENCY'
11184: AND a.creation_date = (select max(b.creation_date)
11185: from iex_score_histories b

Line 11185: from iex_score_histories b

11181: FROM IEX_SCORE_HISTORIES a
11182: WHERE a.score_object_ID = in_ID
11183: AND a.score_object_code = 'IEX_DELINQUENCY'
11184: AND a.creation_date = (select max(b.creation_date)
11185: from iex_score_histories b
11186: where b.score_object_id = in_id
11187: AND b.score_object_code = 'IEX_DELINQUENCY');
11188: --
11189: --

Line 11397: * Get Score From IEX_SCORE_HISTORIES

11393: -- init msg (not from dispute api)
11394: FND_MSG_PUB.initialize;
11395:
11396: /*===========================================
11397: * Get Score From IEX_SCORE_HISTORIES
11398: * If NotFound => Call API to getScore;
11399: *===========================================*/
11400: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Score='|| l_score);
11401: /*===========================================

Line 11973: FROM IEX_SCORE_HISTORIES a

11969: /*
11970: --
11971: CURSOR C_GET_SCORE (IN_ID NUMBER) IS
11972: SELECT a.score_value
11973: FROM IEX_SCORE_HISTORIES a
11974: WHERE a.score_object_ID = in_ID
11975: AND a.score_object_code = 'IEX_DELINQUENCY'
11976: AND a.creation_date = (select max(b.creation_date)
11977: from iex_score_histories b

Line 11977: from iex_score_histories b

11973: FROM IEX_SCORE_HISTORIES a
11974: WHERE a.score_object_ID = in_ID
11975: AND a.score_object_code = 'IEX_DELINQUENCY'
11976: AND a.creation_date = (select max(b.creation_date)
11977: from iex_score_histories b
11978: where b.score_object_id = in_id
11979: AND b.score_object_code = 'IEX_DELINQUENCY');
11980: --
11981: --

Line 12216: * Get Score From IEX_SCORE_HISTORIES

12212: -- init msg (not from dispute api)
12213: FND_MSG_PUB.initialize;
12214: */
12215: /*===========================================
12216: * Get Score From IEX_SCORE_HISTORIES
12217: * If NotFound => Call API to getScore;
12218: *===========================================*/
12219: -- WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Score='|| l_score);
12220: /*===========================================