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.OZF_ACCOUNT_MERGE_PKG dependencies on OZF_CLAIMS

Line 456: | Account merge procedure for the table, ozf_claims

452: |
453: | PROCEDURE
454: | merge_claims
455: | DESCRIPTION :
456: | Account merge procedure for the table, ozf_claims
457: |
458: | NOTES:
459: |
460: |--------------------------------------------------------------*/

Line 473: ozf_claims.claim_id%TYPE

469: INDEX BY BINARY_INTEGER;
470: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
471:
472: TYPE claim_id_LIST_TYPE IS TABLE OF
473: ozf_claims.claim_id%TYPE
474: INDEX BY BINARY_INTEGER;
475: PRIMARY_KEY_ID1_LIST claim_id_LIST_TYPE;
476:
477: TYPE cust_account_id_LIST_TYPE IS TABLE OF

Line 478: ozf_claims.cust_account_id%TYPE

474: INDEX BY BINARY_INTEGER;
475: PRIMARY_KEY_ID1_LIST claim_id_LIST_TYPE;
476:
477: TYPE cust_account_id_LIST_TYPE IS TABLE OF
478: ozf_claims.cust_account_id%TYPE
479: INDEX BY BINARY_INTEGER;
480: NUM_COL1_ORIG_LIST cust_account_id_LIST_TYPE;
481: NUM_COL1_NEW_LIST cust_account_id_LIST_TYPE;
482:

Line 484: ozf_claims.ship_to_cust_account_id%TYPE

480: NUM_COL1_ORIG_LIST cust_account_id_LIST_TYPE;
481: NUM_COL1_NEW_LIST cust_account_id_LIST_TYPE;
482:
483: TYPE ship_to_cust_acct_id_LIST_TYPE IS TABLE OF
484: ozf_claims.ship_to_cust_account_id%TYPE
485: INDEX BY BINARY_INTEGER;
486: NUM_COL2_ORIG_LIST ship_to_cust_acct_id_LIST_TYPE;
487: NUM_COL2_NEW_LIST ship_to_cust_acct_id_LIST_TYPE;
488:

Line 490: ozf_claims.cust_billto_acct_site_id%TYPE

486: NUM_COL2_ORIG_LIST ship_to_cust_acct_id_LIST_TYPE;
487: NUM_COL2_NEW_LIST ship_to_cust_acct_id_LIST_TYPE;
488:
489: TYPE cb_acct_site_id_LIST_TYPE IS TABLE OF
490: ozf_claims.cust_billto_acct_site_id%TYPE
491: INDEX BY BINARY_INTEGER;
492: NUM_COL3_ORIG_LIST cb_acct_site_id_LIST_TYPE;
493: NUM_COL3_NEW_LIST cb_acct_site_id_LIST_TYPE;
494:

Line 496: ozf_claims.cust_shipto_acct_site_id%TYPE

492: NUM_COL3_ORIG_LIST cb_acct_site_id_LIST_TYPE;
493: NUM_COL3_NEW_LIST cb_acct_site_id_LIST_TYPE;
494:
495: TYPE cs_acct_site_id_LIST_TYPE IS TABLE OF
496: ozf_claims.cust_shipto_acct_site_id%TYPE
497: INDEX BY BINARY_INTEGER;
498: NUM_COL4_ORIG_LIST cs_acct_site_id_LIST_TYPE;
499: NUM_COL4_NEW_LIST cs_acct_site_id_LIST_TYPE;
500:

Line 502: ozf_claims.related_cust_account_id%TYPE

498: NUM_COL4_ORIG_LIST cs_acct_site_id_LIST_TYPE;
499: NUM_COL4_NEW_LIST cs_acct_site_id_LIST_TYPE;
500:
501: TYPE rel_cust_account_id_LIST_TYPE IS TABLE OF
502: ozf_claims.related_cust_account_id%TYPE
503: INDEX BY BINARY_INTEGER;
504: NUM_COL5_ORIG_LIST rel_cust_account_id_LIST_TYPE;
505: NUM_COL5_NEW_LIST rel_cust_account_id_LIST_TYPE;
506:

Line 508: ozf_claims.related_site_use_id%TYPE

