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

Line 38: CURSOR c_get_party_name(cp_party_id hz_parties.party_id%TYPE) IS

34: SELECT user_name
35: FROM fnd_user
36: WHERE user_id=cp_user_id;
37:
38: CURSOR c_get_party_name(cp_party_id hz_parties.party_id%TYPE) IS
39: SELECT party_name ,party_number,email_address
40: FROM hz_parties
41: WHERE party_id=cp_party_id;
42:

Line 40: FROM hz_parties

36: WHERE user_id=cp_user_id;
37:
38: CURSOR c_get_party_name(cp_party_id hz_parties.party_id%TYPE) IS
39: SELECT party_name ,party_number,email_address
40: FROM hz_parties
41: WHERE party_id=cp_party_id;
42:
43: -- Get the details of email of approver.
44: CURSOR c_get_approver_email(cp_user_name VARCHAR2) IS

Line 52: from hz_parties

48:
49: CURSOR c_get_req_dets(cp_req_id number)
50: is
51: select party_name, email_address
52: from hz_parties
53: where party_id=cp_req_id;
54:
55: -- get requestor fnd user_name
56: CURSOR c_get_req_fnd_user_name(cp_req_id number)

Line 63: l_party_id hz_parties.party_id%TYPE;

59: FROM fnd_user
60: WHERE PERSON_PARTY_ID=cp_req_id;
61:
62:
63: l_party_id hz_parties.party_id%TYPE;
64: l_user_id fnd_user.user_id%TYPE;
65: l_user_name fnd_user.user_name%TYPE;
66: l_email_address fnd_user.email_address%TYPE;
67: l_person_name hz_parties.party_name%TYPE;

Line 67: l_person_name hz_parties.party_name%TYPE;

63: l_party_id hz_parties.party_id%TYPE;
64: l_user_id fnd_user.user_id%TYPE;
65: l_user_name fnd_user.user_name%TYPE;
66: l_email_address fnd_user.email_address%TYPE;
67: l_person_name hz_parties.party_name%TYPE;
68: l_org hz_parties.party_name%TYPE;
69: l_approver_email fnd_user.email_address%TYPE;
70: l_item_key wf_items.item_key%TYPE;
71: l_classification_cd igp_ac_acc_classes.acc_classification_code%TYPE;

Line 68: l_org hz_parties.party_name%TYPE;

64: l_user_id fnd_user.user_id%TYPE;
65: l_user_name fnd_user.user_name%TYPE;
66: l_email_address fnd_user.email_address%TYPE;
67: l_person_name hz_parties.party_name%TYPE;
68: l_org hz_parties.party_name%TYPE;
69: l_approver_email fnd_user.email_address%TYPE;
70: l_item_key wf_items.item_key%TYPE;
71: l_classification_cd igp_ac_acc_classes.acc_classification_code%TYPE;
72: l_expiration_dt DATE;

Line 85: l_req_email hz_parties.email_address%TYPE;

81: l_url_part1 VARCHAR2(1000);
82: l_url_part2 VARCHAR2(1000);
83: l_url VARCHAR2(2000);
84: l_party_det c_get_party_name%ROWTYPE;
85: l_req_email hz_parties.email_address%TYPE;
86: c_get_req_dets_rec c_get_req_dets%ROWTYPE;
87: l_req_id number;
88:
89: BEGIN

Line 544: l_party_id hz_parties.party_id%TYPE;

540:
541: l_user_id fnd_user.user_id%TYPE;
542: l_user_name fnd_user.user_name%TYPE;
543: l_email_address fnd_user.email_address%TYPE;
544: l_party_id hz_parties.party_id%TYPE;
545: l_return_status VARCHAR2(1);
546: l_msg_count NUMBER;
547: l_msg_data VARCHAR2(2000);
548: l_user_password VARCHAR2(100);

Line 665: l_party_id hz_parties.party_id%TYPE;

661: l_resp NUMBER;
662: l_user_name fnd_user.user_name%TYPE;
663: l_user_id fnd_user.user_id%TYPE;
664: l_fnd_user_id fnd_user.user_id%TYPE;
665: l_party_id hz_parties.party_id%TYPE;
666: l_classification_cd igp_ac_acc_classes.acc_classification_code%TYPE;
667: l_account_id igp_ac_accounts.account_id%TYPE;
668: l_expiration_dt DATE;
669: l_desc fnd_responsibility_tl.description%TYPE;

Line 847: FROM hz_parties hz,igp_ac_accounts ac

843: resultout OUT NOCOPY VARCHAR2 )
844: IS
845: CURSOR c_get_per_details(cp_user_id NUMBER) IS
846: SELECT hz.party_name,hz.party_number
847: FROM hz_parties hz,igp_ac_accounts ac
848: WHERE ac.user_id=cp_user_id AND
849: ac.party_id=hz.party_id;
850:
851: CURSOR c_get_fnd_user(cp_user_id NUMBER) IS

Line 860: hz_parties hz,

856: CURSOR c_get_requestor_det(cp_req_id NUMBER) IS
857: SELECT hz.person_last_name||', '||hz.person_first_name req_name,
858: fu.email_address req_email
859: FROM
860: hz_parties hz,
861: fnd_user fu,
862: igp_ac_Accounts acc
863: WHERE
864: hz.party_id=cp_req_id AND

Line 875: l_requestor_id hz_parties.party_id%TYPE;

871: l_classcode igp_ac_acc_classes.acc_classification_code%TYPE;
872: l_expiry_dt DATE;
873: l_user_name fnd_user.user_name%TYPE;
874: c_get_per_details_rec c_get_per_details%ROWTYPE;
875: l_requestor_id hz_parties.party_id%TYPE;
876: l_requestor_name hz_parties.party_name%TYPE;
877: l_requestor_email fnd_user.email_address%TYPE;
878: l_href_mailto VARCHAR2(1000);
879: c_get_requestor_det_rec c_get_requestor_det%ROWTYPE;

Line 876: l_requestor_name hz_parties.party_name%TYPE;

872: l_expiry_dt DATE;
873: l_user_name fnd_user.user_name%TYPE;
874: c_get_per_details_rec c_get_per_details%ROWTYPE;
875: l_requestor_id hz_parties.party_id%TYPE;
876: l_requestor_name hz_parties.party_name%TYPE;
877: l_requestor_email fnd_user.email_address%TYPE;
878: l_href_mailto VARCHAR2(1000);
879: c_get_requestor_det_rec c_get_requestor_det%ROWTYPE;
880: