APPS.OZF_ACCOUNT_MERGE_PKG dependencies on OZF_REQUEST_HEADERS_ALL_B

Line 1564: | Account merge procedure for the table, ozf_request_headers_all_b

1560: |
1561: | PROCEDURE
1562: | merge_request_header
1563: | DESCRIPTION :
1564: | Account merge procedure for the table, ozf_request_headers_all_b
1565: |
1566: | NOTES:
1567: |
1568: |--------------------------------------------------------------*/

Line 1581: ozf_request_headers_all_b.request_header_id%TYPE

1577: INDEX BY BINARY_INTEGER;
1578: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
1579:
1580: TYPE request_header_id_LIST_TYPE IS TABLE OF
1581: ozf_request_headers_all_b.request_header_id%TYPE
1582: INDEX BY BINARY_INTEGER;
1583: PRIMARY_KEY_ID1_LIST request_header_id_LIST_TYPE;
1584:
1585: TYPE reseller_site_use_id_LIST_TYPE IS TABLE OF

Line 1586: ozf_request_headers_all_b.reseller_site_use_id%TYPE

1582: INDEX BY BINARY_INTEGER;
1583: PRIMARY_KEY_ID1_LIST request_header_id_LIST_TYPE;
1584:
1585: TYPE reseller_site_use_id_LIST_TYPE IS TABLE OF
1586: ozf_request_headers_all_b.reseller_site_use_id%TYPE
1587: INDEX BY BINARY_INTEGER;
1588: NUM_COL1_ORIG_LIST reseller_site_use_id_LIST_TYPE;
1589: NUM_COL1_NEW_LIST reseller_site_use_id_LIST_TYPE;
1590:

Line 1592: ozf_request_headers_all_b.end_cust_site_use_id%TYPE

1588: NUM_COL1_ORIG_LIST reseller_site_use_id_LIST_TYPE;
1589: NUM_COL1_NEW_LIST reseller_site_use_id_LIST_TYPE;
1590:
1591: TYPE end_cust_site_use_id_LIST_TYPE IS TABLE OF
1592: ozf_request_headers_all_b.end_cust_site_use_id%TYPE
1593: INDEX BY BINARY_INTEGER;
1594: NUM_COL2_ORIG_LIST end_cust_site_use_id_LIST_TYPE;
1595: NUM_COL2_NEW_LIST end_cust_site_use_id_LIST_TYPE;
1596:

Line 1598: ozf_request_headers_all_b.partner_site_use_id%TYPE

1594: NUM_COL2_ORIG_LIST end_cust_site_use_id_LIST_TYPE;
1595: NUM_COL2_NEW_LIST end_cust_site_use_id_LIST_TYPE;
1596:
1597: TYPE partner_site_use_id_LIST_TYPE IS TABLE OF
1598: ozf_request_headers_all_b.partner_site_use_id%TYPE
1599: INDEX BY BINARY_INTEGER;
1600: NUM_COL3_ORIG_LIST partner_site_use_id_LIST_TYPE;
1601: NUM_COL3_NEW_LIST partner_site_use_id_LIST_TYPE;
1602:

Line 1610: FROM ozf_request_headers_all_b yt, ra_customer_merges m

1606: ,request_header_id
1607: ,reseller_site_use_id
1608: ,end_cust_site_use_id
1609: ,partner_site_use_id
1610: FROM ozf_request_headers_all_b yt, ra_customer_merges m
1611: WHERE (
1612: yt.reseller_site_use_id = m.DUPLICATE_SITE_ID
1613: OR yt.end_cust_site_use_id = m.DUPLICATE_SITE_ID
1614: OR yt.partner_site_use_id = m.DUPLICATE_SITE_ID

Line 1625: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_request_headers_all_b',FALSE);

1621: IF process_mode='LOCK' THEN
1622: NULL;
1623: ELSE
1624: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1625: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_request_headers_all_b',FALSE);
1626: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1627: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1628:
1629: open merged_records;

Line 1670: 'ozf_request_headers_all_b',

1666: LAST_UPDATE_LOGIN,
1667: LAST_UPDATE_DATE,
1668: LAST_UPDATED_BY
1669: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
1670: 'ozf_request_headers_all_b',
1671: MERGE_HEADER_ID_LIST(I),
1672: PRIMARY_KEY_ID1_LIST(I),
1673: NUM_COL1_ORIG_LIST(I),
1674: NUM_COL1_NEW_LIST(I),

Line 1689: UPDATE ozf_request_headers_all_b yt SET

1685: hz_utility_pub.LAST_UPDATED_BY
1686: );
1687:
1688: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1689: UPDATE ozf_request_headers_all_b yt SET
1690: reseller_site_use_id=NUM_COL1_NEW_LIST(I)
1691: ,end_cust_site_use_id=NUM_COL2_NEW_LIST(I)
1692: ,partner_site_use_id=NUM_COL3_NEW_LIST(I)
1693: , LAST_UPDATE_DATE=SYSDATE