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 3002: FROM IEX_SCORE_HISTORIES a

2998: --
2999: -- begin bug 4914799 ctlee 12/30/2005 add p_dunning_plan_id
3000: CURSOR C_GET_SCORE (IN_ID NUMBER, IN_CODE VARCHAR2, p_dunning_plan_id number) IS
3001: SELECT a.score_value
3002: FROM IEX_SCORE_HISTORIES a
3003: , IEX_DUNNING_PLANS_VL c -- bug 4914799 ctlee 12/30/2005
3004: WHERE a.score_object_ID = in_ID
3005: AND a.score_object_code = IN_CODE
3006: and c.score_id = a.score_id -- bug 4914799 ctlee 12/30/2005

Line 3009: from iex_score_histories b

3005: AND a.score_object_code = IN_CODE
3006: and c.score_id = a.score_id -- bug 4914799 ctlee 12/30/2005
3007: and c.dunning_plan_id = p_dunning_plan_id -- bug 4914799 ctlee 12/30/2005
3008: AND a.creation_date = (select max(b.creation_date)
3009: from iex_score_histories b
3010: where b.score_object_id = in_id
3011: AND b.score_object_code = IN_CODE
3012: AND b.score_id = a.score_id );
3013: -- end bug 4914799 ctlee 12/30/2005 add p_dunning_plan_id

Line 3273: * Get Score From IEX_SCORE_HISTORIES

3269: FND_MSG_PUB.initialize;
3270:
3271:
3272: /*===========================================
3273: * Get Score From IEX_SCORE_HISTORIES
3274: * If NotFound => Call API to getScore;
3275: *===========================================*/
3276: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Get Score');
3277: Open C_Get_SCORE(l_object_id, l_object_Code, p_dunning_plan_id);

Line 3751: FROM IEX_SCORE_HISTORIES a

3747: WHERE delinquency_ID = in_del_ID;
3748: --
3749: CURSOR C_GET_SCORE (IN_ID NUMBER) IS
3750: SELECT a.score_value
3751: FROM IEX_SCORE_HISTORIES a
3752: WHERE a.score_object_ID = in_ID
3753: AND a.score_object_code = 'IEX_DELINQUENCY'
3754: AND a.creation_date = (select max(b.creation_date)
3755: from iex_score_histories b

Line 3755: from iex_score_histories b

3751: FROM IEX_SCORE_HISTORIES a
3752: WHERE a.score_object_ID = in_ID
3753: AND a.score_object_code = 'IEX_DELINQUENCY'
3754: AND a.creation_date = (select max(b.creation_date)
3755: from iex_score_histories b
3756: where b.score_object_id = in_id
3757: AND b.score_object_code = 'IEX_DELINQUENCY');
3758: --
3759: CURSOR C_GET_TEMPLATE (l_line_id NUMBER,

Line 3929: * Get Score From IEX_SCORE_HISTORIES

3925: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - No Dispute or status is COMPLETE');
3926: END IF;
3927:
3928: /*===========================================
3929: * Get Score From IEX_SCORE_HISTORIES
3930: * If NotFound => Call API to getScore;
3931: *===========================================*/
3932:
3933: /*===========================================

Line 4399: FROM IEX_SCORE_HISTORIES a

4395: --
4396: -- begin bug 4914799 ctlee 12/30/2005 add p_dunning_plan_id
4397: CURSOR C_GET_SCORE (IN_ID NUMBER, IN_CODE VARCHAR2, p_dunning_plan_id number) IS
4398: SELECT a.score_value
4399: FROM IEX_SCORE_HISTORIES a
4400: , IEX_DUNNING_PLANS_VL c -- bug 4914799 ctlee 12/30/2005
4401: WHERE a.score_object_ID = in_ID
4402: AND a.score_object_code = IN_CODE
4403: and c.score_id = a.score_id -- bug 4914799 ctlee 12/30/2005

Line 4406: from iex_score_histories b

4402: AND a.score_object_code = IN_CODE
4403: and c.score_id = a.score_id -- bug 4914799 ctlee 12/30/2005
4404: and c.dunning_plan_id = p_dunning_plan_id -- bug 4914799 ctlee 12/30/2005
4405: AND a.creation_date = (select max(b.creation_date)
4406: from iex_score_histories b
4407: where b.score_object_id = in_id
4408: AND b.score_object_code = IN_CODE);
4409: -- end bug 4914799 ctlee 12/30/2005 add p_dunning_plan_id
4410: --

Line 4614: * Get Score From IEX_SCORE_HISTORIES

4610: -- init the msg (not including the msg from dispute api)
4611: FND_MSG_PUB.initialize;
4612:
4613: /*===========================================
4614: * Get Score From IEX_SCORE_HISTORIES
4615: * If NotFound => Call API to getScore;
4616: *===========================================*/
4617: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Get Score');
4618: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - objectCode='||l_object_Code);

Line 5095: FROM IEX_SCORE_HISTORIES a

5091: WHERE delinquency_ID = in_del_ID;
5092: --
5093: CURSOR C_GET_SCORE (IN_ID NUMBER) IS
5094: SELECT a.score_value
5095: FROM IEX_SCORE_HISTORIES a
5096: WHERE a.score_object_ID = in_ID
5097: AND a.score_object_code = 'IEX_DELINQUENCY'
5098: AND a.creation_date = (select max(b.creation_date)
5099: from iex_score_histories b

Line 5099: from iex_score_histories b

5095: FROM IEX_SCORE_HISTORIES a
5096: WHERE a.score_object_ID = in_ID
5097: AND a.score_object_code = 'IEX_DELINQUENCY'
5098: AND a.creation_date = (select max(b.creation_date)
5099: from iex_score_histories b
5100: where b.score_object_id = in_id
5101: AND b.score_object_code = 'IEX_DELINQUENCY');
5102: --
5103: --

Line 5274: * Get Score From IEX_SCORE_HISTORIES

5270: -- init msg (not from dispute api)
5271: FND_MSG_PUB.initialize;
5272:
5273: /*===========================================
5274: * Get Score From IEX_SCORE_HISTORIES
5275: * If NotFound => Call API to getScore;
5276: *===========================================*/
5277: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Score='|| l_score);
5278: /*===========================================