APPS.OZF_ACCOUNT_MERGE_PKG dependencies on OZF_CLAIMS_HISTORY

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)