1 PACKAGE IGS_CA_INS_ROLL_CI AS
2 /* $Header: IGSCA03S.pls 120.0 2005/06/01 22:33:38 appldev noship $ */
3 -- Bug No 1956374 , Procedure admp_val_apcood_da reference is changed
4 -- To insert a date alias instance pair as part of the rollover process
5 FUNCTION calp_ins_rollvr_daip(
6 p_dt_alias IN VARCHAR2 ,
7 p_dai_sequence_number IN NUMBER ,
8 p_cal_type IN VARCHAR2 ,
9 p_ci_sequence_number IN NUMBER ,
10 p_diff_days IN NUMBER ,
11 p_diff_months IN NUMBER ,
12 p_val_dt_alias IN VARCHAR2 ,
13 p_val_dai_sequence_number IN NUMBER ,
14 p_val_cal_type IN VARCHAR2 ,
15 p_val_ci_sequence_number IN NUMBER ,
16 p_daip_related IN boolean ,
17 p_ci_rollover_sequence_number IN NUMBER ,
18 p_message_name OUT NOCOPY VARCHAR2 )
19 RETURN boolean;
20 --
21 -- To insert a dt alias inst offset constraint as part of the rollover.
22 FUNCTION calp_ins_roll_daioc(
23 p_dt_alias IN VARCHAR2 ,
24 p_dai_sequence_number IN NUMBER ,
25 p_cal_type IN VARCHAR2 ,
26 p_ci_sequence_number IN NUMBER ,
27 p_offset_dt_alias IN VARCHAR2 ,
28 p_offset_dai_sequence_number IN NUMBER ,
29 p_offset_cal_type IN VARCHAR2 ,
30 p_offset_ci_sequence_number IN NUMBER ,
31 p_new_dt_alias IN VARCHAR2 ,
32 p_new_dai_sequence_number IN NUMBER ,
33 p_new_cal_type IN VARCHAR2 ,
34 p_new_ci_sequence_number IN NUMBER ,
35 p_new_offset_dt_alias IN VARCHAR2 ,
36 p_new_offset_dai_seq_number IN NUMBER ,
37 p_new_offset_cal_type IN VARCHAR2 ,
38 p_new_offset_ci_seq_number IN NUMBER ,
39 p_ci_rollover_sequence_number IN NUMBER ,
40 p_message_name OUT NOCOPY VARCHAR2 )
41 RETURN boolean;
42 --
43
44
45
46 --
47 -- Validate adm perd date override should be included in rollover.
48 FUNCTION calp_val_apcood_roll(
49 p_dt_alias IN VARCHAR2 ,
50 p_dai_sequence_number IN NUMBER ,
51 p_cal_type IN VARCHAR2 ,
52 p_ci_sequence_number IN NUMBER ,
53 p_message_name OUT NOCOPY VARCHAR2 )
54 RETURN BOOLEAN;
55 PRAGMA RESTRICT_REFERENCES(calp_val_apcood_roll, WNDS);
56 --
57 -- To insert a date alias instance offset as part of the rollover process
58 FUNCTION calp_ins_rollvr_daio(
59 p_dt_alias IN VARCHAR2 ,
60 p_dai_sequence_number IN NUMBER ,
61 p_cal_type IN VARCHAR2 ,
62 p_ci_sequence_number IN NUMBER ,
63 p_diff_days IN NUMBER ,
64 p_diff_months IN NUMBER ,
65 p_val_dt_alias IN VARCHAR2 ,
66 p_val_dai_sequence_number IN NUMBER ,
67 p_val_cal_type IN VARCHAR2 ,
68 p_val_ci_sequence_number IN NUMBER ,
69 p_daio_offset IN boolean ,
70 p_day_offset IN NUMBER ,
71 p_week_offset IN NUMBER ,
72 p_month_offset IN NUMBER ,
73 p_year_offset IN NUMBER,
74 p_ofst_override IN VARCHAR2,
75 p_ci_rollover_sequence_number IN NUMBER ,
76 p_old_ci_sequence_number IN NUMBER ,
77 p_message_name OUT NOCOPY VARCHAR2 )
78 RETURN boolean;
79 --
80 -- To insert a date alias instance as part of the rollover process
81 FUNCTION calp_ins_rollvr_dai(
82 p_cal_type IN VARCHAR2 ,
83 p_ci_sequence_number IN NUMBER ,
84 p_diff_days IN NUMBER ,
85 p_diff_months IN NUMBER ,
86 p_rollover_cal_type IN VARCHAR2 ,
87 p_rollover_ci_sequence_number IN NUMBER ,
88 p_ci_rollover_sequence_number IN NUMBER ,
89 p_message_name OUT NOCOPY VARCHAR2 )
90 RETURN boolean;
91 --
92 -- To insert a ci relationship as part of the rollover process..
93 FUNCTION CALP_INS_ROLLVR_CIR(
94 p_cal_type IN VARCHAR2 ,
95 p_sequence_number IN NUMBER ,
96 p_diff_days IN NUMBER ,
97 p_diff_months IN NUMBER ,
98 p_sub_cal_type IN VARCHAR2 ,
99 p_sub_ci_sequence_number NUMBER ,
100 p_sup_cal_type IN VARCHAR2 ,
101 p_sup_ci_sequence_number IN NUMBER ,
102 p_ci_rollover_sequence_number IN NUMBER ,
103 p_message_name OUT NOCOPY VARCHAR2)
104 RETURN boolean;
105 --
106 -- To insert a calendar instance as part of the rollover process
107 FUNCTION calp_ins_rollvr_ci(
108 p_cal_type IN VARCHAR2 ,
109 p_sequence_number IN NUMBER ,
110 p_diff_days IN NUMBER ,
111 p_diff_months IN NUMBER ,
112 p_rollover_cal_type IN VARCHAR2 ,
113 p_rollover_sequence_number IN NUMBER ,
114 p_message_name OUT NOCOPY VARCHAR2 )
115 RETURN boolean;
116
117 FUNCTION chk_and_roll_ret(
118 p_old_ca_type IN VARCHAR2,
119 p_old_ci_seq_num IN NUMBER,
120 p_old_da_alias IN VARCHAR2,
121 p_old_dai_seq_num IN NUMBER,
122 p_new_ci_seq_num IN NUMBER)
123 RETURN BOOLEAN;
124
125 gv_log_type IGS_GE_S_LOG_ENTRY.s_log_type%TYPE;
126 gv_log_creation_dt IGS_GE_S_LOG_ENTRY.creation_dt%TYPE;
127 gv_log_key IGS_GE_S_LOG_ENTRY.key%TYPE;
128 gv_cal_count NUMBER := 0;
129 END IGS_CA_INS_ROLL_CI;