1 PACKAGE igs_pe_gen_001 AS
2 /* $Header: IGSPE12S.pls 120.2 2005/09/05 08:33:51 appldev ship $ */
3 /* Change Hisotry
4 Who When What
5 ssawhney 30-Aug-2005 Added Func Get_Hold_Count
6 ssawhney 10-nov-2004 Added function to retrun residency status Get_Res_Status
7 pkpatel 8-APR-2003 Bug 2804863
8 Added the variable g_hold_validation.
9 ssawhney 18-feb-2003 Ext Hold, added a default null param p_comments in release hold as this will now be called from form also
10 pkpatel 30-SEP-2002 Bug No: 2600842
11 Added the procedures get_hold_auth, validate_hold_desp and release_hold
12 rboddu 16-JUL-2002 Added the function get_person_encumb
13
14 -----------------------------
15 */
16
17 --when processing for a batch of persons the security level validations should not happen for each record.
18 --instead the validation should be done at the beginning. Hance the value of the variable
19 --igs_pe_gen_001.g_hold_validation should be 'N' for batch processing.
20
21 g_hold_validation VARCHAR2(1) := 'Y';
22
23 FUNCTION Get_Privacy_Lvl_Format_Str (P_person_id igs_pe_priv_level.person_id%TYPE ) RETURN VARCHAR2;
24
25 FUNCTION get_person_encumb(p_person_id igs_pe_person.person_id%TYPE) RETURN VARCHAR2;
26
27 /*
28 || Created By : pkpatel
29 || Created On : 27-SEP-2002
30 || Purpose : This Procedure will get hold Authorizer Information
31 || Known limitations, enhancements or remarks :
32 || Change History :
33 || Who When What
34 || (reverse chronological order - newest change first)
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 );
44
45 /*
46 || Created By : pkpatel
47 || Created On : 27-SEP-2002
48 || Purpose : This Procedure will validate whether the Responsibility passed can release the hold applied on the person
49 || Known limitations, enhancements or remarks :
50 || Change History :
51 || Who When What
52 || (reverse chronological order - newest change first)
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 );
62
63 /*
64 || Created By : pkpatel
65 || Created On : 27-SEP-2002
66 || Purpose : This Procedure will be the API that will be used to release the hold applied on the person.
67 || For p_override_resp = 'Y' the validation of security as per authorizing responsibility will not happen
68 || 'N' validation will happen
69 || 'X' - if its external hold.
70 || Known limitations, enhancements or remarks :
71 || Change History :
72 || Who When What
73 || ssawhney 18-feb-2003 Ext Hold, added a default null param p_comments as this will now be called from form also
74 || (reverse chronological order - newest change first)
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',
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 ;
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.
102 || Who When What
103 */
104
105 END igs_pe_gen_001;