[Home] [Help]
PACKAGE: APPS.XLA_THIRD_PARTY_MERGE_PUB
Source
1 PACKAGE xla_third_party_merge_pub AUTHID CURRENT_USER AS
2 -- $Header: xlamergp.pkh 120.0 2005/10/28 22:21:08 weshen noship $
3 /*===========================================================================+
4 | Copyright (c) 2005 Oracle Corporation |
5 | Redwood Shores, CA, USA |
6 | All rights reserved. |
7 +============================================================================+
8 | FILENAME |
9 | xlamergp.pkh |
10 | |
11 | PACKAGE NAME |
12 | xla_third_party_merge_pub |
13 | |
14 | DESCRIPTION |
15 | This is a public package for product teams, which contains all the |
16 | APIs required for creating Third Party Merge events. |
17 | |
18 | Note: the APIs do not excute COMMIT or ROLLBACK. |
19 | |
20 | These public APIs are wrapper over public routines of |
21 | xla_third_party_merge |
22 | |
23 | HISTORY |
24 | 08-Sep-05 L. Poon Created |
25 +===========================================================================*/
26
27 -------------------------------------------------------------------------------
28 -- Global variables
29 -------------------------------------------------------------------------------
30 G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := 'S';
31 G_RET_STS_WARN CONSTANT VARCHAR2(1) := 'W';
32 G_RET_STS_ERROR CONSTANT VARCHAR2(1) := 'E';
33 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := 'U';
34
35 -------------------------------------------------------------------------------
36 -- Global types
37 -------------------------------------------------------------------------------
38 TYPE t_event_ids IS TABLE OF NUMBER(15) INDEX BY BINARY_INTEGER;
39
40 -------------------------------------------------------------------------------
41 -- Third party merge event creation routine
42 -------------------------------------------------------------------------------
43 PROCEDURE third_party_merge
44 ( x_errbuf OUT NOCOPY VARCHAR2
45 , x_retcode OUT NOCOPY VARCHAR2
46 , x_event_ids OUT NOCOPY t_event_ids
47 , x_request_id OUT NOCOPY INTEGER
48 , p_source_application_id IN INTEGER DEFAULT NULL
49 , p_application_id IN INTEGER
50 , p_ledger_id IN INTEGER DEFAULT NULL
51 , p_third_party_merge_date IN DATE
52 , p_third_party_type IN VARCHAR2
53 , p_original_third_party_id IN INTEGER
54 , p_original_site_id IN INTEGER DEFAULT NULL
55 , p_new_third_party_id IN INTEGER
56 , p_new_site_id IN INTEGER DEFAULT NULL
57 , p_type_of_third_party_merge IN VARCHAR2
58 , p_mapping_flag IN VARCHAR2
59 , p_execution_mode IN VARCHAR2
60 , p_accounting_mode IN VARCHAR2
61 , p_transfer_to_gl_flag IN VARCHAR2
62 , p_post_in_gl_flag IN VARCHAR2);
63
64 -------------------------------------------------------------------------------
65 -- Create third party merge accounting routine - called by SRS
66 -------------------------------------------------------------------------------
67 PROCEDURE create_accounting
68 ( x_errbuf OUT NOCOPY VARCHAR2
69 , x_retcode OUT NOCOPY VARCHAR2
70 , p_application_id IN INTEGER
71 , p_event_id IN INTEGER DEFAULT NULL
72 , p_accounting_mode IN VARCHAR2
73 , p_transfer_to_gl_flag IN VARCHAR2
74 , p_post_in_gl_flag IN VARCHAR2
75 , p_merge_event_set_id IN INTEGER DEFAULT NULL);
76
77 END xla_third_party_merge_pub;