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_PROMISES_PUB dependencies on IEX_PROMISE_DETAILS

Line 124: 'FROM IEX_PROMISE_DETAILS ' ||

120: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
121: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': filtering broken promises...');
122: END IF;
123: l_SQL := 'SELECT state ' ||
124: 'FROM IEX_PROMISE_DETAILS ' ||
125: 'WHERE ' ||
126: 'PROMISE_DETAIL_ID = :P_PROMISE_ID';
127:
128: j := 0;

Line 189: update iex_promise_details

185: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': l_uwq_complete_date: ' || l_uwq_complete_date);
186: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': updating promise details...');
187: END IF;
188: FORALL i in 1..nCount
189: update iex_promise_details
190: set UWQ_STATUS = P_STATUS,
191: UWQ_ACTIVE_DATE = l_uwq_active_date,
192: UWQ_COMPLETE_DATE = l_uwq_complete_date,
193: last_update_date = sysdate,

Line 258: FROM IEX_PROMISE_DETAILS

254:
255: --begin bug#2369298 schekuri 24-Feb-2006
256: /*CURSOR del_crs(p_promise_id number) IS
257: SELECT delinquency_id, cust_account_id, CNSLD_INVOICE_ID, CONTRACT_ID
258: FROM IEX_PROMISE_DETAILS
259: WHERE PROMISE_DETAIL_ID = P_PROMISE_ID;*/
260:
261: l_DefaultStrategyLevel number;
262: l_party_id number;

Line 268: FROM IEX_PROMISE_DETAILS prd,

264: l_unpro_dels number;
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

Line 318: 'FROM IEX_PROMISE_DETAILS ' ||

