1 PACKAGE FA_MASS_RECLASS_PKG AUTHID CURRENT_USER AS
2 /* $Header: FAXMRCLS.pls 120.4 2009/03/27 04:10:28 bridgway 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 ) RETURN BOOLEAN;
53
54
55 /*=====================================================================================+
56 |
57 | Name: Check_Criteria
58 |
59 | Description: Function to make sure additional user selection criteria are met for
60 | the given asset.
61 |
62 | Parameters: X_Asset_Id -- Asset to reclass.
63 | X_Fully_Rsvd_Flag -- User selection criteria to include fully
64 | reserved assets or not.
65 |
66 | Returns: TRUE -- if the asset passes all the criteria.
67 | FALSE -- if the asset fails any one of the criteria.
68 |
69 | Notes:
70 |
71 +======================================================================================*/
72
73 FUNCTION Check_Criteria(
74 X_Asset_Id IN NUMBER,
75 X_Fully_Rsvd_Flag IN VARCHAR2
76 ) RETURN BOOLEAN;
77
78
79 --------------------------------------------------------------------------------------
80
81 PROCEDURE write_message
82 (p_asset_number in varchar2,
83 p_message in varchar2);
84
85 END FA_MASS_RECLASS_PKG;