1 package IGS_FI_F_CAT_CA_INST_PKG AUTHID CURRENT_USER as
2 /* $Header: IGSSI44S.pls 115.3 2002/11/29 03:48:19 nsidana ship $*/
3 procedure INSERT_ROW (
4 X_ROWID in out NOCOPY VARCHAR2,
5 X_FEE_CAT in VARCHAR2,
6 X_FEE_CAL_TYPE in VARCHAR2,
7 X_FEE_CI_SEQUENCE_NUMBER in NUMBER,
8 X_FEE_CAT_CI_STATUS in VARCHAR2,
9 X_START_DT_ALIAS in VARCHAR2,
10 X_START_DAI_SEQUENCE_NUMBER in NUMBER,
11 X_END_DT_ALIAS in VARCHAR2,
12 X_END_DAI_SEQUENCE_NUMBER in NUMBER,
13 X_RETRO_DT_ALIAS in VARCHAR2,
14 X_RETRO_DAI_SEQUENCE_NUMBER in NUMBER,
15 X_MODE in VARCHAR2 default 'R'
16 );
17 procedure LOCK_ROW (
18 X_ROWID in VARCHAR2,
19 X_FEE_CAT in VARCHAR2,
20 X_FEE_CAL_TYPE in VARCHAR2,
21 X_FEE_CI_SEQUENCE_NUMBER in NUMBER,
22 X_FEE_CAT_CI_STATUS in VARCHAR2,
23 X_START_DT_ALIAS in VARCHAR2,
24 X_START_DAI_SEQUENCE_NUMBER in NUMBER,
25 X_END_DT_ALIAS in VARCHAR2,
26 X_END_DAI_SEQUENCE_NUMBER in NUMBER,
27 X_RETRO_DT_ALIAS in VARCHAR2,
28 X_RETRO_DAI_SEQUENCE_NUMBER in NUMBER
29 );
30 procedure UPDATE_ROW (
31 X_ROWID in VARCHAR2,
32 X_FEE_CAT in VARCHAR2,
33 X_FEE_CAL_TYPE in VARCHAR2,
34 X_FEE_CI_SEQUENCE_NUMBER in NUMBER,
35 X_FEE_CAT_CI_STATUS in VARCHAR2,
36 X_START_DT_ALIAS in VARCHAR2,
37 X_START_DAI_SEQUENCE_NUMBER in NUMBER,
38 X_END_DT_ALIAS in VARCHAR2,
39 X_END_DAI_SEQUENCE_NUMBER in NUMBER,
40 X_RETRO_DT_ALIAS in VARCHAR2,
41 X_RETRO_DAI_SEQUENCE_NUMBER in NUMBER,
42 X_MODE in VARCHAR2 default 'R'
43 );
44 procedure ADD_ROW (
45 X_ROWID in out NOCOPY VARCHAR2,
46 X_FEE_CAT in VARCHAR2,
47 X_FEE_CAL_TYPE in VARCHAR2,
48 X_FEE_CI_SEQUENCE_NUMBER in NUMBER,
49 X_FEE_CAT_CI_STATUS in VARCHAR2,
50 X_START_DT_ALIAS in VARCHAR2,
51 X_START_DAI_SEQUENCE_NUMBER in NUMBER,
52 X_END_DT_ALIAS in VARCHAR2,
53 X_END_DAI_SEQUENCE_NUMBER in NUMBER,
54 X_RETRO_DT_ALIAS in VARCHAR2,
55 X_RETRO_DAI_SEQUENCE_NUMBER in NUMBER,
56 X_MODE in VARCHAR2 default 'R'
57 );
58 procedure DELETE_ROW (
59 X_ROWID in VARCHAR2
60 );
61 FUNCTION Get_PK_For_Validation (
62 x_fee_cat IN VARCHAR2,
63 x_fee_cal_type IN VARCHAR2,
64 x_fee_ci_sequence_number IN NUMBER
65 ) RETURN BOOLEAN;
66 PROCEDURE Check_Constraints (
67 column_name IN VARCHAR2 DEFAULT NULL,
68 column_value IN VARCHAR2 DEFAULT NULL
69 );
70 PROCEDURE Before_DML (
71 p_action IN VARCHAR2,
72 x_rowid IN VARCHAR2 DEFAULT NULL,
73 x_fee_cat IN VARCHAR2 DEFAULT NULL,
74 x_fee_cal_type IN VARCHAR2 DEFAULT NULL,
75 x_fee_ci_sequence_number IN NUMBER DEFAULT NULL,
76 x_fee_cat_ci_status IN VARCHAR2 DEFAULT NULL,
77 x_start_dt_alias IN VARCHAR2 DEFAULT NULL,
78 x_start_dai_sequence_number IN NUMBER DEFAULT NULL,
79 x_end_dt_alias IN VARCHAR2 DEFAULT NULL,
80 x_end_dai_sequence_number IN NUMBER DEFAULT NULL,
81 x_retro_dt_alias IN VARCHAR2 DEFAULT NULL,
82 x_retro_dai_sequence_number IN NUMBER DEFAULT NULL,
83 x_creation_date IN DATE DEFAULT NULL,
84 x_created_by IN NUMBER DEFAULT NULL,
85 x_last_update_date IN DATE DEFAULT NULL,
86 x_last_updated_by IN NUMBER DEFAULT NULL,
87 x_last_update_login IN NUMBER DEFAULT NULL
88 );
89 PROCEDURE GET_FK_IGS_CA_DA_INST (
90 x_dt_alias IN VARCHAR2,
91 x_sequence_number IN NUMBER,
92 x_cal_type IN VARCHAR2,
93 x_ci_sequence_number IN NUMBER
94 );
95 PROCEDURE GET_FK_IGS_CA_INST (
96 x_cal_type IN VARCHAR2,
97 x_sequence_number IN NUMBER
98 );
99 PROCEDURE GET_FK_IGS_FI_FEE_CAT (
100 x_fee_cat IN VARCHAR2
101 );
102 PROCEDURE GET_FK_IGS_FI_FEE_STR_STAT (
103 x_fee_structure_status IN VARCHAR2
104 );
105 end IGS_FI_F_CAT_CA_INST_PKG;