APPS.EGO_SECURITY_PUB dependencies on HZ_PARTIES

Line 71: l_grantee_type hz_parties.party_type%TYPE;

67: )
68: IS
69:
70: x_grant_guid fnd_grants.grant_guid%TYPE;
71: l_grantee_type hz_parties.party_type%TYPE;
72: l_instance_type fnd_grants.instance_type%TYPE;
73: l_grantee_key fnd_grants.grantee_key%TYPE;
74: l_dummy VARCHAR2(1);
75: CURSOR get_party_type (cp_party_id NUMBER)

Line 78: FROM hz_parties

74: l_dummy VARCHAR2(1);
75: CURSOR get_party_type (cp_party_id NUMBER)
76: IS
77: SELECT party_type
78: FROM hz_parties
79: WHERE party_id=cp_party_id;
80:
81: CURSOR check_fnd_grant_exist (cp_grantee_key VARCHAR2,
82: cp_grantee_type VARCHAR2,

Line 305: l_grantee_type hz_parties.party_type%TYPE;

301: )
302: IS
303:
304: --x_grant_guid fnd_grants.grant_guid%TYPE;
305: l_grantee_type hz_parties.party_type%TYPE;
306: l_instance_type fnd_grants.instance_type%TYPE;
307: l_grantee_key fnd_grants.grantee_key%TYPE;
308: l_dummy VARCHAR2(1);
309: l_msg_count NUMBER;

Line 313: FROM hz_parties

309: l_msg_count NUMBER;
310: l_msg_data VARCHAR2(4000);
311: CURSOR get_party_type (cp_party_id NUMBER) IS
312: SELECT party_type
313: FROM hz_parties
314: WHERE party_id=cp_party_id;
315:
316: CURSOR check_fnd_grant_exist (cp_grantee_key VARCHAR2,
317: cp_grantee_type VARCHAR2,

Line 896: FROM hz_parties

892: l_index INTEGER;
893: CURSOR get_party_type (cp_party_id NUMBER)
894: IS
895: SELECT party_type
896: FROM hz_parties
897: WHERE party_id=cp_party_id;
898:
899: CURSOR get_object_privileges(cp_object_name VARCHAR2) IS
900: select function_name

Line 1721: l_grantee_type hz_parties.party_type%TYPE;

1717:
1718:
1719:
1720:
1721: l_grantee_type hz_parties.party_type%TYPE;
1722: l_grantee_key fnd_grants.grantee_key%TYPE;
1723: l_instance_set_id fnd_grants.instance_set_id%TYPE;
1724: l_instance_pk1_value fnd_grants.instance_pk1_value%TYPE;
1725: l_dummy VARCHAR2(1);

Line 1729: FROM hz_parties

1725: l_dummy VARCHAR2(1);
1726: CURSOR get_party_type (cp_party_id NUMBER)
1727: IS
1728: SELECT party_type
1729: FROM hz_parties
1730: WHERE party_id=cp_party_id;
1731:
1732:
1733: BEGIN

Line 1875: l_grantee_type hz_parties.party_type%TYPE;

1871: AND (( grants.end_date IS NULL) OR (cp_start_date <=grants.end_date )))
1872: OR ((grants.start_date >= cp_start_date )
1873: AND (( cp_end_date IS NULL) OR (cp_end_date >=grants.start_date))));
1874:
1875: l_grantee_type hz_parties.party_type%TYPE;
1876: l_grantee_key fnd_grants.grantee_key%TYPE;
1877: l_instance_set_id fnd_grants.instance_set_id%TYPE;
1878: l_instance_pk1_value fnd_grants.instance_pk1_value%TYPE;
1879: l_dummy VARCHAR2(1);

Line 1884: FROM hz_parties

1880:
1881: CURSOR get_party_type (cp_party_id NUMBER)
1882: IS
1883: SELECT party_type
1884: FROM hz_parties
1885: WHERE party_id=cp_party_id;
1886:
1887: BEGIN
1888: