DBA Data[Home] [Help]

PACKAGE: APPS.IGW_SUBJECT_INFORMATION_TBH

Source


1 package IGW_SUBJECT_INFORMATION_TBH AUTHID CURRENT_USER as
2  /* $Header: igwtsuis.pls 115.3 2002/11/15 00:51:13 ashkumar ship $ */
3 procedure INSERT_ROW (
4   X_ROWID                           out NOCOPY rowid,
5   X_STUDY_TITLE_ID                  IN  NUMBER,
6   X_SUBJECT_TYPE_CODE               IN  VARCHAR2,
7   X_SUBJECT_RACE_CODE               IN  VARCHAR2,
8   X_SUBJECT_ETHNICITY_CODE	    IN  VARCHAR2,
9   X_NO_OF_SUBJECTS                  IN  NUMBER,
10   X_RETURN_STATUS   OUT NOCOPY VARCHAR2
11   );
12 -----------------------------------------------------------------------
13 procedure UPDATE_ROW (
14   X_ROWID                           IN ROWID,
15   X_STUDY_TITLE_ID                  IN  NUMBER,
16   X_SUBJECT_TYPE_CODE               IN  VARCHAR2,
17   X_SUBJECT_RACE_CODE               IN  VARCHAR2,
18   X_SUBJECT_ETHNICITY_CODE	    IN  VARCHAR2,
19   X_NO_OF_SUBJECTS                  IN  NUMBER,
20   X_RECORD_VERSION_NUMBER           IN NUMBER,
21   X_RETURN_STATUS                   OUT NOCOPY VARCHAR2
22   );
23 ---------------------------------------------------------------------------------
24 procedure DELETE_ROW (
25   x_rowid in rowid
26   ,x_record_version_number in number
27   ,X_RETURN_STATUS   OUT NOCOPY VARCHAR2
28 );
29 end IGW_SUBJECT_INFORMATION_TBH;