[Home] [Help]
PACKAGE: APPS.CSI_ASSET_VLD_PVT
Source
1 PACKAGE CSI_Asset_vld_pvt AUTHID CURRENT_USER AS
2 /* $Header: csivavs.pls 115.15 2003/09/04 00:39:22 sguthiva ship $ */
3
4 /*-----------------------------------------------------------*/
5 /* Procedure name: Check_Reqd_Param */
6 /* Description : To Check if the reqd parameter is passed */
7 /*-----------------------------------------------------------*/
8
9 PROCEDURE Check_Reqd_Param
10 (
11 p_number IN NUMBER,
12 p_param_name IN VARCHAR2,
13 p_api_name IN VARCHAR2
14 );
15
16 /*-----------------------------------------------------------*/
17 /* Procedure name: Check_Reqd_Param */
18 /* Description : To Check if the reqd parameter is passed */
19 /*-----------------------------------------------------------*/
20
21 PROCEDURE Check_Reqd_Param
22 (
23 p_variable IN VARCHAR2,
24 p_param_name IN VARCHAR2,
25 p_api_name IN VARCHAR2
26 );
27
28 /*-----------------------------------------------------------*/
29 /* Procedure name: Check_Reqd_Param */
30 /* Description : To Check if the reqd parameter is passed */
31 /*-----------------------------------------------------------*/
32
33 PROCEDURE Check_Reqd_Param
34 (
35 p_date IN DATE,
36 p_param_name IN VARCHAR2,
37 p_api_name IN VARCHAR2
38 );
39
40 /*-----------------------------------------------------------*/
41 /* Procedure name: Is_InstanceID_Valid */
42 /* Description : Check if the Instance Id exists */
43 /*-----------------------------------------------------------*/
44
45
46 FUNCTION Is_InstanceID_Valid
47 ( p_instance_id IN NUMBER,
48 p_check_for_instance_expiry IN VARCHAR2,
49 p_stack_err_msg IN BOOLEAN DEFAULT TRUE
50 ) RETURN BOOLEAN;
51
52 /*-----------------------------------------------------------*/
53 /* Procedure name: generate_inst_asset_id */
54 /* Description : Generate instance asset id from */
55 /* the sequence */
56 /*-----------------------------------------------------------*/
57
58 FUNCTION gen_inst_asset_id
59 RETURN NUMBER;
60
61 /*-----------------------------------------------------------*/
62 /* Procedure name: Is_Inst_assetID_exists */
63 /* Description : Check if the instance asset id */
64 /* exists in csi_i_assets */
65 /*-----------------------------------------------------------*/
66
67 FUNCTION Is_Inst_assetID_exists
68
69 ( p_instance_asset_id IN NUMBER,
70 p_stack_err_msg IN BOOLEAN DEFAULT TRUE
71 ) RETURN BOOLEAN ;
72
73 /*-----------------------------------------------------------*/
74 /* Procedure name: Is_Inst_asset_id_valid */
75 /* Description : Check if the instance asset id */
76 /* exists in csi_i_assets */
77 /*-----------------------------------------------------------*/
78
79 FUNCTION Is_Inst_asset_id_valid
80
81 ( p_instance_asset_id IN NUMBER,
82 p_stack_err_msg IN BOOLEAN DEFAULT TRUE
83 ) RETURN BOOLEAN ;
84
85 /*-----------------------------------------------------------*/
86 /* Procedure name: Is_Update_Status_Exists */
87 /* Description : Check if the update status is */
88 /* defined in fnd_lookups */
89 /*-----------------------------------------------------------*/
90
91 FUNCTION Is_Update_Status_Exists
92 (
93 p_update_status IN VARCHAR2,
94 p_stack_err_msg IN BOOLEAN DEFAULT TRUE
95 ) RETURN BOOLEAN;
96
97
98 /*-----------------------------------------------------------*/
99 /* Procedure name: Is_Quantity_Valid */
100 /* Description : Check if the asset quantity > 0 */
101 /*-----------------------------------------------------------*/
102
103 FUNCTION Is_Quantity_Valid
104 (
105 p_asset_quantity IN NUMBER,
106 p_stack_err_msg IN BOOLEAN DEFAULT TRUE
107 ) RETURN BOOLEAN;
108
109
110 /*-----------------------------------------------------------*/
111 /* Procedure name: generate_inst_asset_hist_id */
112 /* Description : Generate instance asset id from */
113 /* the sequence */
114 /*-----------------------------------------------------------*/
115
116 FUNCTION gen_inst_asset_hist_id
117 RETURN NUMBER;
118 /*-----------------------------------------------------------*/
119 /* Procedure name: Is_Asset_Comb_Valid */
120 /* Description : Check if the instance asset id and location */
121 /* id exists in fa_books */
122 /*-----------------------------------------------------------*/
123
124 FUNCTION Is_Asset_Comb_Valid
125
126 ( p_asset_id IN NUMBER,
127 p_book_type_code IN VARCHAR2,
128 p_stack_err_msg IN BOOLEAN DEFAULT TRUE
129 ) RETURN BOOLEAN ;
130
131 /*-----------------------------------------------------------*/
132 /* Procedure name: Is_Asset_Location_Valid */
133 /* Description : Check if the instance location id */
134 /* exists in csi_a_locations */
135 /*-----------------------------------------------------------*/
136
137 FUNCTION Is_Asset_Location_Valid
138 ( p_location_id IN NUMBER,
139 p_stack_err_msg IN BOOLEAN DEFAULT TRUE
140 ) RETURN BOOLEAN ;
141
142 /*-----------------------------------------------------------*/
143 /* Procedure name: Is_StartDate_Valid */
144 /* Description : Check if instance assets active start */
145 /* date is valid */
146 /*-----------------------------------------------------------*/
147
148 FUNCTION Is_StartDate_Valid
149 ( p_start_date IN DATE,
150 p_end_date IN DATE,
151 p_instance_id IN NUMBER,
152 p_check_for_instance_expiry IN VARCHAR2, -- Added for cse on 14-feb-03
153 p_stack_err_msg IN BOOLEAN DEFAULT TRUE
154 ) RETURN BOOLEAN;
155
156 /*----------------------------------------------------------*/
157 /* Function Name : Is_EndDate_Valid */
158 /* */
159 /* Description : This function checks if end date */
160 /* is valid */
161 /*----------------------------------------------------------*/
162
163 FUNCTION Is_EndDate_Valid
164 (
165 p_start_date IN DATE,
166 p_end_date IN DATE,
167 p_instance_id IN NUMBER,
168 p_inst_asset_id IN NUMBER,
169 p_txn_id IN NUMBER,
170 p_check_for_instance_expiry IN VARCHAR2, -- Added for cse on 14-feb-03
171 p_stack_err_msg IN BOOLEAN DEFAULT TRUE
172 ) RETURN BOOLEAN;
173
174
175 END CSI_Asset_vld_pvt ;
176