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 1140: IEX_DELINQUENCIES_ALL.DELINQUENCY_ID%TYPE

1136: INDEX BY BINARY_INTEGER;
1137: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
1138:
1139: TYPE DELINQUENCY_ID_LIST_TYPE IS TABLE OF
1140: IEX_DELINQUENCIES_ALL.DELINQUENCY_ID%TYPE
1141: INDEX BY BINARY_INTEGER;
1142: PRIMARY_KEY_ID_LIST DELINQUENCY_ID_LIST_TYPE;
1143:
1144: TYPE CUST_ACCOUNT_ID_LIST_TYPE IS TABLE OF

Line 1145: IEX_DELINQUENCIES_ALL.CUST_ACCOUNT_ID%TYPE

1141: INDEX BY BINARY_INTEGER;
1142: PRIMARY_KEY_ID_LIST DELINQUENCY_ID_LIST_TYPE;
1143:
1144: TYPE CUST_ACCOUNT_ID_LIST_TYPE IS TABLE OF
1145: IEX_DELINQUENCIES_ALL.CUST_ACCOUNT_ID%TYPE
1146: INDEX BY BINARY_INTEGER;
1147: TYPE CUSTOMER_SITE_USE_ID_LIST_TYPE IS TABLE OF
1148: IEX_DELINQUENCIES_ALL.CUSTOMER_SITE_USE_ID%TYPE
1149: INDEX BY BINARY_INTEGER;

Line 1148: IEX_DELINQUENCIES_ALL.CUSTOMER_SITE_USE_ID%TYPE

1144: TYPE CUST_ACCOUNT_ID_LIST_TYPE IS TABLE OF
1145: IEX_DELINQUENCIES_ALL.CUST_ACCOUNT_ID%TYPE
1146: INDEX BY BINARY_INTEGER;
1147: TYPE CUSTOMER_SITE_USE_ID_LIST_TYPE IS TABLE OF
1148: IEX_DELINQUENCIES_ALL.CUSTOMER_SITE_USE_ID%TYPE
1149: INDEX BY BINARY_INTEGER;
1150: TYPE PARTY_ID_LIST_TYPE IS TABLE OF
1151: IEX_DELINQUENCIES_ALL.PARTY_CUST_ID%TYPE
1152: INDEX BY BINARY_INTEGER;

Line 1151: IEX_DELINQUENCIES_ALL.PARTY_CUST_ID%TYPE

1147: TYPE CUSTOMER_SITE_USE_ID_LIST_TYPE IS TABLE OF
1148: IEX_DELINQUENCIES_ALL.CUSTOMER_SITE_USE_ID%TYPE
1149: INDEX BY BINARY_INTEGER;
1150: TYPE PARTY_ID_LIST_TYPE IS TABLE OF
1151: IEX_DELINQUENCIES_ALL.PARTY_CUST_ID%TYPE
1152: INDEX BY BINARY_INTEGER;
1153:
1154: NUM_COL1_ORIG_LIST CUST_ACCOUNT_ID_LIST_TYPE;
1155: NUM_COL1_NEW_LIST CUST_ACCOUNT_ID_LIST_TYPE;

Line 1187: FROM IEX_DELINQUENCIES_ALL yt, ra_customer_merges m, hz_cust_accounts c

1183: SELECT distinct m.CUSTOMER_MERGE_HEADER_ID
1184: ,yt.DELINQUENCY_ID
1185: ,yt.CUST_ACCOUNT_ID
1186: ,c.party_id
1187: FROM IEX_DELINQUENCIES_ALL yt, ra_customer_merges m, hz_cust_accounts c
1188: WHERE yt.CUST_ACCOUNT_ID = m.DUPLICATE_ID AND
1189: m.process_flag = 'N' AND
1190: m.request_id = req_id AND
1191: m.set_number = set_num and

Line 1198: FROM IEX_DELINQUENCIES_ALL yt, ra_customer_merges m

1194: CURSOR merged_records1 IS
1195: SELECT distinct CUSTOMER_MERGE_HEADER_ID
1196: ,DELINQUENCY_ID
1197: ,CUSTOMER_SITE_USE_ID
1198: FROM IEX_DELINQUENCIES_ALL yt, ra_customer_merges m
1199: WHERE yt.CUSTOMER_SITE_USE_ID = m.DUPLICATE_SITE_ID AND
1200: m.process_flag = 'N' AND
1201: m.request_id = req_id AND
1202: m.set_number = set_num;

Line 1283: 'IEX_DELINQUENCIES_ALL',

