APPS.IEX_DUNNING_PVT dependencies on IEX_DUNNINGS

Line 2564: IEX_Dunnings_PKG.insert_row(

2560: --
2561: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - InsertRow');
2562:
2563: -- Create Dunning
2564: IEX_Dunnings_PKG.insert_row(
2565: px_rowid => l_rowid
2566: , px_dunning_id => x_dunning_id
2567: , p_last_update_date => sysdate
2568: , p_last_updated_by => FND_GLOBAL.USER_ID

Line 2690: from iex_DUNNINGS

2686: interest_amt, -- bug 3955222
2687: dunning_plan_id, -- bug 3955222
2688: contact_destination, -- bug 3955222
2689: contact_party_id -- bug 3955222
2690: from iex_DUNNINGS
2691: where dunning_id = in_dunning_id
2692: FOR UPDATE NOWAIT;
2693: --
2694: l_api_name CONSTANT VARCHAR2(30) := 'Update_DUNNING';

Line 2775: FND_MESSAGE.Set_Token ('INFO', 'iex_DUNNINGs', FALSE);

2771: If ( C_GET_DUNNING_REC%NOTFOUND) Then
2772: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2773: THEN
2774: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
2775: FND_MESSAGE.Set_Token ('INFO', 'iex_DUNNINGs', FALSE);
2776: FND_MSG_PUB.Add;
2777: END IF;
2778: raise FND_API.G_EXC_ERROR;
2779: END IF;

Line 2884: IEX_DUNNINGS_PKG.Update_Row(

2880: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - dunningid='||l_dunning_rec.dunning_id );
2881: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - delivery_status= ' || l_dunning_rec.delivery_status);
2882:
2883: -- Invoke table handler
2884: IEX_DUNNINGS_PKG.Update_Row(
2885: p_rowid => l_rowid
2886: , p_dunning_id => l_dunning_rec.dunning_id
2887: , p_last_update_date => sysdate
2888: , p_last_updated_by => FND_GLOBAL.USER_ID

Line 3724: * insert ffm_request_id into iex_dunnings after CALL_FFM successfully;

3720:
3721:
3722: /*==========================================================================
3723: * clchang updated 09/19/2002 -
3724: * insert ffm_request_id into iex_dunnings after CALL_FFM successfully;
3725: * Create_Dunning and Update_Dunning also updated;
3726: *
3727: *==========================================================================*/
3728: Procedure Send_Dunning

Line 8407: FROM IEX_DUNNINGS

8403:
8404: IS
8405: CURSOR C_GET_DUNNING (IN_ID NUMBER, IN_TYPE VARCHAR2) IS
8406: SELECT dunning_ID
8407: FROM IEX_DUNNINGS
8408: WHERE STATUS = 'OPEN'
8409: AND dunning_level = IN_TYPE
8410: AND dunning_object_id = IN_ID;
8411: --

Line 8426: TYPE Dunning_ID_TBL_type is Table of IEX_DUNNINGS.DUNNING_ID%TYPE

8422: errmsg VARCHAR2(32767);
8423: nIdx NUMBER := 0;
8424: nCnt NUMBER := 0;
8425: --
8426: TYPE Dunning_ID_TBL_type is Table of IEX_DUNNINGS.DUNNING_ID%TYPE
8427: INDEX BY BINARY_INTEGER;
8428: dunning_tbl Dunning_ID_TBL_TYPE;
8429: --
8430: BEGIN

Line 8508: UPDATE IEX_DUNNINGS

8504:
8505: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - DunnCnt='||nIdx||';'||dunning_tbl.count);
8506:
8507: FORALL i in 1..dunning_tbl.count
8508: UPDATE IEX_DUNNINGS
8509: SET CALLBACK_YN = 'N',
8510: STATUS = 'CLOSE',
8511: LAST_UPDATE_DATE = sysdate
8512: WHERE Dunning_id = dunning_tbl(i);

Line 8580: FROM IEX_DUNNINGS

8576: SELECT dunning_ID,
8577: delinquency_id,
8578: dunning_object_id,
8579: to_char(callback_date, 'YYYYMMDD')
8580: FROM IEX_DUNNINGS
8581: WHERE STATUS = 'OPEN'
8582: AND CALLBACK_YN = 'Y'
8583: AND dunning_level = IN_LEVEL
8584: AND to_char(callback_date, 'YYYYMMDD') <= to_char(sysdate,'YYYYMMDD');

Line 8628: TYPE Dunning_ID_TBL_type is Table of IEX_DUNNINGS.DUNNING_ID%TYPE

8624: l_chk NUMBER := 0;
8625: l_task_cnt NUMBER := 0;
8626: l_skip NUMBER := 0;
8627: --
8628: TYPE Dunning_ID_TBL_type is Table of IEX_DUNNINGS.DUNNING_ID%TYPE
8629: INDEX BY BINARY_INTEGER;
8630: dunning_tbl Dunning_ID_TBL_TYPE;
8631: l_dunning_object_id NUMBER;
8632:

Line 8845: UPDATE IEX_DUNNINGS

8841:
8842: IF (nCnt > 0) THEN
8843:
8844: FORALL i in 1..dunning_tbl.count
8845: UPDATE IEX_DUNNINGS
8846: SET CALLBACK_YN = 'N',
8847: LAST_UPDATE_DATE = sysdate
8848: WHERE Dunning_id = dunning_tbl(i);
8849:

Line 8881: ||' iex_dunnings dun'

8877: ||' from jtf_tasks_b tsk,'
8878: ||' jtf_task_types_tl typ,'
8879: ||' jtf_task_statuses_b st,'
8880: ||' jtf_task_references_b ref,'
8881: ||' iex_dunnings dun'
8882: ||' where tsk.task_type_id=typ.task_type_id'
8883: ||' and typ.name=''Callback'''
8884: ||' and tsk.task_status_id=st.task_status_id'
8885: ||' and nvl(st.closed_flag, ''N'') <>''Y'''