DBA Data[Home] [Help]

PACKAGE: APPS.PER_JP_SCHOOL_LOOKUPS_PKG

Source


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;