1279: LAST_UPDATE_DATE,
1280: LAST_UPDATED_BY)
1281: VALUES
1282: (HZ_CUSTOMER_MERGE_LOG_s.nextval,
1283: 'IEX_DELINQUENCIES_ALL',
1284: MERGE_HEADER_ID_LIST(I),
1285: PRIMARY_KEY_ID_LIST(I),
1286: NUM_COL1_ORIG_LIST(I),
1287: NUM_COL1_NEW_LIST(I),

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

1298: END IF;
1299:
1300: END IF;
1301: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1302: IEX_DEBUG_PUB.logMessage('Updating IEX_DELINQUENCIES_ALL...');
1303: END IF;
1304:
1305: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1306: UPDATE IEX_DELINQUENCIES_ALL yt SET

Line 1306: UPDATE IEX_DELINQUENCIES_ALL yt SET

1302: IEX_DEBUG_PUB.logMessage('Updating IEX_DELINQUENCIES_ALL...');
1303: END IF;
1304:
1305: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1306: UPDATE IEX_DELINQUENCIES_ALL yt SET
1307: CUST_ACCOUNT_ID = NUM_COL1_NEW_LIST(I)
1308: , PARTY_CUST_ID = PARTY_LIST(I)
1309: , LAST_UPDATE_DATE = SYSDATE
1310: , last_updated_by = arp_standard.profile.user_id

Line 1396: 'IEX_DELINQUENCIES_ALL',

1392: LAST_UPDATE_DATE,
1393: LAST_UPDATED_BY)
1394: VALUES
1395: (HZ_CUSTOMER_MERGE_LOG_s.nextval,
1396: 'IEX_DELINQUENCIES_ALL',
1397: MERGE_HEADER_ID_LIST(I),
1398: PRIMARY_KEY_ID_LIST(I),
1399: NUM_COL2_ORIG_LIST(I),
1400: NUM_COL2_NEW_LIST(I),

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

1412:
1413: END IF;
1414:
1415: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1416: IEX_DEBUG_PUB.logMessage('Updating IEX_DELINQUENCIES_ALL...');
1417: END IF;
1418:
1419: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1420: UPDATE IEX_DELINQUENCIES_ALL yt SET

Line 1420: UPDATE IEX_DELINQUENCIES_ALL yt SET

1416: IEX_DEBUG_PUB.logMessage('Updating IEX_DELINQUENCIES_ALL...');
1417: END IF;
1418:
1419: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1420: UPDATE IEX_DELINQUENCIES_ALL yt SET
1421: CUSTOMER_SITE_USE_ID = NUM_COL2_NEW_LIST(I)
1422: , LAST_UPDATE_DATE = SYSDATE
1423: , last_updated_by = arp_standard.profile.user_id
1424: , last_update_login = arp_standard.profile.last_update_login

Line 1513: FROM IEX_DELINQUENCIES_ALL

1509:
1510: /* Check if the delinquency is being used some where. If so, do not allow Merge */
1511: /*
1512: SELECT count(1) INTO l_num_records
1513: FROM IEX_DELINQUENCIES_ALL
1514: WHERE delinquency_id = p_from_id;
1515: IF l_num_records >= 1 THEN
1516: x_return_status := FND_API.G_RET_STS_ERROR;
1517: FND_MESSAGE.SET_NAME('JTF','JTF_MERGE_NOTALLOWED');

Line 1546: UPDATE IEX_DELINQUENCIES_ALL

1542: /* begin raverma 07242001
1543: */
1544: -- do we really care if something is being "merged" or transferred?? i think not
1545: -- lets just update the table to reflect the new party_id
1546: UPDATE IEX_DELINQUENCIES_ALL
1547: SET party_cust_id = p_To_FK_id,
1548: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1549: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1550: last_update_login = HZ_UTILITY_V2PUB.last_update_login,

Line 1722: FROM IEX_DELINQUENCIES_ALL

1718: IF p_from_FK_id <> p_to_FK_id THEN
1719: BEGIN
1720: SELECT party_cust_id
1721: INTO v_merged_to_id
1722: FROM IEX_DELINQUENCIES_ALL
1723: WHERE party_cust_id = p_To_FK_id
1724: --and category = p_parent_entity_name
1725: --and resource_name = (select resource_name
1726: -- from JTF_RS_RESOURCE_EXTNS

Line 1737: UPDATE IEX_DELINQUENCIES_ALL

1733: END IF;
1734:
1735: IF v_merged_to_id IS NULL THEN
1736: -- Duplicate Does Not exist. Therefore transfer
1737: UPDATE IEX_DELINQUENCIES_ALL
1738: SET party_cust_id = p_To_FK_id,
1739: last_update_date = hz_utility_pub.last_update_date,
1740: last_updated_by = hz_utility_pub.user_id,
1741: last_update_login = hz_utility_pub.last_update_login,

Line 1754: UPDATE IEX_DELINQUENCIES_ALL

1750:
1751: IF v_merged_to_id IS NOT NULL THEN
1752: /* Duplicate Exists. Therefore Merge */
1753: /*
1754: UPDATE IEX_DELINQUENCIES_ALL
1755: SET STATUS = 'CLOSED',
1756: last_update_date = hz_utility_pub.last_update_date,
1757: last_updated_by = hz_utility_pub.user_id,
1758: last_update_login = hz_utility_pub.last_update_login,