APPS.OZF_ACCOUNT_MERGE_PKG dependencies on OZF_CUST_DAILY_FACTS

Line 988: | Account merge procedure for the table, ozf_cust_daily_facts

984: |
985: | PROCEDURE
986: | merge_cust_daily_facts
987: | DESCRIPTION :
988: | Account merge procedure for the table, ozf_cust_daily_facts
989: |
990: | NOTES:
991: |
992: |--------------------------------------------------------------*/

Line 1005: ozf_cust_daily_facts.cust_daily_fact_id%TYPE

1001: INDEX BY BINARY_INTEGER;
1002: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
1003:
1004: TYPE cust_daily_fact_id_LIST_TYPE IS TABLE OF
1005: ozf_cust_daily_facts.cust_daily_fact_id%TYPE
1006: INDEX BY BINARY_INTEGER;
1007: PRIMARY_KEY_ID1_LIST cust_daily_fact_id_LIST_TYPE;
1008:
1009: TYPE cust_account_id_LIST_TYPE IS TABLE OF

Line 1010: ozf_cust_daily_facts.cust_account_id%TYPE

1006: INDEX BY BINARY_INTEGER;
1007: PRIMARY_KEY_ID1_LIST cust_daily_fact_id_LIST_TYPE;
1008:
1009: TYPE cust_account_id_LIST_TYPE IS TABLE OF
1010: ozf_cust_daily_facts.cust_account_id%TYPE
1011: INDEX BY BINARY_INTEGER;
1012: NUM_COL1_ORIG_LIST cust_account_id_LIST_TYPE;
1013: NUM_COL1_NEW_LIST cust_account_id_LIST_TYPE;
1014:

Line 1016: ozf_cust_daily_facts.bill_to_site_use_id%TYPE

1012: NUM_COL1_ORIG_LIST cust_account_id_LIST_TYPE;
1013: NUM_COL1_NEW_LIST cust_account_id_LIST_TYPE;
1014:
1015: TYPE bill_to_site_use_id_LIST_TYPE IS TABLE OF
1016: ozf_cust_daily_facts.bill_to_site_use_id%TYPE
1017: INDEX BY BINARY_INTEGER;
1018: NUM_COL2_ORIG_LIST bill_to_site_use_id_LIST_TYPE;
1019: NUM_COL2_NEW_LIST bill_to_site_use_id_LIST_TYPE;
1020:

Line 1022: ozf_cust_daily_facts.ship_to_site_use_id%TYPE

1018: NUM_COL2_ORIG_LIST bill_to_site_use_id_LIST_TYPE;
1019: NUM_COL2_NEW_LIST bill_to_site_use_id_LIST_TYPE;
1020:
1021: TYPE ship_to_site_use_id_LIST_TYPE IS TABLE OF
1022: ozf_cust_daily_facts.ship_to_site_use_id%TYPE
1023: INDEX BY BINARY_INTEGER;
1024: NUM_COL3_ORIG_LIST ship_to_site_use_id_LIST_TYPE;
1025: NUM_COL3_NEW_LIST ship_to_site_use_id_LIST_TYPE;
1026:

Line 1034: FROM ozf_cust_daily_facts yt, ra_customer_merges m

1030: ,cust_daily_fact_id
1031: ,cust_account_id
1032: ,bill_to_site_use_id
1033: ,ship_to_site_use_id
1034: FROM ozf_cust_daily_facts yt, ra_customer_merges m
1035: WHERE (
1036: yt.cust_account_id = m.DUPLICATE_ADDRESS_ID
1037: OR yt.bill_to_site_use_id = m.DUPLICATE_SITE_ID
1038: OR yt.ship_to_site_use_id = m.DUPLICATE_SITE_ID

Line 1049: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_cust_daily_facts',FALSE);

1045: IF process_mode='LOCK' THEN
1046: NULL;
1047: ELSE
1048: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1049: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_cust_daily_facts',FALSE);
1050: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1051: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1052:
1053: open merged_records;

Line 1095: 'ozf_cust_daily_facts',

1091: LAST_UPDATE_LOGIN,
1092: LAST_UPDATE_DATE,
1093: LAST_UPDATED_BY
1094: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
1095: 'ozf_cust_daily_facts',
1096: MERGE_HEADER_ID_LIST(I),
1097: PRIMARY_KEY_ID1_LIST(I),
1098: NUM_COL1_ORIG_LIST(I),
1099: NUM_COL1_NEW_LIST(I),

Line 1114: UPDATE ozf_cust_daily_facts yt SET

1110: hz_utility_pub.LAST_UPDATED_BY
1111: );
1112:
1113: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1114: UPDATE ozf_cust_daily_facts yt SET
1115: cust_account_id=NUM_COL1_NEW_LIST(I)
1116: ,bill_to_site_use_id=NUM_COL2_NEW_LIST(I)
1117: ,ship_to_site_use_id=NUM_COL3_NEW_LIST(I)
1118: , LAST_UPDATE_DATE=SYSDATE