1 PACKAGE xla_hist_ledger_upg_pkg AUTHID CURRENT_USER AS
2 /* $Header: xlahupg.pkh 120.4.12010000.2 2010/01/03 07:59:13 vkasina ship $ */
3 /*======================================================================+
4 | Copyright (c) 2000-2001 Oracle Corporation |
5 | Redwood Shores, CA, USA |
6 | All rights reserved. |
7 +=======================================================================+
8 | PACKAGE NAME |
9 | xla_hist_ledger_upg_pkg |
10 | |
11 | |
12 | DESCRIPTION |
13 | Description |
14 | |
15 | HISTORY |
16 | 01-DEC-07 Kapil Kumar Created |
17 | 02-JAN-10 Kapil Kumar PHASE2 (redesign) |
18 | |
19 +======================================================================*/
20
21
22
23 PROCEDURE upg_main
24 (
25 p_errbuf OUT NOCOPY VARCHAR2
26 ,p_retcode OUT NOCOPY NUMBER
27 ,p_application_id IN NUMBER
28 ,p_primary_ledger_id IN NUMBER
29 ,p_sec_alc_ledger_id IN NUMBER
30 ,p_rep_ledger_type IN VARCHAR2
31 ,p_mode IN VARCHAR2
32 ,p_mode_check IN VARCHAR2
33 ,p_start_date IN DATE
34 ,p_conversion_option IN VARCHAR2
35 ,p_currency_conversion_type IN VARCHAR2
36 ,p_currency_conversion_date IN DATE
37 ,p_batch_size IN NUMBER
38 ,p_num_workers IN NUMBER
39 );
40
41
42
43 PROCEDURE validate_recovery_mode;
44
45
46 PROCEDURE validate_final_mode;
47
48
49 PROCEDURE retrieve_validate;
50
51
52 PROCEDURE populate_rates;
53
54 PROCEDURE insert_data(p_primary_ledger_id IN NUMBER,
55 p_sec_alc_ledger_id IN NUMBER,
56 p_application_id IN NUMBER,
57 p_relationship_id IN NUMBER,
58 p_upgrade_id IN NUMBER,
59 p_script_name IN VARCHAR2,
60 p_batch_size IN NUMBER,
61 p_num_workers IN NUMBER);
62
63 PROCEDURE historic_worker
64 (
65 p_errbuf OUT NOCOPY VARCHAR2
66 ,p_retcode OUT NOCOPY NUMBER
67 ,p_batch_size IN NUMBER
68 ,p_worker_id IN NUMBER
69 ,p_num_workers IN NUMBER
70 ,p_script_name IN VARCHAR2
71 ,p_application_id IN NUMBER
72 ,p_primary_ledger_id IN NUMBER
73 ,p_sec_alc_ledger_id IN NUMBER
74 ,p_ugprade_id IN NUMBER
75 ,p_relationship_id IN NUMBER
76 ,p_ccid_map IN VARCHAR2
77 ,p_calendar_convert IN VARCHAR2
78 ,p_dynamic_flag IN VARCHAR2
79 ,p_mapping_rel_id IN NUMBER
80 ,p_coa_map_name IN VARCHAR2
81 );
82
83 END xla_hist_ledger_upg_pkg;