PACKAGE: APPS.IGS_CA_COMPUTE_DA_VAL_PKG

Source

1 PACKAGE igs_ca_compute_da_val_pkg
2 /* $Header: IGSCA15S.pls 120.1 2005/08/16 22:18:10 appldev noship $ */
3 /*****************************************************
4 ||  Created By : Navin Sidana
5 ||  Created On : 10/13/2004
6 ||  Purpose : Package for computing date alias values.
7 ||  Known limitations, enhancements or remarks :
8 ||  Change History :
9 ||  Who             When            What
10 ||  nsidana         10/13/2004      Created
11 ||  skpandey        17-AUG-2005     Bug:4356272
12 ||                                  Added an additional parameter "app_type" in cal_da_elt_val and cal_da_elt_ofst_val function
13 *****************************************************/
14 AS
15 
16 TYPE t_ofst_rec IS RECORD(ofst_lvl VARCHAR2(30),
17                           dt_alias VARCHAR2(30),
18 			  da_seq_num NUMBER,
19 			  offset_cal_type VARCHAR2(30),
20 			  offset_ci_sequence_number NUMBER,
21                           day_offset NUMBER,
22 			  week_offset NUMBER,
23 			  month_offset NUMBER,
24 			  year_offset NUMBER,
25 			  ofst_override VARCHAR2(1)
26 			  );
27 
28 FUNCTION cal_da_elt_val(p_sys_date_type  IN  VARCHAR2,
29           	        p_cal_type       IN  VARCHAR2,
30 		        p_seq_number     IN  NUMBER,
31 			p_org_unit       IN VARCHAR2,
32 			p_prog_type      IN VARCHAR2,
33 			p_prog_ver       IN VARCHAR2,
34 			p_app_type       IN VARCHAR2 DEFAULT NULL
35 		        ) RETURN DATE;
36 
37 FUNCTION cal_da_elt_ofst_val(p_dt_alias     IN  VARCHAR2,
38 			     p_da_seq_num   IN NUMBER,
39 			     p_cal_type     IN  VARCHAR2,
40 			     p_seq_number   IN  NUMBER,
41 			     p_org_unit     IN VARCHAR2,
42 			     p_prog_type    IN VARCHAR2,
43 			     p_prog_ver     IN VARCHAR2,
44 			     p_app_type     IN VARCHAR2 DEFAULT NULL
45 			     ) RETURN DATE;
46 
47 END igs_ca_compute_da_val_pkg;