1 PACKAGE xla_source_params_f_pkg AS
2 /* $Header: xlathspm.pkh 120.0 2004/09/28 22:00:44 wychan noship $ */
3 /*======================================================================+
4 | Copyright (c) 2001-2002 Oracle Corporation |
5 | Redwood Shores, CA, USA |
6 | All rights reserved. |
7 +=======================================================================+
8 | PACKAGE NAME |
9 | xla_source_params_f_pkg |
10 | |
11 | DESCRIPTION |
12 | Forms PL/SQL Wrapper for xla_source_params |
13 | |
14 | HISTORY |
15 | 09/27/04 W Chan Created |
16 | |
17 +======================================================================*/
18
19
20
21 PROCEDURE insert_row
22 (x_rowid IN OUT NOCOPY VARCHAR2
23 ,x_source_param_id IN NUMBER
24 ,x_application_id IN NUMBER
25 ,x_source_type_code IN VARCHAR2
26 ,x_source_code IN VARCHAR2
27 ,x_user_sequence IN NUMBER
28 ,x_parameter_type_code IN VARCHAR2
29 ,x_constant_value IN VARCHAR2
30 ,x_ref_source_application_id IN NUMBER
31 ,x_ref_source_type_code IN VARCHAR2
32 ,x_ref_source_code IN VARCHAR2
33 ,x_creation_date IN DATE
34 ,x_created_by IN NUMBER
35 ,x_last_update_date IN DATE
36 ,x_last_updated_by IN NUMBER
37 ,x_last_update_login IN NUMBER);
38
39 PROCEDURE lock_row
40 (x_source_param_id IN NUMBER
41 ,x_application_id IN NUMBER
42 ,x_source_type_code IN VARCHAR2
43 ,x_source_code IN VARCHAR2
44 ,x_user_sequence IN NUMBER
45 ,x_parameter_type_code IN VARCHAR2
46 ,x_constant_value IN VARCHAR2
47 ,x_ref_source_application_id IN NUMBER
48 ,x_ref_source_type_code IN VARCHAR2
49 ,x_ref_source_code IN VARCHAR2
50 );
51
52 PROCEDURE update_row
53 (x_source_param_id IN NUMBER
54 ,x_application_id IN NUMBER
55 ,x_source_type_code IN VARCHAR2
56 ,x_source_code IN VARCHAR2
57 ,x_user_sequence IN NUMBER
58 ,x_parameter_type_code IN VARCHAR2
59 ,x_constant_value IN VARCHAR2
60 ,x_ref_source_application_id IN NUMBER
61 ,x_ref_source_type_code IN VARCHAR2
62 ,x_ref_source_code IN VARCHAR2
63 ,x_last_update_date IN DATE
64 ,x_last_updated_by IN NUMBER
65 ,x_last_update_login IN NUMBER);
66
67 PROCEDURE delete_row
68 (x_source_param_id IN NUMBER);
69
70 PROCEDURE load_row
71 (p_application_short_name IN VARCHAR2
72 ,p_source_type_code IN VARCHAR2
73 ,p_source_code IN VARCHAR2
74 ,p_user_sequence IN VARCHAR2
75 ,p_parameter_type_code IN VARCHAR2
76 ,p_constant_value IN VARCHAR2
77 ,p_ref_source_app_short_name IN VARCHAR2
78 ,p_ref_source_type_code IN VARCHAR2
79 ,p_ref_source_code IN VARCHAR2
80 ,p_owner IN VARCHAR2
81 ,p_last_update_date IN VARCHAR2);
82
83 END xla_source_params_f_pkg;