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.LNS_MERGE_PKG dependencies on HZ_CUSTOMER_MERGE_LOG

Line 352: LogMessage(FND_LOG.LEVEL_STATEMENT,'Inserting into HZ_CUSTOMER_MERGE_LOG...');

348: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
349: END LOOP;
350:
351: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
352: LogMessage(FND_LOG.LEVEL_STATEMENT,'Inserting into HZ_CUSTOMER_MERGE_LOG...');
353:
354: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
355: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
356: MERGE_LOG_ID,

Line 355: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

351: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
352: LogMessage(FND_LOG.LEVEL_STATEMENT,'Inserting into HZ_CUSTOMER_MERGE_LOG...');
353:
354: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
355: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
356: MERGE_LOG_ID,
357: TABLE_NAME,
358: MERGE_HEADER_ID,
359: PRIMARY_KEY_ID1,

Line 370: (HZ_CUSTOMER_MERGE_LOG_s.nextval,

366: LAST_UPDATE_LOGIN,
367: LAST_UPDATE_DATE,
368: LAST_UPDATED_BY)
369: VALUES
370: (HZ_CUSTOMER_MERGE_LOG_s.nextval,
371: 'LNS_LOAN_HEADERS',
372: MERGE_HEADER_ID_LIST(I),
373: PRIMARY_KEY_ID1_LIST(I),
374: NUM_COL1_ORIG_LIST(I),

Line 446: LogMessage(FND_LOG.LEVEL_STATEMENT,'Inserting CustActSites into HZ_CUSTOMER_MERGE_LOG...');

442: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL2_ORIG_LIST(I));
443: END LOOP;
444:
445: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
446: LogMessage(FND_LOG.LEVEL_STATEMENT,'Inserting CustActSites into HZ_CUSTOMER_MERGE_LOG...');
447:
448: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
449: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
450: MERGE_LOG_ID,

Line 449: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

445: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
446: LogMessage(FND_LOG.LEVEL_STATEMENT,'Inserting CustActSites into HZ_CUSTOMER_MERGE_LOG...');
447:
448: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
449: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
450: MERGE_LOG_ID,
451: TABLE_NAME,
452: MERGE_HEADER_ID,
453: PRIMARY_KEY_ID1,

Line 464: (HZ_CUSTOMER_MERGE_LOG_s.nextval,

460: LAST_UPDATE_LOGIN,
461: LAST_UPDATE_DATE,
462: LAST_UPDATED_BY)
463: VALUES
464: (HZ_CUSTOMER_MERGE_LOG_s.nextval,
465: 'LNS_LOAN_HEADERS',
466: MERGE_HEADER_ID_LIST(I),
467: PRIMARY_KEY_ID1_LIST(I),
468: NUM_COL2_ORIG_LIST(I),

Line 617: LogMessage(FND_LOG.LEVEL_STATEMENT,'Inserting into HZ_CUSTOMER_MERGE_LOG...');

613: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
614: END LOOP;
615:
616: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
617: LogMessage(FND_LOG.LEVEL_STATEMENT,'Inserting into HZ_CUSTOMER_MERGE_LOG...');
618:
619: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
620: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
621: MERGE_LOG_ID,

Line 620: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

616: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
617: LogMessage(FND_LOG.LEVEL_STATEMENT,'Inserting into HZ_CUSTOMER_MERGE_LOG...');
618:
619: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
620: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
621: MERGE_LOG_ID,
622: TABLE_NAME,
623: MERGE_HEADER_ID,
624: PRIMARY_KEY_ID1,

Line 635: HZ_CUSTOMER_MERGE_LOG_s.nextval,

631: LAST_UPDATE_LOGIN,
632: LAST_UPDATE_DATE,
633: LAST_UPDATED_BY
634: ) VALUES (
635: HZ_CUSTOMER_MERGE_LOG_s.nextval,
636: 'LNS_PARTICIPANTS',
637: MERGE_HEADER_ID_LIST(I),
638: PRIMARY_KEY_ID1_LIST(I),
639: NUM_COL1_ORIG_LIST(I),

Line 712: LogMessage(FND_LOG.LEVEL_STATEMENT,'Inserting CustActSites into HZ_CUSTOMER_MERGE_LOG...');

708: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL2_ORIG_LIST(I));
709: END LOOP;
710:
711: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
712: LogMessage(FND_LOG.LEVEL_STATEMENT,'Inserting CustActSites into HZ_CUSTOMER_MERGE_LOG...');
713:
714: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
715: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
716: MERGE_LOG_ID,

Line 715: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

711: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
712: LogMessage(FND_LOG.LEVEL_STATEMENT,'Inserting CustActSites into HZ_CUSTOMER_MERGE_LOG...');
713:
714: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
715: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
716: MERGE_LOG_ID,
717: TABLE_NAME,
718: MERGE_HEADER_ID,
719: PRIMARY_KEY_ID1,

Line 730: (HZ_CUSTOMER_MERGE_LOG_s.nextval,

726: LAST_UPDATE_LOGIN,
727: LAST_UPDATE_DATE,
728: LAST_UPDATED_BY)
729: VALUES
730: (HZ_CUSTOMER_MERGE_LOG_s.nextval,
731: 'LNS_PARTICIPANTS',
732: MERGE_HEADER_ID_LIST(I),
733: PRIMARY_KEY_ID1_LIST(I),
734: NUM_COL2_ORIG_LIST(I),