1 PACKAGE XLA_UPGRADE_PUB AUTHID CURRENT_USER AS
2 -- $Header: xlaugupg.pkh 120.14.12010000.3 2009/08/12 15:42:17 vgopiset ship $
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 | 22-JUL-2009 VGOPISET 8717476 :Enabled SET_STATUS_CODE procedure to |
28 | run On Demand Upgrade by Concurrent Program |
29 +===========================================================================*/
30
31 PROCEDURE Insert_Line_Criteria (
32 p_batch_id IN NUMBER
33 , p_batch_size IN NUMBER
34 , p_application_id IN NUMBER
35 , p_error_detected OUT NOCOPY BOOLEAN
36 , p_overwrite_flag IN BOOLEAN);
37
38 FUNCTION set_migration_status_code
39 (p_application_id in number,
40 p_set_of_books_id in number,
41 p_period_name in varchar2 default null,
42 p_period_year in number default null)
43 return varchar2;
44
45 -- Re-Enabled procedure for bug:8717476
46 PROCEDURE set_status_code
47 (p_errbuf OUT NOCOPY VARCHAR2,
48 p_retcode OUT NOCOPY NUMBER,
49 p_application_id IN NUMBER,
50 p_ledger_id IN NUMBER,
51 p_period_name IN VARCHAR2,
52 p_number_of_workers IN NUMBER,
53 p_batch_size IN NUMBER);
54
55 PROCEDURE Validate_Header_Line_Entries
56 (p_application_id IN NUMBER,
57 p_header_id IN NUMBER );
58
59 PROCEDURE pre_upgrade_set_status_code
60 (p_error_buf OUT NOCOPY VARCHAR2,
61 p_retcode OUT NOCOPY NUMBER,
62 p_migrate_all_ledgers IN VARCHAR2,
63 p_dummy_parameter IN VARCHAR2,
64 p_ledger_id IN NUMBER DEFAULT NULL,
65 p_start_date IN VARCHAR2);
66
67
68 END XLA_UPGRADE_PUB;