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.QA_SECURITY_PKG dependencies on HZ_PARTIES

Line 364: FROM hz_parties

360: v_person.person_first_name := p_fname;
361: v_person.party_rec.party_id := p_party_id;
362:
363: SELECT object_version_number INTO v_object_version
364: FROM hz_parties
365: WHERE party_id = p_party_id;
366:
367: hz_party_v2pub.update_person (
368: p_person_rec => v_person,

Line 401: FROM hz_parties

397: v_grp.group_type := c_app_name;
398: v_grp.party_rec.party_id := p_party_id;
399:
400: SELECT object_version_number INTO v_object_version
401: FROM hz_parties
402: WHERE party_id = p_party_id;
403:
404: hz_party_v2pub.update_group (
405: p_group_rec => v_grp,

Line 425: v_party_number HZ_PARTIES.PARTY_NUMBER%TYPE;

421: -- bso Thu Jul 14 13:55:27 PDT 2005
422: --
423: v_grp hz_party_v2pub.group_rec_type;
424: v_msg_count NUMBER;
425: v_party_number HZ_PARTIES.PARTY_NUMBER%TYPE;
426:
427: begin
428:
429: v_grp.group_name := p_group_name;

Line 456: v_party_number HZ_PARTIES.PARTY_NUMBER%TYPE;

452: -- bso Thu Jul 14 13:55:27 PDT 2005
453: --
454: v_person hz_party_v2pub.person_rec_type;
455: v_msg_count NUMBER;
456: v_party_number HZ_PARTIES.PARTY_NUMBER%TYPE;
457: v_profile_id NUMBER;
458: begin
459:
460: v_person.created_by_module := c_module_name;

Line 487: v_party_number HZ_PARTIES.PARTY_NUMBER%TYPE;

483: -- R12 ER 2648803/4614568. Rewritten to use TCA V2 APIs.
484: -- bso Fri Sep 16 13:33:01 PDT 2005
485: v_rel hz_relationship_v2pub.relationship_rec_type;
486: v_msg_count NUMBER;
487: v_party_number HZ_PARTIES.PARTY_NUMBER%TYPE;
488: v_profile_id NUMBER;
489: begin
490:
491: v_rel.subject_id := P_SUBJECT_ID;

Line 493: v_rel.subject_table_name := 'HZ_PARTIES';

489: begin
490:
491: v_rel.subject_id := P_SUBJECT_ID;
492: v_rel.subject_type := 'PERSON';
493: v_rel.subject_table_name := 'HZ_PARTIES';
494: v_rel.object_id := P_OBJECT_ID;
495: v_rel.object_type := 'GROUP';
496: v_rel.object_table_name := 'HZ_PARTIES';
497: v_rel.relationship_code := 'MEMBER_OF';

Line 496: v_rel.object_table_name := 'HZ_PARTIES';

492: v_rel.subject_type := 'PERSON';
493: v_rel.subject_table_name := 'HZ_PARTIES';
494: v_rel.object_id := P_OBJECT_ID;
495: v_rel.object_type := 'GROUP';
496: v_rel.object_table_name := 'HZ_PARTIES';
497: v_rel.relationship_code := 'MEMBER_OF';
498: v_rel.relationship_type := 'MEMBERSHIP';
499: v_rel.start_date := sysdate;
500: v_rel.created_by_module := c_module_name;

Line 556: -- from HZ_Parties table. It is used by

552:
553: --
554: -- Bug 4057596
555: -- Selecting the object version number
556: -- from HZ_Parties table. It is used by
557: -- the TCA procedure to detect locking issues
558: -- ntungare Wed Aug 2 00:29:49 PDT 2006
559: --
560: SELECT object_version_number

Line 562: FROM hz_parties

558: -- ntungare Wed Aug 2 00:29:49 PDT 2006
559: --
560: SELECT object_version_number
561: INTO l_dummy_party_object_ver
562: FROM hz_parties
563: WHERE party_id = p_party_id;
564:
565: hz_relationship_v2pub.update_relationship (
566: p_relationship_rec => l_rel_rec,