PACKAGE: APPS.IGS_OR_GEN_001

Source

1 PACKAGE IGS_OR_GEN_001 AUTHID CURRENT_USER AS
2 /* $Header: IGSOR01S.pls 115.5 2002/11/29 01:45:44 nsidana ship $ */
3 
4 /*
5   ||  Created By : pkpatel
6   ||  Created On : 10-DEC-2001
7   ||  Purpose :
8   ||  Known limitations, enhancements or remarks :
9   ||  Change History :
10   ||  Who             When            What
11   ||  (reverse chronological order - newest change first)
12   || pkpatel         12-MAY-2002      Bug No: 2266315
13   ||                                  Added the Procedure update_org.
14 */
15 
16 g_org_unit_cd    hz_parties.party_number%TYPE;
17 
18 PROCEDURE orgp_del_instn_hist(
19   p_institution_cd IN VARCHAR2 );
20 
21 PROCEDURE orgp_del_ou_hist(
22   p_org_unit_cd IN VARCHAR2 ,
23   p_start_dt IN DATE );
24 
25 FUNCTION orgp_get_local_inst
26 RETURN VARCHAR2;
27 
28 FUNCTION orgp_get_s_loc_type(
29  p_location_cd  IGS_AD_LOCATION_ALL.location_cd%TYPE )
30 RETURN VARCHAR2;
31 
32 FUNCTION orgp_get_s_loc_type2(
33   p_location_type  IGS_AD_LOCATION_ALL.location_type%TYPE )
34 RETURN VARCHAR2;
35 
36 FUNCTION ORGP_GET_WITHIN_OU(
37   p_parent_org_unit_cd IN VARCHAR2 ,
38   p_parent_start_dt IN DATE ,
39   p_child_org_unit_cd IN VARCHAR2 ,
40   p_child_start_dt IN DATE ,
41   p_direct_match_ind IN VARCHAR2 DEFAULT 'N')
42 RETURN VARCHAR2;
43 PRAGMA RESTRICT_REFERENCES(ORGP_GET_WITHIN_OU, WNDS,WNPS);
44 
45 PROCEDURE orgp_ins_ou_hist(
46   p_org_unit_cd IN VARCHAR2 ,
47   p_ou_start_dt IN DATE ,
48   p_hist_start_dt IN DATE ,
49   p_hist_end_dt IN DATE ,
50   p_hist_who IN VARCHAR2 ,
51   p_ou_end_dt IN DATE ,
52   p_description IN VARCHAR2 ,
53   p_org_status IN VARCHAR2 ,
54   p_org_type IN VARCHAR2 ,
55   p_member_type IN VARCHAR2 ,
56   p_institution_cd IN VARCHAR2 );
57 
58 
59 PROCEDURE orgp_upd_ins_ou_sts(
60   p_institution_cd IN VARCHAR2 ,
61   p_org_status  VARCHAR2 ,
62   p_message_name OUT NOCOPY VARCHAR2 );
63 
64 PROCEDURE orgp_upd_ou_sts(
65   p_org_unit_cd IN VARCHAR2 ,
66   p_start_dt IN DATE ,
67   p_end_dt IN DATE ,
68   p_org_status IN VARCHAR2 ,
69   p_message_name OUT NOCOPY VARCHAR2 );
70 
71 PROCEDURE  update_org(p_org_unit_cd  hz_parties.party_number%TYPE,
72                       p_org_status   igs_pe_hz_parties.ou_org_status%TYPE,
73                       p_end_date     igs_pe_hz_parties.ou_end_dt%TYPE
74   				      );
75 
76 END IGS_OR_GEN_001 ;