1 PACKAGE PAY_JP_SWOT_NUMBERS_PKG AUTHID CURRENT_USER AS
2 /* $Header: pyjppswn.pkh 120.1.12010000.3 2009/06/24 06:49:28 keyazawa ship $ */
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_efile_exclusive_flag in varchar2,
12 x_output_file_name in varchar2,
13 x_import_exclusive_flag in varchar2,
14 x_input_file_name in varchar2,
15 x_last_update_date in date,
16 x_last_updated_by in number,
17 x_last_update_login in number,
18 x_created_by in number,
19 x_creation_date in date
20 );
21 --
22 PROCEDURE lock_row
23 (
24 x_rowid in varchar2,
25 x_organization_id in number,
26 x_district_code in varchar2,
27 x_report_district_code in varchar2,
28 x_swot_number in varchar2,
29 x_efile_exclusive_flag in varchar2,
30 x_output_file_name in varchar2,
31 x_import_exclusive_flag in varchar2,
32 x_input_file_name in varchar2,
33 x_last_update_date in date,
34 x_last_updated_by in number,
35 x_last_update_login in number,
36 x_created_by in number,
37 x_creation_date in date
38 );
39 --
40 PROCEDURE update_row
41 (
42 x_rowid in varchar2,
43 x_organization_id in number,
44 x_district_code in varchar2,
45 x_report_district_code in varchar2,
46 x_swot_number in varchar2,
47 x_efile_exclusive_flag in varchar2,
48 x_output_file_name in varchar2,
49 x_import_exclusive_flag in varchar2,
50 x_input_file_name in varchar2,
51 x_last_update_date in date,
52 x_last_updated_by in number,
53 x_last_update_login in number,
54 x_created_by in number,
55 x_creation_date in date
56 );
57 --
58 PROCEDURE delete_row(x_rowid in varchar2);
59 --
60 FUNCTION chk_swot_number(p_value in VARCHAR2) return varchar2;
61 --
62 function chk_output_file_name(
63 p_output_file_name in varchar2)
64 return boolean;
65 --
66 END PAY_JP_SWOT_NUMBERS_PKG;
[Home] [Help]