504: NUM_COL5_ORIG_LIST rel_cust_account_id_LIST_TYPE;
505: NUM_COL5_NEW_LIST rel_cust_account_id_LIST_TYPE;
506:
507: TYPE related_site_use_id_LIST_TYPE IS TABLE OF
508: ozf_claims.related_site_use_id%TYPE
509: INDEX BY BINARY_INTEGER;
510: NUM_COL6_ORIG_LIST related_site_use_id_LIST_TYPE;
511: NUM_COL6_NEW_LIST related_site_use_id_LIST_TYPE;
512:

Line 523: FROM ozf_claims yt, ra_customer_merges m

519: ,cust_billto_acct_site_id
520: ,cust_shipto_acct_site_id
521: ,related_cust_account_id
522: ,related_site_use_id
523: FROM ozf_claims yt, ra_customer_merges m
524: WHERE (
525: yt.cust_account_id = m.DUPLICATE_ID
526: OR yt.ship_to_cust_account_id = m.DUPLICATE_ID
527: OR yt.cust_billto_acct_site_id = m.DUPLICATE_SITE_ID

Line 541: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_claims',FALSE);

537: IF process_mode='LOCK' THEN
538: NULL;
539: ELSE
540: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
541: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_claims',FALSE);
542: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
543: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
544:
545: open merged_records;

Line 598: 'ozf_claims',

594: LAST_UPDATE_LOGIN,
595: LAST_UPDATE_DATE,
596: LAST_UPDATED_BY
597: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
598: 'ozf_claims',
599: MERGE_HEADER_ID_LIST(I),
600: PRIMARY_KEY_ID1_LIST(I),
601: NUM_COL1_ORIG_LIST(I),
602: NUM_COL1_NEW_LIST(I),

Line 623: UPDATE ozf_claims yt SET

619: hz_utility_pub.LAST_UPDATED_BY
620: );
621:
622: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
623: UPDATE ozf_claims yt SET
624: cust_account_id=NUM_COL1_NEW_LIST(I)
625: ,ship_to_cust_account_id=NUM_COL2_NEW_LIST(I)
626: ,cust_billto_acct_site_id=NUM_COL3_NEW_LIST(I)
627: ,cust_shipto_acct_site_id=NUM_COL4_NEW_LIST(I)

Line 660: | Account merge procedure for the table, ozf_claims_history

656: |
657: | PROCEDURE
658: | merge_claims_history
659: | DESCRIPTION :
660: | Account merge procedure for the table, ozf_claims_history
661: |
662: | NOTES:
663: |
664: |--------------------------------------------------------------*/

Line 677: ozf_claims_history.claim_history_id%TYPE

673: INDEX BY BINARY_INTEGER;
674: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
675:
676: TYPE claim_history_id_LIST_TYPE IS TABLE OF
677: ozf_claims_history.claim_history_id%TYPE
678: INDEX BY BINARY_INTEGER;
679: PRIMARY_KEY_ID1_LIST claim_history_id_LIST_TYPE;
680:
681: TYPE cust_account_id_LIST_TYPE IS TABLE OF

Line 682: ozf_claims_history.cust_account_id%TYPE

678: INDEX BY BINARY_INTEGER;
679: PRIMARY_KEY_ID1_LIST claim_history_id_LIST_TYPE;
680:
681: TYPE cust_account_id_LIST_TYPE IS TABLE OF
682: ozf_claims_history.cust_account_id%TYPE
683: INDEX BY BINARY_INTEGER;
684: NUM_COL1_ORIG_LIST cust_account_id_LIST_TYPE;
685: NUM_COL1_NEW_LIST cust_account_id_LIST_TYPE;
686:

Line 688: ozf_claims_history.ship_to_cust_account_id%TYPE

684: NUM_COL1_ORIG_LIST cust_account_id_LIST_TYPE;
685: NUM_COL1_NEW_LIST cust_account_id_LIST_TYPE;
686:
687: TYPE ship_to_cust_acct_id_LIST_TYPE IS TABLE OF
688: ozf_claims_history.ship_to_cust_account_id%TYPE
689: INDEX BY BINARY_INTEGER;
690: NUM_COL2_ORIG_LIST ship_to_cust_acct_id_LIST_TYPE;
691: NUM_COL2_NEW_LIST ship_to_cust_acct_id_LIST_TYPE;
692:

Line 694: ozf_claims_history.cust_billto_acct_site_id%TYPE

