PACKAGE: APPS.IGS_PS_USEC_GRD_SCHM_PKG

Source

1 PACKAGE igs_ps_usec_grd_schm_pkg AS
2 /* $Header: IGSPI0NS.pls 120.1 2005/10/04 00:39:48 appldev ship $ */
3  procedure INSERT_ROW (
4       X_ROWID in out NOCOPY VARCHAR2,
5        x_UNIT_SECTION_GRAD_SCHEMA_ID IN OUT NOCOPY NUMBER,
6        x_UOO_ID IN NUMBER,
7        x_GRADING_SCHEMA_CODE IN VARCHAR2,
8        x_GRD_SCHM_VERSION_NUMBER IN NUMBER,
9        x_DEFAULT_FLAG IN VARCHAR2,
10       X_MODE in VARCHAR2 default 'R'
11   );
12 
13  procedure LOCK_ROW (
14       X_ROWID in  VARCHAR2,
15        x_UNIT_SECTION_GRAD_SCHEMA_ID IN NUMBER,
16        x_UOO_ID IN NUMBER,
17        x_GRADING_SCHEMA_CODE IN VARCHAR2,
18        x_GRD_SCHM_VERSION_NUMBER IN NUMBER,
19        x_DEFAULT_FLAG IN VARCHAR2  );
20  procedure UPDATE_ROW (
21       X_ROWID in  VARCHAR2,
22        x_UNIT_SECTION_GRAD_SCHEMA_ID IN NUMBER,
23        x_UOO_ID IN NUMBER,
24        x_GRADING_SCHEMA_CODE IN VARCHAR2,
25        x_GRD_SCHM_VERSION_NUMBER IN NUMBER,
26        x_DEFAULT_FLAG IN VARCHAR2,
27       X_MODE in VARCHAR2 default 'R'
28   );
29 
30  procedure ADD_ROW (
31       X_ROWID in out NOCOPY VARCHAR2,
32        x_UNIT_SECTION_GRAD_SCHEMA_ID IN OUT NOCOPY NUMBER,
33        x_UOO_ID IN NUMBER,
34        x_GRADING_SCHEMA_CODE IN VARCHAR2,
35        x_GRD_SCHM_VERSION_NUMBER IN NUMBER,
36        x_DEFAULT_FLAG IN VARCHAR2,
37       X_MODE in VARCHAR2 default 'R'
38   ) ;
39 
40 procedure DELETE_ROW (
41   X_ROWID in VARCHAR2
42 ) ;
43   FUNCTION Get_PK_For_Validation (
44     x_unit_section_grad_schema_id IN NUMBER
45     ) RETURN BOOLEAN ;
46 
47   FUNCTION Get_UK_For_Validation (
48     x_grading_schema_code IN VARCHAR2,
49     x_grd_schm_version_number IN NUMBER,
50     x_uoo_id IN NUMBER
51     ) RETURN BOOLEAN;
52 
53   PROCEDURE Get_FK_Igs_As_Grd_Schema (
54     x_grading_schema_cd IN VARCHAR2,
55     x_version_number IN NUMBER
56     );
57 
58   PROCEDURE Get_UFK_Igs_Ps_Unit_Ofr_Opt (
59     x_uoo_id IN NUMBER
60     );
61 
62   PROCEDURE Check_Constraints (
63 		 Column_Name IN VARCHAR2  DEFAULT NULL,
64 		 Column_Value IN VARCHAR2  DEFAULT NULL ) ;
65   PROCEDURE Before_DML (
66     p_action IN VARCHAR2,
67     x_rowid IN VARCHAR2 DEFAULT NULL,
68     x_unit_section_grad_schema_id IN NUMBER DEFAULT NULL,
69     x_uoo_id IN NUMBER DEFAULT NULL,
70     x_grading_schema_code IN VARCHAR2 DEFAULT NULL,
71     x_grd_schm_version_number IN NUMBER DEFAULT NULL,
72     x_default_flag IN VARCHAR2 DEFAULT NULL,
73     x_creation_date IN DATE DEFAULT NULL,
74     x_created_by IN NUMBER DEFAULT NULL,
75     x_last_update_date IN DATE DEFAULT NULL,
76     x_last_updated_by IN NUMBER DEFAULT NULL,
77     x_last_update_login IN NUMBER DEFAULT NULL
78  );
79 END igs_ps_usec_grd_schm_pkg;