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_MERGE_PVT dependencies on IEX_DELINQUENCIES_ALL

Line 1143: -- Changed cusrsor to join with ar_payment_schedules_all ps,iex_delinquencies_all del to fix 14492050 Snuthala

1139: NUM_COL1_ORIG_LIST CUST_ACCOUNT_ID_LIST_TYPE;
1140: NUM_COL1_NEW_LIST CUST_ACCOUNT_ID_LIST_TYPE;
1141:
1142: l_profile_val VARCHAR2(30);
1143: -- Changed cusrsor to join with ar_payment_schedules_all ps,iex_delinquencies_all del to fix 14492050 Snuthala
1144: CURSOR merged_records IS
1145: SELECT distinct m.CUSTOMER_MERGE_HEADER_ID
1146: ,yt.PROMISE_DETAIL_ID
1147: ,yt.CUST_ACCOUNT_ID

Line 1148: FROM IEX_PROMISE_DETAILS yt, ra_customer_merges m,ar_payment_schedules_all ps,iex_delinquencies_all del

1144: CURSOR merged_records IS
1145: SELECT distinct m.CUSTOMER_MERGE_HEADER_ID
1146: ,yt.PROMISE_DETAIL_ID
1147: ,yt.CUST_ACCOUNT_ID
1148: FROM IEX_PROMISE_DETAILS yt, ra_customer_merges m,ar_payment_schedules_all ps,iex_delinquencies_all del
1149: WHERE yt.CUST_ACCOUNT_ID = m.DUPLICATE_ID AND
1150: m.process_flag = 'N' AND
1151: m.request_id = req_id AND
1152: m.set_number = set_num AND

Line 1257: IEX_DELINQUENCIES_ALL.DELINQUENCY_ID%TYPE

1253: INDEX BY BINARY_INTEGER;
1254: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
1255:
1256: TYPE DELINQUENCY_ID_LIST_TYPE IS TABLE OF
1257: IEX_DELINQUENCIES_ALL.DELINQUENCY_ID%TYPE
1258: INDEX BY BINARY_INTEGER;
1259: PRIMARY_KEY_ID_LIST DELINQUENCY_ID_LIST_TYPE;
1260:
1261: TYPE CUST_ACCOUNT_ID_LIST_TYPE IS TABLE OF

Line 1262: IEX_DELINQUENCIES_ALL.CUST_ACCOUNT_ID%TYPE

1258: INDEX BY BINARY_INTEGER;
1259: PRIMARY_KEY_ID_LIST DELINQUENCY_ID_LIST_TYPE;
1260:
1261: TYPE CUST_ACCOUNT_ID_LIST_TYPE IS TABLE OF
1262: IEX_DELINQUENCIES_ALL.CUST_ACCOUNT_ID%TYPE
1263: INDEX BY BINARY_INTEGER;
1264: TYPE CUSTOMER_SITE_USE_ID_LIST_TYPE IS TABLE OF
1265: IEX_DELINQUENCIES_ALL.CUSTOMER_SITE_USE_ID%TYPE
1266: INDEX BY BINARY_INTEGER;

Line 1265: IEX_DELINQUENCIES_ALL.CUSTOMER_SITE_USE_ID%TYPE

1261: TYPE CUST_ACCOUNT_ID_LIST_TYPE IS TABLE OF
1262: IEX_DELINQUENCIES_ALL.CUST_ACCOUNT_ID%TYPE
1263: INDEX BY BINARY_INTEGER;
1264: TYPE CUSTOMER_SITE_USE_ID_LIST_TYPE IS TABLE OF
1265: IEX_DELINQUENCIES_ALL.CUSTOMER_SITE_USE_ID%TYPE
1266: INDEX BY BINARY_INTEGER;
1267: TYPE PARTY_ID_LIST_TYPE IS TABLE OF
1268: IEX_DELINQUENCIES_ALL.PARTY_CUST_ID%TYPE
1269: INDEX BY BINARY_INTEGER;

