1 PACKAGE igs_ps_rlovr_fac_tsk AS
2 /* $Header: IGSPS83S.pls 120.1 2005/10/04 00:29:21 appldev ship $ */
3
4 --who when what
5 --
6 --============================================================================
7
8
9 FUNCTION crsp_chk_inst_time_conft(
10 p_start_dt_1 IN DATE ,
11 p_end_dt_1 IN DATE,
12 p_monday_1 IN VARCHAR2 ,
13 p_tuesday_1 IN VARCHAR2 ,
14 p_wednesday_1 IN VARCHAR2 ,
15 p_thursday_1 IN VARCHAR2 ,
16 p_friday_1 IN VARCHAR2 ,
17 p_saturday_1 IN VARCHAR2 ,
18 p_sunday_1 IN VARCHAR2 ,
19 p_start_dt_2 IN DATE ,
20 p_end_dt_2 IN DATE,
21 p_monday_2 IN VARCHAR2 ,
22 p_tuesday_2 IN VARCHAR2 ,
23 p_wednesday_2 IN VARCHAR2 ,
24 p_thursday_2 IN VARCHAR2 ,
25 p_friday_2 IN VARCHAR2 ,
26 p_saturday_2 IN VARCHAR2 ,
27 p_sunday_2 IN VARCHAR2
28 ) RETURN BOOLEAN ;
29
30 --
31 FUNCTION crsp_instrct_time_conflct(
32 p_person_id IN NUMBER ,
33 p_unit_section_occurrence_id IN NUMBER ,
34 p_monday IN VARCHAR2 ,
35 p_tuesday IN VARCHAR2 ,
36 p_wednesday IN VARCHAR2 ,
37 p_thursday IN VARCHAR2 ,
38 p_friday IN VARCHAR2 ,
39 p_saturday IN VARCHAR2 ,
40 p_sunday IN VARCHAR2 ,
41 p_start_time IN DATE ,
42 p_end_time IN DATE ,
43 p_start_date IN DATE ,
44 p_end_date IN DATE ,
45 p_calling_module IN VARCHAR2 ,
46 p_message_name OUT NOCOPY VARCHAR2
47 ) RETURN BOOLEAN ;
48
49 --
50 PROCEDURE crsp_prc_inst_time_cft(
51 p_person_id IN NUMBER ,
52 p_cal_type IN VARCHAR2 ,
53 p_sequence_number IN NUMBER
54 ) ;
55
56 --
57 PROCEDURE rollover_fac_task(
58 errbuf OUT NOCOPY VARCHAR2 ,
59 retcode OUT NOCOPY NUMBER ,
60 p_person_id IN NUMBER ,
61 p_source_cal_type IN VARCHAR2 ,
62 p_dest_cal_type IN VARCHAR2 ,
63 p_org_id IN NUMBER
64 ) ;
65
66
67 END igs_ps_rlovr_fac_tsk;