1 PACKAGE PAY_JP_SWOT_NUMBERS_PKG AS
2 /* $Header: pyjppswn.pkh 120.1 2005/10/19 20:29:53 hikubo noship $ */
3 --
4 PROCEDURE insert_row
5 (
6 x_rowid in out nocopy varchar2,
7 x_organization_id in number,
8 x_district_code in varchar2,
9 x_report_district_code in varchar2,
10 x_swot_number in varchar2,
11 x_last_update_date in date,
12 x_last_updated_by in number,
13 x_last_update_login in number,
14 x_created_by in number,
15 x_creation_date in date
16 );
17 --
18 PROCEDURE lock_row
19 (
20 x_rowid in varchar2,
21 x_organization_id in number,
22 x_district_code in varchar2,
23 x_report_district_code in varchar2,
24 x_swot_number in varchar2,
25 x_last_update_date in date,
26 x_last_updated_by in number,
27 x_last_update_login in number,
28 x_created_by in number,
29 x_creation_date in date
30 );
31 --
32 PROCEDURE update_row
33 (
34 x_rowid in varchar2,
35 x_organization_id in number,
36 x_district_code in varchar2,
37 x_report_district_code in varchar2,
38 x_swot_number in varchar2,
39 x_last_update_date in date,
40 x_last_updated_by in number,
41 x_last_update_login in number,
42 x_created_by in number,
43 x_creation_date in date
44 );
45 --
46 PROCEDURE delete_row(x_rowid in varchar2);
47 --
48 FUNCTION chk_swot_number(p_value in VARCHAR2) return varchar2;
49 --
50 END PAY_JP_SWOT_NUMBERS_PKG;
[Home] [Help]