DBA Data[Home] [Help]

APPS.IEX_DUNNING_PUB dependencies on IEX_DELINQUENCY_PUB

Line 509: l_delinquencies_tbl IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE;

505: l_party_id NUMBER;
506: l_account_id NUMBER;
507: l_customer_site_use_id NUMBER;
508: l_score NUMBER;
509: l_delinquencies_tbl IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE;
510: l_delinquency_rec IEX_DELINQUENCY_PUB.DELINQUENCY_REC_TYPE;
511: l_bucket VARCHAR2(100);
512: nIdx NUMBER;
513: nDelIdx NUMBER;

Line 510: l_delinquency_rec IEX_DELINQUENCY_PUB.DELINQUENCY_REC_TYPE;

506: l_account_id NUMBER;
507: l_customer_site_use_id NUMBER;
508: l_score NUMBER;
509: l_delinquencies_tbl IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE;
510: l_delinquency_rec IEX_DELINQUENCY_PUB.DELINQUENCY_REC_TYPE;
511: l_bucket VARCHAR2(100);
512: nIdx NUMBER;
513: nDelIdx NUMBER;
514: errmsg VARCHAR2(32767);

Line 643: --l_delinquency_rec := IEX_DELINQUENCY_PUB.G_MISS_DELINQUENCY_REC; -- clear rec

639: l_delinquency_rec.customer_site_use_id := l_customer_site_use_id;
640: l_delinquencies_Tbl(nDelIdx) := l_delinquency_rec;
641:
642: --clchang updated to fix the gscc warning 10/28/04
643: --l_delinquency_rec := IEX_DELINQUENCY_PUB.G_MISS_DELINQUENCY_REC; -- clear rec
644: l_delinquency_rec := null; -- clear rec
645: --WriteLog('***iexpdunb:SEND_DUNN:save data');
646: end if;
647: END LOOP;

Line 756: --l_delinquency_rec := IEX_DELINQUENCY_PUB.G_MISS_DELINQUENCY_REC; -- clear rec

752: l_delinquency_rec.cust_account_id := l_account_id;
753: l_delinquency_rec.customer_site_use_id := l_customer_site_use_id;
754: l_delinquencies_Tbl(nDelIdx) := l_delinquency_rec;
755: --clchang updated to fix the gscc warning 10/28/04
756: --l_delinquency_rec := IEX_DELINQUENCY_PUB.G_MISS_DELINQUENCY_REC; -- clear rec
757: l_delinquency_rec := null; -- clear rec
758: end if;
759: END LOOP;
760: Close C_Get_ACCOUNT_DEL;

Line 854: --l_delinquency_rec := IEX_DELINQUENCY_PUB.G_MISS_DELINQUENCY_REC; -- clear rec

850: l_delinquency_rec.party_cust_id := l_party_id;
851: l_delinquency_rec.cust_account_id := l_account_id;
852: l_delinquency_rec.customer_site_use_id := l_customer_site_use_id;
853: l_delinquencies_Tbl(nDelIdx) := l_delinquency_rec;
854: --l_delinquency_rec := IEX_DELINQUENCY_PUB.G_MISS_DELINQUENCY_REC; -- clear rec
855: l_delinquency_rec := null; -- clear rec
856: end if;
857: END LOOP;
858: Close C_Get_SITE_DEL;

Line 935: --l_delinquency_rec := IEX_DELINQUENCY_PUB.G_MISS_DELINQUENCY_REC; -- clear rec

931: l_delinquency_rec.cust_account_id := l_account_id;
932: l_delinquency_rec.customer_site_use_id := l_customer_site_use_id;
933: l_delinquency_rec.score_value := l_score;
934: l_delinquencies_Tbl(nIdx) := l_delinquency_rec;
935: --l_delinquency_rec := IEX_DELINQUENCY_PUB.G_MISS_DELINQUENCY_REC; -- clear rec
936: l_delinquency_rec := null; -- clear rec
937: end if;
938:
939: END LOOP;