1 package IGS_PR_RU_CA_TYPE_PKG AUTHID CURRENT_USER AS
2 /* $Header: IGSQI12S.pls 115.4 2002/11/29 03:16:58 nsidana ship $ */
3 procedure INSERT_ROW (
4 X_ROWID in out NOCOPY VARCHAR2,
5 X_PROGRESSION_RULE_CAT in VARCHAR2,
6 X_PRA_SEQUENCE_NUMBER in NUMBER,
7 X_PRG_CAL_TYPE in VARCHAR2,
8 X_START_SEQUENCE_NUMBER in NUMBER,
9 X_END_SEQUENCE_NUMBER in NUMBER,
10 X_START_EFFECTIVE_PERIOD in NUMBER,
11 X_NUM_OF_APPLICATIONS in NUMBER,
12 X_MODE in VARCHAR2 default 'R' ,
13 X_ORG_ID in NUMBER
14 );
15 procedure LOCK_ROW (
16 X_ROWID in VARCHAR2,
17 X_PROGRESSION_RULE_CAT in VARCHAR2,
18 X_PRA_SEQUENCE_NUMBER in NUMBER,
19 X_PRG_CAL_TYPE in VARCHAR2,
20 X_START_SEQUENCE_NUMBER in NUMBER,
21 X_END_SEQUENCE_NUMBER in NUMBER,
22 X_START_EFFECTIVE_PERIOD in NUMBER,
23 X_NUM_OF_APPLICATIONS in NUMBER
24 );
25 procedure UPDATE_ROW (
26 X_ROWID in VARCHAR2,
27 X_PROGRESSION_RULE_CAT in VARCHAR2,
28 X_PRA_SEQUENCE_NUMBER in NUMBER,
29 X_PRG_CAL_TYPE in VARCHAR2,
30 X_START_SEQUENCE_NUMBER in NUMBER,
31 X_END_SEQUENCE_NUMBER in NUMBER,
32 X_START_EFFECTIVE_PERIOD in NUMBER,
33 X_NUM_OF_APPLICATIONS in NUMBER,
34 X_MODE in VARCHAR2 default 'R'
35 );
36 procedure ADD_ROW (
37 X_ROWID in out NOCOPY VARCHAR2,
38 X_PROGRESSION_RULE_CAT in VARCHAR2,
39 X_PRA_SEQUENCE_NUMBER in NUMBER,
40 X_PRG_CAL_TYPE in VARCHAR2,
41 X_START_SEQUENCE_NUMBER in NUMBER,
42 X_END_SEQUENCE_NUMBER in NUMBER,
43 X_START_EFFECTIVE_PERIOD in NUMBER,
44 X_NUM_OF_APPLICATIONS in NUMBER,
45 X_MODE in VARCHAR2 default 'R',
46 X_ORG_ID in NUMBER
47 );
48 procedure DELETE_ROW (
49 X_ROWID in VARCHAR2
50 );
51 FUNCTION Get_PK_For_Validation (
52 x_progression_rule_cat IN VARCHAR2,
53 x_pra_sequence_number IN NUMBER,
54 x_prg_cal_type IN VARCHAR2
55 ) RETURN BOOLEAN;
56
57 PROCEDURE GET_FK_IGS_CA_TYPE (
58 x_cal_type IN VARCHAR2
59 );
60
61 PROCEDURE GET_FK_IGS_CA_INST (
62 x_cal_type IN VARCHAR2,
63 x_sequence_number IN NUMBER
64 );
65
66
67 PROCEDURE GET_FK_IGS_PR_RU_APPL (
68 x_progression_rule_cat IN VARCHAR2,
69 x_sequence_number IN NUMBER
70 );
71 PROCEDURE Before_DML (
72 p_action IN VARCHAR2,
73 x_rowid IN VARCHAR2 DEFAULT NULL,
74 x_progression_rule_cat IN VARCHAR2 DEFAULT NULL,
75 x_pra_sequence_number IN NUMBER DEFAULT NULL,
76 x_prg_cal_type IN VARCHAR2 DEFAULT NULL,
77 x_start_sequence_number IN NUMBER DEFAULT NULL,
78 x_end_sequence_number IN NUMBER DEFAULT NULL,
79 x_start_effective_period IN NUMBER DEFAULT NULL,
80 x_num_of_applications IN NUMBER DEFAULT NULL,
81 x_creation_date IN DATE DEFAULT NULL,
82 x_created_by IN NUMBER DEFAULT NULL,
83 x_last_update_date IN DATE DEFAULT NULL,
84 x_last_updated_by IN NUMBER DEFAULT NULL,
85 x_last_update_login IN NUMBER DEFAULT NULL,
86 X_ORG_ID in NUMBER DEFAULT NULL
87 );
88 PROCEDURE Check_Constraints(
89 Column_Name IN VARCHAR2 DEFAULT NULL,
90 Column_Value IN VARCHAR2 DEFAULT NULL
91 );
92 end IGS_PR_RU_CA_TYPE_PKG;