APPS.OZF_ACCOUNT_MERGE_PKG dependencies on OZF_RETAIL_PRICE_POINTS

Line 1723: | Account merge procedure for the table, ozf_retail_price_points

1719: |
1720: | PROCEDURE
1721: | merge_retail_price_points
1722: | DESCRIPTION :
1723: | Account merge procedure for the table, ozf_retail_price_points
1724: |
1725: | NOTES:
1726: |
1727: |--------------------------------------------------------------*/

Line 1740: ozf_retail_price_points.retail_price_point_id%TYPE

1736: INDEX BY BINARY_INTEGER;
1737: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
1738:
1739: TYPE rp_point_id_LIST_TYPE IS TABLE OF
1740: ozf_retail_price_points.retail_price_point_id%TYPE
1741: INDEX BY BINARY_INTEGER;
1742: PRIMARY_KEY_ID1_LIST rp_point_id_LIST_TYPE;
1743:
1744: TYPE cust_account_id_LIST_TYPE IS TABLE OF

Line 1745: ozf_retail_price_points.cust_account_id%TYPE

1741: INDEX BY BINARY_INTEGER;
1742: PRIMARY_KEY_ID1_LIST rp_point_id_LIST_TYPE;
1743:
1744: TYPE cust_account_id_LIST_TYPE IS TABLE OF
1745: ozf_retail_price_points.cust_account_id%TYPE
1746: INDEX BY BINARY_INTEGER;
1747: NUM_COL1_ORIG_LIST cust_account_id_LIST_TYPE;
1748: NUM_COL1_NEW_LIST cust_account_id_LIST_TYPE;
1749:

Line 1751: ozf_retail_price_points.site_use_id%TYPE

1747: NUM_COL1_ORIG_LIST cust_account_id_LIST_TYPE;
1748: NUM_COL1_NEW_LIST cust_account_id_LIST_TYPE;
1749:
1750: TYPE site_use_id_LIST_TYPE IS TABLE OF
1751: ozf_retail_price_points.site_use_id%TYPE
1752: INDEX BY BINARY_INTEGER;
1753: NUM_COL2_ORIG_LIST site_use_id_LIST_TYPE;
1754: NUM_COL2_NEW_LIST site_use_id_LIST_TYPE;
1755:

Line 1762: FROM ozf_retail_price_points yt, ra_customer_merges m

1758: SELECT distinct CUSTOMER_MERGE_HEADER_ID
1759: ,retail_price_point_id
1760: ,cust_account_id
1761: ,site_use_id
1762: FROM ozf_retail_price_points yt, ra_customer_merges m
1763: WHERE (
1764: yt.cust_account_id = m.DUPLICATE_ADDRESS_ID
1765: OR yt.site_use_id = m.DUPLICATE_SITE_ID
1766: ) AND m.process_flag = 'N'

Line 1776: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_retail_price_points',FALSE);

1772: IF process_mode='LOCK' THEN
1773: NULL;
1774: ELSE
1775: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1776: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_retail_price_points',FALSE);
1777: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1778: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1779:
1780: open merged_records;

Line 1818: 'ozf_retail_price_points',

1814: LAST_UPDATE_LOGIN,
1815: LAST_UPDATE_DATE,
1816: LAST_UPDATED_BY
1817: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
1818: 'ozf_retail_price_points',
1819: MERGE_HEADER_ID_LIST(I),
1820: PRIMARY_KEY_ID1_LIST(I),
1821: NUM_COL1_ORIG_LIST(I),
1822: NUM_COL1_NEW_LIST(I),

Line 1835: UPDATE ozf_retail_price_points yt SET

1831: hz_utility_pub.LAST_UPDATED_BY
1832: );
1833:
1834: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1835: UPDATE ozf_retail_price_points yt SET
1836: cust_account_id=NUM_COL1_NEW_LIST(I)
1837: ,site_use_id=NUM_COL2_NEW_LIST(I)
1838: , LAST_UPDATE_DATE=SYSDATE
1839: , last_updated_by=arp_standard.profile.user_id