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_PARTIES

Line 425: v_return hz_parties.party_name%type;

421: end;
422:
423: function get_cust_name(v_cust_id number) return varchar2 is
424:
425: v_return hz_parties.party_name%type;
426:
427: cursor c is
428: select b.party_name
429: from hz_cust_accounts a, hz_parties b

Line 429: from hz_cust_accounts a, hz_parties b

425: v_return hz_parties.party_name%type;
426:
427: cursor c is
428: select b.party_name
429: from hz_cust_accounts a, hz_parties b
430: where a.cust_account_id = v_cust_id
431: and a.party_id = b.party_id;
432:
433: begin

Line 445: v_return hz_parties.party_name%type;

441: end;
442:
443: function get_cust_contact_name(v_contact_id number) return varchar2 is
444:
445: v_return hz_parties.party_name%type;
446:
447: cursor c is
448: select b.person_first_name||' '||b.person_last_name
449: from hz_cust_account_roles a,

Line 450: hz_parties b,

446:
447: cursor c is
448: select b.person_first_name||' '||b.person_last_name
449: from hz_cust_account_roles a,
450: hz_parties b,
451: hz_relationships c
452: where a.cust_account_role_id = v_contact_id
453: and c.party_id =a.party_id
454: and c.subject_id = b.party_id

Line 455: and c.subject_table_name = 'HZ_PARTIES'

451: hz_relationships c
452: where a.cust_account_role_id = v_contact_id
453: and c.party_id =a.party_id
454: and c.subject_id = b.party_id
455: and c.subject_table_name = 'HZ_PARTIES'
456: and c.object_table_name = 'HZ_PARTIES'
457: and c.directional_flag = 'F';
458:
459: begin

Line 456: and c.object_table_name = 'HZ_PARTIES'

452: where a.cust_account_role_id = v_contact_id
453: and c.party_id =a.party_id
454: and c.subject_id = b.party_id
455: and c.subject_table_name = 'HZ_PARTIES'
456: and c.object_table_name = 'HZ_PARTIES'
457: and c.directional_flag = 'F';
458:
459: begin
460: if v_contact_id is not null then

Line 471: v_return hz_parties.party_name%type;

467: end;
468:
469: function get_party_name(v_party_id number) return varchar2 is
470:
471: v_return hz_parties.party_name%type;
472:
473: cursor c is
474: select b.party_name
475: from hz_parties b

Line 475: from hz_parties b

471: v_return hz_parties.party_name%type;
472:
473: cursor c is
474: select b.party_name
475: from hz_parties b
476: where b.party_id = v_party_id;
477:
478: begin
479: if v_party_id is not null then

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 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');

1021: system.ad_apps_private.get_apps_schema_name(
1022: 1, l_aol_schema, l_apps_schema, l_apps_mls_schema);
1023:
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');

Line 1044: | was already added to HZ_PARTIES,HZ_PERSON_PROFILES, |

1040: | drop_hcare_policy_function |
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: | |

Line 1103: FND_ACCESS_CONTROL_UTIL.DROP_POLICY(l_ar_schema, 'HZ_PARTIES', 'hcare_created_by_module_sec');

1099: system.ad_apps_private.get_apps_schema_name(
1100: 1, l_aol_schema, l_apps_schema, l_apps_mls_schema);
1101:
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');