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 280: l_grantee_type hz_parties.party_type%TYPE;

276: )
277: IS
278:
279: --x_grant_guid fnd_grants.grant_guid%TYPE;
280: l_grantee_type hz_parties.party_type%TYPE;
281: l_instance_type fnd_grants.instance_type%TYPE;
282: l_grantee_key fnd_grants.grantee_key%TYPE;
283: l_dummy VARCHAR2(1);
284: l_msg_count NUMBER;

Line 288: FROM hz_parties

284: l_msg_count NUMBER;
285: l_msg_data VARCHAR2(4000);
286: CURSOR get_party_type (cp_party_id NUMBER) IS
287: SELECT party_type
288: FROM hz_parties
289: WHERE party_id=cp_party_id;
290:
291: CURSOR check_fnd_grant_exist (cp_grantee_key VARCHAR2,
292: cp_grantee_type VARCHAR2,

Line 841: FROM hz_parties

837: l_index INTEGER;
838: CURSOR get_party_type (cp_party_id NUMBER)
839: IS
840: SELECT party_type
841: FROM hz_parties
842: WHERE party_id=cp_party_id;
843:
844: CURSOR get_object_privileges(cp_object_name VARCHAR2) IS
845: select function_name

Line 1635: l_grantee_type hz_parties.party_type%TYPE;

1631: AND (( grants.end_date IS NULL) OR (cp_start_date <=grants.end_date )))
1632: OR ((grants.start_date >= cp_start_date )
1633: AND (( cp_end_date IS NULL) OR (cp_end_date >=grants.start_date))));
1634:
1635: l_grantee_type hz_parties.party_type%TYPE;
1636: l_grantee_key fnd_grants.grantee_key%TYPE;
1637: l_instance_set_id fnd_grants.instance_set_id%TYPE;
1638: l_instance_pk1_value fnd_grants.instance_pk1_value%TYPE;
1639: l_dummy VARCHAR2(1);

Line 1643: FROM hz_parties

1639: l_dummy VARCHAR2(1);
1640: CURSOR get_party_type (cp_party_id NUMBER)
1641: IS
1642: SELECT party_type
1643: FROM hz_parties
1644: WHERE party_id=cp_party_id;
1645:
1646:
1647: BEGIN

Line 1789: l_grantee_type hz_parties.party_type%TYPE;

1785: AND (( grants.end_date IS NULL) OR (cp_start_date <=grants.end_date )))
1786: OR ((grants.start_date >= cp_start_date )
1787: AND (( cp_end_date IS NULL) OR (cp_end_date >=grants.start_date))));
1788:
1789: l_grantee_type hz_parties.party_type%TYPE;
1790: l_grantee_key fnd_grants.grantee_key%TYPE;
1791: l_instance_set_id fnd_grants.instance_set_id%TYPE;
1792: l_instance_pk1_value fnd_grants.instance_pk1_value%TYPE;
1793: l_dummy VARCHAR2(1);

Line 1798: FROM hz_parties

1794:
1795: CURSOR get_party_type (cp_party_id NUMBER)
1796: IS
1797: SELECT party_type
1798: FROM hz_parties
1799: WHERE party_id=cp_party_id;
1800:
1801: BEGIN
1802: