PACKAGE: APPS.IGS_EN_ENCMB_EFCTTYP_PKG

Source

1 package IGS_EN_ENCMB_EFCTTYP_PKG AUTHID CURRENT_USER AS
2 /* $Header: IGSEI32S.pls 115.6 2003/02/17 12:30:48 adhawan ship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out NOCOPY VARCHAR2,
5   X_S_ENCMB_EFFECT_TYPE in VARCHAR2,
6   X_APPLY_TO_COURSE_IND in VARCHAR2,
7   X_CLOSED_IND in VARCHAR2,
8   X_MODE in VARCHAR2 default 'R'
9   );
10 procedure LOCK_ROW (
11   X_ROWID in VARCHAR2,
12   X_S_ENCMB_EFFECT_TYPE in VARCHAR2,
13   X_APPLY_TO_COURSE_IND in VARCHAR2,
14   X_CLOSED_IND in VARCHAR2
15 );
16 
17 procedure UPDATE_ROW (
18   X_ROWID in VARCHAR2,
19   X_S_ENCMB_EFFECT_TYPE in VARCHAR2,
20   X_APPLY_TO_COURSE_IND in VARCHAR2,
21   X_CLOSED_IND in VARCHAR2,
22   X_MODE in VARCHAR2 default 'R'
23   );
24 procedure ADD_ROW (
25   X_ROWID in out NOCOPY VARCHAR2,
26   X_S_ENCMB_EFFECT_TYPE in VARCHAR2,
27   X_APPLY_TO_COURSE_IND in VARCHAR2,
28   X_CLOSED_IND in VARCHAR2,
29   X_MODE in VARCHAR2 default 'R'
30   );
31 
32 FUNCTION Get_PK_For_Validation (
33     x_s_encmb_effect_type IN VARCHAR2
34     )
35 RETURN BOOLEAN;
36 PROCEDURE Before_DML (
37     p_action IN VARCHAR2,
38     x_rowid IN  VARCHAR2 DEFAULT NULL,
39     x_s_encmb_effect_type IN VARCHAR2 DEFAULT NULL,
40     x_apply_to_course_ind IN VARCHAR2 DEFAULT NULL,
41     x_closed_ind IN VARCHAR2 DEFAULT NULL,
42     x_creation_date IN DATE DEFAULT NULL,
43     x_created_by IN NUMBER DEFAULT NULL,
44     x_last_update_date IN DATE DEFAULT NULL,
45     x_last_updated_by IN NUMBER DEFAULT NULL,
46     x_last_update_login IN NUMBER DEFAULT NULL
47   );
48 procedure Check_constraints(
49 	column_name IN VARCHAR2 DEFAULT NULL,
50 	column_value IN VARCHAR2 DEFAULT NULL
51    );
52 end IGS_EN_ENCMB_EFCTTYP_PKG;