314: --begin bug#2369298 schekuri 24-Feb-2006
315: --get party_id and cust_site_use id also
316: /* getting delinquency_id, cust_account_id, l_cnsld_id and l_contract_id */
317: /*l_SQL := 'SELECT delinquency_id, cust_account_id, CNSLD_INVOICE_ID, CONTRACT_ID ' ||
318: 'FROM IEX_PROMISE_DETAILS ' ||
319: 'WHERE ' ||
320: 'PROMISE_DETAIL_ID = :P_PROMISE_ID';
321:
322: open l_cursor for l_SQL

Line 771: 'FROM IEX_PROMISE_DETAILS ' ||

767: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' = ' || P_PROMISE_REC.PROMISE_DATE);
768: END IF;
769:
770: l_SQL := 'SELECT COUNT(1) ' ||
771: 'FROM IEX_PROMISE_DETAILS ' ||
772: 'WHERE ' ||
773: 'DELINQUENCY_ID IS NULL AND CNSLD_INVOICE_ID IS NULL AND CONTRACT_ID IS NULL AND ' ||
774: 'CUST_ACCOUNT_ID IS NOT NULL AND CUST_ACCOUNT_ID = :P_CUST_ACCOUNT_ID AND ' ||
775: 'PROMISE_DATE = :P_PROMISE_DATE AND ' ||

Line 837: 'FROM IEX_PROMISE_DETAILS ' ||

833: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' = ' || P_PROMISE_REC.PROMISE_DATE);
834: END IF;
835:
836: l_SQL := 'SELECT COUNT(1) ' ||
837: 'FROM IEX_PROMISE_DETAILS ' ||
838: 'WHERE ' ||
839: 'CNSLD_INVOICE_ID IS NULL AND CONTRACT_ID IS NULL AND ' ||
840: 'CUST_ACCOUNT_ID IS NOT NULL AND CUST_ACCOUNT_ID = :P_CUST_ACCOUNT_ID AND ' ||
841: 'DELINQUENCY_ID IS NOT NULL AND DELINQUENCY_ID = :P_DELINQUENCY_ID AND ' ||

Line 916: 'FROM IEX_PROMISE_DETAILS ' ||

912: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' = ' || P_PROMISE_REC.PROMISE_DATE);
913: END IF;
914:
915: l_SQL := 'SELECT COUNT(1) ' ||
916: 'FROM IEX_PROMISE_DETAILS ' ||
917: 'WHERE ' ||
918: 'DELINQUENCY_ID IS NULL AND CONTRACT_ID IS NULL AND ' ||
919: 'CUST_ACCOUNT_ID IS NOT NULL AND CUST_ACCOUNT_ID = :P_CUST_ACCOUNT_ID AND ' ||
920: 'CNSLD_INVOICE_ID IS NOT NULL AND CNSLD_INVOICE_ID = :P_CNSLD_INVOICE_ID AND ' ||

Line 995: 'FROM IEX_PROMISE_DETAILS ' ||

991: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' = ' || P_PROMISE_REC.PROMISE_DATE);
992: END IF;
993:
994: l_SQL := 'SELECT COUNT(1) ' ||
995: 'FROM IEX_PROMISE_DETAILS ' ||
996: 'WHERE ' ||
997: 'DELINQUENCY_ID IS NULL AND CNSLD_INVOICE_ID IS NULL AND ' ||
998: 'CUST_ACCOUNT_ID IS NOT NULL AND CUST_ACCOUNT_ID = :P_CUST_ACCOUNT_ID AND ' ||
999: 'CONTRACT_ID IS NOT NULL AND CONTRACT_ID = :P_CONTRACT_ID AND ' ||

Line 1094: select IEX_PROMISE_DETAILS_S.NEXTVAL from dual;

1090:
1091:
1092: -- generate new promise detail
1093: CURSOR prd_genid_crs IS
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

Line 1176: INSERT INTO IEX_PROMISE_DETAILS

1172: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1173: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Doing insert...');
1174: END IF;
1175:
1176: INSERT INTO IEX_PROMISE_DETAILS
1177: (
1178: PROMISE_DETAIL_ID,
1179: OBJECT_VERSION_NUMBER,
1180: PROGRAM_ID,

Line 1454: -- 'FROM IEX_PROMISE_DETAILS ' ||

1450: l_str_cnsld2 varchar2(100); -- := ' AND CNSLD_INVOICE_ID is null';
1451: l_str_cnt1 varchar2(100); -- := ' AND CONTRACT_ID = ';
1452: l_str_cnt2 varchar2(100); -- := ' AND CONTRACT_ID is null';
1453: l_str_select varchar2(1000); -- := 'SELECT COUNT(1) ' ||
1454: -- 'FROM IEX_PROMISE_DETAILS ' ||
1455: -- 'WHERE ';
1456: l_str_cond varchar2(1000); -- := ' AND ' ||
1457: -- 'promise_detail_id <> :P_PROMISE_ID AND ' ||
1458: -- 'PROMISE_DATE = :P_PROMISE_DATE AND ' ||

Line 1470: 'FROM IEX_PROMISE_DETAILS ' ||

1466: l_str_cnsld2 := ' AND CNSLD_INVOICE_ID is null';
1467: l_str_cnt1 := ' AND CONTRACT_ID = ';
1468: l_str_cnt2 := ' AND CONTRACT_ID is null';
1469: l_str_select := 'SELECT COUNT(1) ' ||
1470: 'FROM IEX_PROMISE_DETAILS ' ||
1471: 'WHERE ';
1472: l_str_cond := ' AND ' ||
1473: 'promise_detail_id <> :P_PROMISE_ID AND ' ||
1474: 'PROMISE_DATE = :P_PROMISE_DATE AND ' ||

Line 1532: 'FROM IEX_PROMISE_DETAILS ' ||

1528: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1529: iex_debug_pub.LogMessage(G_PKG_NAME || '.' ||l_procedure || ': Validating db data');
1530: END IF;
1531: l_SQL := 'SELECT CUST_ACCOUNT_ID, DELINQUENCY_ID, CNSLD_INVOICE_ID, CONTRACT_ID, STATUS, STATE, PROMISE_AMOUNT, AMOUNT_DUE_REMAINING ' ||
1532: 'FROM IEX_PROMISE_DETAILS ' ||
1533: 'WHERE ' ||
1534: 'PROMISE_DETAIL_ID = :P_PROMISE_ID';
1535:
1536: open l_cursor for l_SQL

Line 1646: 'FROM IEX_PROMISE_DETAILS ' ||

1642: l_SQL := l_str_select || l_where_clause || l_str_cond;
1643:
1644: /* fix bind varviolation error
1645: l_SQL := 'SELECT COUNT(1) ' ||
1646: 'FROM IEX_PROMISE_DETAILS ' ||
1647: 'WHERE ' || l_where_clause || ' AND ' ||
1648: 'promise_detail_id <> :P_PROMISE_ID AND ' ||
1649: 'PROMISE_DATE = :P_PROMISE_DATE AND ' ||
1650: 'STATUS in (''COLLECTABLE'', ''PENDING'')';

Line 1794: UPDATE iex_promise_details

1790: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1791: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Doing update...');
1792: END IF;
1793:
1794: UPDATE iex_promise_details
1795: SET PROMISE_AMOUNT = P_PROMISE_REC.PROMISE_AMOUNT,
1796: AMOUNT_DUE_REMAINING = P_PROMISE_REC.PROMISE_AMOUNT,
1797: PROMISE_DATE = P_PROMISE_REC.PROMISE_DATE,
1798: BROKEN_ON_DATE = l_broken_on_date,

Line 1836: l_SQL := 'SELECT state FROM IEX_PROMISE_DETAILS WHERE PROMISE_DETAIL_ID = :P_PROMISE_ID';

1832: X_PRORESP_REC.PROMISE_ID := P_PROMISE_REC.PROMISE_ID;
1833: X_PRORESP_REC.STATUS := l_promise_status;
1834:
1835: /* getting promise state */
1836: l_SQL := 'SELECT state FROM IEX_PROMISE_DETAILS WHERE PROMISE_DETAIL_ID = :P_PROMISE_ID';
1837:
1838: open l_cursor for l_SQL
1839: using P_PROMISE_REC.PROMISE_ID;
1840: fetch l_cursor into X_PRORESP_REC.STATE;

