APPS.IEX_PROMISES_PUB dependencies on IEX_DELINQUENCIES

Line 269: IEX_DELINQUENCIES_ALL del

265: CURSOR del_crs(p_promise_id number) IS
266: SELECT del.party_cust_id,del.cust_account_id,del.CUSTOMER_SITE_USE_ID,
267: del.delinquency_id, prd.CNSLD_INVOICE_ID, prd.CONTRACT_ID
268: FROM IEX_PROMISE_DETAILS prd,
269: IEX_DELINQUENCIES_ALL del
270: WHERE prd.PROMISE_DETAIL_ID = P_PROMISE_ID
271: and prd.delinquency_id = del.delinquency_id;
272: --end bug#2369298 schekuri 24-Feb-2006
273:

Line 869: 'FROM AR_PAYMENT_SCHEDULES PSA, IEX_DELINQUENCIES DEL ' ||

865: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Validating ' || l_validation_item);
866: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' = ' || P_PROMISE_REC.CURRENCY_CODE);
867: END IF;
868: l_SQL := 'SELECT PSA.INVOICE_CURRENCY_CODE ' ||
869: 'FROM AR_PAYMENT_SCHEDULES PSA, IEX_DELINQUENCIES DEL ' ||
870: 'WHERE ' ||
871: 'DEL.DELINQUENCY_ID = :P_DELINQUENCY_ID AND ' ||
872: 'DEL.PAYMENT_SCHEDULE_ID = PSA.PAYMENT_SCHEDULE_ID';
873:

Line 1098: from iex_delinquencies_all

1094: select IEX_PROMISE_DETAILS_S.NEXTVAL from dual;
1095: --Begin bug 7237026 17-Nov-2208 barathsr
1096: CURSOR c_org_id (p_del_id number) IS
1097: select org_id
1098: from iex_delinquencies_all
1099: where delinquency_id = p_del_id;
1100: --End bug 7237026 17-Nov-2208 barathsr
1101:
1102: BEGIN

Line 2350: l_SQL := 'SELECT count(distinct CUST_ACCOUNT_ID) from iex_delinquencies where delinquency_id in (';

2346: END IF;
2347: */
2348: /* building sql for validating ids */
2349: /*
2350: l_SQL := 'SELECT count(distinct CUST_ACCOUNT_ID) from iex_delinquencies where delinquency_id in (';
2351: FOR i IN 1..P_MASS_IDS_TBL.COUNT LOOP
2352: if i = 1 then
2353: l_SQL := l_SQL || P_MASS_IDS_TBL(i);
2354: else

Line 2501: from iex_delinquencies_all

2497:
2498: --Begin bug 7237026 17-Nov-2008 barathsr
2499: CURSOR c_org_id (p_del_id number) IS
2500: select org_id
2501: from iex_delinquencies_all
2502: where delinquency_id = p_del_id;
2503: --End bug 7237026 17-Nov-2008 barathsr
2504:
2505:

Line 2564: ' FROM iex_delinquencies del, ar_payment_schedules psa ' ||

2560: -- l_SQL := 'SELECT CUSTOMER_ID, CUSTOMER_SITE_USE_ID, payment_schedule_id' ||
2561: -- ' from iex_pay_invoices_v where delinquency_id = :P_DEL_ID';
2562:
2563: l_SQL := 'SELECT psa.CUSTOMER_ID, psa.CUSTOMER_SITE_USE_ID, del.payment_schedule_id ' ||
2564: ' FROM iex_delinquencies del, ar_payment_schedules psa ' ||
2565: ' WHERE psa.payment_schedule_id = del.payment_schedule_id and psa.status = ''OP'' and ' ||
2566: ' psa.AMOUNT_DUE_REMAINING > 0 and del.DELINQUENCY_ID = :P_DEL_ID';
2567:
2568: open l_cursor for l_SQL

Line 2665: ' FROM iex_delinquencies del, ar_payment_schedules psa ' ||

2661: close l_cursor;
2662:
2663: -- fixed a perf bug 4930381 l_SQL := 'SELECT CUSTOMER_ID, AMOUNT_DUE_REMAINING, INVOICE_CURRENCY_CODE, CUSTOMER_SITE_USE_ID FROM iex_pay_invoices_v WHERE DELINQUENCY_ID = :P_DEL_ID';
2664: l_SQL := 'SELECT psa.CUSTOMER_ID, psa.AMOUNT_DUE_REMAINING, psa.INVOICE_CURRENCY_CODE, psa.CUSTOMER_SITE_USE_ID '||
2665: ' FROM iex_delinquencies del, ar_payment_schedules psa ' ||
2666: ' WHERE psa.payment_schedule_id = del.payment_schedule_id and psa.status = ''OP'' and ' ||
2667: ' psa.AMOUNT_DUE_REMAINING > 0 and del.DELINQUENCY_ID = :P_DEL_ID';
2668: open l_cursor for l_SQL
2669: using P_MASS_IDS_TBL(i);

Line 3030: iex_delinquencies del

3026: END IF;
3027: Begin
3028: SELECT amount_due_remaining into l_amt_due_remaining
3029: from ar_payment_schedules pay,
3030: iex_delinquencies del
3031: where
3032: del.payment_schedule_id = pay.payment_schedule_id
3033: and del.delinquency_id = l_promised_delinquency_id;
3034: Exception

Line 3042: update iex_delinquencies_all

3038: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3039: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || 'l_amt_due_remaining: ' || l_amt_due_remaining);
3040: end if;
3041: if l_amt_due_remaining <= l_total_already_pro_amt and nvl(fnd_profile.value('IEX_ALLOW_DUN_FULL_PROMISE'),'N')= 'Y' then --modified for bug 14318148
3042: update iex_delinquencies_all
3043: set staged_dunning_level = 0
3044: where delinquency_id = l_promised_delinquency_id;
3045:
3046: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 3052: update iex_delinquencies_all

3048: end if;
3049: else
3050: iex_utilities.MaxStageForanDelinquency (p_delinquency_id => l_promised_delinquency_id
3051: , p_stage_number => l_stage_number);
3052: update iex_delinquencies_all
3053: set staged_dunning_level = l_stage_number
3054: where delinquency_id = l_promised_delinquency_id
3055: and staged_dunning_level=0; --added for bug 14318148
3056: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN