PACKAGE: APPS.IGS_AS_GRD_SCH_TRN_PKG

Source

1 package IGS_AS_GRD_SCH_TRN_PKG AUTHID CURRENT_USER as
2  /* $Header: IGSDI15S.pls 115.4 2002/11/28 23:14:13 nsidana ship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out NOCOPY VARCHAR2,
5   X_ORG_ID in NUMBER,
6   X_GRADING_SCHEMA_CD in VARCHAR2,
7   X_VERSION_NUMBER in NUMBER,
8   X_GRADE in VARCHAR2,
9   X_TO_GRADING_SCHEMA_CD in VARCHAR2,
10   X_TO_VERSION_NUMBER in NUMBER,
11   X_TO_GRADE in VARCHAR2,
12   X_MODE in VARCHAR2 default 'R'
13   );
14 procedure LOCK_ROW (
15   X_ROWID in VARCHAR2,
16   X_GRADING_SCHEMA_CD in VARCHAR2,
17   X_VERSION_NUMBER in NUMBER,
18   X_GRADE in VARCHAR2,
19   X_TO_GRADING_SCHEMA_CD in VARCHAR2,
20   X_TO_VERSION_NUMBER in NUMBER,
21   X_TO_GRADE in VARCHAR2
22 );
23 procedure DELETE_ROW (
24   X_ROWID in VARCHAR2
25   );
26 FUNCTION Get_PK_For_Validation (
27     x_grading_schema_cd IN VARCHAR2,
28     x_version_number IN NUMBER,
29     x_grade IN VARCHAR2,
30     x_to_grading_schema_cd IN VARCHAR2,
31     x_to_version_number IN NUMBER,
32     x_to_grade IN VARCHAR2
33     )RETURN BOOLEAN;
34   PROCEDURE GET_FK_IGS_AS_GRD_SCH_GRADE (
35     x_grading_schema_cd IN VARCHAR2,
36     x_version_number IN NUMBER,
37     x_grade IN VARCHAR2
38     );
39  	PROCEDURE Check_Constraints (
40 
41 
42 
43 
44 	Column_Name	IN	VARCHAR2	DEFAULT NULL,
45 
46 
47 
48 
49 	Column_Value 	IN	VARCHAR2	DEFAULT NULL
50 
51 
52 
53 
54 	);
55 
56 
57 
58 
59 PROCEDURE Before_DML (
60 
61 
62 
63 
64     p_action IN VARCHAR2,
65 
66 
67 
68 
69     x_rowid IN  VARCHAR2 DEFAULT NULL,
70 
71 
72    x_org_id IN NUMBER DEFAULT NULL,
73 
74     x_grading_schema_cd IN VARCHAR2 DEFAULT NULL,
75 
76 
77 
78 
79     x_version_number IN NUMBER DEFAULT NULL,
80 
81 
82 
83 
84     x_grade IN VARCHAR2 DEFAULT NULL,
85 
86 
87 
88 
89     x_to_grading_schema_cd IN VARCHAR2 DEFAULT NULL,
90 
91 
92 
93 
94     x_to_version_number IN NUMBER DEFAULT NULL,
95 
96 
97 
98 
99     x_to_grade IN VARCHAR2 DEFAULT NULL,
100 
101 
102 
103 
104     x_creation_date IN DATE DEFAULT NULL,
105 
106 
107 
108 
109     x_created_by IN NUMBER DEFAULT NULL,
110 
111 
112 
113 
114     x_last_update_date IN DATE DEFAULT NULL,
115 
116 
117 
118 
119     x_last_updated_by IN NUMBER DEFAULT NULL,
120 
121 
122 
123 
124     x_last_update_login IN NUMBER DEFAULT NULL
125 
126 
127 
128 
129   ) ;
130 end IGS_AS_GRD_SCH_TRN_PKG;