1 PACKAGE igs_pe_gen_002 AS
2 /* $Header: IGSPE14S.pls 120.1 2005/09/30 04:23:35 appldev noship $ */
3 /* Change Hisotry
4 Who When What
5
6 */
7
8 PROCEDURE apply_admin_hold
9 /*
10 || Created By : ssawhney
11 || Created On : 17-feb-2003
12 || Purpose : This Procedure will apply admin holds on a person. There were 3 steps while applying admin hold and not just a call to the TBH
13 || Hence created an API that all the 3 process are kept together and can be used
14 || Known limitations, enhancements or remarks :
15 || Change History :
16 || Who When What
17 || (reverse chronological order - newest change first)
18 */
19
20 (P_PERSON_ID IN hz_parties.party_id%TYPE,
21 P_ENCUMBRANCE_TYPE IN igs_pe_pers_encumb.encumbrance_type%TYPE,
22 P_START_DT IN Date,
23 P_END_DT IN Date,
24 P_AUTHORISING_PERSON_ID IN hz_parties.party_id%TYPE,
25 P_COMMENTS IN igs_pe_pers_encumb.comments%TYPE,
26 P_SPO_COURSE_CD IN igs_pe_pers_encumb.spo_course_cd%TYPE,
27 P_SPO_SEQUENCE_NUMBER IN igs_pe_pers_encumb.spo_sequence_number%TYPE,
28 P_CAL_TYPE IN igs_pe_pers_encumb.cal_type%TYPE,
29 P_SEQUENCE_NUMBER IN igs_pe_pers_encumb.sequence_number%TYPE,
30 P_AUTH_RESP_ID IN igs_pe_pers_encumb.auth_resp_id%TYPE,
31 P_EXTERNAL_REFERENCE IN igs_pe_pers_encumb.external_reference%TYPE,
32 P_MESSAGE_NAME OUT NOCOPY Varchar2,
33 P_MESSAGE_STRING OUT NOCOPY Varchar2
34 );
35
36
37 PROCEDURE Receive_External_Hold
38 /*
39 || Created By : KUMMA
40 || Created On : 17-feb-2003
41 || Purpose : This Procedure will be called by the function activity of the workflow "Process External Holds" which inturn will call the API to apply
42 || or to release the holds.
43 || Known limitations, enhancements or remarks :
44 || Change History :
45 || Who When What
46 || (reverse chronological order - newest change first)
47 */
48
49 (
50 itemtype IN VARCHAR2,
51 itemkey IN VARCHAR2,
52 actid IN NUMBER,
53 funcmode IN VARCHAR2,
54 resultout OUT NOCOPY VARCHAR2
55 );
56
57 FUNCTION GET_HR_INSTALLED
58 RETURN VARCHAR2;
59
60 FUNCTION GET_ACTIVE_EMP_CAT(P_PERSON_ID IN IGS_PE_TYP_INSTANCES_ALL.PERSON_ID%TYPE)
61 RETURN VARCHAR2;
62
63 END igs_pe_gen_002;