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_DUNNINGS

Line 2571: IEX_Dunnings_PKG.insert_row(

2567: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_dunning_rec.dunning_mode :'||l_dunning_rec.dunning_mode);
2568: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_dunning_rec.confirmation_mode : '||l_dunning_rec.confirmation_mode);
2569: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_dunning_rec.parent_dunning_id : '||l_dunning_rec.parent_dunning_id);
2570: -- Create Dunning
2571: IEX_Dunnings_PKG.insert_row(
2572: px_rowid => l_rowid
2573: , px_dunning_id => x_dunning_id
2574: , p_last_update_date => sysdate
2575: , p_last_updated_by => FND_GLOBAL.USER_ID

Line 2870: IEX_Dunnings_PKG.insert_staged_dunning_row(

2866: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - sql_cur.l_delinquency_id :'||l_delinquency_id);
2867: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - sql_cur.l_transaction_id :'||l_transaction_id);
2868: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - sql_cur.l_payment_schedule_id : '||l_payment_schedule_id);
2869:
2870: IEX_Dunnings_PKG.insert_staged_dunning_row(
2871: px_rowid => l_rowid
2872: , px_dunning_trx_id => x_dunning_trx_id
2873: , p_dunning_id => p_dunning_id
2874: , p_cust_trx_id => l_transaction_id

Line 2942: IEX_Dunnings_PKG.insert_staged_dunning_row(

2938: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - sql_cur1.l_delinquency_id :'||l_delinquency_id);
2939: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - sql_cur1.l_transaction_id :'||l_transaction_id);
2940: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - sql_cur1.l_payment_schedule_id : '||l_payment_schedule_id);
2941:
2942: IEX_Dunnings_PKG.insert_staged_dunning_row(
2943: px_rowid => l_rowid
2944: , px_dunning_trx_id => x_dunning_trx_id
2945: , p_dunning_id => p_dunning_id
2946: , p_cust_trx_id => l_transaction_id

Line 2998: ' (select trunc(correspondence_date) from iex_dunnings ' ||

2994: ' and arp.invoice_currency_code = :p_inv_curr ' ||
2995: ' and nvl(arp.amount_in_dispute,0) = decode(:p_include_dis_items, ''Y'', nvl(arp.amount_in_dispute,0), 0) ' ||
2996: ' and nvl( ' ||
2997: ' ( ' ||
2998: ' (select trunc(correspondence_date) from iex_dunnings ' ||
2999: ' where dunning_id = ' ||
3000: ' (select max(iet.DUNNING_ID) from iex_dunning_transactions iet, ' ||
3001: ' iex_dunnings dunn ' ||
3002: ' where iet.PAYMENT_SCHEDULE_ID = del.payment_schedule_id ' ||

Line 3001: ' iex_dunnings dunn ' ||

2997: ' ( ' ||
2998: ' (select trunc(correspondence_date) from iex_dunnings ' ||
2999: ' where dunning_id = ' ||
3000: ' (select max(iet.DUNNING_ID) from iex_dunning_transactions iet, ' ||
3001: ' iex_dunnings dunn ' ||
3002: ' where iet.PAYMENT_SCHEDULE_ID = del.payment_schedule_id ' ||
3003: ' and dunn.dunning_id = iet.dunning_id ' ||
3004: ' and ((dunn.dunning_mode = ''DRAFT'' and dunn.confirmation_mode = ''CONFIRMED'') ' ||
3005: ' OR (dunn.dunning_mode = ''FINAL'')) ' ||

Line 3055: IEX_Dunnings_PKG.insert_staged_dunning_row(

3051: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - sql_cur.l_delinquency_id :'||l_delinquency_id);
3052: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - sql_cur.l_transaction_id :'||l_transaction_id);
3053: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - sql_cur.l_payment_schedule_id : '||l_payment_schedule_id);
3054:
3055: IEX_Dunnings_PKG.insert_staged_dunning_row(
3056: px_rowid => l_rowid
3057: , px_dunning_trx_id => x_dunning_trx_id
3058: , p_dunning_id => p_dunning_id
3059: , p_cust_trx_id => l_transaction_id

Line 3110: ' (select trunc(correspondence_date) from iex_dunnings ' ||

3106: ' and arp.invoice_currency_code = :p_inv_curr ' ||
3107: ' and arp.amount_in_dispute >= decode(:p_include_dis_items, ''Y'', arp.amount_due_remaining, (arp.amount_due_original + 1)) ' ||
3108: ' and nvl( ' ||
3109: ' ( ' ||
3110: ' (select trunc(correspondence_date) from iex_dunnings ' ||
3111: ' where dunning_id = ' ||
3112: ' (select max(iet.DUNNING_ID) from iex_dunning_transactions iet, ' ||
3113: ' iex_dunnings dunn ' ||
3114: ' where iet.PAYMENT_SCHEDULE_ID = del.payment_schedule_id ' ||

Line 3113: ' iex_dunnings dunn ' ||

3109: ' ( ' ||
3110: ' (select trunc(correspondence_date) from iex_dunnings ' ||
3111: ' where dunning_id = ' ||
3112: ' (select max(iet.DUNNING_ID) from iex_dunning_transactions iet, ' ||
3113: ' iex_dunnings dunn ' ||
3114: ' where iet.PAYMENT_SCHEDULE_ID = del.payment_schedule_id ' ||
3115: ' and dunn.dunning_id = iet.dunning_id ' ||
3116: ' and ((dunn.dunning_mode = ''DRAFT'' and dunn.confirmation_mode = ''CONFIRMED'') ' ||
3117: ' OR (dunn.dunning_mode = ''FINAL'')) ' ||

Line 3142: IEX_Dunnings_PKG.insert_staged_dunning_row(

3138: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - sql_cur1.l_delinquency_id :'||l_delinquency_id);
3139: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - sql_cur1.l_transaction_id :'||l_transaction_id);
3140: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - sql_cur1.l_payment_schedule_id : '||l_payment_schedule_id);
3141:
3142: IEX_Dunnings_PKG.insert_staged_dunning_row(
3143: px_rowid => l_rowid
3144: , px_dunning_trx_id => x_dunning_trx_id
3145: , p_dunning_id => p_dunning_id
3146: , p_cust_trx_id => l_transaction_id

Line 3248: IEX_Dunnings_PKG.insert_staged_dunning_row(

3244:
3245: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - sql_cur2.l_customer_trx_id :'||l_customer_trx_id);
3246: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - sql_cur2.l_payment_schedule_id : '||l_payment_schedule_id);
3247:
3248: IEX_Dunnings_PKG.insert_staged_dunning_row(
3249: px_rowid => l_rowid
3250: , px_dunning_trx_id => x_dunning_trx_id
3251: , p_dunning_id => p_dunning_id
3252: , p_cust_trx_id => l_customer_trx_id

Line 3348: IEX_Dunnings_PKG.insert_staged_dunning_row(

3344: select count(*) into iex_dunn_trx_counter from iex_dunning_transactions where dunning_id = p_dunning_id and PAYMENT_SCHEDULE_ID = l_payment_schedule_id;
3345:
3346: if iex_dunn_trx_counter = 0 then
3347:
3348: IEX_Dunnings_PKG.insert_staged_dunning_row(
3349: px_rowid => l_rowid
3350: , px_dunning_trx_id => x_dunning_trx_id
3351: , p_dunning_id => p_dunning_id
3352: , p_cust_trx_id => l_transaction_id

Line 3428: IEX_Dunnings_PKG.insert_staged_dunning_row(

3424: exit when sql_cur2%notfound;
3425:
3426: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - sql_cur2.l_payment_schedule_id : '||l_payment_schedule_id);
3427:
3428: IEX_Dunnings_PKG.insert_staged_dunning_row(
3429: px_rowid => l_rowid
3430: , px_dunning_trx_id => x_dunning_trx_id
3431: , p_dunning_id => p_dunning_id
3432: --, p_cust_trx_id => l_customer_trx_id

Line 3499: IEX_Dunnings_PKG.insert_staged_dunning_row(

3495:
3496: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - sql_cur2.l_customer_trx_id :'||l_customer_trx_id);
3497: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - sql_cur2.l_payment_schedule_id : '||l_payment_schedule_id);
3498:
3499: IEX_Dunnings_PKG.insert_staged_dunning_row(
3500: px_rowid => l_rowid
3501: , px_dunning_trx_id => x_dunning_trx_id
3502: , p_dunning_id => p_dunning_id
3503: , p_cust_trx_id => l_customer_trx_id

Line 3628: from iex_DUNNINGS

3624: ag_dn_xref_id,
3625: correspondence_date,
3626: addt_xml_template_id,
3627: addt_delivery_status
3628: from iex_DUNNINGS
3629: where dunning_id = in_dunning_id
3630: FOR UPDATE NOWAIT;
3631: --
3632: l_api_name CONSTANT VARCHAR2(30) := 'Update_DUNNING';

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

3715: If ( C_GET_DUNNING_REC%NOTFOUND) Then
3716: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3717: THEN
3718: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
3719: FND_MESSAGE.Set_Token ('INFO', 'iex_DUNNINGs', FALSE);
3720: FND_MSG_PUB.Add;
3721: END IF;
3722: raise FND_API.G_EXC_ERROR;
3723: END IF;

Line 3876: IEX_DUNNINGS_PKG.Update_Row(

3872: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_dunning_rec.dunning_mode= ' || l_dunning_rec.dunning_mode);
3873: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_dunning_rec.confirmation_mode= ' || l_dunning_rec.confirmation_mode);
3874:
3875: -- Invoke table handler
3876: IEX_DUNNINGS_PKG.Update_Row(
3877: p_rowid => l_rowid
3878: , p_dunning_id => l_dunning_rec.dunning_id
3879: , p_last_update_date => sysdate
3880: , p_last_updated_by => FND_GLOBAL.USER_ID

Line 5749: (select trunc(correspondence_date) from iex_dunnings

5745: and staged_dunning_level = 99
5746: and status in ('DELINQUENT','PREDELINQUENT')
5747: and nvl(
5748: (
5749: (select trunc(correspondence_date) from iex_dunnings
5750: where dunning_id =
5751: (select max(iet.DUNNING_ID)
5752: from iex_dunning_transactions iet,
5753: iex_dunnings dunn

Line 5753: iex_dunnings dunn

5749: (select trunc(correspondence_date) from iex_dunnings
5750: where dunning_id =
5751: (select max(iet.DUNNING_ID)
5752: from iex_dunning_transactions iet,
5753: iex_dunnings dunn
5754: where iet.PAYMENT_SCHEDULE_ID = del.payment_schedule_id
5755: and dunn.dunning_id = iet.dunning_id
5756: and ((dunn.dunning_mode = 'DRAFT' and dunn.confirmation_mode = 'CONFIRMED')
5757: OR (dunn.dunning_mode = 'FINAL'))

Line 5776: (select trunc(correspondence_date) from iex_dunnings

5772: and staged_dunning_level = 99
5773: and status in ('DELINQUENT','PREDELINQUENT')
5774: and nvl(
5775: (
5776: (select trunc(correspondence_date) from iex_dunnings
5777: where dunning_id =
5778: (select max(iet.DUNNING_ID)
5779: from iex_dunning_transactions iet,
5780: iex_dunnings dunn

Line 5780: iex_dunnings dunn

5776: (select trunc(correspondence_date) from iex_dunnings
5777: where dunning_id =
5778: (select max(iet.DUNNING_ID)
5779: from iex_dunning_transactions iet,
5780: iex_dunnings dunn
5781: where iet.PAYMENT_SCHEDULE_ID = del.payment_schedule_id
5782: and dunn.dunning_id = iet.dunning_id
5783: and ((dunn.dunning_mode = 'DRAFT' and dunn.confirmation_mode = 'CONFIRMED')
5784: OR (dunn.dunning_mode = 'FINAL'))

Line 5803: (select trunc(correspondence_date) from iex_dunnings

5799: and staged_dunning_level = 99
5800: and status in ('DELINQUENT','PREDELINQUENT')
5801: and nvl(
5802: (
5803: (select trunc(correspondence_date) from iex_dunnings
5804: where dunning_id =
5805: (select max(iet.DUNNING_ID)
5806: from iex_dunning_transactions iet,
5807: iex_dunnings dunn

Line 5807: iex_dunnings dunn

5803: (select trunc(correspondence_date) from iex_dunnings
5804: where dunning_id =
5805: (select max(iet.DUNNING_ID)
5806: from iex_dunning_transactions iet,
5807: iex_dunnings dunn
5808: where iet.PAYMENT_SCHEDULE_ID = del.payment_schedule_id
5809: and dunn.dunning_id = iet.dunning_id
5810: and ((dunn.dunning_mode = 'DRAFT' and dunn.confirmation_mode = 'CONFIRMED')
5811: OR (dunn.dunning_mode = 'FINAL'))

Line 6106: ' (select trunc(correspondence_date) from iex_dunnings ' ||

6102: ' and del.staged_dunning_level = :p_stage_no ' ||
6103: ' and nvl(arp.amount_in_dispute,0) = decode(:p_include_dis_items, ''Y'', nvl(arp.amount_in_dispute,0), 0) ' ||
6104: ' and nvl( ' ||
6105: ' ( ' ||
6106: ' (select trunc(correspondence_date) from iex_dunnings ' ||
6107: ' where dunning_id = ' ||
6108: ' (select max(iet.DUNNING_ID) from iex_dunning_transactions iet, ' ||
6109: ' iex_dunnings dunn ' ||
6110: ' where iet.PAYMENT_SCHEDULE_ID = del.payment_schedule_id ' ||

Line 6109: ' iex_dunnings dunn ' ||

6105: ' ( ' ||
6106: ' (select trunc(correspondence_date) from iex_dunnings ' ||
6107: ' where dunning_id = ' ||
6108: ' (select max(iet.DUNNING_ID) from iex_dunning_transactions iet, ' ||
6109: ' iex_dunnings dunn ' ||
6110: ' where iet.PAYMENT_SCHEDULE_ID = del.payment_schedule_id ' ||
6111: ' and dunn.dunning_id = iet.dunning_id ' ||
6112: ' and ((dunn.dunning_mode = ''DRAFT'' and dunn.confirmation_mode = ''CONFIRMED'') ' ||
6113: ' OR (dunn.dunning_mode = ''FINAL'')) ' ||

Line 6155: ' (select trunc(correspondence_date) from iex_dunnings ' ||

6151: ' and arp.class = ''INV'' ' ||
6152: ' and arp.amount_in_dispute >= decode(:p_include_dis_items, ''Y'', arp.amount_due_remaining, (arp.amount_due_original + 1)) ' ||
6153: ' and nvl( ' ||
6154: ' ( ' ||
6155: ' (select trunc(correspondence_date) from iex_dunnings ' ||
6156: ' where dunning_id = ' ||
6157: ' (select max(iet.DUNNING_ID) from iex_dunning_transactions iet, ' ||
6158: ' iex_dunnings dunn ' ||
6159: ' where iet.PAYMENT_SCHEDULE_ID = del.payment_schedule_id ' ||

Line 6158: ' iex_dunnings dunn ' ||

6154: ' ( ' ||
6155: ' (select trunc(correspondence_date) from iex_dunnings ' ||
6156: ' where dunning_id = ' ||
6157: ' (select max(iet.DUNNING_ID) from iex_dunning_transactions iet, ' ||
6158: ' iex_dunnings dunn ' ||
6159: ' where iet.PAYMENT_SCHEDULE_ID = del.payment_schedule_id ' ||
6160: ' and dunn.dunning_id = iet.dunning_id ' ||
6161: ' and ((dunn.dunning_mode = ''DRAFT'' and dunn.confirmation_mode = ''CONFIRMED'') ' ||
6162: ' OR (dunn.dunning_mode = ''FINAL'')) ' ||

Line 6612: from iex_dunnings

6608:
6609: if (l_curr_dmethod = 'FFM') then
6610: select template_id
6611: into l_xdo_template_id
6612: from iex_dunnings
6613: where dunning_id = l_dunning_id;
6614: else
6615: select xml_template_id
6616: into l_xdo_template_id

Line 6617: from iex_dunnings

6613: where dunning_id = l_dunning_id;
6614: else
6615: select xml_template_id
6616: into l_xdo_template_id
6617: from iex_dunnings
6618: where dunning_id = l_dunning_id;
6619: end if;
6620: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_xdo_template_id='||l_xdo_template_id);
6621:

Line 6749: iex_dunnings dunn

6745: and staged_dunning_level = 98
6746: and status in ('DELINQUENT','PREDELINQUENT')
6747: and exists (select count(iet.DUNNING_ID)
6748: from iex_dunning_transactions iet,
6749: iex_dunnings dunn
6750: where iet.PAYMENT_SCHEDULE_ID = del.payment_schedule_id
6751: and dunn.dunning_id = iet.dunning_id
6752: and ((dunn.dunning_mode = 'DRAFT' and dunn.confirmation_mode = 'CONFIRMED')
6753: OR (dunn.dunning_mode = 'FINAL'))

Line 6766: iex_dunnings dunn

6762: and staged_dunning_level = 98
6763: and status in ('DELINQUENT','PREDELINQUENT')
6764: and exists (select count(iet.DUNNING_ID)
6765: from iex_dunning_transactions iet,
6766: iex_dunnings dunn
6767: where iet.PAYMENT_SCHEDULE_ID = del.payment_schedule_id
6768: and dunn.dunning_id = iet.dunning_id
6769: and ((dunn.dunning_mode = 'DRAFT' and dunn.confirmation_mode = 'CONFIRMED')
6770: OR (dunn.dunning_mode = 'FINAL'))

Line 6783: iex_dunnings dunn

6779: and staged_dunning_level = 98
6780: and status in ('DELINQUENT','PREDELINQUENT')
6781: and exists (select count(iet.DUNNING_ID)
6782: from iex_dunning_transactions iet,
6783: iex_dunnings dunn
6784: where iet.PAYMENT_SCHEDULE_ID = del.payment_schedule_id
6785: and dunn.dunning_id = iet.dunning_id
6786: and ((dunn.dunning_mode = 'DRAFT' and dunn.confirmation_mode = 'CONFIRMED')
6787: OR (dunn.dunning_mode = 'FINAL'))

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

6874: END Send_Level_Staged_Dunning;
6875:
6876: /*==========================================================================
6877: * clchang updated 09/19/2002 -
6878: * insert ffm_request_id into iex_dunnings after CALL_FFM successfully;
6879: * Create_Dunning and Update_Dunning also updated;
6880: *
6881: *==========================================================================*/
6882: Procedure Send_Dunning

Line 8208: (select trunc(correspondence_date) from iex_dunnings

8204: and del.staged_dunning_level = p_stage_no
8205: and nvl(arp.amount_in_dispute,0) = decode(p_include_dis_items, 'Y', nvl(arp.amount_in_dispute,0), 0)
8206: and nvl(
8207: (
8208: (select trunc(correspondence_date) from iex_dunnings
8209: where dunning_id =
8210: (select max(iet.DUNNING_ID) from iex_dunning_transactions iet,
8211: iex_dunnings dunn
8212: where iet.PAYMENT_SCHEDULE_ID = del.payment_schedule_id

Line 8211: iex_dunnings dunn

8207: (
8208: (select trunc(correspondence_date) from iex_dunnings
8209: where dunning_id =
8210: (select max(iet.DUNNING_ID) from iex_dunning_transactions iet,
8211: iex_dunnings dunn
8212: where iet.PAYMENT_SCHEDULE_ID = del.payment_schedule_id
8213: and dunn.dunning_id = iet.dunning_id
8214: and ((dunn.dunning_mode = 'DRAFT' and dunn.confirmation_mode = 'CONFIRMED')
8215: OR (dunn.dunning_mode = 'FINAL'))

Line 8244: (select trunc(correspondence_date) from iex_dunnings

8240: and arp.class = 'INV'
8241: and arp.amount_in_dispute >= decode(p_include_dis_items, 'Y', arp.amount_due_remaining, (arp.amount_due_original + 1))
8242: and nvl(
8243: (
8244: (select trunc(correspondence_date) from iex_dunnings
8245: where dunning_id =
8246: (select distinct DUNNING_ID from iex_dunning_transactions
8247: where PAYMENT_SCHEDULE_ID = del.payment_schedule_id
8248: and STAGE_NUMBER = p_stage_no))

Line 8456: (select trunc(correspondence_date) from iex_dunnings

8452: and staged_dunning_level = 99
8453: and status in ('DELINQUENT','PREDELINQUENT')
8454: and nvl(
8455: (
8456: (select trunc(correspondence_date) from iex_dunnings
8457: where dunning_id =
8458: (select max(iet.DUNNING_ID)
8459: from iex_dunning_transactions iet,
8460: iex_dunnings dunn

Line 8460: iex_dunnings dunn

8456: (select trunc(correspondence_date) from iex_dunnings
8457: where dunning_id =
8458: (select max(iet.DUNNING_ID)
8459: from iex_dunning_transactions iet,
8460: iex_dunnings dunn
8461: where iet.PAYMENT_SCHEDULE_ID = del.payment_schedule_id
8462: and dunn.dunning_id = iet.dunning_id
8463: and ((dunn.dunning_mode = 'DRAFT' and dunn.confirmation_mode = 'CONFIRMED')
8464: OR (dunn.dunning_mode = 'FINAL'))

Line 8837: IEX_Dunnings_PKG.insert_staged_dunning_row(

8833: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_delinquency_id :'||l_delinquency_id);
8834: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_transaction_id :'||l_transaction_id);
8835: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_payment_schedule_id : '||l_payment_schedule_id);
8836:
8837: IEX_Dunnings_PKG.insert_staged_dunning_row(
8838: px_rowid => l_rowid
8839: , px_dunning_trx_id => x_dunning_trx_id
8840: , p_dunning_id => l_dunning_id
8841: , p_cust_trx_id => l_transaction_id

Line 9051: iex_dunnings dunn

9047: and staged_dunning_level = 98
9048: and status in ('DELINQUENT','PREDELINQUENT')
9049: and exists (select count(iet.DUNNING_ID)
9050: from iex_dunning_transactions iet,
9051: iex_dunnings dunn
9052: where iet.PAYMENT_SCHEDULE_ID = del.payment_schedule_id
9053: and dunn.dunning_id = iet.dunning_id
9054: and ((dunn.dunning_mode = 'DRAFT' and dunn.confirmation_mode = 'CONFIRMED')
9055: OR (dunn.dunning_mode = 'FINAL'))

Line 9199: from iex_dunnings dunn

9195: where dunning_plan_id = p_dunn_plan_id;
9196:
9197: cursor c_as_of_date (p_dunning_id number) is
9198: select nvl(dunn.as_of_date,sysdate)
9199: from iex_dunnings dunn
9200: where dunning_id = p_dunning_id;
9201:
9202: cursor c_cust_acct_amt_due_rem(p_party_id number,p_org_id number, p_corr_date date, p_grace_days number, p_include_dis_items varchar) is
9203: select nvl(sum(aps.acctd_amount_due_remaining),0)

Line 10338: FROM iex_dunnings

10334: dunning_method,
10335: amount_due_remaining,
10336: currency_code,
10337: nvl(as_of_date,sysdate)
10338: FROM iex_dunnings
10339: WHERE dunning_id = in_dunning_id;
10340:
10341: CURSOR C_CALLBACK_DETAILS (p_ag_dn_xref_id number) IS
10342: SELECT

Line 10369: from iex_dunnings dunn

10365: WHERE xml_request_id = p_xml_req_id;
10366:
10367: cursor c_as_of_date (p_dunning_id number) is
10368: select nvl(dunn.as_of_date,sysdate)
10369: from iex_dunnings dunn
10370: where dunning_id = p_dunning_id;
10371:
10372: temp_dunning_id number; -- for bug 16290958
10373: BEGIN

Line 11036: from iex_dunnings

11032: -- start bug 16290958
11033: --l_dunning_rec.parent_dunning_id := p_dunning_id; -- added for bug 9937306 by snuthala 11/25/2011
11034: temp_dunning_id := NULL;
11035: select parent_dunning_id into temp_dunning_id
11036: from iex_dunnings
11037: where dunning_id = p_dunning_id;
11038: WriteLog('temp_dunning_id -- '||temp_dunning_id);
11039: IF temp_dunning_id is not NULL then
11040: l_dunning_rec.parent_dunning_id := temp_dunning_id;

Line 11299: from iex_dunnings dunn

11295: l_as_of_date date;
11296:
11297: cursor c_as_of_date (p_dunning_id number) is
11298: select nvl(dunn.as_of_date,sysdate)
11299: from iex_dunnings dunn
11300: where dunning_id = p_dunning_id;
11301:
11302: BEGIN
11303: -- Standard Start of API savepoint

Line 12082: FROM iex_dunnings

12078: xml_template_id,
12079: ag_dn_xref_id,
12080: xml_request_id,
12081: addt_xml_template_id
12082: FROM iex_dunnings
12083: WHERE dunning_id = in_dunning_id;
12084:
12085: CURSOR C_CALLBACK_DETAILS (p_ag_dn_xref_id number) IS
12086: SELECT x.fm_method,

Line 12108: from iex_dunnings dunn

12104: l_as_of_date date;
12105:
12106: cursor c_as_of_date (p_dunning_id number) is
12107: select nvl(dunn.as_of_date,sysdate)
12108: from iex_dunnings dunn
12109: where dunning_id = p_dunning_id;
12110:
12111: temp_dunning_id number; -- added for bug 16290958
12112:

Line 12636: from iex_dunnings

12632: -- start bug 16290958
12633: --l_dunning_rec.parent_dunning_id := p_dunning_id; -- bug 997306 by snuthala 11/25/2011
12634: temp_dunning_id := NULL;
12635: select parent_dunning_id into temp_dunning_id
12636: from iex_dunnings
12637: where dunning_id = p_dunning_id;
12638: WriteLog('temp_dunning_id -- '||temp_dunning_id);
12639: IF temp_dunning_id is not NULL then
12640: l_dunning_rec.parent_dunning_id := temp_dunning_id;

Line 14345: from IEX_DUNNING_PLANS_B plan, iex_dunnings dunn

14341:
14342: If p_request_id is not null then
14343: select nvl(plan.dunning_type,'DAYS_OVERDUE')
14344: into l_dunning_type
14345: from IEX_DUNNING_PLANS_B plan, iex_dunnings dunn
14346: where dunn.xml_request_id = p_request_id
14347: and plan.dunning_plan_id = dunn.dunning_plan_id;
14348: end if;
14349:

Line 14415: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Calling IEX_Dunnings_PKG.insert_staged_dunning_row');

14411:
14412: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_transaction_id: ' || l_transaction_id);
14413: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_payment_schedule_id: ' || l_payment_schedule_id);
14414: --insert invoice list in to iex_dunning_transactions table for all correspondence.
14415: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Calling IEX_Dunnings_PKG.insert_staged_dunning_row');
14416: IEX_Dunnings_PKG.insert_staged_dunning_row(
14417: px_rowid => l_rowid
14418: , px_dunning_trx_id => x_dunning_trx_id
14419: , p_dunning_id => l_dunning_id

Line 14416: IEX_Dunnings_PKG.insert_staged_dunning_row(

14412: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_transaction_id: ' || l_transaction_id);
14413: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_payment_schedule_id: ' || l_payment_schedule_id);
14414: --insert invoice list in to iex_dunning_transactions table for all correspondence.
14415: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Calling IEX_Dunnings_PKG.insert_staged_dunning_row');
14416: IEX_Dunnings_PKG.insert_staged_dunning_row(
14417: px_rowid => l_rowid
14418: , px_dunning_trx_id => x_dunning_trx_id
14419: , p_dunning_id => l_dunning_id
14420: , p_cust_trx_id => l_transaction_id

Line 14795: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Calling IEX_Dunnings_PKG.insert_staged_dunning_row');

14791:
14792: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_transaction_id: ' || l_transaction_id);
14793: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_payment_schedule_id: ' || l_payment_schedule_id);
14794: --insert invoice list in to iex_dunning_transactions table for all correspondence.
14795: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Calling IEX_Dunnings_PKG.insert_staged_dunning_row');
14796: IEX_Dunnings_PKG.insert_staged_dunning_row(
14797: px_rowid => l_rowid
14798: , px_dunning_trx_id => x_dunning_trx_id
14799: , p_dunning_id => l_dunning_id

Line 14796: IEX_Dunnings_PKG.insert_staged_dunning_row(

14792: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_transaction_id: ' || l_transaction_id);
14793: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_payment_schedule_id: ' || l_payment_schedule_id);
14794: --insert invoice list in to iex_dunning_transactions table for all correspondence.
14795: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Calling IEX_Dunnings_PKG.insert_staged_dunning_row');
14796: IEX_Dunnings_PKG.insert_staged_dunning_row(
14797: px_rowid => l_rowid
14798: , px_dunning_trx_id => x_dunning_trx_id
14799: , p_dunning_id => l_dunning_id
14800: , p_cust_trx_id => l_transaction_id

Line 15912: FROM IEX_DUNNINGS

15908: IS
15909: --Start adding for bug 8489610 by gnramasa 14-May-09
15910: CURSOR C_GET_DUNNING (IN_ID NUMBER, IN_TYPE VARCHAR2) IS
15911: SELECT dunning_ID
15912: FROM IEX_DUNNINGS
15913: WHERE
15914: STATUS = 'OPEN'
15915: AND dunning_level = IN_TYPE
15916: AND dunning_object_id = IN_ID;

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

15931: errmsg VARCHAR2(32767);
15932: nIdx NUMBER := 0;
15933: nCnt NUMBER := 0;
15934: --
15935: TYPE Dunning_ID_TBL_type is Table of IEX_DUNNINGS.DUNNING_ID%TYPE
15936: INDEX BY BINARY_INTEGER;
15937: dunning_tbl Dunning_ID_TBL_TYPE;
15938: --
15939: BEGIN

Line 16017: UPDATE IEX_DUNNINGS

16013:
16014: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - DunnCnt='||nIdx||';'||dunning_tbl.count);
16015:
16016: FORALL i in 1..dunning_tbl.count
16017: UPDATE IEX_DUNNINGS
16018: SET CALLBACK_YN = 'N',
16019: STATUS = 'CLOSE',
16020: LAST_UPDATE_DATE = sysdate
16021: WHERE Dunning_id = dunning_tbl(i);

Line 16091: FROM IEX_DUNNINGS

16087: IS
16088: --Start adding for bug 8489610 by gnramasa 14-May-09
16089: CURSOR C_GET_DUNNING (IN_ID NUMBER, IN_TYPE VARCHAR2, IN_DUNN_PLAN_LINE_ID NUMBER) IS
16090: SELECT dunning_ID
16091: FROM IEX_DUNNINGS
16092: WHERE
16093: STATUS = 'OPEN'
16094: AND dunning_level = IN_TYPE
16095: AND dunning_object_id = IN_ID

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

16110: errmsg VARCHAR2(32767);
16111: nIdx NUMBER := 0;
16112: nCnt NUMBER := 0;
16113: --
16114: TYPE Dunning_ID_TBL_type is Table of IEX_DUNNINGS.DUNNING_ID%TYPE
16115: INDEX BY BINARY_INTEGER;
16116: dunning_tbl Dunning_ID_TBL_TYPE;
16117: --
16118: BEGIN

Line 16197: UPDATE IEX_DUNNINGS

16193:
16194: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - DunnCnt='||nIdx||';'||dunning_tbl.count);
16195:
16196: FORALL i in 1..dunning_tbl.count
16197: UPDATE IEX_DUNNINGS
16198: SET CALLBACK_YN = 'N',
16199: STATUS = 'CLOSE',
16200: LAST_UPDATE_DATE = sysdate
16201: WHERE Dunning_id = dunning_tbl(i);

Line 16269: FROM IEX_DUNNINGS

16265: SELECT dunning_ID,
16266: delinquency_id,
16267: dunning_object_id,
16268: to_char(callback_date, 'YYYYMMDD')
16269: FROM IEX_DUNNINGS
16270: WHERE STATUS = 'OPEN'
16271: AND CALLBACK_YN = 'Y'
16272: AND dunning_level = IN_LEVEL
16273: AND to_char(callback_date, 'YYYYMMDD') <= to_char(sysdate,'YYYYMMDD');

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

16315: l_chk NUMBER := 0;
16316: l_task_cnt NUMBER := 0;
16317: l_skip NUMBER := 0;
16318: --
16319: TYPE Dunning_ID_TBL_type is Table of IEX_DUNNINGS.DUNNING_ID%TYPE
16320: INDEX BY BINARY_INTEGER;
16321: dunning_tbl Dunning_ID_TBL_TYPE;
16322: l_dunning_object_id NUMBER;
16323:

Line 16533: UPDATE IEX_DUNNINGS

16529:
16530: IF (nCnt > 0) THEN
16531:
16532: FORALL i in 1..dunning_tbl.count
16533: UPDATE IEX_DUNNINGS
16534: SET CALLBACK_YN = 'N',
16535: LAST_UPDATE_DATE = sysdate
16536: WHERE Dunning_id = dunning_tbl(i);
16537:

Line 16568: ||' iex_dunnings dun'

16564: ||' from jtf_tasks_b tsk,'
16565: ||' jtf_task_types_tl typ,'
16566: ||' jtf_task_statuses_b st,'
16567: ||' jtf_task_references_b ref,'
16568: ||' iex_dunnings dun'
16569: ||' where tsk.task_type_id=typ.task_type_id'
16570: ||' and typ.name=''Callback'''
16571: ||' and tsk.task_status_id=st.task_status_id'
16572: ||' and nvl(st.closed_flag, ''N'') <>''Y'''

Line 17849: FROM iex_dunnings id

17845: SELECT
17846: count(*) no_of_rec_processed,
17847: sum(decode(delivery_status,NULL,1,0)) no_of_success_records,
17848: sum(decode(delivery_status,NULL,0,1)) no_of_failure_records
17849: FROM iex_dunnings id
17850: WHERE id.request_id = p_req_id
17851: AND id.object_type <> 'IEX_INVOICES'
17852: AND id.dunning_id = (SELECT MAX(dunning_id)
17853: FROM iex_dunnings d

Line 17853: FROM iex_dunnings d

17849: FROM iex_dunnings id
17850: WHERE id.request_id = p_req_id
17851: AND id.object_type <> 'IEX_INVOICES'
17852: AND id.dunning_id = (SELECT MAX(dunning_id)
17853: FROM iex_dunnings d
17854: WHERE d.dunning_object_id = id.dunning_object_id
17855: AND d.dunning_level = id.dunning_level
17856: AND d.request_id = id.request_id
17857: AND d.object_type <> 'IEX_INVOICES');

Line 17875: 'iex_dunnings id, ' ||

17871: --'ixr.xml_request_id REQUEST_ID ' ||
17872: --' ''http://techcm.us.oracle.com:8000/OA_HTML/IEXDUNCPRRedirect.jsp?RequestId='' || ixr.xml_request_id DOWNLOAD_URL ' ||
17873: 'from iex_xml_request_histories ixr, ' ||
17874: 'hz_parties p, ' ||
17875: 'iex_dunnings id, ' ||
17876: 'XDO_TEMPLATES_B xtb, ' ||
17877: 'XDO_TEMPLATES_TL xtvl ' ||
17878: 'where id.dunning_object_id = p.party_id ' ||
17879: 'and ixr.xml_request_id (+) = id.xml_request_id ' ||

Line 17885: 'and id.dunning_id = (select max(dunning_id) from iex_dunnings d ' ||

17881: 'and xtb.template_code=xtvl.template_code ' ||
17882: 'and xtb.template_id = id.xml_template_id ' ||
17883: 'and xtvl.language=userenv(''LANG'') ' ||
17884: 'AND id.object_type <> ''IEX_INVOICES'' ' ||
17885: 'and id.dunning_id = (select max(dunning_id) from iex_dunnings d ' ||
17886: ' where d.dunning_object_id = id.dunning_object_id and d.dunning_level=id.dunning_level and d.request_id = id.request_id ' ||
17887: ' AND d.object_type <> ''IEX_INVOICES'' ) ' ||
17888: --'order by lower(p.party_name)' ;
17889: 'order by NLSSORT(lower(p.party_name),''NLS_SORT=BINARY'')'; -- added by sunagesh for bug 13877178

Line 17908: 'iex_dunnings id, ' ||

17904: --' ''http://techcm.us.oracle.com:8000/OA_HTML/IEXDUNCPRRedirect.jsp?RequestId='' || ixr.xml_request_id DOWNLOAD_URL ' ||
17905: 'from iex_xml_request_histories ixr, ' ||
17906: 'hz_parties p, ' ||
17907: 'hz_cust_accounts hcu, ' ||
17908: 'iex_dunnings id, ' ||
17909: 'XDO_TEMPLATES_B xtb, ' ||
17910: 'XDO_TEMPLATES_TL xtvl ' ||
17911: 'where id.dunning_object_id = hcu.cust_account_id ' ||
17912: 'and hcu.party_id = p.party_id ' ||

Line 17919: 'and id.dunning_id = (select max(dunning_id) from iex_dunnings d ' ||

17915: 'and xtb.template_code=xtvl.template_code ' ||
17916: 'and xtb.template_id = id.xml_template_id ' ||
17917: 'and xtvl.language=userenv(''LANG'') ' ||
17918: 'AND id.object_type <> ''IEX_INVOICES'' ' ||
17919: 'and id.dunning_id = (select max(dunning_id) from iex_dunnings d ' ||
17920: ' where d.dunning_object_id = id.dunning_object_id and d.dunning_level=id.dunning_level and d.request_id = id.request_id ' ||
17921: ' AND d.object_type <> ''IEX_INVOICES'' ) ' ||
17922: --'order by lower(p.party_name)' ;
17923: 'order by NLSSORT(lower(p.party_name),''NLS_SORT=BINARY'')'; -- added by sunagesh for bug 13877178

Line 17945: 'iex_dunnings id, ' ||

17941: 'hz_parties p, ' ||
17942: 'hz_cust_accounts hcu,' ||
17943: 'hz_cust_acct_sites_all acct_sites, ' ||
17944: 'hz_cust_site_uses_all site_uses, ' ||
17945: 'iex_dunnings id, ' ||
17946: 'XDO_TEMPLATES_B xtb, ' ||
17947: 'XDO_TEMPLATES_TL xtvl ' ||
17948: 'where id.dunning_object_id = site_uses.site_use_id ' ||
17949: 'and acct_sites.cust_acct_site_id = site_uses.cust_acct_site_id ' ||

Line 17959: 'and id.dunning_id = (select max(dunning_id) from iex_dunnings d ' ||

17955: 'and xtb.template_id = id.xml_template_id ' ||
17956: 'and xtvl.language=userenv(''LANG'') ' ||
17957: 'AND id.object_type <> ''IEX_INVOICES'' ' ||
17958: --'and nvl(id.confirmation_mode,''CONFIRMED'') <> ''REJECTED'' ' ||
17959: 'and id.dunning_id = (select max(dunning_id) from iex_dunnings d ' ||
17960: ' where d.dunning_object_id = id.dunning_object_id and d.dunning_level=id.dunning_level and d.request_id = id.request_id ' ||
17961: ' AND d.object_type <> ''IEX_INVOICES'' ) ' ||
17962: -- 'order by lower(p.party_name)' ;
17963: 'order by NLSSORT(lower(p.party_name),''NLS_SORT=BINARY'')'; -- added by sunagesh for bug 13877178

Line 17981: 'iex_dunnings id, ' ||

17977: --'ixr.xml_request_id REQUEST_ID ' ||
17978: --' ''http://techcm.us.oracle.com:8000/OA_HTML/IEXDUNCPRRedirect.jsp?RequestId='' || ixr.xml_request_id DOWNLOAD_URL ' ||
17979: 'from iex_xml_request_histories ixr, ' ||
17980: 'hz_parties p, ' ||
17981: 'iex_dunnings id, ' ||
17982: 'XDO_TEMPLATES_B xtb, ' ||
17983: 'XDO_TEMPLATES_TL xtvl, ' ||
17984: 'iex_delinquencies_all del, ' ||
17985: 'ar_payment_schedules_all aps ' ||

Line 17995: 'and id.dunning_id = (select max(dunning_id) from iex_dunnings d ' ||

17991: 'and xtb.template_code=xtvl.template_code ' ||
17992: 'and xtb.template_id = id.xml_template_id ' ||
17993: 'and xtvl.language=userenv(''LANG'') ' ||
17994: 'AND id.object_type <> ''IEX_INVOICES'' ' ||
17995: 'and id.dunning_id = (select max(dunning_id) from iex_dunnings d ' ||
17996: ' where d.dunning_object_id = id.dunning_object_id and d.dunning_level=id.dunning_level and d.request_id = id.request_id ' ||
17997: ' AND d.object_type <> ''IEX_INVOICES'' ) ' ||
17998: -- 'order by lower(p.party_name)' ;
17999: 'order by NLSSORT(lower(p.party_name),''NLS_SORT=BINARY'')'; -- added by sunagesh for bug 13877178

Line 18176: iex_dunnings dunn,

18172: select idt.cust_trx_id,
18173: dunn.object_id,
18174: dunn.object_type
18175: from iex_dunning_transactions idt,
18176: iex_dunnings dunn,
18177: iex_ag_dn_xref xref
18178: where idt.dunning_id = dunn.dunning_id
18179: and dunn.request_id = p_conc_req_id
18180: and dunn.ag_dn_xref_id = xref.ag_dn_xref_id

Line 18199: ' iex_dunnings dunn, ' ||

18195: ' dunn.object_id, ' ||
18196: ' dunn.object_type, ' ||
18197: ' dunn.dunning_method ' ||
18198: ' from iex_dunning_transactions idt, ' ||
18199: ' iex_dunnings dunn, ' ||
18200: ' iex_ag_dn_xref xref, ' ||
18201: ' ra_customer_trx trx ' ||
18202: ' where idt.dunning_id = dunn.dunning_id ' ||
18203: ' and dunn.request_id = :p_conc_req_id ' ||

Line 18567: IEX_Dunnings_PKG.insert_staged_dunning_row(

18563: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - sql_cur.l_delinquency_id :'||l_delinquency_id);
18564: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - sql_cur.l_transaction_id :'||l_transaction_id);
18565: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - sql_cur.l_payment_schedule_id : '||l_payment_schedule_id);
18566:
18567: IEX_Dunnings_PKG.insert_staged_dunning_row(
18568: px_rowid => l_rowid
18569: , px_dunning_trx_id => x_dunning_trx_id
18570: , p_dunning_id => p_dunning_id
18571: , p_cust_trx_id => l_transaction_id

Line 18658: IEX_Dunnings_PKG.insert_staged_dunning_row(

18654: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - sql_cur.l_delinquency_id :'||l_delinquency_id);
18655: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - sql_cur.l_transaction_id :'||l_transaction_id);
18656: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - sql_cur.l_payment_schedule_id : '||l_payment_schedule_id);
18657:
18658: IEX_Dunnings_PKG.insert_staged_dunning_row(
18659: px_rowid => l_rowid
18660: , px_dunning_trx_id => x_dunning_trx_id
18661: , p_dunning_id => p_dunning_id
18662: , p_cust_trx_id => l_transaction_id

Line 18732: IEX_Dunnings_PKG.insert_staged_dunning_row(

18728: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - sql_cur1.l_delinquency_id :'||l_delinquency_id);
18729: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - sql_cur1.l_transaction_id :'||l_transaction_id);
18730: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - sql_cur1.l_payment_schedule_id : '||l_payment_schedule_id);
18731:
18732: IEX_Dunnings_PKG.insert_staged_dunning_row(
18733: px_rowid => l_rowid
18734: , px_dunning_trx_id => x_dunning_trx_id
18735: , p_dunning_id => p_dunning_id
18736: , p_cust_trx_id => l_transaction_id

Line 18832: IEX_Dunnings_PKG.insert_staged_dunning_row(

18828:
18829: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - sql_cur2.l_customer_trx_id :'||l_customer_trx_id);
18830: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - sql_cur2.l_payment_schedule_id : '||l_payment_schedule_id);
18831:
18832: IEX_Dunnings_PKG.insert_staged_dunning_row(
18833: px_rowid => l_rowid
18834: , px_dunning_trx_id => x_dunning_trx_id
18835: , p_dunning_id => p_dunning_id
18836: , p_cust_trx_id => l_customer_trx_id

Line 18912: IEX_Dunnings_PKG.insert_staged_dunning_row(

18908: exit when sql_cur2%notfound;
18909:
18910: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - sql_cur2.l_payment_schedule_id : '||l_payment_schedule_id);
18911:
18912: IEX_Dunnings_PKG.insert_staged_dunning_row(
18913: px_rowid => l_rowid
18914: , px_dunning_trx_id => x_dunning_trx_id
18915: , p_dunning_id => p_dunning_id
18916: --, p_cust_trx_id => l_customer_trx_id

Line 18984: IEX_Dunnings_PKG.insert_staged_dunning_row(

18980:
18981: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - sql_cur2.l_customer_trx_id :'||l_customer_trx_id);
18982: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - sql_cur2.l_payment_schedule_id : '||l_payment_schedule_id);
18983:
18984: IEX_Dunnings_PKG.insert_staged_dunning_row(
18985: px_rowid => l_rowid
18986: , px_dunning_trx_id => x_dunning_trx_id
18987: , p_dunning_id => p_dunning_id
18988: , p_cust_trx_id => l_customer_trx_id