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_STRATEGIES

Line 426: /* process IEX_STRATEGIES.CUST_ACCOUNT_ID */

422: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IEX_DUNNING',FALSE);
423: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
424: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
425:
426: /* process IEX_STRATEGIES.CUST_ACCOUNT_ID */
427: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
428: IEX_DEBUG_PUB.logMessage('IEX_DUNNING.DUNNING_OBJECT_ID');
429: END IF;
430: open merged_records1;

Line 611: | Account merge procedure for the table, IEX_STRATEGIES

Line 629: IEX_STRATEGIES.STRATEGY_ID%TYPE

625: INDEX BY BINARY_INTEGER;
626: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
627:
628: TYPE STRATEGY_ID_LIST_TYPE IS TABLE OF
629: IEX_STRATEGIES.STRATEGY_ID%TYPE
630: INDEX BY BINARY_INTEGER;
631: PRIMARY_KEY_ID_LIST STRATEGY_ID_LIST_TYPE;
632:
633: TYPE CUST_ACCOUNT_ID_LIST_TYPE IS TABLE OF

Line 634: IEX_STRATEGIES.CUST_ACCOUNT_ID%TYPE

630: INDEX BY BINARY_INTEGER;
631: PRIMARY_KEY_ID_LIST STRATEGY_ID_LIST_TYPE;
632:
633: TYPE CUST_ACCOUNT_ID_LIST_TYPE IS TABLE OF
634: IEX_STRATEGIES.CUST_ACCOUNT_ID%TYPE
635: INDEX BY BINARY_INTEGER;
636: NUM_COL1_ORIG_LIST CUST_ACCOUNT_ID_LIST_TYPE;
637: NUM_COL1_NEW_LIST CUST_ACCOUNT_ID_LIST_TYPE;
638:

Line 640: IEX_STRATEGIES.JTF_OBJECT_ID%TYPE

636: NUM_COL1_ORIG_LIST CUST_ACCOUNT_ID_LIST_TYPE;
637: NUM_COL1_NEW_LIST CUST_ACCOUNT_ID_LIST_TYPE;
638:
639: TYPE JTF_OBJECT_ID_LIST_TYPE IS TABLE OF
640: IEX_STRATEGIES.JTF_OBJECT_ID%TYPE
641: INDEX BY BINARY_INTEGER;
642: NUM_COL2_ORIG_LIST JTF_OBJECT_ID_LIST_TYPE;
643: NUM_COL2_NEW_LIST JTF_OBJECT_ID_LIST_TYPE;
644: NUM_COL3_ORIG_LIST JTF_OBJECT_ID_LIST_TYPE;

Line 650: IEX_STRATEGIES.STATUS_CODE%TYPE

646:
647:
648: --Added for bug#6974531 by schekuri on 14-Aug-2008
649: TYPE STATUS_CODE_LIST_TYPE IS TABLE OF
650: IEX_STRATEGIES.STATUS_CODE%TYPE
651: INDEX BY BINARY_INTEGER;
652: STATUS_CODE_LIST STATUS_CODE_LIST_TYPE;
653: TYPE PARTY_ID_LIST_TYPE IS TABLE OF
654: IEX_STRATEGIES.PARTY_ID%TYPE

Line 654: IEX_STRATEGIES.PARTY_ID%TYPE

650: IEX_STRATEGIES.STATUS_CODE%TYPE
651: INDEX BY BINARY_INTEGER;
652: STATUS_CODE_LIST STATUS_CODE_LIST_TYPE;
653: TYPE PARTY_ID_LIST_TYPE IS TABLE OF
654: IEX_STRATEGIES.PARTY_ID%TYPE
655: INDEX BY BINARY_INTEGER;
656: PARTY_ID_LIST PARTY_ID_LIST_TYPE;
657:
658:

Line 661: /* this cursor is for IEX_STRATEGIES.CUST_ACCOUNT_ID column update */