Line 1268: IEX_DELINQUENCIES_ALL.PARTY_CUST_ID%TYPE

1264: TYPE CUSTOMER_SITE_USE_ID_LIST_TYPE IS TABLE OF
1265: IEX_DELINQUENCIES_ALL.CUSTOMER_SITE_USE_ID%TYPE
1266: INDEX BY BINARY_INTEGER;
1267: TYPE PARTY_ID_LIST_TYPE IS TABLE OF
1268: IEX_DELINQUENCIES_ALL.PARTY_CUST_ID%TYPE
1269: INDEX BY BINARY_INTEGER;
1270:
1271: NUM_COL1_ORIG_LIST CUST_ACCOUNT_ID_LIST_TYPE;
1272: NUM_COL1_NEW_LIST CUST_ACCOUNT_ID_LIST_TYPE;

Line 1305: FROM IEX_DELINQUENCIES_ALL yt, ra_customer_merges m, hz_cust_accounts c, ar_payment_schedules_all ps

1301: SELECT distinct m.CUSTOMER_MERGE_HEADER_ID
1302: ,yt.DELINQUENCY_ID
1303: ,yt.CUST_ACCOUNT_ID
1304: ,c.party_id
1305: FROM IEX_DELINQUENCIES_ALL yt, ra_customer_merges m, hz_cust_accounts c, ar_payment_schedules_all ps
1306: WHERE yt.CUST_ACCOUNT_ID = m.DUPLICATE_ID AND
1307: m.process_flag = 'N' AND
1308: m.request_id = req_id AND
1309: m.set_number = set_num and

Line 1318: FROM IEX_DELINQUENCIES_ALL yt, ra_customer_merges m,ar_payment_schedules_all ar

1314: CURSOR merged_records1 IS
1315: SELECT distinct m.CUSTOMER_MERGE_HEADER_ID
1316: ,yt.DELINQUENCY_ID
1317: ,yt.CUSTOMER_SITE_USE_ID
1318: FROM IEX_DELINQUENCIES_ALL yt, ra_customer_merges m,ar_payment_schedules_all ar
1319: WHERE yt.CUSTOMER_SITE_USE_ID = m.DUPLICATE_SITE_ID AND
1320: m.process_flag = 'N' AND
1321: m.request_id = req_id AND
1322: m.set_number = set_num AND

Line 1405: 'IEX_DELINQUENCIES_ALL',

