DBA Data[Home] [Help]

PACKAGE: APPS.IGS_CA_GEN_001

Source


1 PACKAGE IGS_CA_GEN_001 AUTHID CURRENT_USER AS
2 /* $Header: IGSCA01S.pls 115.3 2002/11/28 22:56:16 nsidana ship $ */
3 FUNCTION calp_get_alias_val(
4   p_dt_alias IN IGS_CA_DA_INST.DT_ALIAS%TYPE ,
5   p_sequence_num  IGS_CA_DA_INST.sequence_number%TYPE ,
6   p_cal_type IN IGS_CA_DA_INST.CAL_TYPE%TYPE ,
7   p_ci_sequence_num IN IGS_CA_DA_INST.ci_sequence_number%TYPE )
8 RETURN DATE ;
9 PRAGMA RESTRICT_REFERENCES(calp_get_alias_val,WNDS,WNPS);
10 --
11 FUNCTION CALP_GET_ALT_CD(
12   p_cal_type IN VARCHAR2 ,
13   p_sequence_number IN NUMBER )
14 RETURN VARCHAR2 ;
15 PRAGMA RESTRICT_REFERENCES(CALP_GET_ALT_CD,WNDS,WNPS);
16 --
17 FUNCTION calp_get_cat_closed(
18   p_cal_type IN VARCHAR2 ,
19   p_message_name OUT NOCOPY VARCHAR2 )
20 RETURN boolean;
21 PRAGMA RESTRICT_REFERENCES(calp_get_cat_closed,WNDS);
22 --
23 PROCEDURE CALP_GET_CI_DATES(
24   p_cal_type IN VARCHAR2 ,
25   p_ci_sequence_number IN NUMBER ,
26   p_start_dt OUT NOCOPY DATE ,
27   p_end_dt OUT NOCOPY DATE );
28 --
29 FUNCTION calp_get_ci_start_dt(
30   p_cal_type IN VARCHAR2 ,
31   p_sequence_number IN NUMBER )
32 RETURN DATE;
33 PRAGMA RESTRICT_REFERENCES(calp_get_ci_start_dt,WNDS);
34 --
35 FUNCTION CALP_GET_RLTV_TIME(
36   p_source_cal_type IN VARCHAR2 ,
37   p_source_ci_sequence_number IN NUMBER ,
38   p_related_cal_type IN VARCHAR2 ,
39   p_related_ci_sequence_number IN NUMBER )
40 RETURN VARCHAR2 ;
41 PRAGMA RESTRICT_REFERENCES(CALP_GET_RLTV_TIME,WNDS);
42 --
43 FUNCTION calp_get_sup_inst(
44   p_sup_cal_type IN VARCHAR2 ,
45   p_sub_cal_type IN VARCHAR2 ,  p_sub_ci_sequence_number IN NUMBER )
46 RETURN NUMBER ;
47 PRAGMA RESTRICT_REFERENCES(calp_get_sup_inst,WNDS,WNPS);
48 --
49 FUNCTION calp_set_alias_value(
50   p_absolute_val IN DATE ,
51   p_derived_val IN DATE )
52 RETURN DATE ;
53 PRAGMA RESTRICT_REFERENCES(calp_set_alias_value,WNDS,WNPS);
54 --
55 FUNCTION calp_set_alt_code(
56   p_cal_type IN VARCHAR2 ,
57   p_alternate_code IN VARCHAR2 ,
58   p_message_name OUT NOCOPY VARCHAR2 )
59 RETURN VARCHAR2;
60 PRAGMA RESTRICT_REFERENCES(calp_set_alt_code,WNDS);
61 --
62 END IGS_CA_GEN_001;