1 PACKAGE JMF_SHIKYU_RECONCILIAITON_PVT AS
2 --$Header: JMFVSKRS.pls 120.0 2005/07/06 00:25 rajkrish noship $
3 --+===========================================================================+
4 --| Copyright (c) YYYY Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+===========================================================================+
8 --| FILENAME |
9 --| JMFVSHRB.pls|
10 --| |
11 --| DESCRIPTION |
12 --| This package is used for SHIKYU Reconciliation purposes
13 --| |
14 --| PROCEDURES: |
15 --| Process_SHIKYU_Reconciliation
16 --| |
17 --| FUNCTIONS: |
18 --| |
19 --| HISTORY |
20 --| May-01 2005 rajkrish created
21 -- Last updated: May-19th afternoon
22 --| |
23 --+===========================================================================+
24
25 --=============================================================================
26 -- TYPE DECLARATIONS
27 --=============================================================================
28
29 --=============================================================================
30 -- CONSTANTS
31 --=============================================================================
32
33 --=============================================================================
34 -- GLOBAL VARIABLES
35 --=============================================================================
36 --g_fnd_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'), 'N');
37
38 --=============================================================================
39 -- PROCEDURES AND FUNCTIONS
40 --=============================================================================e
41 --=============================================================================
42 -- API NAME : Process_SHIKYU_Reconciliation
43 -- TYPE : PRIVATE
44 -- PRE-REQS : SHIKYU datamodel and SHIKYU process should exists
45 -- DESCRIPTION : Process the SHIKYi reconciliation once the
46 --- shikyu Interlock has been run
47 ---
48 -- PARAMETERS :
49 -- p_api_version REQUIRED. API version
50 -- p_init_msg_list REQUIRED. FND_API.G_TRUE to reset the message list
51 -- FND_API.G_FALSE to not reset it.
52 -- If pass NULL, it means FND_API.G_FALSE.
53 -- p_commit OPTIONAL. FND_API.G_TRUE to have API commit the change
54 -- FND_API.G_FALSE to not commit the change.
55 -- Include this if API does DML.
56 -- If pass NULL, it means FND_API.G_FALSE.
57 -- p_validation_level OPTIONAL. value between 0 and 100.
58 -- FND_API.G_VALID_LEVEL_NONE -> 0
59 -- FND_API.G_VALID_LEVEL_FULL -> 100
60 -- Public APIs should not have this parameter
61 -- since it should always be FULL validation.
62 -- If API perform some level not required by
63 -- some API caller, this parameter should be
64 -- included.
65 -- Product group can define intermediate
66 -- validation levels.
67 -- If pass NULL, it means i
68 -- FND_API.G_VALID_LEVEL_FULL
69 --
70 -- x_return_status REQUIRED. Value can be
71 -- FND_API.G_RET_STS_SUCCESS
72 -- FND_API.G_RET_STS_ERROR
73 -- FND_API.G_RET_STS_UNEXP_ERROR
74 -- x_msg_count REQUIRED. Number of messages on the message list
75 -- x_msg_data REQUIRED. Return message data if message count is 1
76 -- p_card_id REQUIRED. Card ID to be deleted.
77 -- EXCEPTIONS :
78 --
79 --=============================================================================
80
81 PROCEDURE Process_SHIKYU_Reconciliation
82 ( p_api_version IN NUMBER
83 , p_init_msg_list IN VARCHAR2
84 , p_commit IN VARCHAR2
85 , p_validation_level IN NUMBER
86 , x_return_status OUT NOCOPY VARCHAR2
87 , x_msg_count OUT NOCOPY NUMBER
88 , x_msg_data OUT NOCOPY VARCHAR2
89 , P_Operating_unit IN NUMBER
90 , p_from_organization IN NUMBER
91 , p_to_organization IN NUMBER
92 );
93
94
95 END JMF_SHIKYU_RECONCILIAITON_PVT ;