APPS.DOM_SECURITY_PUB dependencies on HZ_PARTIES

Line 200: FROM hz_parties

196:
197: CURSOR get_party_type (cp_party_id NUMBER)
198: IS
199: SELECT party_type
200: FROM hz_parties
201: WHERE party_id=cp_party_id;
202:
203: BEGIN
204:

Line 387: l_party_type hz_parties.party_type%TYPE;

383: l_user_name VARCHAR2(30);
384: l_service_url VARCHAR2(100);
385: l_user_login VARCHAR2(30);
386: l_protocol VARCHAR2(30);
387: l_party_type hz_parties.party_type%TYPE;
388: get_attachments DYNAMIC_CUR;
389: l_dynamic_sql VARCHAR2(32767);
390: l_media_id NUMBER;
391: l_node_id NUMBER;

Line 442: FROM hz_parties

438: SELECT user_name INTO l_user_name
439: FROM FND_USER where person_party_id = p_party_ids(lcount);
440:
441: SELECT party_type INTO l_party_type
442: FROM hz_parties
443: WHERE party_id = p_party_ids(lcount);
444:
445: IF(l_party_type = 'PERSON') THEN
446: l_party_type := 'USER';

Line 721: l_party_type hz_parties.party_type%TYPE;

717: l_created_by NUMBER;
718: l_file_type VARCHAR2(10);
719: l_ocs_role_to_revoke VARCHAR2(30);
720: l_entity_name VARCHAR2(30);
721: l_party_type hz_parties.party_type%TYPE;
722: l_rows NUMBER := 0;
723:
724: BEGIN
725:

Line 792: FROM hz_parties

788: FROM fnd_user
789: WHERE user_id = l_created_by ;
790:
791: SELECT party_type INTO l_party_type
792: FROM hz_parties
793: WHERE party_id = p_party_ids(lcount);
794:
795: IF(l_party_type = 'PERSON') THEN
796: l_party_type := 'USER';

Line 915: l_grantee_type hz_parties.party_type%TYPE;

911: AND ((grants.parameter2=cp_change_line_id )
912: OR((grants.parameter2 IS NULL) AND (cp_change_line_id IS NULL))
913: );
914:
915: l_grantee_type hz_parties.party_type%TYPE;
916: l_grantee_key fnd_grants.grantee_key%TYPE;
917: l_instance_set_id fnd_grants.instance_set_id%TYPE;
918: l_instance_pk1_value fnd_grants.instance_pk1_value%TYPE;
919: l_dummy VARCHAR2(1);

Line 925: FROM hz_parties

921:
922: CURSOR get_party_type (cp_party_id NUMBER)
923: IS
924: SELECT party_type
925: FROM hz_parties
926: WHERE party_id=cp_party_id;
927:
928: BEGIN
929:

Line 974: l_party_type hz_parties.party_type%TYPE;

970: )
971: RETURN NUMBER
972: IS
973:
974: l_party_type hz_parties.party_type%TYPE;
975: l_count NUMBER := 0;
976:
977: CURSOR get_party_type (cp_party_id NUMBER)
978: IS

Line 980: FROM hz_parties

976:
977: CURSOR get_party_type (cp_party_id NUMBER)
978: IS
979: SELECT party_type
980: FROM hz_parties
981: WHERE party_id=cp_party_id;
982:
983: BEGIN
984: