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 125: 'FROM IEX_PROMISE_DETAILS ' ||

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

Line 190: update iex_promise_details

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

Line 259: FROM IEX_PROMISE_DETAILS

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

Line 269: FROM IEX_PROMISE_DETAILS prd,

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

Line 311: 'FROM IEX_PROMISE_DETAILS ' ||

307: --begin bug#2369298 schekuri 24-Feb-2006
308: --get party_id and cust_site_use id also
309: /* getting delinquency_id, cust_account_id, l_cnsld_id and l_contract_id */
310: /*l_SQL := 'SELECT delinquency_id, cust_account_id, CNSLD_INVOICE_ID, CONTRACT_ID ' ||
311: 'FROM IEX_PROMISE_DETAILS ' ||
312: 'WHERE ' ||
313: 'PROMISE_DETAIL_ID = :P_PROMISE_ID';
314:
315: open l_cursor for l_SQL

Line 756: 'FROM IEX_PROMISE_DETAILS ' ||

752: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' = ' || P_PROMISE_REC.PROMISE_DATE);
753: END IF;
754:
755: l_SQL := 'SELECT COUNT(1) ' ||
756: 'FROM IEX_PROMISE_DETAILS ' ||
757: 'WHERE ' ||
758: 'DELINQUENCY_ID IS NULL AND CNSLD_INVOICE_ID IS NULL AND CONTRACT_ID IS NULL AND ' ||
759: 'CUST_ACCOUNT_ID IS NOT NULL AND CUST_ACCOUNT_ID = :P_CUST_ACCOUNT_ID AND ' ||
760: 'PROMISE_DATE = :P_PROMISE_DATE AND ' ||

Line 822: 'FROM IEX_PROMISE_DETAILS ' ||

818: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' = ' || P_PROMISE_REC.PROMISE_DATE);
819: END IF;
820:
821: l_SQL := 'SELECT COUNT(1) ' ||
822: 'FROM IEX_PROMISE_DETAILS ' ||
823: 'WHERE ' ||
824: 'CNSLD_INVOICE_ID IS NULL AND CONTRACT_ID IS NULL AND ' ||
825: 'CUST_ACCOUNT_ID IS NOT NULL AND CUST_ACCOUNT_ID = :P_CUST_ACCOUNT_ID AND ' ||
826: 'DELINQUENCY_ID IS NOT NULL AND DELINQUENCY_ID = :P_DELINQUENCY_ID AND ' ||

Line 901: 'FROM IEX_PROMISE_DETAILS ' ||

897: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' = ' || P_PROMISE_REC.PROMISE_DATE);
898: END IF;
899:
900: l_SQL := 'SELECT COUNT(1) ' ||
901: 'FROM IEX_PROMISE_DETAILS ' ||
902: 'WHERE ' ||
903: 'DELINQUENCY_ID IS NULL AND CONTRACT_ID IS NULL AND ' ||
904: 'CUST_ACCOUNT_ID IS NOT NULL AND CUST_ACCOUNT_ID = :P_CUST_ACCOUNT_ID AND ' ||
905: 'CNSLD_INVOICE_ID IS NOT NULL AND CNSLD_INVOICE_ID = :P_CNSLD_INVOICE_ID AND ' ||

Line 980: 'FROM IEX_PROMISE_DETAILS ' ||

976: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' = ' || P_PROMISE_REC.PROMISE_DATE);
977: END IF;
978:
979: l_SQL := 'SELECT COUNT(1) ' ||
980: 'FROM IEX_PROMISE_DETAILS ' ||
981: 'WHERE ' ||
982: 'DELINQUENCY_ID IS NULL AND CNSLD_INVOICE_ID IS NULL AND ' ||
983: 'CUST_ACCOUNT_ID IS NOT NULL AND CUST_ACCOUNT_ID = :P_CUST_ACCOUNT_ID AND ' ||
984: 'CONTRACT_ID IS NOT NULL AND CONTRACT_ID = :P_CONTRACT_ID AND ' ||

Line 1079: select IEX_PROMISE_DETAILS_S.NEXTVAL from dual;

1075:
1076:
1077: -- generate new promise detail
1078: CURSOR prd_genid_crs IS
1079: select IEX_PROMISE_DETAILS_S.NEXTVAL from dual;
1080: --Begin bug 7237026 17-Nov-2208 barathsr
1081: CURSOR c_org_id (p_del_id number) IS
1082: select org_id
1083: from iex_delinquencies_all

Line 1161: INSERT INTO IEX_PROMISE_DETAILS

1157: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1158: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Doing insert...');
1159: END IF;
1160:
1161: INSERT INTO IEX_PROMISE_DETAILS
1162: (
1163: PROMISE_DETAIL_ID,
1164: OBJECT_VERSION_NUMBER,
1165: PROGRAM_ID,

Line 1415: -- 'FROM IEX_PROMISE_DETAILS ' ||

1411: l_str_cnsld2 varchar2(100); -- := ' AND CNSLD_INVOICE_ID is null';
1412: l_str_cnt1 varchar2(100); -- := ' AND CONTRACT_ID = ';
1413: l_str_cnt2 varchar2(100); -- := ' AND CONTRACT_ID is null';
1414: l_str_select varchar2(1000); -- := 'SELECT COUNT(1) ' ||
1415: -- 'FROM IEX_PROMISE_DETAILS ' ||
1416: -- 'WHERE ';
1417: l_str_cond varchar2(1000); -- := ' AND ' ||
1418: -- 'promise_detail_id <> :P_PROMISE_ID AND ' ||
1419: -- 'PROMISE_DATE = :P_PROMISE_DATE AND ' ||

Line 1431: 'FROM IEX_PROMISE_DETAILS ' ||

1427: l_str_cnsld2 := ' AND CNSLD_INVOICE_ID is null';
1428: l_str_cnt1 := ' AND CONTRACT_ID = ';
1429: l_str_cnt2 := ' AND CONTRACT_ID is null';
1430: l_str_select := 'SELECT COUNT(1) ' ||
1431: 'FROM IEX_PROMISE_DETAILS ' ||
1432: 'WHERE ';
1433: l_str_cond := ' AND ' ||
1434: 'promise_detail_id <> :P_PROMISE_ID AND ' ||
1435: 'PROMISE_DATE = :P_PROMISE_DATE AND ' ||

Line 1493: 'FROM IEX_PROMISE_DETAILS ' ||

1489: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1490: iex_debug_pub.LogMessage(G_PKG_NAME || '.' ||l_procedure || ': Validating db data');
1491: END IF;
1492: l_SQL := 'SELECT CUST_ACCOUNT_ID, DELINQUENCY_ID, CNSLD_INVOICE_ID, CONTRACT_ID, STATUS, STATE, PROMISE_AMOUNT, AMOUNT_DUE_REMAINING ' ||
1493: 'FROM IEX_PROMISE_DETAILS ' ||
1494: 'WHERE ' ||
1495: 'PROMISE_DETAIL_ID = :P_PROMISE_ID';
1496:
1497: open l_cursor for l_SQL

Line 1607: 'FROM IEX_PROMISE_DETAILS ' ||

1603: l_SQL := l_str_select || l_where_clause || l_str_cond;
1604:
1605: /* fix bind varviolation error
1606: l_SQL := 'SELECT COUNT(1) ' ||
1607: 'FROM IEX_PROMISE_DETAILS ' ||
1608: 'WHERE ' || l_where_clause || ' AND ' ||
1609: 'promise_detail_id <> :P_PROMISE_ID AND ' ||
1610: 'PROMISE_DATE = :P_PROMISE_DATE AND ' ||
1611: 'STATUS in (''COLLECTABLE'', ''PENDING'')';

Line 1755: UPDATE iex_promise_details

1751: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1752: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Doing update...');
1753: END IF;
1754:
1755: UPDATE iex_promise_details
1756: SET PROMISE_AMOUNT = P_PROMISE_REC.PROMISE_AMOUNT,
1757: AMOUNT_DUE_REMAINING = P_PROMISE_REC.PROMISE_AMOUNT,
1758: PROMISE_DATE = P_PROMISE_REC.PROMISE_DATE,
1759: BROKEN_ON_DATE = l_broken_on_date,

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

1793: X_PRORESP_REC.PROMISE_ID := P_PROMISE_REC.PROMISE_ID;
1794: X_PRORESP_REC.STATUS := l_promise_status;
1795:
1796: /* getting promise state */
1797: l_SQL := 'SELECT state FROM IEX_PROMISE_DETAILS WHERE PROMISE_DETAIL_ID = :P_PROMISE_ID';
1798:
1799: open l_cursor for l_SQL
1800: using P_PROMISE_REC.PROMISE_ID;
1801: fetch l_cursor into X_PRORESP_REC.STATE;

Line 1823: 'FROM IEX_PROMISE_DETAILS ' ||

1819: end if;
1820:
1821: /* adding account into note context */
1822: l_SQL := 'SELECT CUST_ACCOUNT_ID ' ||
1823: 'FROM IEX_PROMISE_DETAILS ' ||
1824: 'WHERE ' ||
1825: 'PROMISE_DETAIL_ID = :P_PROMISE_ID';
1826:
1827: open l_cursor for l_SQL

Line 2059: UPDATE iex_promise_details

2055: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2056: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Doing update...');
2057: END IF;
2058:
2059: UPDATE iex_promise_details
2060: SET STATUS = l_promise_status,
2061: RESOURCE_ID = P_PROMISE_REC.TAKEN_BY_RESOURCE_ID,
2062: PROMISE_MADE_BY = P_PROMISE_REC.PROMISED_BY_PARTY_PER_ID,
2063: PROGRAM_ID = G_APP_ID,

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

2072: X_PRORESP_REC.PROMISE_ID := P_PROMISE_REC.PROMISE_ID;
2073: X_PRORESP_REC.STATUS := l_promise_status;
2074:
2075: /* getting promise state */
2076: l_SQL := 'SELECT state FROM IEX_PROMISE_DETAILS WHERE PROMISE_DETAIL_ID = :P_PROMISE_ID';
2077:
2078: open l_cursor for l_SQL
2079: using P_PROMISE_REC.PROMISE_ID;
2080: fetch l_cursor into X_PRORESP_REC.STATE;

Line 2102: 'FROM IEX_PROMISE_DETAILS ' ||

2098: end if;
2099:
2100: /* adding account into note context */
2101: l_SQL := 'SELECT CUST_ACCOUNT_ID ' ||
2102: 'FROM IEX_PROMISE_DETAILS ' ||
2103: 'WHERE ' ||
2104: 'PROMISE_DETAIL_ID = :P_PROMISE_ID';
2105:
2106: open l_cursor for l_SQL

Line 2395: select IEX_PROMISE_DETAILS_S.NEXTVAL from dual;

2391: l_org_id number; --Added for bug 7237026 17-Nov-2008 barathsr
2392:
2393: -- generate new promise detail
2394: CURSOR prd_genid_crs IS
2395: select IEX_PROMISE_DETAILS_S.NEXTVAL from dual;
2396:
2397: --Begin bug 7237026 17-Nov-2008 barathsr
2398: CURSOR c_org_id (p_del_id number) IS
2399: select org_id

Line 2480: 'FROM IEX_PROMISE_DETAILS ' ||

2476: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2477: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Getting promises to be canceled...');
2478: END IF;
2479: l_SQL := 'SELECT PROMISE_DETAIL_ID, PROMISE_AMOUNT, CURRENCY_CODE, STATUS, STATE, AMOUNT_DUE_REMAINING ' ||
2480: 'FROM IEX_PROMISE_DETAILS ' ||
2481: 'WHERE DELINQUENCY_ID = :P_DEL_ID AND STATUS in (''COLLECTABLE'', ''PENDING'') ' ||
2482: 'UNION ' ||
2483: 'SELECT PROMISE_DETAIL_ID, PROMISE_AMOUNT, CURRENCY_CODE, STATUS, STATE, AMOUNT_DUE_REMAINING ' ||
2484: 'FROM IEX_PROMISE_DETAILS ' ||

Line 2484: 'FROM IEX_PROMISE_DETAILS ' ||

2480: 'FROM IEX_PROMISE_DETAILS ' ||
2481: 'WHERE DELINQUENCY_ID = :P_DEL_ID AND STATUS in (''COLLECTABLE'', ''PENDING'') ' ||
2482: 'UNION ' ||
2483: 'SELECT PROMISE_DETAIL_ID, PROMISE_AMOUNT, CURRENCY_CODE, STATUS, STATE, AMOUNT_DUE_REMAINING ' ||
2484: 'FROM IEX_PROMISE_DETAILS ' ||
2485: 'WHERE CUST_ACCOUNT_ID = :P_CUST_ACCOUNT_ID AND ' ||
2486: 'DELINQUENCY_ID IS NULL AND CNSLD_INVOICE_ID IS NULL AND CONTRACT_ID IS NULL AND ' ||
2487: 'TRUNC(promise_date) = TRUNC(:P_PROMISE_DATE) AND ' ||
2488: 'STATUS in (''COLLECTABLE'', ''PENDING'')';

Line 2521: UPDATE iex_promise_details

2517:
2518: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2519: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Canceling the promise...');
2520: END IF;
2521: UPDATE iex_promise_details
2522: SET STATUS = 'CANCELLED',
2523: RESOURCE_ID = P_MASS_PROMISE_REC.TAKEN_BY_RESOURCE_ID,
2524: PROMISE_MADE_BY = P_MASS_PROMISE_REC.PROMISED_BY_PARTY_PER_ID,
2525: PROGRAM_ID = G_APP_ID,

Line 2568: INSERT INTO IEX_PROMISE_DETAILS

2564:
2565: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2566: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Inserting new promise...');
2567: END IF;
2568: INSERT INTO IEX_PROMISE_DETAILS
2569: (
2570: PROMISE_DETAIL_ID,
2571: OBJECT_VERSION_NUMBER,
2572: PROGRAM_ID,