[Home] [Help]
PACKAGE: APPS.HZ_EDUCATION_PKG
Source
1 PACKAGE HZ_EDUCATION_PKG AUTHID CURRENT_USER as
2 /* $Header: ARHPEDTS.pls 115.4 2003/02/10 09:38:28 ssmohan ship $ */
3
4
5 PROCEDURE Insert_Row(
6 x_EDUCATION_ID IN OUT NOCOPY NUMBER,
7 x_COURSE_MAJOR IN VARCHAR2,
8 x_PARTY_ID IN NUMBER,
9 x_DEGREE_RECEIVED IN VARCHAR2,
10 x_LAST_DATE_ATTENDED IN DATE,
11 x_SCHOOL_ATTENDED_NAME IN VARCHAR2,
12 x_TYPE_OF_SCHOOL IN VARCHAR2,
13 x_START_DATE_ATTENDED IN DATE,
14 x_STATUS IN VARCHAR2,
15 x_SCHOOL_PARTY_ID IN NUMBER,
16 x_OBJECT_VERSION_NUMBER IN NUMBER,
17 x_CREATED_BY_MODULE IN VARCHAR2,
18 x_APPLICATION_ID IN NUMBER
19 );
20
21
22
23 PROCEDURE Lock_Row(
24 x_Rowid VARCHAR2,
25 x_EDUCATION_ID NUMBER,
26 x_COURSE_MAJOR VARCHAR2,
27 x_PARTY_ID NUMBER,
28 x_SCHOOL_PARTY_ID NUMBER,
29 x_DEGREE_RECEIVED VARCHAR2,
30 x_LAST_DATE_ATTENDED DATE,
31 x_SCHOOL_ATTENDED_NAME VARCHAR2,
32 x_TYPE_OF_SCHOOL VARCHAR2,
33 x_CREATED_BY NUMBER,
34 x_CREATION_DATE DATE,
35 x_LAST_UPDATE_LOGIN NUMBER,
36 x_LAST_UPDATE_DATE DATE,
37 x_LAST_UPDATED_BY NUMBER,
38 x_REQUEST_ID NUMBER,
39 x_PROGRAM_APPLICATION_ID NUMBER,
40 x_PROGRAM_ID NUMBER,
41 x_PROGRAM_UPDATE_DATE DATE,
42 x_WH_UPDATE_DATE DATE,
43 x_START_DATE_ATTENDED DATE,
44 x_STATUS VARCHAR2
45 );
46
47
48
49 PROCEDURE Update_Row(
50 x_Rowid IN OUT NOCOPY VARCHAR2,
51 x_EDUCATION_ID IN OUT NOCOPY NUMBER,
52 x_COURSE_MAJOR IN VARCHAR2,
53 x_PARTY_ID IN NUMBER,
54 x_SCHOOL_PARTY_ID IN NUMBER,
55 x_DEGREE_RECEIVED IN VARCHAR2,
56 x_LAST_DATE_ATTENDED IN DATE,
57 x_SCHOOL_ATTENDED_NAME IN VARCHAR2,
58 x_TYPE_OF_SCHOOL IN VARCHAR2,
59 x_START_DATE_ATTENDED IN DATE,
60 x_STATUS IN VARCHAR2,
61 x_OBJECT_VERSION_NUMBER IN NUMBER,
62 x_CREATED_BY_MODULE IN VARCHAR2,
63 x_APPLICATION_ID IN NUMBER
64 );
65
66
67 PROCEDURE Select_Row (
68 x_education_id IN OUT NOCOPY NUMBER,
69 x_course_major OUT NOCOPY VARCHAR2,
70 x_party_id OUT NOCOPY NUMBER,
71 x_school_party_id OUT NOCOPY NUMBER,
72 x_degree_received OUT NOCOPY VARCHAR2,
73 x_last_date_attended OUT NOCOPY DATE,
74 x_start_date_attended OUT NOCOPY DATE,
75 x_school_attended_name OUT NOCOPY VARCHAR2,
76 x_type_of_school OUT NOCOPY VARCHAR2,
77 x_status OUT NOCOPY VARCHAR2,
78 x_application_id OUT NOCOPY NUMBER,
79 x_created_by_module OUT NOCOPY VARCHAR2
80
81 );
82
83
84 PROCEDURE Delete_Row(
85 x_EDUCATION_ID NUMBER);
86
87 END HZ_EDUCATION_PKG;