APPS.OZF_ACCOUNT_MERGE_PKG dependencies on OZF_ACTIVITY_CUSTOMERS

Line 1287: | Account merge procedure for the table, ozf_activity_customers

1283: |
1284: | PROCEDURE
1285: | merge_offer_denorm
1286: | DESCRIPTION :
1287: | Account merge procedure for the table, ozf_activity_customers
1288: |
1289: | NOTES:
1290: |
1291: |--------------------------------------------------------------*/

Line 1304: ozf_activity_customers.object_class%TYPE

1300: INDEX BY BINARY_INTEGER;
1301: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
1302:
1303: TYPE object_class_LIST_TYPE IS TABLE OF
1304: ozf_activity_customers.object_class%TYPE
1305: INDEX BY BINARY_INTEGER;
1306: PRIMARY_KEY1_LIST object_class_LIST_TYPE;
1307:
1308: TYPE object_id_LIST_TYPE IS TABLE OF

Line 1309: ozf_activity_customers.object_id%TYPE

1305: INDEX BY BINARY_INTEGER;
1306: PRIMARY_KEY1_LIST object_class_LIST_TYPE;
1307:
1308: TYPE object_id_LIST_TYPE IS TABLE OF
1309: ozf_activity_customers.object_id%TYPE
1310: INDEX BY BINARY_INTEGER;
1311: PRIMARY_KEY2_LIST object_id_LIST_TYPE;
1312:
1313: TYPE cust_account_id_LIST_TYPE IS TABLE OF

Line 1314: ozf_activity_customers.cust_account_id%TYPE

1310: INDEX BY BINARY_INTEGER;
1311: PRIMARY_KEY2_LIST object_id_LIST_TYPE;
1312:
1313: TYPE cust_account_id_LIST_TYPE IS TABLE OF
1314: ozf_activity_customers.cust_account_id%TYPE
1315: INDEX BY BINARY_INTEGER;
1316: NUM_COL1_ORIG_LIST cust_account_id_LIST_TYPE;
1317: NUM_COL1_NEW_LIST cust_account_id_LIST_TYPE;
1318:

Line 1320: ozf_activity_customers.site_use_id%TYPE

1316: NUM_COL1_ORIG_LIST cust_account_id_LIST_TYPE;
1317: NUM_COL1_NEW_LIST cust_account_id_LIST_TYPE;
1318:
1319: TYPE site_use_id_LIST_TYPE IS TABLE OF
1320: ozf_activity_customers.site_use_id%TYPE
1321: INDEX BY BINARY_INTEGER;
1322: NUM_COL2_ORIG_LIST site_use_id_LIST_TYPE;
1323: NUM_COL2_NEW_LIST site_use_id_LIST_TYPE;
1324:

Line 1332: FROM ozf_activity_customers yt, ra_customer_merges m

1328: ,object_class
1329: ,object_id
1330: ,cust_account_id
1331: ,site_use_id
1332: FROM ozf_activity_customers yt, ra_customer_merges m
1333: WHERE (
1334: yt.cust_account_id = m.DUPLICATE_ADDRESS_ID
1335: OR yt.site_use_id = m.DUPLICATE_SITE_ID
1336: ) AND m.process_flag = 'N'

Line 1346: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_activity_customers',FALSE);

1342: IF process_mode='LOCK' THEN
1343: NULL;
1344: ELSE
1345: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1346: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_activity_customers',FALSE);
1347: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1348: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1349:
1350: open merged_records;

Line 1390: 'ozf_activity_customers',

1386: LAST_UPDATE_LOGIN,
1387: LAST_UPDATE_DATE,
1388: LAST_UPDATED_BY
1389: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
1390: 'ozf_activity_customers',
1391: MERGE_HEADER_ID_LIST(I),
1392: PRIMARY_KEY1_LIST(I),
1393: PRIMARY_KEY2_LIST(I),
1394: NUM_COL1_ORIG_LIST(I),

Line 1408: UPDATE ozf_activity_customers yt SET

1404: hz_utility_pub.LAST_UPDATED_BY
1405: );
1406:
1407: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1408: UPDATE ozf_activity_customers yt SET
1409: cust_account_id=NUM_COL1_NEW_LIST(I)
1410: ,site_use_id=NUM_COL2_NEW_LIST(I)
1411: , LAST_UPDATE_DATE=SYSDATE
1412: , last_updated_by=arp_standard.profile.user_id