Line 1885: 'FROM IEX_PROMISE_DETAILS ' ||

1881: end if;
1882:
1883: /* adding account into note context */
1884: l_SQL := 'SELECT CUST_ACCOUNT_ID ' ||
1885: 'FROM IEX_PROMISE_DETAILS ' ||
1886: 'WHERE ' ||
1887: 'PROMISE_DETAIL_ID = :P_PROMISE_ID';
1888:
1889: open l_cursor for l_SQL

Line 2122: UPDATE iex_promise_details

2118: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2119: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Doing update...');
2120: END IF;
2121:
2122: UPDATE iex_promise_details
2123: SET STATUS = l_promise_status,
2124: RESOURCE_ID = P_PROMISE_REC.TAKEN_BY_RESOURCE_ID,
2125: PROMISE_MADE_BY = P_PROMISE_REC.PROMISED_BY_PARTY_PER_ID,
2126: PROGRAM_ID = G_APP_ID,

Line 2155: l_SQL := 'SELECT state FROM IEX_PROMISE_DETAILS WHERE PROMISE_DETAIL_ID = :P_PROMISE_ID';

2151: X_PRORESP_REC.PROMISE_ID := P_PROMISE_REC.PROMISE_ID;
2152: X_PRORESP_REC.STATUS := l_promise_status;
2153:
2154: /* getting promise state */
2155: l_SQL := 'SELECT state FROM IEX_PROMISE_DETAILS WHERE PROMISE_DETAIL_ID = :P_PROMISE_ID';
2156:
2157: open l_cursor for l_SQL
2158: using P_PROMISE_REC.PROMISE_ID;
2159: fetch l_cursor into X_PRORESP_REC.STATE;

Line 2203: 'FROM IEX_PROMISE_DETAILS ' ||

2199: end if;
2200:
2201: /* adding account into note context */
2202: l_SQL := 'SELECT CUST_ACCOUNT_ID ' ||
2203: 'FROM IEX_PROMISE_DETAILS ' ||
2204: 'WHERE ' ||
2205: 'PROMISE_DETAIL_ID = :P_PROMISE_ID';
2206:
2207: open l_cursor for l_SQL

Line 2496: select IEX_PROMISE_DETAILS_S.NEXTVAL from dual;

