APPS.PER_JP_SCHOOL_LOOKUPS_PKG dependencies on PER_JP_SCHOOL_LOOKUPS

Line 1: package body PER_JP_SCHOOL_LOOKUPS_PKG as

1: package body PER_JP_SCHOOL_LOOKUPS_PKG as
2: /* $Header: pejpschl.pkb 115.6 99/07/18 13:59:12 porting ship $ */
3: PROCEDURE insert_row(
4: p_rowid OUT VARCHAR2,
5: p_school_id IN VARCHAR2,

Line 19: from per_jp_school_lookups

15: IS
16: l_rowid ROWID;
17: CURSOR csr_school_rowid IS
18: select rowid
19: from per_jp_school_lookups
20: where school_id=p_school_id;
21: BEGIN
22: insert into per_jp_school_lookups(
23: SCHOOL_ID,

Line 22: insert into per_jp_school_lookups(

18: select rowid
19: from per_jp_school_lookups
20: where school_id=p_school_id;
21: BEGIN
22: insert into per_jp_school_lookups(
23: SCHOOL_ID,
24: SCHOOL_NAME,
25: SCHOOL_NAME_KANA,
26: MAJOR,

Line 61: from per_jp_school_lookups

57: p_major_kana IN VARCHAR2)
58: IS
59: CURSOR csr_school IS
60: select *
61: from per_jp_school_lookups
62: where rowid=chartorowid(p_rowid)
63: for update of school_id nowait;
64: l_rec csr_school%ROWTYPE;
65: BEGIN

Line 101: update per_jp_school_lookups

97: p_last_update_date IN DATE,
98: p_last_update_login IN NUMBER)
99: IS
100: BEGIN
101: update per_jp_school_lookups
102: set school_id = p_school_id,
103: school_name = p_school_name,
104: school_name_kana = p_school_name_kana,
105: major = p_major,