eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_PARTY_V2PUB dependencies on HZ_CUST_ACCT_SITES_ALL

Line 8830: | hz_cust_acct_sites_all with the NULL value |

8826: | update_party_search |
8827: | |
8828: | DESCRIPTION |
8829: | This procedure updates the address_text column of |
8830: | hz_cust_acct_sites_all with the NULL value |
8831: | only to change the address_text column status |
8832: | so that interMedia index can be created on it to perform text searches. |
8833: | |
8834: | NOTE :- After Calling this procedure the user has to execute the |

Line 8861: HZ_CUST_ACCT_SITES_ALL ac

8857: IS
8858: CURSOR c_cust_acct_sites(p_party_id NUMBER) IS
8859: SELECT ac.CUST_ACCT_SITE_ID
8860: FROM HZ_PARTIES p, HZ_CUST_ACCOUNTS c,
8861: HZ_CUST_ACCT_SITES_ALL ac
8862: WHERE p.party_id=p_party_id
8863: AND p.party_id = c.party_id
8864: AND c.cust_account_id = ac.cust_account_id;
8865: TYPE siteidtab IS TABLE OF HZ_CUST_ACCT_SITES_ALL.CUST_ACCT_SITE_ID%TYPE;

Line 8865: TYPE siteidtab IS TABLE OF HZ_CUST_ACCT_SITES_ALL.CUST_ACCT_SITE_ID%TYPE;

8861: HZ_CUST_ACCT_SITES_ALL ac
8862: WHERE p.party_id=p_party_id
8863: AND p.party_id = c.party_id
8864: AND c.cust_account_id = ac.cust_account_id;
8865: TYPE siteidtab IS TABLE OF HZ_CUST_ACCT_SITES_ALL.CUST_ACCT_SITE_ID%TYPE;
8866: l_siteidtab siteidtab;
8867:
8868: BEGIN
8869: SAVEPOINT update_party_search;

Line 8879: update HZ_CUST_ACCT_SITES_ALL set address_text=NULL where cust_acct_site_id=l_siteidtab(i);

8875: FETCH c_cust_acct_sites BULK COLLECT INTO l_siteidtab;
8876: CLOSE c_cust_acct_sites;
8877: IF l_siteidtab.COUNT >0 THEN
8878: FORALL i IN l_siteidtab.FIRST..l_siteidtab.LAST
8879: update HZ_CUST_ACCT_SITES_ALL set address_text=NULL where cust_acct_site_id=l_siteidtab(i);
8880: END IF;
8881: END IF;
8882: EXCEPTION
8883: WHEN OTHERS THEN

Line 8907: | hz_cust_acct_sites_all with the NULL value |

8903: | update_rel_person_search |
8904: | |
8905: | DESCRIPTION |
8906: | This procedure updates the address_text column of |
8907: | hz_cust_acct_sites_all with the NULL value |
8908: | only to change the address_text column status |
8909: | so that interMedia index can be created on it to perform text searches. |
8910: | |
8911: | NOTE :- After Calling this procedure the user has to execute the |

Line 8933: HZ_RELATIONSHIPS rel,HZ_CUST_ACCT_SITES_ALL ac

8929: ---(Party level relationship )
8930: CURSOR c_party_cust_acct_sites(p_party_id NUMBER) IS
8931: SELECT distinct ac.CUST_ACCT_SITE_ID
8932: FROM HZ_PARTIES p, HZ_CUST_ACCOUNT_ROLES ar,
8933: HZ_RELATIONSHIPS rel,HZ_CUST_ACCT_SITES_ALL ac
8934: WHERE rel.subject_id=p_party_id
8935: AND ar.ROLE_TYPE = 'CONTACT'
8936: AND rel.party_id=ar.party_id
8937: AND rel.subject_id=p.party_id

Line 8945: HZ_RELATIONSHIPS rel,HZ_CUST_ACCT_SITES_ALL ac

8941: ----(Site Level relationship)
8942: CURSOR c_site_cust_acct_sites(p_party_id NUMBER) IS
8943: SELECT distinct ac.CUST_ACCT_SITE_ID
8944: FROM HZ_PARTIES p, HZ_CUST_ACCOUNT_ROLES ar,
8945: HZ_RELATIONSHIPS rel,HZ_CUST_ACCT_SITES_ALL ac
8946: WHERE rel.subject_id=p_party_id
8947: AND ar.ROLE_TYPE = 'CONTACT'
8948: AND ar.party_id = rel.party_id
8949: AND p.party_id = rel.subject_id

Line 8953: TYPE siteidtab IS TABLE OF HZ_CUST_ACCT_SITES_ALL.CUST_ACCT_SITE_ID%TYPE;

8949: AND p.party_id = rel.subject_id
8950: AND ar.cust_account_id = ac.cust_account_id
8951: AND ar.cust_acct_site_id = ac.cust_acct_site_id;
8952:
8953: TYPE siteidtab IS TABLE OF HZ_CUST_ACCT_SITES_ALL.CUST_ACCT_SITE_ID%TYPE;
8954: l_siteidtab siteidtab;
8955:
8956: BEGIN
8957: SAVEPOINT update_rel_person_search;

Line 8967: update HZ_CUST_ACCT_SITES_ALL set address_text=NULL where cust_acct_site_id=l_siteidtab(i);

8963: FETCH c_party_cust_acct_sites BULK COLLECT INTO l_siteidtab;
8964: CLOSE c_party_cust_acct_sites;
8965: IF l_siteidtab.COUNT >0 THEN
8966: FORALL i IN l_siteidtab.FIRST..l_siteidtab.LAST
8967: update HZ_CUST_ACCT_SITES_ALL set address_text=NULL where cust_acct_site_id=l_siteidtab(i);
8968: END IF;
8969: ---Process site level relationship's records.
8970: OPEN c_site_cust_acct_sites(p_old_person_rec.party_rec.party_id);
8971: FETCH c_site_cust_acct_sites BULK COLLECT INTO l_siteidtab;

Line 8975: update HZ_CUST_ACCT_SITES_ALL set address_text=NULL where cust_acct_site_id=l_siteidtab(i);

8971: FETCH c_site_cust_acct_sites BULK COLLECT INTO l_siteidtab;
8972: CLOSE c_site_cust_acct_sites;
8973: IF l_siteidtab.COUNT >0 THEN
8974: FORALL i IN l_siteidtab.FIRST..l_siteidtab.LAST
8975: update HZ_CUST_ACCT_SITES_ALL set address_text=NULL where cust_acct_site_id=l_siteidtab(i);
8976: END IF;
8977: END IF;
8978: EXCEPTION
8979: WHEN OTHERS THEN