DBA Data[Home] [Help]

PACKAGE: APPS.FARX_MCP

Source


1 PACKAGE FARX_MCP AS
2 /* $Header: FARXMCPS.pls 120.0 2004/07/06 18:45:40 bridgway noship $ */
3 
4 
5 
6 /*=====================================================================================+
7 |
8 |   Name:          Preview_Change
9 |
10 |   Description:   Procedure for mass change preview.
11 |                  This procedure is called from the concurrent wrapper procedure
12 |                  FARX_C_CP.Mass_Change_Preview().
13 |                  This procedure inserts the results into the interface table:
14 |                     FA_MASS_CHANGE_ITF.
15 |                  User asset selection and change criteria are fetched from
16 |                  FA_MASS_CHANGES table.
17 |
18 |   Parameters:    X_Mass_Change_Id -- Mass Change ID from FA_MASS_CHANGES table.
19 |                  X_RX_Flag -- Indicates whether this procedure is called from
20 |                               RX report or not.
21 |                  retcode -- OUT parameter.  Denotes completion status.
22 |                        0 -- Completed normally.
23 |                        1 -- Completed with warning.
24 |                        2 -- Completed with error.
25 |                  errbuf -- OUT parameter.  Error or warning description.
26 |
27 |   Returns:
28 |
29 |   Notes:
30 |
31 +=====================================================================================*/
32 
33 PROCEDURE Preview_Change(
34      X_Mass_Change_Id     IN     NUMBER,
35      X_RX_Flag            IN     VARCHAR2 := 'NO',
36      retcode              OUT NOCOPY NUMBER,
37      errbuf               OUT NOCOPY VARCHAR2);
38 
39 
40 /*=====================================================================================+
41 |
42 |   Name:          Store_Results
43 |
44 |   Description:   Procedure to store the preview results of an asset into a
45 |                  private pl/sql asset table(of type
46 |                  FA_MASS_CHG_UTILS_PKG.asset_table) for all the books
47 |                  the asset belongs to.  Proper conversions for output
48 |                  are taken care of in this procedure.
49 |
50 |   Parameters:    X_mc_rec
51 |                  X_to_rsr  (new rate source rule)
52 |                  X_cat_Flex_Struct
53 |
54 |   Returns:
55 |
56 |   Notes:
57 |
58 +=====================================================================================*/
59 
60 PROCEDURE Store_Results(
61      X_mc_rec              IN  FA_MASS_CHG_UTILS_PKG.mass_change_rec_type,
62      X_To_RSR              IN  VARCHAR2,
63      X_Cat_Flex_Struct     IN  NUMBER   := NULL
64      );
65 
66 
67 
68 END FARX_MCP;