1 package PER_JP_SCHOOL_LOOKUPS_PKG AUTHID CURRENT_USER as
2 /* $Header: pejpschl.pkh 115.2 99/07/18 13:59:40 porting ship $ */
3 PROCEDURE insert_row(
4 p_rowid OUT VARCHAR2,
5 p_school_id IN VARCHAR2,
6 p_school_name IN VARCHAR2,
7 p_school_name_kana IN VARCHAR2,
8 p_major IN VARCHAR2,
9 p_major_kana IN VARCHAR2,
10 p_created_by IN NUMBER,
11 p_creation_date IN DATE,
12 p_last_updated_by IN NUMBER,
13 p_last_update_date IN DATE,
14 p_last_update_login IN NUMBER);
15 --
16 PROCEDURE lock_row(
17 p_rowid IN VARCHAR2,
18 p_school_id IN VARCHAR2,
19 p_school_name IN VARCHAR2,
20 p_school_name_kana IN VARCHAR2,
21 p_major IN VARCHAR2,
22 p_major_kana IN VARCHAR2);
23 --
24 PROCEDURE update_row(
25 p_rowid IN VARCHAR2,
26 p_school_id IN VARCHAR2,
27 p_school_name IN VARCHAR2,
28 p_school_name_kana IN VARCHAR2,
29 p_major IN VARCHAR2,
30 p_major_kana IN VARCHAR2,
31 p_created_by IN NUMBER,
32 p_creation_date IN DATE,
33 p_last_updated_by IN NUMBER,
34 p_last_update_date IN DATE,
35 p_last_update_login IN NUMBER);
36 end;