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_COMMON_PUB dependencies on HZ_PARTY_SITES

Line 313: FROM hz_party_sites

309: WHILE l_count > 0 LOOP
310: SELECT to_char(hz_party_site_number_s.nextval)
311: INTO l_party_site_number FROM dual;
312: SELECT COUNT(*) INTO l_count
313: FROM hz_party_sites
314: WHERE party_site_number = l_party_site_number;
315:
316: END LOOP;
317: RETURN l_party_site_number;

Line 357: IF p_object_name = 'HZ_PARTY_SITES' THEN

353: -- END IF;
354: */
355: /* Bug 2780113- fix for DNB hierarchy project */
356: /*
357: IF p_object_name = 'HZ_PARTY_SITES' THEN
358: l_predicate := 'actual_content_source NOT IN ('||l_not_data_source||')';
359: ELSE
360: l_predicate := 'NVL(actual_content_source,content_source_type) NOT IN ('||l_not_data_source||')';
361: END IF;

Line 407: from hz_cust_acct_sites_all a, hz_party_sites b, hz_locations c,fnd_territories_vl d

403: DECODE(c.ADDRESS1, NULL, NULL, ', ') || c.CITY || DECODE(c.CITY,
404: NULL, NULL, ', ') || c.STATE || DECODE(c.STATE, NULL, NULL, ' ') ||
405: c.POSTAL_CODE || DECODE(d.TERRITORY_SHORT_NAME, NULL, NULL, ', ')
406: || d.TERRITORY_SHORT_NAME
407: from hz_cust_acct_sites_all a, hz_party_sites b, hz_locations c,fnd_territories_vl d
408: where a.party_site_id =b.party_site_id
409: and b.location_id = c.location_id
410: and d.territory_code = c.country
411: and a.cust_acct_site_id = v_address_id;

Line 968: | HZ_PARTIES,HZ_PERSON_PROFILES,HZ_LOCATIONS,HZ_PARTY_SITES, |

964: | add_hcare_policy_function |
965: | |
966: | DESCRIPTION |
967: | Adds the hcare_created_by_module_sec policy function to |
968: | HZ_PARTIES,HZ_PERSON_PROFILES,HZ_LOCATIONS,HZ_PARTY_SITES, |
969: | HZ_PARTY_SITE_USES,HZ_CITIZENSHIP,HZ_PERSON_LANGUAGE and |
970: | HZ_CONTACT_POINTS. |
971: | |
972: | SCOPE - PUBLIC |

Line 1028: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_PARTY_SITES', 'hcare_created_by_module_sec', l_apps_schema, 'hz_common_pub.hcare_created_by_module_sec');

1024: --Add policy functions
1025: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_PARTIES', 'hcare_created_by_module_sec', l_apps_schema, 'hz_common_pub.hcare_created_by_module_sec');
1026: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_PERSON_PROFILES', 'hcare_created_by_module_sec', l_apps_schema, 'hz_common_pub.hcare_created_by_module_sec');
1027: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_LOCATIONS', 'hcare_created_by_module_sec', l_apps_schema, 'hz_common_pub.hcare_created_by_module_sec');
1028: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_PARTY_SITES', 'hcare_created_by_module_sec', l_apps_schema, 'hz_common_pub.hcare_created_by_module_sec');
1029: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_PARTY_SITE_USES', 'hcare_created_by_module_sec', l_apps_schema, 'hz_common_pub.hcare_created_by_module_sec');
1030: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_CITIZENSHIP', 'hcare_created_by_module_sec', l_apps_schema, 'hz_common_pub.hcare_created_by_module_sec');
1031: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_PERSON_LANGUAGE','hcare_created_by_module_sec', l_apps_schema, 'hz_common_pub.hcare_created_by_module_sec');
1032: FND_ACCESS_CONTROL_UTIL.ADD_POLICY(l_ar_schema, 'HZ_CONTACT_POINTS', 'hcare_created_by_module_sec', l_apps_schema, 'hz_common_pub.hcare_created_by_module_sec');

Line 1045: | HZ_LOCATIONS,HZ_PARTY_SITES,HZ_PARTY_SITE_USES,HZ_CITIZENSHIP, |

1041: | |
1042: | DESCRIPTION |
1043: | Drops the hcare_created_by_module_sec policy function which |
1044: | was already added to HZ_PARTIES,HZ_PERSON_PROFILES, |
1045: | HZ_LOCATIONS,HZ_PARTY_SITES,HZ_PARTY_SITE_USES,HZ_CITIZENSHIP, |
1046: | HZ_PERSON_LANGUAGE and HZ_CONTACT_POINTS. |
1047: | |
1048: | |
1049: | SCOPE - PUBLIC |

Line 1106: FND_ACCESS_CONTROL_UTIL.DROP_POLICY(l_ar_schema, 'HZ_PARTY_SITES', 'hcare_created_by_module_sec');

1102: --Drop policy functions
1103: FND_ACCESS_CONTROL_UTIL.DROP_POLICY(l_ar_schema, 'HZ_PARTIES', 'hcare_created_by_module_sec');
1104: FND_ACCESS_CONTROL_UTIL.DROP_POLICY(l_ar_schema, 'HZ_PERSON_PROFILES', 'hcare_created_by_module_sec');
1105: FND_ACCESS_CONTROL_UTIL.DROP_POLICY(l_ar_schema, 'HZ_LOCATIONS', 'hcare_created_by_module_sec');
1106: FND_ACCESS_CONTROL_UTIL.DROP_POLICY(l_ar_schema, 'HZ_PARTY_SITES', 'hcare_created_by_module_sec');
1107: FND_ACCESS_CONTROL_UTIL.DROP_POLICY(l_ar_schema, 'HZ_PARTY_SITE_USES', 'hcare_created_by_module_sec');
1108: FND_ACCESS_CONTROL_UTIL.DROP_POLICY(l_ar_schema, 'HZ_CITIZENSHIP', 'hcare_created_by_module_sec');
1109: FND_ACCESS_CONTROL_UTIL.DROP_POLICY(l_ar_schema, 'HZ_PERSON_LANGUAGE','hcare_created_by_module_sec');
1110: FND_ACCESS_CONTROL_UTIL.DROP_POLICY(l_ar_schema, 'HZ_CONTACT_POINTS', 'hcare_created_by_module_sec');