690: NUM_COL2_ORIG_LIST ship_to_cust_acct_id_LIST_TYPE;
691: NUM_COL2_NEW_LIST ship_to_cust_acct_id_LIST_TYPE;
692:
693: TYPE cb_acct_site_id_LIST_TYPE IS TABLE OF
694: ozf_claims_history.cust_billto_acct_site_id%TYPE
695: INDEX BY BINARY_INTEGER;
696: NUM_COL3_ORIG_LIST cb_acct_site_id_LIST_TYPE;
697: NUM_COL3_NEW_LIST cb_acct_site_id_LIST_TYPE;
698:

Line 700: ozf_claims_history.cust_shipto_acct_site_id%TYPE

696: NUM_COL3_ORIG_LIST cb_acct_site_id_LIST_TYPE;
697: NUM_COL3_NEW_LIST cb_acct_site_id_LIST_TYPE;
698:
699: TYPE cs_acct_site_id_LIST_TYPE IS TABLE OF
700: ozf_claims_history.cust_shipto_acct_site_id%TYPE
701: INDEX BY BINARY_INTEGER;
702: NUM_COL4_ORIG_LIST cs_acct_site_id_LIST_TYPE;
703: NUM_COL4_NEW_LIST cs_acct_site_id_LIST_TYPE;
704:

Line 706: ozf_claims_history.related_cust_account_id%TYPE

702: NUM_COL4_ORIG_LIST cs_acct_site_id_LIST_TYPE;
703: NUM_COL4_NEW_LIST cs_acct_site_id_LIST_TYPE;
704:
705: TYPE rel_cust_account_id_LIST_TYPE IS TABLE OF
706: ozf_claims_history.related_cust_account_id%TYPE
707: INDEX BY BINARY_INTEGER;
708: NUM_COL5_ORIG_LIST rel_cust_account_id_LIST_TYPE;
709: NUM_COL5_NEW_LIST rel_cust_account_id_LIST_TYPE;
710:

Line 712: ozf_claims_history.related_site_use_id%TYPE

708: NUM_COL5_ORIG_LIST rel_cust_account_id_LIST_TYPE;
709: NUM_COL5_NEW_LIST rel_cust_account_id_LIST_TYPE;
710:
711: TYPE related_site_use_id_LIST_TYPE IS TABLE OF
712: ozf_claims_history.related_site_use_id%TYPE
713: INDEX BY BINARY_INTEGER;
714: NUM_COL6_ORIG_LIST related_site_use_id_LIST_TYPE;
715: NUM_COL6_NEW_LIST related_site_use_id_LIST_TYPE;
716:

Line 727: FROM ozf_claims_history yt, ra_customer_merges m

723: ,cust_billto_acct_site_id
724: ,cust_shipto_acct_site_id
725: ,related_cust_account_id
726: ,related_site_use_id
727: FROM ozf_claims_history yt, ra_customer_merges m
728: WHERE (
729: yt.cust_account_id = m.DUPLICATE_ID
730: OR yt.ship_to_cust_account_id = m.DUPLICATE_ID
731: OR yt.cust_billto_acct_site_id = m.DUPLICATE_SITE_ID

Line 745: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_claims_history',FALSE);

741: IF process_mode='LOCK' THEN
742: NULL;
743: ELSE
744: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
745: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_claims_history',FALSE);
746: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
747: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
748:
749: open merged_records;

Line 802: 'ozf_claims_history',

798: LAST_UPDATE_LOGIN,
799: LAST_UPDATE_DATE,
800: LAST_UPDATED_BY
801: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
802: 'ozf_claims_history',
803: MERGE_HEADER_ID_LIST(I),
804: PRIMARY_KEY_ID1_LIST(I),
805: NUM_COL1_ORIG_LIST(I),
806: NUM_COL1_NEW_LIST(I),

Line 827: UPDATE ozf_claims_history yt SET

823: hz_utility_pub.LAST_UPDATED_BY
824: );
825:
826: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
827: UPDATE ozf_claims_history yt SET
828: cust_account_id=NUM_COL1_NEW_LIST(I)
829: ,ship_to_cust_account_id=NUM_COL2_NEW_LIST(I)
830: ,cust_billto_acct_site_id=NUM_COL3_NEW_LIST(I)
831: ,cust_shipto_acct_site_id=NUM_COL4_NEW_LIST(I)