1 PACKAGE XLA_UPGRADE_PUB AS
2 -- $Header: xlaugupg.pkh 120.14 2006/11/08 16:50:39 jlarre noship $
3 /*===========================================================================+
4 | Copyright (c) 2001-2002 Oracle Corporation |
5 | Redwood Shores, CA, USA |
6 | All rights reserved. |
7 +============================================================================+
8 | FILENAME |
9 | xlaugupg.pkh |
10 | |
11 | PACKAGE NAME |
12 | XLA_UPGRADE_PUB |
13 | |
14 | DESCRIPTION |
15 | This is a XLA package which contains all the APIs required by the |
16 | product teams to validate data in journal entry tables and also to |
17 | input data in analytical criteria and ae segment values tables. |
18 | HISTORY |
19 | 15-Dec-04 G. Bellary Created |
20 | 23-Jun-05 V. Mahajan Modified |
21 | 04-Jan-06 Koushik VS Modified Set_Status_Code to include number |
22 | of workers and batch size. |
23 | 16-May-06 Jorge Larre Add pre_upgrade_set_status_code |
24 | 08-NOV-2006 Jorge Larre Bug 5648571: Obsolete the procedure |
25 | set_status_code. This change is to be in sync with xlaugupg.pkb. |
26 | The code is left commented in case we decide to use it again. |
27 +===========================================================================*/
28
29 PROCEDURE Insert_Line_Criteria (
30 p_batch_id IN NUMBER
31 , p_batch_size IN NUMBER
32 , p_application_id IN NUMBER
33 , p_error_detected OUT NOCOPY BOOLEAN
34 , p_overwrite_flag IN BOOLEAN);
35
36 FUNCTION set_migration_status_code
37 (p_application_id in number,
38 p_set_of_books_id in number,
39 p_period_name in varchar2 default null,
40 p_period_year in number default null)
41 return varchar2;
42
43 --PROCEDURE set_status_code
44 --(p_error_buf OUT NOCOPY VARCHAR2,
45 -- p_retcode OUT NOCOPY NUMBER,
46 -- p_application_id IN NUMBER,
47 -- p_ledger_id IN NUMBER,
48 -- p_period_name IN VARCHAR2,
49 -- p_number_of_workers IN NUMBER,
50 -- p_batch_size IN NUMBER);
51
52 PROCEDURE Validate_Header_Line_Entries
53 (p_application_id IN NUMBER,
54 p_header_id IN NUMBER );
55
56 PROCEDURE pre_upgrade_set_status_code
57 (p_error_buf OUT NOCOPY VARCHAR2,
58 p_retcode OUT NOCOPY NUMBER,
59 p_migrate_all_ledgers IN VARCHAR2,
60 p_dummy_parameter IN VARCHAR2,
61 p_ledger_id IN NUMBER DEFAULT NULL,
62 p_start_date IN VARCHAR2);
63
64
65 END XLA_UPGRADE_PUB;