APPS.CSI_ASSET_VLD_PVT dependencies on CSI_I_ASSETS

Line 135: SELECT CSI_I_ASSETS_S.nextval

131:
132: l_inst_asset_id NUMBER;
133:
134: BEGIN
135: SELECT CSI_I_ASSETS_S.nextval
136: INTO l_inst_asset_id
137: FROM sys.dual;
138:
139: RETURN l_inst_asset_id;

Line 146: /* exists in csi_i_assets */

142:
143: /*-----------------------------------------------------------*/
144: /* Procedure name: Is_Inst_assetID_exists */
145: /* Description : Check if the instance asset id */
146: /* exists in csi_i_assets */
147: /*-----------------------------------------------------------*/
148:
149: FUNCTION Is_Inst_assetID_exists
150:

Line 160: FROM csi_i_assets

156: l_return_value BOOLEAN := TRUE;
157: BEGIN
158: SELECT 'x'
159: INTO l_dummy
160: FROM csi_i_assets
161: WHERE instance_asset_id = p_instance_asset_id ;
162:
163: IF ( p_stack_err_msg = TRUE ) THEN
164: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_INST_ASSET_ID');

Line 178: /* exists in csi_i_assets */

174:
175: /*-----------------------------------------------------------*/
176: /* Procedure name: Is_Inst_asset_id_valid */
177: /* Description : Check if the instance asset id */
178: /* exists in csi_i_assets */
179: /*-----------------------------------------------------------*/
180:
181: FUNCTION Is_Inst_asset_id_valid
182:

Line 192: FROM csi_i_assets

188: l_return_value BOOLEAN := TRUE;
189: BEGIN
190: SELECT 'x'
191: INTO l_dummy
192: FROM csi_i_assets
193: WHERE instance_asset_id = p_instance_asset_id ;
194: RETURN l_return_value;
195: EXCEPTION
196: WHEN NO_DATA_FOUND THEN

Line 281: SELECT CSI_I_ASSETS_H_S.nextval

277:
278: l_inst_asset_hist_id NUMBER;
279:
280: BEGIN
281: SELECT CSI_I_ASSETS_H_S.nextval
282: INTO l_inst_asset_hist_id
283: FROM sys.dual;
284: RETURN l_inst_asset_hist_id;
285: END gen_inst_asset_hist_id;

Line 478: FROM csi_i_assets_h s,

474: ELSE
475: IF p_end_date < SYSDATE THEN
476: SELECT MAX(t.transaction_date)
477: INTO l_transaction_date
478: FROM csi_i_assets_h s,
479: csi_transactions t
480: WHERE s.instance_asset_id=p_inst_asset_id
481: AND s.transaction_id=t.transaction_id
482: AND t.transaction_id <> nvl(p_txn_id, -999999);