APPS.OZF_ACCOUNT_MERGE_PKG dependencies on OZF_OFFERS

Line 1438: | Account merge procedure for the table, ozf_offers

1434: |
1435: | PROCEDURE
1436: | merge_offer_header
1437: | DESCRIPTION :
1438: | Account merge procedure for the table, ozf_offers
1439: |
1440: | NOTES:
1441: |
1442: |--------------------------------------------------------------*/

Line 1455: ozf_offers.qp_list_header_id%TYPE

1451: INDEX BY BINARY_INTEGER;
1452: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
1453:
1454: TYPE qp_list_header_id_LIST_TYPE IS TABLE OF
1455: ozf_offers.qp_list_header_id%TYPE
1456: INDEX BY BINARY_INTEGER;
1457: PRIMARY_KEY_ID1_LIST qp_list_header_id_LIST_TYPE;
1458:
1459: TYPE ben_account_id_LIST_TYPE IS TABLE OF

Line 1460: ozf_offers.beneficiary_account_id%TYPE

1456: INDEX BY BINARY_INTEGER;
1457: PRIMARY_KEY_ID1_LIST qp_list_header_id_LIST_TYPE;
1458:
1459: TYPE ben_account_id_LIST_TYPE IS TABLE OF
1460: ozf_offers.beneficiary_account_id%TYPE
1461: INDEX BY BINARY_INTEGER;
1462: NUM_COL1_ORIG_LIST ben_account_id_LIST_TYPE;
1463: NUM_COL1_NEW_LIST ben_account_id_LIST_TYPE;
1464:

Line 1470: FROM ozf_offers yt, ra_customer_merges m

1466: CURSOR merged_records IS
1467: SELECT distinct CUSTOMER_MERGE_HEADER_ID
1468: ,qp_list_header_id
1469: ,beneficiary_account_id
1470: FROM ozf_offers yt, ra_customer_merges m
1471: WHERE (
1472: yt.beneficiary_account_id = m.DUPLICATE_ADDRESS_ID
1473: ) AND m.process_flag = 'N'
1474: AND m.request_id = req_id

Line 1483: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_offers',FALSE);

1479: IF process_mode='LOCK' THEN
1480: NULL;
1481: ELSE
1482: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1483: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_offers',FALSE);
1484: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1485: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1486:
1487: open merged_records;

Line 1521: 'ozf_offers',

1517: LAST_UPDATE_LOGIN,
1518: LAST_UPDATE_DATE,
1519: LAST_UPDATED_BY
1520: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
1521: 'ozf_offers',
1522: MERGE_HEADER_ID_LIST(I),
1523: PRIMARY_KEY_ID1_LIST(I),
1524: NUM_COL1_ORIG_LIST(I),
1525: NUM_COL1_NEW_LIST(I),

Line 1536: UPDATE ozf_offers yt SET

1532: hz_utility_pub.LAST_UPDATED_BY
1533: );
1534:
1535: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1536: UPDATE ozf_offers yt SET
1537: beneficiary_account_id=NUM_COL1_NEW_LIST(I)
1538: , LAST_UPDATE_DATE=SYSDATE
1539: , last_updated_by=arp_standard.profile.user_id
1540: , last_update_login=arp_standard.profile.last_update_login