1 PACKAGE xla_third_party_merge AUTHID CURRENT_USER AS
2 -- $Header: xlamerge.pkh 120.0 2005/10/28 22:27:09 weshen noship $
3 /*===========================================================================+
4 | Copyright (c) 2005 Oracle Corporation |
5 | Redwood Shores, CA, USA |
6 | All rights reserved. |
7 +============================================================================+
8 | FILENAME |
9 | xlamerge.pkh |
10 | |
11 | PACKAGE NAME |
12 | xla_third_party_merge |
13 | |
14 | DESCRIPTION |
15 | This is a XLA private package, which contains all the APIs required for |
16 | creating Third Party Merge events. |
17 | |
18 | The public wrapper called xla_third_party_merge_pub, is built based on |
19 | this package. |
20 | |
21 | Note: |
22 | - the APIs do not execute any COMMIT |
23 | - the APIs may perform ROLLBACK for what changes they have made |
24 | - these APIs are not supposed to raise any exception |
25 | |
26 | HISTORY |
27 | 08-Sep-05 L. Poon Created |
28 +===========================================================================*/
29
30 -------------------------------------------------------------------------------
31 -- Third party merge event creation routine
32 -------------------------------------------------------------------------------
33 PROCEDURE third_party_merge
34 ( x_errbuf OUT NOCOPY VARCHAR2
35 , x_retcode OUT NOCOPY VARCHAR2
36 , x_event_ids OUT NOCOPY xla_third_party_merge_pub.t_event_ids
37 , x_request_id OUT NOCOPY INTEGER
38 , p_source_application_id IN INTEGER DEFAULT NULL
39 , p_application_id IN INTEGER
40 , p_ledger_id IN INTEGER DEFAULT NULL
41 , p_third_party_merge_date IN DATE
42 , p_third_party_type IN VARCHAR2
43 , p_original_third_party_id IN INTEGER
44 , p_original_site_id IN INTEGER DEFAULT NULL
45 , p_new_third_party_id IN INTEGER
46 , p_new_site_id IN INTEGER DEFAULT NULL
47 , p_type_of_third_party_merge IN VARCHAR2
48 , p_mapping_flag IN VARCHAR2
49 , p_execution_mode IN VARCHAR2
50 , p_accounting_mode IN VARCHAR2
51 , p_transfer_to_gl_flag IN VARCHAR2
52 , p_post_in_gl_flag IN VARCHAR2);
53
54 -------------------------------------------------------------------------------
55 -- Create third party merge accounting routine
56 -------------------------------------------------------------------------------
57 PROCEDURE create_accounting
58 ( x_errbuf OUT NOCOPY VARCHAR2
59 , x_retcode OUT NOCOPY VARCHAR2
60 , p_application_id IN INTEGER
61 , p_event_id IN INTEGER DEFAULT NULL
62 , p_accounting_mode IN VARCHAR2
63 , p_transfer_to_gl_flag IN VARCHAR2
64 , p_post_in_gl_flag IN VARCHAR2
65 , p_merge_event_set_id IN INTEGER DEFAULT NULL
66 , p_srs_flag IN VARCHAR2 DEFAULT NULL);
67
68 END xla_third_party_merge;