DBA Data[Home] [Help]

PACKAGE: APPS.JMF_SHIKYU_RECONCILIAITON_PVT

Source


1 PACKAGE JMF_SHIKYU_RECONCILIAITON_PVT AUTHID CURRENT_USER 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 ;