1401: LAST_UPDATE_DATE,
1402: LAST_UPDATED_BY)
1403: VALUES
1404: (HZ_CUSTOMER_MERGE_LOG_s.nextval,
1405: 'IEX_DELINQUENCIES_ALL',
1406: MERGE_HEADER_ID_LIST(I),
1407: PRIMARY_KEY_ID_LIST(I),
1408: NUM_COL1_ORIG_LIST(I),
1409: NUM_COL1_NEW_LIST(I),

Line 1424: IEX_DEBUG_PUB.logMessage('Updating IEX_DELINQUENCIES_ALL...');

1420: END IF;
1421:
1422: END IF;
1423: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1424: IEX_DEBUG_PUB.logMessage('Updating IEX_DELINQUENCIES_ALL...');
1425: END IF;
1426:
1427: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1428: UPDATE IEX_DELINQUENCIES_ALL yt SET

Line 1428: UPDATE IEX_DELINQUENCIES_ALL yt SET

1424: IEX_DEBUG_PUB.logMessage('Updating IEX_DELINQUENCIES_ALL...');
1425: END IF;
1426:
1427: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1428: UPDATE IEX_DELINQUENCIES_ALL yt SET
1429: CUST_ACCOUNT_ID = NUM_COL1_NEW_LIST(I)
1430: , PARTY_CUST_ID = PARTY_LIST(I)
1431: , LAST_UPDATE_DATE = SYSDATE
1432: , last_updated_by = arp_standard.profile.user_id

Line 1518: 'IEX_DELINQUENCIES_ALL',

1514: LAST_UPDATE_DATE,
1515: LAST_UPDATED_BY)
1516: VALUES
1517: (HZ_CUSTOMER_MERGE_LOG_s.nextval,
1518: 'IEX_DELINQUENCIES_ALL',
1519: MERGE_HEADER_ID_LIST(I),
1520: PRIMARY_KEY_ID_LIST(I),
1521: NUM_COL2_ORIG_LIST(I),
1522: NUM_COL2_NEW_LIST(I),

Line 1538: IEX_DEBUG_PUB.logMessage('Updating IEX_DELINQUENCIES_ALL...');

1534:
1535: END IF;
1536:
1537: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1538: IEX_DEBUG_PUB.logMessage('Updating IEX_DELINQUENCIES_ALL...');
1539: END IF;
1540:
1541: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1542: UPDATE IEX_DELINQUENCIES_ALL yt SET

Line 1542: UPDATE IEX_DELINQUENCIES_ALL yt SET

1538: IEX_DEBUG_PUB.logMessage('Updating IEX_DELINQUENCIES_ALL...');
1539: END IF;
1540:
1541: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1542: UPDATE IEX_DELINQUENCIES_ALL yt SET
1543: CUSTOMER_SITE_USE_ID = NUM_COL2_NEW_LIST(I)
1544: , LAST_UPDATE_DATE = SYSDATE
1545: , last_updated_by = arp_standard.profile.user_id
1546: , last_update_login = arp_standard.profile.last_update_login

Line 1635: FROM IEX_DELINQUENCIES_ALL

1631:
1632: /* Check if the delinquency is being used some where. If so, do not allow Merge */
1633: /*
1634: SELECT count(1) INTO l_num_records
1635: FROM IEX_DELINQUENCIES_ALL
1636: WHERE delinquency_id = p_from_id;
1637: IF l_num_records >= 1 THEN
1638: x_return_status := FND_API.G_RET_STS_ERROR;
1639: FND_MESSAGE.SET_NAME('JTF','JTF_MERGE_NOTALLOWED');

Line 1668: UPDATE IEX_DELINQUENCIES_ALL

1664: /* begin raverma 07242001
1665: */
1666: -- do we really care if something is being "merged" or transferred?? i think not
1667: -- lets just update the table to reflect the new party_id
1668: UPDATE IEX_DELINQUENCIES_ALL
1669: SET party_cust_id = p_To_FK_id,
1670: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1671: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1672: last_update_login = HZ_UTILITY_V2PUB.last_update_login,

Line 1844: FROM IEX_DELINQUENCIES_ALL

1840: IF p_from_FK_id <> p_to_FK_id THEN
1841: BEGIN
1842: SELECT party_cust_id
1843: INTO v_merged_to_id
1844: FROM IEX_DELINQUENCIES_ALL
1845: WHERE party_cust_id = p_To_FK_id
1846: --and category = p_parent_entity_name
1847: --and resource_name = (select resource_name
1848: -- from JTF_RS_RESOURCE_EXTNS

Line 1859: UPDATE IEX_DELINQUENCIES_ALL

1855: END IF;
1856:
1857: IF v_merged_to_id IS NULL THEN
1858: -- Duplicate Does Not exist. Therefore transfer
1859: UPDATE IEX_DELINQUENCIES_ALL
1860: SET party_cust_id = p_To_FK_id,
1861: last_update_date = hz_utility_pub.last_update_date,
1862: last_updated_by = hz_utility_pub.user_id,
1863: last_update_login = hz_utility_pub.last_update_login,

Line 1876: UPDATE IEX_DELINQUENCIES_ALL

1872:
1873: IF v_merged_to_id IS NOT NULL THEN
1874: /* Duplicate Exists. Therefore Merge */
1875: /*
1876: UPDATE IEX_DELINQUENCIES_ALL
1877: SET STATUS = 'CLOSED',
1878: last_update_date = hz_utility_pub.last_update_date,
1879: last_updated_by = hz_utility_pub.user_id,
1880: last_update_login = hz_utility_pub.last_update_login,