APPS.CSI_INSTANCE_PARTIES_VLD_PVT dependencies on CSI_I_ASSETS

Line 1507: SELECT CSI_I_ASSETS_S.nextval

1503:
1504: l_inst_asset_id NUMBER;
1505:
1506: BEGIN
1507: SELECT CSI_I_ASSETS_S.nextval
1508: INTO l_inst_asset_id
1509: FROM sys.dual;
1510:
1511: RETURN l_inst_asset_id;

Line 1518: /* exists in csi_i_assets */

1514:
1515: /*-----------------------------------------------------------*/
1516: /* Procedure name: Is_Inst_assetID_exists */
1517: /* Description : Check if the instance asset id */
1518: /* exists in csi_i_assets */
1519: /*-----------------------------------------------------------*/
1520:
1521: FUNCTION Is_Inst_assetID_exists
1522:

Line 1532: FROM csi_i_assets

1528: l_return_value BOOLEAN := TRUE;
1529: BEGIN
1530: SELECT 'x'
1531: INTO l_dummy
1532: FROM csi_i_assets
1533: WHERE instance_asset_id = p_instance_asset_id ;
1534:
1535: IF ( p_stack_err_msg = TRUE ) THEN
1536: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_INST_ASSET_ID');

Line 1622: SELECT CSI_I_ASSETS_H_S.nextval

1618:
1619: l_inst_asset_hist_id NUMBER;
1620:
1621: BEGIN
1622: SELECT CSI_I_ASSETS_H_S.nextval
1623: INTO l_inst_asset_hist_id
1624: FROM sys.dual;
1625: RETURN l_inst_asset_hist_id;
1626: END gen_inst_asset_hist_id;