1 PACKAGE xla_subledgers_f_pkg AUTHID CURRENT_USER AS
2 /* $Header: xlatbapp.pkh 120.9.12010000.2 2009/12/28 09:19:54 vkasina ship $ */
3 /*======================================================================+
4 | Copyright (c) 2001-2002 Oracle Corporation |
5 | Redwood Shores, CA, USA |
6 | All rights reserved. |
7 +=======================================================================+
8 | PACKAGE NAME |
9 | xla_subledgers |
10 | |
11 | DESCRIPTION |
12 | Forms PL/SQL Wrapper for xla_subledgers |
13 | |
14 | HISTORY |
15 | 08/06/02 W Chan Created |
16 | 09/05/04 W Chan Add load_row API to be used by FNDLOAD |
17 | |
18 +======================================================================*/
19
20
21
22 PROCEDURE insert_row
23 (x_rowid IN OUT NOCOPY VARCHAR2
24 ,x_application_id IN NUMBER
25 ,x_application_type_code IN VARCHAR2
26 ,x_je_source_name IN VARCHAR2
27 ,x_valuation_method_flag IN VARCHAR2
28 ,x_drilldown_procedure_name IN VARCHAR2
29 ,x_security_function_name IN VARCHAR2
30 -- ,x_control_account_enabled_flag IN VARCHAR2
31 -- ,x_control_account_source_code IN VARCHAR2
32 -- ,x_default_party_type_code IN VARCHAR2
33 ,x_control_account_type_code IN VARCHAR2
34 ,x_alc_enabled_flag IN VARCHAR2
35 ,x_creation_date IN DATE
36 ,x_created_by IN NUMBER
37 ,x_last_update_date IN DATE
38 ,x_last_updated_by IN NUMBER
39 ,x_last_update_login IN NUMBER);
40
41 PROCEDURE lock_row
42 (x_application_id IN NUMBER
43 ,x_application_type_code IN VARCHAR2
44 ,x_je_source_name IN VARCHAR2
45 ,x_valuation_method_flag IN VARCHAR2
46 ,x_drilldown_procedure_name IN VARCHAR2
47 ,x_security_function_name IN VARCHAR2
48 -- ,x_control_account_enabled_flag IN VARCHAR2
49 -- ,x_control_account_source_code IN VARCHAR2
50 -- ,x_default_party_type_code IN VARCHAR2
51 ,x_control_account_type_code IN VARCHAR2
52 ,x_alc_enabled_flag IN VARCHAR2);
53
54 PROCEDURE update_row
55 (x_application_id IN NUMBER
56 ,x_application_type_code IN VARCHAR2 DEFAULT NULL
57 ,x_je_source_name IN VARCHAR2
58 ,x_valuation_method_flag IN VARCHAR2
59 ,x_drilldown_procedure_name IN VARCHAR2
60 ,x_security_function_name IN VARCHAR2
61 -- ,x_control_account_enabled_flag IN VARCHAR2
62 -- ,x_control_account_source_code IN VARCHAR2
63 -- ,x_default_party_type_code IN VARCHAR2
64 ,x_control_account_type_code IN VARCHAR2
65 ,x_alc_enabled_flag IN VARCHAR2
66 ,x_last_update_date IN DATE
67 ,x_last_updated_by IN NUMBER
68 ,x_last_update_login IN NUMBER);
69
70 PROCEDURE delete_row
71 (x_application_id IN NUMBER);
72
73 PROCEDURE load_row
74 (p_application_short_name IN VARCHAR2
75 ,p_je_source_name IN VARCHAR2
76 ,p_valuation_method_flag IN VARCHAR2
77 ,p_drilldown_procedure_name IN VARCHAR2
78 ,p_security_function_name IN VARCHAR2
79 ,p_application_type_code IN VARCHAR2
80 --,p_control_account_enabled_flag IN VARCHAR2
81 --,p_default_party_type_code IN VARCHAR2
82 ,p_alc_enabled_flag IN VARCHAR2
83 ,p_control_account_type_code IN VARCHAR2
84 ,p_owner IN VARCHAR2
85 ,p_last_update_date IN VARCHAR2);
86
87 END xla_subledgers_f_pkg;