APPS.OZF_ACCOUNT_MERGE_PKG dependencies on OZF_CUST_TRD_PRFLS

Line 1864: | Account merge procedure for the table, ozf_cust_trd_prfls

1860: |
1861: | PROCEDURE
1862: | merge_trade_profiles
1863: | DESCRIPTION :
1864: | Account merge procedure for the table, ozf_cust_trd_prfls
1865: |
1866: | NOTES:
1867: |
1868: |--------------------------------------------------------------*/

Line 1881: ozf_cust_trd_prfls.trade_profile_id%TYPE

1877: INDEX BY BINARY_INTEGER;
1878: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
1879:
1880: TYPE trade_profile_id_LIST_TYPE IS TABLE OF
1881: ozf_cust_trd_prfls.trade_profile_id%TYPE
1882: INDEX BY BINARY_INTEGER;
1883: PRIMARY_KEY_ID1_LIST trade_profile_id_LIST_TYPE;
1884:
1885: TYPE cust_account_id_LIST_TYPE IS TABLE OF

Line 1886: ozf_cust_trd_prfls.cust_account_id%TYPE

1882: INDEX BY BINARY_INTEGER;
1883: PRIMARY_KEY_ID1_LIST trade_profile_id_LIST_TYPE;
1884:
1885: TYPE cust_account_id_LIST_TYPE IS TABLE OF
1886: ozf_cust_trd_prfls.cust_account_id%TYPE
1887: INDEX BY BINARY_INTEGER;
1888: NUM_COL1_ORIG_LIST cust_account_id_LIST_TYPE;
1889: NUM_COL1_NEW_LIST cust_account_id_LIST_TYPE;
1890:

Line 1892: ozf_cust_trd_prfls.cust_acct_site_id%TYPE

1888: NUM_COL1_ORIG_LIST cust_account_id_LIST_TYPE;
1889: NUM_COL1_NEW_LIST cust_account_id_LIST_TYPE;
1890:
1891: TYPE cust_acct_site_id_LIST_TYPE IS TABLE OF
1892: ozf_cust_trd_prfls.cust_acct_site_id%TYPE
1893: INDEX BY BINARY_INTEGER;
1894: NUM_COL2_ORIG_LIST cust_acct_site_id_LIST_TYPE;
1895: NUM_COL2_NEW_LIST cust_acct_site_id_LIST_TYPE;
1896:

Line 1903: FROM ozf_cust_trd_prfls yt, ra_customer_merges m

1899: SELECT distinct CUSTOMER_MERGE_HEADER_ID
1900: ,trade_profile_id
1901: ,cust_account_id
1902: ,cust_acct_site_id
1903: FROM ozf_cust_trd_prfls yt, ra_customer_merges m
1904: WHERE (
1905: yt.cust_account_id = m.DUPLICATE_ID
1906: OR yt.cust_acct_site_id = m.DUPLICATE_SITE_ID
1907: ) AND m.process_flag = 'N'

Line 1917: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_cust_trd_prfls',FALSE);

1913: IF process_mode='LOCK' THEN
1914: NULL;
1915: ELSE
1916: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1917: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_cust_trd_prfls',FALSE);
1918: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1919: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1920:
1921: open merged_records;

Line 1958: 'ozf_cust_trd_prfls',

1954: LAST_UPDATE_LOGIN,
1955: LAST_UPDATE_DATE,
1956: LAST_UPDATED_BY
1957: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
1958: 'ozf_cust_trd_prfls',
1959: MERGE_HEADER_ID_LIST(I),
1960: PRIMARY_KEY_ID1_LIST(I),
1961: NUM_COL1_ORIG_LIST(I),
1962: NUM_COL1_NEW_LIST(I),

Line 1975: UPDATE ozf_cust_trd_prfls yt SET

1971: hz_utility_pub.LAST_UPDATED_BY
1972: );
1973:
1974: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1975: UPDATE ozf_cust_trd_prfls yt SET
1976: cust_account_id=NUM_COL1_NEW_LIST(I)
1977: ,cust_acct_site_id=NUM_COL2_NEW_LIST(I)
1978: , LAST_UPDATE_DATE=SYSDATE
1979: , last_updated_by=arp_standard.profile.user_id