657:
658:
659: l_profile_val VARCHAR2(30);
660:
661: /* this cursor is for IEX_STRATEGIES.CUST_ACCOUNT_ID column update */
662: CURSOR merged_records1 IS
663: SELECT distinct CUSTOMER_MERGE_HEADER_ID
664: ,yt.STRATEGY_ID
665: ,yt.CUST_ACCOUNT_ID

Line 668: FROM IEX_STRATEGIES yt, ra_customer_merges m, hz_cust_accounts hca

664: ,yt.STRATEGY_ID
665: ,yt.CUST_ACCOUNT_ID
666: ,hca.party_id
667: ,yt.status_code --Added for bug#6974531 by schekuri on 14-Aug-2008
668: FROM IEX_STRATEGIES yt, ra_customer_merges m, hz_cust_accounts hca
669: WHERE yt.CUST_ACCOUNT_ID = m.DUPLICATE_ID AND
670: hca.cust_account_id = m.customer_id AND
671: m.process_flag = 'N' AND
672: m.request_id = req_id AND

Line 676: /* this cursor is for IEX_STRATEGIES.JTF_OBJECT_ID column update if Object is IEX_ACCOUNT */

672: m.request_id = req_id AND
673: m.set_number = set_num;
674:
675:
676: /* this cursor is for IEX_STRATEGIES.JTF_OBJECT_ID column update if Object is IEX_ACCOUNT */
677: CURSOR merged_records2 IS
678: SELECT distinct CUSTOMER_MERGE_HEADER_ID
679: ,STRATEGY_ID
680: ,JTF_OBJECT_ID

Line 682: FROM IEX_STRATEGIES yt, ra_customer_merges m

678: SELECT distinct CUSTOMER_MERGE_HEADER_ID
679: ,STRATEGY_ID
680: ,JTF_OBJECT_ID
681: ,yt.status_code --Added for bug#6974531 by schekuri on 14-Aug-2008
682: FROM IEX_STRATEGIES yt, ra_customer_merges m
683: WHERE yt.JTF_OBJECT_ID = m.DUPLICATE_ID AND
684: m.process_flag = 'N' AND
685: m.request_id = req_id AND
686: m.set_number = set_num AND

Line 689: /* this cursor is for IEX_STRATEGIES.JTF_OBJECT_ID column update if Object is IEX_BILLTO */

685: m.request_id = req_id AND
686: m.set_number = set_num AND
687: yt.jtf_object_type = 'IEX_ACCOUNT';
688:
689: /* this cursor is for IEX_STRATEGIES.JTF_OBJECT_ID column update if Object is IEX_BILLTO */
690: CURSOR merged_records3 IS
691: SELECT distinct CUSTOMER_MERGE_HEADER_ID
692: ,STRATEGY_ID
693: ,JTF_OBJECT_ID

Line 695: FROM IEX_STRATEGIES yt, ra_customer_merges m

691: SELECT distinct CUSTOMER_MERGE_HEADER_ID
692: ,STRATEGY_ID
693: ,JTF_OBJECT_ID
694: ,yt.status_code --Added for bug#6974531 by schekuri on 14-Aug-2008
695: FROM IEX_STRATEGIES yt, ra_customer_merges m
696: WHERE yt.JTF_OBJECT_ID = m.DUPLICATE_SITE_ID AND
697: m.process_flag = 'N' AND
698: m.request_id = req_id AND
699: m.set_number = set_num AND

Line 714: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IEX_STRATEGIES',FALSE);

710: IEX_DEBUG_PUB.logMessage('IEX_MERGE_PVT.STRATEGY_MERGE BEGIN');
711: END IF;
712:
713: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
714: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IEX_STRATEGIES',FALSE);
715: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
716: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
717:
718: /* process IEX_STRATEGIES.CUST_ACCOUNT_ID */

Line 718: /* process IEX_STRATEGIES.CUST_ACCOUNT_ID */

714: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IEX_STRATEGIES',FALSE);
715: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
716: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
717:
718: /* process IEX_STRATEGIES.CUST_ACCOUNT_ID */
719: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
720: IEX_DEBUG_PUB.logMessage('IEX_STRATEGIES.CUST_ACCOUNT_ID');
721: END IF;
722: open merged_records1;

