PACKAGE: APPS.IGS_RE_THESIS_EXAM_PKG

Source

1 package  IGS_RE_THESIS_EXAM_PKG as
2 /* $Header: IGSRI16S.pls 120.0 2005/06/01 19:22:44 appldev noship $ */
3 Procedure INSERT_ROW (
4   X_ROWID in out NOCOPY VARCHAR2,
5   X_PERSON_ID in NUMBER,
6   X_CA_SEQUENCE_NUMBER in NUMBER,
7   X_THE_SEQUENCE_NUMBER in NUMBER,
8   X_CREATION_DT in DATE,
9   X_SUBMISSION_DT in DATE,
10   X_THESIS_EXAM_TYPE in VARCHAR2,
11   X_THESIS_PANEL_TYPE in VARCHAR2,
12   X_TRACKING_ID in NUMBER,
13   X_THESIS_RESULT_CD in VARCHAR2,
14   X_MODE in VARCHAR2 default 'R'
15   );
16 procedure LOCK_ROW (
17   X_ROWID in VARCHAR2,
18   X_PERSON_ID in NUMBER,
19   X_CA_SEQUENCE_NUMBER in NUMBER,
20   X_THE_SEQUENCE_NUMBER in NUMBER,
21   X_CREATION_DT in DATE,
22   X_SUBMISSION_DT in DATE,
23   X_THESIS_EXAM_TYPE in VARCHAR2,
24   X_THESIS_PANEL_TYPE in VARCHAR2,
25   X_TRACKING_ID in NUMBER,
26   X_THESIS_RESULT_CD in VARCHAR2
27 );
28 procedure UPDATE_ROW (
29   X_ROWID in VARCHAR2,
30   X_PERSON_ID in NUMBER,
31   X_CA_SEQUENCE_NUMBER in NUMBER,
32   X_THE_SEQUENCE_NUMBER in NUMBER,
33   X_CREATION_DT in DATE,
34   X_SUBMISSION_DT in DATE,
35   X_THESIS_EXAM_TYPE in VARCHAR2,
36   X_THESIS_PANEL_TYPE in VARCHAR2,
37   X_TRACKING_ID in NUMBER,
38   X_THESIS_RESULT_CD in VARCHAR2,
39   X_MODE in VARCHAR2 default 'R'
40   );
41 procedure ADD_ROW (
42   X_ROWID in out NOCOPY VARCHAR2,
43   X_PERSON_ID in NUMBER,
44   X_CA_SEQUENCE_NUMBER in NUMBER,
45   X_THE_SEQUENCE_NUMBER in NUMBER,
46   X_CREATION_DT in DATE,
47   X_SUBMISSION_DT in DATE,
48   X_THESIS_EXAM_TYPE in VARCHAR2,
49   X_THESIS_PANEL_TYPE in VARCHAR2,
50   X_TRACKING_ID in NUMBER,
51   X_THESIS_RESULT_CD in VARCHAR2,
52   X_MODE in VARCHAR2 default 'R'
53   );
54 procedure DELETE_ROW (
55   X_ROWID in VARCHAR2,
56   x_mode IN VARCHAR2 DEFAULT 'R'
57   );
58 
59   FUNCTION Get_PK_For_Validation (
60     x_person_id IN NUMBER,
61     x_ca_sequence_number IN NUMBER,
62     x_the_sequence_number IN NUMBER,
63     x_creation_dt IN DATE
64     ) RETURN BOOLEAN;
65 
66   PROCEDURE GET_FK_IGS_RE_THS_EXAM_TYPE (
67     x_thesis_exam_type IN VARCHAR2
68     );
69 
70   PROCEDURE GET_FK_IGS_RE_THESIS (
71     x_person_id IN NUMBER,
72     x_ca_sequence_number IN NUMBER,
73     x_sequence_number IN NUMBER
74     );
75 
76   PROCEDURE GET_FK_IGS_RE_THESIS_RESULT (
77     x_thesis_result_cd IN VARCHAR2
78     );
79 
80   PROCEDURE GET_FK_IGS_RE_THS_PNL_TYPE (
81     x_thesis_panel_type IN VARCHAR2
82     );
83 
84   PROCEDURE GET_FK_IGS_TR_ITEM (
85     x_tracking_id IN NUMBER
86     );
87 
88 PROCEDURE Check_Constraints (
89   Column_Name in VARCHAR2 DEFAULT NULL ,
90   Column_Value in VARCHAR2 DEFAULT NULL
91   ) ;
92   PROCEDURE Before_DML (
93     p_action IN VARCHAR2,
94     x_rowid IN VARCHAR2 DEFAULT NULL,
95     x_person_id IN NUMBER DEFAULT NULL,
96     x_ca_sequence_number IN NUMBER DEFAULT NULL,
97     x_the_sequence_number IN NUMBER DEFAULT NULL,
98     x_creation_dt IN DATE DEFAULT NULL,
99     x_submission_dt IN DATE DEFAULT NULL,
100     x_thesis_exam_type IN VARCHAR2 DEFAULT NULL,
101     x_thesis_panel_type IN VARCHAR2 DEFAULT NULL,
102     x_tracking_id IN NUMBER DEFAULT NULL,
103     x_thesis_result_cd IN VARCHAR2 DEFAULT NULL,
104     x_creation_date IN DATE DEFAULT NULL,
105     x_created_by IN NUMBER DEFAULT NULL,
106     x_last_update_date IN DATE DEFAULT NULL,
107     x_last_updated_by IN NUMBER DEFAULT NULL,
108     x_last_update_login IN NUMBER DEFAULT NULL
109   );
110 
111 
112 end IGS_RE_THESIS_EXAM_PKG;