APPS.IGS_PE_GEN_001 dependencies on HZ_PARTIES

Line 39: p_person_id OUT NOCOPY hz_parties.party_id%TYPE,

35: */
36:
37: PROCEDURE get_hold_auth
38: (p_fnd_user_id IN fnd_user.user_id%TYPE,
39: p_person_id OUT NOCOPY hz_parties.party_id%TYPE,
40: p_person_number OUT NOCOPY hz_parties.party_number%TYPE,
41: p_person_name OUT NOCOPY hz_person_profiles.person_name%TYPE,
42: p_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE
43: );

Line 40: p_person_number OUT NOCOPY hz_parties.party_number%TYPE,

36:
37: PROCEDURE get_hold_auth
38: (p_fnd_user_id IN fnd_user.user_id%TYPE,
39: p_person_id OUT NOCOPY hz_parties.party_id%TYPE,
40: p_person_number OUT NOCOPY hz_parties.party_number%TYPE,
41: p_person_name OUT NOCOPY hz_person_profiles.person_name%TYPE,
42: p_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE
43: );
44:

Line 57: p_person_id IN hz_parties.party_id%TYPE,

53: */
54: PROCEDURE validate_hold_resp
55: (p_resp_id IN fnd_responsibility.responsibility_id%TYPE,
56: p_fnd_user_id IN fnd_user.user_id%TYPE,
57: p_person_id IN hz_parties.party_id%TYPE,
58: p_encumbrance_type IN igs_pe_pers_encumb.encumbrance_type%TYPE,
59: p_start_dt IN igs_pe_pers_encumb.start_dt%TYPE,
60: p_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE
61: );

Line 79: p_person_id IN hz_parties.party_id%TYPE,

75: */
76: PROCEDURE release_hold
77: (p_resp_id IN fnd_responsibility.responsibility_id%TYPE,
78: p_fnd_user_id IN fnd_user.user_id%TYPE,
79: p_person_id IN hz_parties.party_id%TYPE,
80: p_encumbrance_type IN igs_pe_pers_encumb.encumbrance_type%TYPE,
81: p_start_dt IN igs_pe_pers_encumb.start_dt%TYPE,
82: p_expiry_dt IN igs_pe_pers_encumb.expiry_dt%TYPE,
83: p_override_resp IN VARCHAR2 DEFAULT 'Y',

Line 88: p_person_id hz_parties.party_id%TYPE,

84: p_comments IN igs_pe_pers_encumb.comments%TYPE DEFAULT NULL,
85: p_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE
86: );
87: FUNCTION Get_Res_Status (
88: p_person_id hz_parties.party_id%TYPE,
89: p_residency_class igs_pe_res_dtls_all.residency_class_cd%TYPE,
90: p_cal_type igs_ca_inst.cal_type%TYPE,
91: p_sequence_number igs_ca_inst.sequence_number%TYPE
92: ) RETURN VARCHAR2 ;

Line 97: FUNCTION Get_Hold_Count(p_person_id IN hz_parties.party_id%TYPE ) RETURN NUMBER;

93:
94: FUNCTION GET_SS_PRIVACY_LVL (P_person_id igs_pe_priv_level.person_id%TYPE ) RETURN VARCHAR2;
95:
96:
97: FUNCTION Get_Hold_Count(p_person_id IN hz_parties.party_id%TYPE ) RETURN NUMBER;
98: /*
99: || Created By : ssawhney
100: || Created On : 27-SEP-2002
101: || Purpose : Function returns the count of no. of active holds on the passed person as of sysdate.