1 PACKAGE GCS_ENTRY_PKG AUTHID CURRENT_USER AS
2 /* $Header: gcsentrys.pls 120.7 2007/10/09 07:18:19 smatam ship $ */
3 --
4 -- Procedure
5 -- upload_entry_headers
6 -- Purpose
7 -- An API to handle entry headers upload from Web ADI
8 -- Arguments
9 -- Notes
10 --
11 PROCEDURE upload_entry_headers(p_entry_id_char IN OUT NOCOPY VARCHAR2,
12 p_end_cal_period_id IN VARCHAR2,
13 p_hierarchy_id IN NUMBER,
14 p_entity_id IN VARCHAR2,
15 p_start_cal_period_id IN VARCHAR2,
16 p_currency_code IN VARCHAR2,
17 p_process_code IN VARCHAR2,
18 p_description IN VARCHAR2,
19 p_entry_name IN VARCHAR2,
20 p_category_code IN VARCHAR2,
21 p_balance_type_code IN VARCHAR2,
22 p_writeback_needed IN VARCHAR2,
23 p_ledger_id IN VARCHAR2,
24 p_cal_period_name IN VARCHAR2,
25 p_conversion_type IN VARCHAR2,
26 p_hierarchy_grp_flag IN VARCHAR2);
27
28 --
29 -- Procedure
30 -- Manual_Entries_Import
31 -- Purpose
32 -- An API to import entry from Web ADI
33 -- Arguments
34 -- Notes
35 --
36 PROCEDURE manual_entries_import(p_entry_id_char IN VARCHAR2,
37 p_end_cal_period_id IN VARCHAR2,
38 p_hierarchy_id IN NUMBER,
39 p_entity_id_char IN VARCHAR2,
40 p_start_cal_period_id IN VARCHAR2,
41 p_currency_code IN VARCHAR2,
42 p_process_code IN VARCHAR2,
43 p_description IN VARCHAR2,
44 p_entry_name IN VARCHAR2,
45 p_category_code IN VARCHAR2,
46 p_balance_type_code IN VARCHAR2,
47 p_writeback_needed IN VARCHAR2,
48 p_ledger_id IN VARCHAR2,
49 p_cal_period_name IN VARCHAR2,
50 p_conversion_type IN VARCHAR2,
51 p_new_entry_id IN NUMBER,
52 p_hierarchy_grp_flag IN VARCHAR2);
53
54 -- PROCEDURE
55 -- create_entry_header
56 -- Purpose
57 -- An API to create an entry header row
58 -- Arguments
59 -- x_errbuf Error Buffer
60 -- x_retcode Return Code; possible values are fnd_api.g_ret_sts_success, fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_unexp_error
61 -- p_entry_id Entry Identifier; if NULL, will create from the sequence
62 -- p_hierarchy_id Hierarchy Identifier
63 -- p_entity_id Entity Identifier
64 -- p_start_cal_period_id Start Calender Period Identifier
65 -- p_end_cal_period_id End Calender Period Identifier
66 -- p_entry_type_code Entry Type Code
67 -- p_balance_type_code Balance Type Code
68 -- p_currency_code Currency Code
69 -- p_process_code Process Code
70 -- p_category_code Category Code
71 -- p_xlate_flag Translation Indicator; Only set to 'Y' when calling from translation package
72 -- p_rule_id Elimination Rule Identifier
73 -- p_period_init_entry_flag Period Initialization Entry Flag
74 -- Notes
75 --
76 PROCEDURE create_entry_header(x_errbuf OUT NOCOPY VARCHAR2,
77 x_retcode OUT NOCOPY VARCHAR2,
78 p_entry_id IN OUT NOCOPY NUMBER,
79 p_hierarchy_id IN NUMBER,
80 p_entity_id IN NUMBER,
81 p_start_cal_period_id IN NUMBER,
82 p_end_cal_period_id IN NUMBER,
83 p_entry_type_code IN VARCHAR2,
84 p_balance_type_code IN VARCHAR2,
85 p_currency_code IN VARCHAR2,
86 p_process_code IN VARCHAR2,
87 p_category_code IN VARCHAR2,
88 p_xlate_flag IN VARCHAR2 DEFAULT 'N',
89 p_rule_id IN NUMBER DEFAULT NULL,
90 p_period_init_entry_flag IN VARCHAR2 DEFAULT 'N');
91 PROCEDURE insert_entry_header(x_errbuf OUT NOCOPY VARCHAR2,
92 x_retcode OUT NOCOPY VARCHAR2,
93 p_entry_id IN NUMBER,
94 p_hierarchy_id IN NUMBER,
95 p_entity_id IN NUMBER,
96 p_year_to_apply_re IN NUMBER,
97 p_start_cal_period_id IN NUMBER,
98 p_end_cal_period_id IN NUMBER,
99 p_entry_type_code IN VARCHAR2,
100 p_balance_type_code IN VARCHAR2,
101 p_currency_code IN VARCHAR2,
102 p_process_code IN VARCHAR2,
103 p_category_code IN VARCHAR2,
104 p_entry_name IN VARCHAR2,
105 p_description IN VARCHAR2,
106 p_period_init_entry_flag IN VARCHAR2 DEFAULT 'N');
107
108 --
109 -- Procedure
110 -- delete_entry
111 -- Purpose
112 -- An API to delete an entry from both gcs_entry_headers and gcs_entry_lines tables
113 -- Arguments
114 -- p_entry_id Entry Identifier
115 -- x_errbuf Error Buffer
116 -- x_retcode Return Code
117 -- Notes
118 --
119 PROCEDURE delete_entry(p_entry_id IN NUMBER,
120 x_errbuf OUT NOCOPY VARCHAR2,
121 x_retcode OUT NOCOPY VARCHAR2);
122
123 --
124 -- Procedure
125 -- raise_disable_event
126 -- Purpose
127 -- An API to disable an entry and track impact analysis and notify
128 -- Arguments
129 -- p_entry_id Entry Identifier
130 -- p_cal_period_id Calendar Period Identifier
131 -- Notes
132 -- Bugfix 5613302
133 PROCEDURE raise_disable_event(p_entry_id IN NUMBER,
134 p_cal_period_id IN NUMBER);
135
136 END gcs_entry_pkg;
137
[Home] [Help]