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.

[Home] [Help]

APPS.HZ_COMMON_PUB dependencies on HZ_PARTIES

Line 423: v_return hz_parties.party_name%type;

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

Line 427: from hz_cust_accounts a, hz_parties b

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

Line 443: v_return hz_parties.party_name%type;

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

Line 448: hz_parties b,

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

Line 453: and c.subject_table_name = 'HZ_PARTIES'

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

Line 454: and c.object_table_name = 'HZ_PARTIES'

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

Line 469: v_return hz_parties.party_name%type;

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

Line 473: from hz_parties b

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

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

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

Line 1023: 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');

1019: system.ad_apps_private.get_apps_schema_name(
1020: 1, l_aol_schema, l_apps_schema, l_apps_mls_schema);
1021:
1022: --Add policy functions
1023: 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');
1024: 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');
1025: 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');
1026: 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');
1027: 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 1042: | was already added to HZ_PARTIES,HZ_PERSON_PROFILES, |

1038: | drop_hcare_policy_function |
1039: | |
1040: | DESCRIPTION |
1041: | Drops the hcare_created_by_module_sec policy function which |
1042: | was already added to HZ_PARTIES,HZ_PERSON_PROFILES, |
1043: | HZ_LOCATIONS,HZ_PARTY_SITES,HZ_PARTY_SITE_USES,HZ_CITIZENSHIP, |
1044: | HZ_PERSON_LANGUAGE and HZ_CONTACT_POINTS. |
1045: | |
1046: | |

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

1097: system.ad_apps_private.get_apps_schema_name(
1098: 1, l_aol_schema, l_apps_schema, l_apps_mls_schema);
1099:
1100: --Drop policy functions
1101: FND_ACCESS_CONTROL_UTIL.DROP_POLICY(l_ar_schema, 'HZ_PARTIES', 'hcare_created_by_module_sec');
1102: FND_ACCESS_CONTROL_UTIL.DROP_POLICY(l_ar_schema, 'HZ_PERSON_PROFILES', 'hcare_created_by_module_sec');
1103: FND_ACCESS_CONTROL_UTIL.DROP_POLICY(l_ar_schema, 'HZ_LOCATIONS', 'hcare_created_by_module_sec');
1104: FND_ACCESS_CONTROL_UTIL.DROP_POLICY(l_ar_schema, 'HZ_PARTY_SITES', 'hcare_created_by_module_sec');
1105: FND_ACCESS_CONTROL_UTIL.DROP_POLICY(l_ar_schema, 'HZ_PARTY_SITE_USES', 'hcare_created_by_module_sec');