1 PACKAGE FA_MASS_RECLASS_PKG AS
2 /* $Header: FAXMRCLS.pls 120.3 2005/06/24 17:00:38 snarayan ship $ */
3
4 /*=====================================================================================+
5 |
6 | Name: Do_Mass_Reclass
7 |
8 | Description: Mass transaction procedure for mass reclass.
9 | This procedure is no longer called from the concurrent
10 | wrapper procedure FA_C_MASS_RECLASS.Mass_Reclass().
11 |
12 | Instead it is called from a new pro*c wrapper (famrcl.opc)
13 |
14 | Returns:
15 |
16 | Notes: 02/01/02 bridgway overhauled to be called from pro*c wrapper
17 |
18 +=====================================================================================*/
19
20 PROCEDURE Do_Mass_Reclass(
21 p_mass_reclass_id IN NUMBER,
22 p_parent_request_id IN NUMBER,
23 p_total_requests IN NUMBER,
24 p_request_number IN NUMBER,
25 px_max_asset_id IN OUT NOCOPY NUMBER,
26 x_processed_count OUT NOCOPY NUMBER,
27 x_success_count OUT NOCOPY number,
28 x_failure_count OUT NOCOPY number,
29 x_return_status OUT NOCOPY number);
30
31 /*=====================================================================================+
32 |
33 | Name: Check_Trans_Date
34 |
35 | Description: Function to check if reclass transaction date for the mass
36 | reclass record from mass reclass form is in the current
37 | corporate book period.
38 |
39 | Parameters: X_Corp_Book -- Corporate book to reclass.
40 | X_Trans_Date -- Reclass transaction date.
41 |
42 | Returns: TRUE -- if reclass date is in current corporate book period.
43 | FALSE -- if reclass date is in the prior corporate book period.
44 |
45 | Notes:
46 |
47 +======================================================================================*/
48
49 FUNCTION Check_Trans_Date(
50 X_Corp_Book IN VARCHAR2,
51 X_Trans_Date IN DATE,
52 p_log_level_rec IN fa_api_types.log_level_rec_type default null
53 ) RETURN BOOLEAN;
54
55
56 /*=====================================================================================+
57 |
58 | Name: Check_Criteria
59 |
60 | Description: Function to make sure additional user selection criteria are met for
61 | the given asset.
62 |
63 | Parameters: X_Asset_Id -- Asset to reclass.
64 | X_Fully_Rsvd_Flag -- User selection criteria to include fully
65 | reserved assets or not.
66 |
67 | Returns: TRUE -- if the asset passes all the criteria.
68 | FALSE -- if the asset fails any one of the criteria.
69 |
70 | Notes:
71 |
72 +======================================================================================*/
73
74 FUNCTION Check_Criteria(
75 X_Asset_Id IN NUMBER,
76 X_Fully_Rsvd_Flag IN VARCHAR2,
77 p_log_level_rec IN fa_api_types.log_level_rec_type default null
78 ) RETURN BOOLEAN;
79
80
81 --------------------------------------------------------------------------------------
82
83 PROCEDURE write_message
84 (p_asset_number in varchar2,
85 p_message in varchar2,
86 p_log_level_rec IN fa_api_types.log_level_rec_type default null);
87
88 END FA_MASS_RECLASS_PKG;