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 8942: | hz_cust_acct_sites_all with the NULL value |

8938: | update_party_search |
8939: | |
8940: | DESCRIPTION |
8941: | This procedure updates the address_text column of |
8942: | hz_cust_acct_sites_all with the NULL value |
8943: | only to change the address_text column status |
8944: | so that interMedia index can be created on it to perform text searches. |
8945: | |
8946: | NOTE :- After Calling this procedure the user has to execute the |

Line 8973: HZ_CUST_ACCT_SITES_ALL ac

8969: IS
8970: CURSOR c_cust_acct_sites(p_party_id NUMBER) IS
8971: SELECT ac.CUST_ACCT_SITE_ID
8972: FROM HZ_PARTIES p, HZ_CUST_ACCOUNTS c,
8973: HZ_CUST_ACCT_SITES_ALL ac
8974: WHERE p.party_id=p_party_id
8975: AND p.party_id = c.party_id
8976: AND c.cust_account_id = ac.cust_account_id;
8977: TYPE siteidtab IS TABLE OF HZ_CUST_ACCT_SITES_ALL.CUST_ACCT_SITE_ID%TYPE;

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

8973: HZ_CUST_ACCT_SITES_ALL ac
8974: WHERE p.party_id=p_party_id
8975: AND p.party_id = c.party_id
8976: AND c.cust_account_id = ac.cust_account_id;
8977: TYPE siteidtab IS TABLE OF HZ_CUST_ACCT_SITES_ALL.CUST_ACCT_SITE_ID%TYPE;
8978: l_siteidtab siteidtab;
8979:
8980: BEGIN
8981: SAVEPOINT update_party_search;

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

8987: FETCH c_cust_acct_sites BULK COLLECT INTO l_siteidtab;
8988: CLOSE c_cust_acct_sites;
8989: IF l_siteidtab.COUNT >0 THEN
8990: FORALL i IN l_siteidtab.FIRST..l_siteidtab.LAST
8991: update HZ_CUST_ACCT_SITES_ALL set address_text=NULL where cust_acct_site_id=l_siteidtab(i);
8992: END IF;
8993: END IF;
8994: EXCEPTION
8995: WHEN OTHERS THEN

Line 9019: | hz_cust_acct_sites_all with the NULL value |

9015: | update_rel_person_search |
9016: | |
9017: | DESCRIPTION |
9018: | This procedure updates the address_text column of |
9019: | hz_cust_acct_sites_all with the NULL value |
9020: | only to change the address_text column status |
9021: | so that interMedia index can be created on it to perform text searches. |
9022: | |
9023: | NOTE :- After Calling this procedure the user has to execute the |

Line 9045: HZ_RELATIONSHIPS rel,HZ_CUST_ACCT_SITES_ALL ac

9041: ---(Party level relationship )
9042: CURSOR c_party_cust_acct_sites(p_party_id NUMBER) IS
9043: SELECT distinct ac.CUST_ACCT_SITE_ID
9044: FROM HZ_PARTIES p, HZ_CUST_ACCOUNT_ROLES ar,
9045: HZ_RELATIONSHIPS rel,HZ_CUST_ACCT_SITES_ALL ac
9046: WHERE rel.subject_id=p_party_id
9047: AND ar.ROLE_TYPE = 'CONTACT'
9048: AND rel.party_id=ar.party_id
9049: AND rel.subject_id=p.party_id

Line 9057: HZ_RELATIONSHIPS rel,HZ_CUST_ACCT_SITES_ALL ac

9053: ----(Site Level relationship)
9054: CURSOR c_site_cust_acct_sites(p_party_id NUMBER) IS
9055: SELECT distinct ac.CUST_ACCT_SITE_ID
9056: FROM HZ_PARTIES p, HZ_CUST_ACCOUNT_ROLES ar,
9057: HZ_RELATIONSHIPS rel,HZ_CUST_ACCT_SITES_ALL ac
9058: WHERE rel.subject_id=p_party_id
9059: AND ar.ROLE_TYPE = 'CONTACT'
9060: AND ar.party_id = rel.party_id
9061: AND p.party_id = rel.subject_id

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

9061: AND p.party_id = rel.subject_id
9062: AND ar.cust_account_id = ac.cust_account_id
9063: AND ar.cust_acct_site_id = ac.cust_acct_site_id;
9064:
9065: TYPE siteidtab IS TABLE OF HZ_CUST_ACCT_SITES_ALL.CUST_ACCT_SITE_ID%TYPE;
9066: l_siteidtab siteidtab;
9067:
9068: BEGIN
9069: SAVEPOINT update_rel_person_search;

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

9075: FETCH c_party_cust_acct_sites BULK COLLECT INTO l_siteidtab;
9076: CLOSE c_party_cust_acct_sites;
9077: IF l_siteidtab.COUNT >0 THEN
9078: FORALL i IN l_siteidtab.FIRST..l_siteidtab.LAST
9079: update HZ_CUST_ACCT_SITES_ALL set address_text=NULL where cust_acct_site_id=l_siteidtab(i);
9080: END IF;
9081: ---Process site level relationship's records.
9082: OPEN c_site_cust_acct_sites(p_old_person_rec.party_rec.party_id);
9083: FETCH c_site_cust_acct_sites BULK COLLECT INTO l_siteidtab;

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

9083: FETCH c_site_cust_acct_sites BULK COLLECT INTO l_siteidtab;
9084: CLOSE c_site_cust_acct_sites;
9085: IF l_siteidtab.COUNT >0 THEN
9086: FORALL i IN l_siteidtab.FIRST..l_siteidtab.LAST
9087: update HZ_CUST_ACCT_SITES_ALL set address_text=NULL where cust_acct_site_id=l_siteidtab(i);
9088: END IF;
9089: END IF;
9090: EXCEPTION
9091: WHEN OTHERS THEN