1 PACKAGE xla_tab_ats_f_pkg AUTHID CURRENT_USER AS
2 /* $Header: xlathtabats.pkh 120.0 2005/09/05 16:51:39 jlarre noship $ */
3 /*======================================================================+
4 | Copyright (c) 2001-2002 Oracle Corporation |
5 | Redwood Shores, CA, USA |
6 | All rights reserved. |
7 +=======================================================================+
8 | PACKAGE NAME |
9 | xla_tab_ats_f_pkg |
10 | |
11 | DESCRIPTION |
12 | Plsql table handler for table xla_tab_acct_type_srcs |
13 | |
14 | HISTORY |
15 | 01-SEP-2005 Jorge Larre Initial Creation |
16 | |
17 +======================================================================*/
18
19 PROCEDURE trace
20 (p_msg IN VARCHAR2
21 ,p_module IN VARCHAR2
22 ,p_level IN NUMBER);
23
24 PROCEDURE insert_row
25 (x_rowid IN OUT NOCOPY VARCHAR2
26 ,x_application_id IN NUMBER
27 ,x_account_type_code IN VARCHAR2
28 ,x_source_application_id IN NUMBER
29 ,x_source_type_code IN VARCHAR2
30 ,x_source_code IN VARCHAR2
31 ,x_creation_date IN DATE
32 ,x_created_by IN NUMBER
33 ,x_last_update_date IN DATE
34 ,x_last_updated_by IN NUMBER
35 ,x_last_update_login IN NUMBER);
36
37 PROCEDURE lock_row
38 (x_application_id IN NUMBER
39 ,x_account_type_code IN VARCHAR2
40 ,x_source_application_id IN NUMBER
41 ,x_source_type_code IN VARCHAR2
42 ,x_source_code IN VARCHAR2);
43
44 PROCEDURE update_row
45 (x_application_id IN NUMBER
46 ,x_account_type_code IN VARCHAR2
47 ,x_source_application_id IN NUMBER
48 ,x_source_type_code IN VARCHAR2
49 ,x_source_code IN VARCHAR2
50 ,x_last_update_date IN DATE
51 ,x_last_updated_by IN NUMBER
52 ,x_last_update_login IN NUMBER);
53
54 PROCEDURE delete_row
55 (x_application_id IN NUMBER
56 ,x_account_type_code IN VARCHAR2
57 ,x_source_application_id IN NUMBER
58 ,x_source_type_code IN VARCHAR2
59 ,x_source_code IN VARCHAR2);
60
61 PROCEDURE load_row
62 (p_application_short_name IN VARCHAR2
63 ,p_account_type_code IN VARCHAR2
64 ,p_source_app_short_name IN VARCHAR2
65 ,p_source_type_code IN VARCHAR2
66 ,p_source_code IN VARCHAR2
67 ,p_owner IN VARCHAR2
68 ,p_last_update_date IN VARCHAR2);
69
70 END xla_tab_ats_f_pkg;