2492: l_org_id number; --Added for bug 7237026 17-Nov-2008 barathsr
2493:
2494: -- generate new promise detail
2495: CURSOR prd_genid_crs IS
2496: select IEX_PROMISE_DETAILS_S.NEXTVAL from dual;
2497:
2498: --Begin bug 7237026 17-Nov-2008 barathsr
2499: CURSOR c_org_id (p_del_id number) IS
2500: select org_id

Line 2581: 'FROM IEX_PROMISE_DETAILS ' ||

2577: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2578: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Getting promises to be canceled...');
2579: END IF;
2580: l_SQL := 'SELECT PROMISE_DETAIL_ID, PROMISE_AMOUNT, CURRENCY_CODE, STATUS, STATE, AMOUNT_DUE_REMAINING ' ||
2581: 'FROM IEX_PROMISE_DETAILS ' ||
2582: 'WHERE DELINQUENCY_ID = :P_DEL_ID AND STATUS in (''COLLECTABLE'', ''PENDING'') ' ||
2583: 'UNION ' ||
2584: 'SELECT PROMISE_DETAIL_ID, PROMISE_AMOUNT, CURRENCY_CODE, STATUS, STATE, AMOUNT_DUE_REMAINING ' ||
2585: 'FROM IEX_PROMISE_DETAILS ' ||

Line 2585: 'FROM IEX_PROMISE_DETAILS ' ||

2581: 'FROM IEX_PROMISE_DETAILS ' ||
2582: 'WHERE DELINQUENCY_ID = :P_DEL_ID AND STATUS in (''COLLECTABLE'', ''PENDING'') ' ||
2583: 'UNION ' ||
2584: 'SELECT PROMISE_DETAIL_ID, PROMISE_AMOUNT, CURRENCY_CODE, STATUS, STATE, AMOUNT_DUE_REMAINING ' ||
2585: 'FROM IEX_PROMISE_DETAILS ' ||
2586: 'WHERE CUST_ACCOUNT_ID = :P_CUST_ACCOUNT_ID AND ' ||
2587: 'DELINQUENCY_ID IS NULL AND CNSLD_INVOICE_ID IS NULL AND CONTRACT_ID IS NULL AND ' ||
2588: 'TRUNC(promise_date) = TRUNC(:P_PROMISE_DATE) AND ' ||
2589: 'STATUS in (''COLLECTABLE'', ''PENDING'')';

Line 2622: UPDATE iex_promise_details

2618:
2619: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2620: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Canceling the promise...');
2621: END IF;
2622: UPDATE iex_promise_details
2623: SET STATUS = 'CANCELLED',
2624: RESOURCE_ID = P_MASS_PROMISE_REC.TAKEN_BY_RESOURCE_ID,
2625: PROMISE_MADE_BY = P_MASS_PROMISE_REC.PROMISED_BY_PARTY_PER_ID,
2626: PROGRAM_ID = G_APP_ID,

Line 2694: INSERT INTO IEX_PROMISE_DETAILS

2690:
2691: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2692: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Inserting new promise...');
2693: END IF;
2694: INSERT INTO IEX_PROMISE_DETAILS
2695: (
2696: PROMISE_DETAIL_ID,
2697: OBJECT_VERSION_NUMBER,
2698: PROGRAM_ID,

Line 3013: from iex_promise_details

3009: l_return_status := FND_API.G_RET_STS_SUCCESS;
3010: --start
3011: Begin
3012: select delinquency_id into l_promised_delinquency_id
3013: from iex_promise_details
3014: where promise_detail_id = p_promise_id;
3015:
3016: SELECT sum(promise_amount) into l_total_already_pro_amt
3017: from iex_promise_details where delinquency_id = l_promised_delinquency_id

Line 3017: from iex_promise_details where delinquency_id = l_promised_delinquency_id

3013: from iex_promise_details
3014: where promise_detail_id = p_promise_id;
3015:
3016: SELECT sum(promise_amount) into l_total_already_pro_amt
3017: from iex_promise_details where delinquency_id = l_promised_delinquency_id
3018: and status = 'COLLECTABLE'
3019: and state = 'PROMISE';
3020: Exception
3021: WHEN NO_DATA_FOUND then