Line 720: IEX_DEBUG_PUB.logMessage('IEX_STRATEGIES.CUST_ACCOUNT_ID');

716: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
717:
718: /* process IEX_STRATEGIES.CUST_ACCOUNT_ID */
719: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
720: IEX_DEBUG_PUB.logMessage('IEX_STRATEGIES.CUST_ACCOUNT_ID');
721: END IF;
722: open merged_records1;
723: LOOP
724: FETCH merged_records1 BULK COLLECT INTO

Line 762: 'IEX_STRATEGIES',

758: LAST_UPDATE_DATE,
759: LAST_UPDATED_BY)
760: VALUES
761: (HZ_CUSTOMER_MERGE_LOG_s.nextval,
762: 'IEX_STRATEGIES',
763: MERGE_HEADER_ID_LIST(I),
764: PRIMARY_KEY_ID_LIST(I),
765: NUM_COL1_ORIG_LIST(I),
766: NUM_COL1_NEW_LIST(I),

Line 780: UPDATE IEX_STRATEGIES yt SET

776: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
777: IEX_DEBUG_PUB.logMessage('Merging ' || MERGE_HEADER_ID_LIST.COUNT || ' Records');
778: END IF;
779: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
780: UPDATE IEX_STRATEGIES yt SET
781: CUST_ACCOUNT_ID = NUM_COL1_NEW_LIST(I)
782: , PARTY_ID = PARTY_ID_LIST(I)
783: , LAST_UPDATE_DATE = SYSDATE
784: , last_updated_by = arp_standard.profile.user_id

Line 801: /* process IEX_STRATEGIES.JTF_OBJECT_ID where JTF_OBJECT_TYPE = 'IEX_ACCOUNT' */

797: arp_message.set_name('AR','AR_ROWS_UPDATED');
798: arp_message.set_token('NUM_ROWS',to_char(l_count));
799:
800: <>
801: /* process IEX_STRATEGIES.JTF_OBJECT_ID where JTF_OBJECT_TYPE = 'IEX_ACCOUNT' */
802: MERGE_HEADER_ID_LIST.delete;
803: PRIMARY_KEY_ID_LIST.delete;
804: PARTY_ID_LIST.delete;
805: STATUS_CODE_LIST.delete; --Added for bug#6974531 by schekuri on 14-Aug-2008

Line 808: IEX_DEBUG_PUB.logMessage('IEX_STRATEGIES.JTF_OBJECT_ID.TYPE=IEX_ACCOUNT');

804: PARTY_ID_LIST.delete;
805: STATUS_CODE_LIST.delete; --Added for bug#6974531 by schekuri on 14-Aug-2008
806: l_count := 0;
807: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
808: IEX_DEBUG_PUB.logMessage('IEX_STRATEGIES.JTF_OBJECT_ID.TYPE=IEX_ACCOUNT');
809: END IF;
810: open merged_records2;
811: LOOP
812: FETCH merged_records2 BULK COLLECT INTO

Line 850: 'IEX_STRATEGIES',

846: LAST_UPDATE_DATE,
847: LAST_UPDATED_BY)
848: VALUES
849: (HZ_CUSTOMER_MERGE_LOG_s.nextval,
850: 'IEX_STRATEGIES',
851: MERGE_HEADER_ID_LIST(I),
852: PRIMARY_KEY_ID_LIST(I),
853: NUM_COL2_ORIG_LIST(I),
854: NUM_COL2_NEW_LIST(I),

Line 870: UPDATE IEX_STRATEGIES yt SET

866: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
867: IEX_DEBUG_PUB.logMessage('Merging ' || MERGE_HEADER_ID_LIST.COUNT || ' Records');
868: END IF;
869: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
870: UPDATE IEX_STRATEGIES yt SET
871: JTF_OBJECT_ID = NUM_COL2_NEW_LIST(I)
872: , LAST_UPDATE_DATE = SYSDATE
873: , last_updated_by = arp_standard.profile.user_id
874: , last_update_login = arp_standard.profile.last_update_login

Line 898: /* process IEX_STRATEGIES.JTF_OBJECT_ID where JTF_OBJECT_TYPE = 'IEX_BILLTO' */

894: arp_message.set_token('NUM_ROWS',to_char(l_count));
895:
896: <>
897:
898: /* process IEX_STRATEGIES.JTF_OBJECT_ID where JTF_OBJECT_TYPE = 'IEX_BILLTO' */
899: MERGE_HEADER_ID_LIST.delete;
900: PRIMARY_KEY_ID_LIST.delete;
901: STATUS_CODE_LIST.delete; --Added for bug#6974531 by schekuri on 14-Aug-2008
902: l_count := 0;

Line 904: IEX_DEBUG_PUB.logMessage('IEX_STRATEGIES.JTF_OBJECT_ID.TYPE=IEX_BILLTO');

900: PRIMARY_KEY_ID_LIST.delete;
901: STATUS_CODE_LIST.delete; --Added for bug#6974531 by schekuri on 14-Aug-2008
902: l_count := 0;
903: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
904: IEX_DEBUG_PUB.logMessage('IEX_STRATEGIES.JTF_OBJECT_ID.TYPE=IEX_BILLTO');
905: END IF;
906: open merged_records3;
907: LOOP
908: FETCH merged_records3 BULK COLLECT INTO

Line 946: 'IEX_STRATEGIES',

942: LAST_UPDATE_DATE,
943: LAST_UPDATED_BY)
944: VALUES (
945: HZ_CUSTOMER_MERGE_LOG_s.nextval,
946: 'IEX_STRATEGIES',
947: MERGE_HEADER_ID_LIST(I),
948: PRIMARY_KEY_ID_LIST(I),
949: NUM_COL3_ORIG_LIST(I),
950: NUM_COL3_NEW_LIST(I),

Line 966: UPDATE IEX_STRATEGIES yt SET

962: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
963: IEX_DEBUG_PUB.logMessage('Merging ' || MERGE_HEADER_ID_LIST.COUNT || ' Records');
964: END IF;
965: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
966: UPDATE IEX_STRATEGIES yt SET
967: -- CUST_ACCOUNT_ID = NUM_COL3_NEW_LIST(I) Updated for bug#6974531 by schekuri on 14-Aug-2008
968: JTF_OBJECT_ID = NUM_COL3_NEW_LIST(I)
969: , CUSTOMER_SITE_USE_ID = NUM_COL3_NEW_LIST(I)
970: , LAST_UPDATE_DATE = SYSDATE

Line 1578: IEX_STRATEGIES

1574: iex_writeoffs
1575: iex_bankruptcies
1576: iex_litigations
1577: -- 02182002 add IEX_SCORE_HISTORIES
1578: IEX_STRATEGIES
1579: */
1580: UPDATE IEX_STRATEGIES
1581: SET JTF_OBJECT_ID = p_To_FK_ID,
1582: last_update_date = HZ_UTILITY_V2PUB.last_update_date,

Line 1580: UPDATE IEX_STRATEGIES

1576: iex_litigations
1577: -- 02182002 add IEX_SCORE_HISTORIES
1578: IEX_STRATEGIES
1579: */
1580: UPDATE IEX_STRATEGIES
1581: SET JTF_OBJECT_ID = p_To_FK_ID,
1582: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1583: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1584: last_update_login = HZ_UTILITY_V2PUB.last_update_login,

Line 1596: UPDATE IEX_STRATEGIES

1592: WHERE JTF_OBJECT_ID = p_from_fk_id AND
1593: JTF_OBJECT_TYPE = 'PARTY';
1594:
1595: -- Begin - 10/12/2005 - Andre Araujo - Need to update party_id also
1596: UPDATE IEX_STRATEGIES
1597: SET last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1598: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1599: last_update_login = HZ_UTILITY_V2PUB.last_update_login,
1600: request_id = HZ_UTILITY_V2PUB.request_id,