PACKAGE: APPS.IGS_PS_DEGREES_PKG

Source

1 PACKAGE igs_ps_degrees_pkg AS
2 /* $Header: IGSPI1IS.pls 120.0 2005/06/02 03:29:49 appldev noship $ */
3  procedure INSERT_ROW (
4       X_ROWID in out NOCOPY VARCHAR2,
5        x_DEGREE_CD IN VARCHAR2,
6        x_DESCRIPTION IN VARCHAR2,
7        x_PROGRAM_TYPE IN VARCHAR2 DEFAULT NULL,
8        x_CLOSED_IND IN VARCHAR2,
9       X_MODE in VARCHAR2 default 'R'
10   );
11 
12  procedure LOCK_ROW (
13       X_ROWID in  VARCHAR2,
14        x_DEGREE_CD IN VARCHAR2,
15        x_DESCRIPTION IN VARCHAR2,
16        x_PROGRAM_TYPE IN VARCHAR2 DEFAULT NULL,
17        x_CLOSED_IND IN VARCHAR2  );
18  procedure UPDATE_ROW (
19       X_ROWID in  VARCHAR2,
20        x_DEGREE_CD IN VARCHAR2,
21        x_DESCRIPTION IN VARCHAR2,
22        x_PROGRAM_TYPE IN VARCHAR2 DEFAULT NULL,
23        x_CLOSED_IND IN VARCHAR2,
24       X_MODE in VARCHAR2 default 'R'
25   );
26 
27  procedure ADD_ROW (
28       X_ROWID in out NOCOPY VARCHAR2,
29        x_DEGREE_CD IN VARCHAR2,
30        x_DESCRIPTION IN VARCHAR2,
31        x_PROGRAM_TYPE IN VARCHAR2 DEFAULT NULL,
32        x_CLOSED_IND IN VARCHAR2,
33       X_MODE in VARCHAR2 default 'R'
34   ) ;
35 
36 procedure DELETE_ROW (
37   X_ROWID in VARCHAR2
38 ) ;
39   FUNCTION Get_PK_For_Validation (
40     x_degree_cd IN VARCHAR2
41     ) RETURN BOOLEAN ;
42 
43   PROCEDURE Check_Constraints (
44 		 Column_Name IN VARCHAR2  DEFAULT NULL,
45 		 Column_Value IN VARCHAR2  DEFAULT NULL ) ;
46   PROCEDURE Before_DML (
47     p_action IN VARCHAR2,
48     x_rowid IN VARCHAR2 DEFAULT NULL,
49     x_degree_cd IN VARCHAR2 DEFAULT NULL,
50     x_description IN VARCHAR2 DEFAULT NULL,
51     x_program_type IN VARCHAR2 DEFAULT NULL,
52     x_closed_ind IN VARCHAR2 DEFAULT NULL,
53     x_creation_date IN DATE DEFAULT NULL,
54     x_created_by IN NUMBER DEFAULT NULL,
55     x_last_update_date IN DATE DEFAULT NULL,
56     x_last_updated_by IN NUMBER DEFAULT NULL,
57     x_last_update_login IN NUMBER DEFAULT NULL
58  );
59 END igs_ps_degrees_pkg;